This is a discussion on RMAN configure channel with multiple parameters within the Oracle Database forums, part of the Database Server Software category; --> Dear All, Environment OS: linux, SuSE SLES-8 Kernel: 2.4.21-215-smp RDBMS: Oracle EE + RAC 9.2.0.5 RMAN configured with recover ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Dear All, Environment OS: linux, SuSE SLES-8 Kernel: 2.4.21-215-smp RDBMS: Oracle EE + RAC 9.2.0.5 RMAN configured with recover catalog database. Backup Software: Time Navigator Media Management 3.7 Maybe this is an easy question, but I can't find the solution yet. I'm trying to configure RMAN automatic channels with multiple parms. a) manually allocating an sbt channel works fine: (I abbreviated the pathnames and included line breaks for better readability) RUN { allocate channel c1 type 'sbt_tape' parms="SBT_LIBRARY=$ORACLE_HOME/lib/libobk.so, ENV=(TINA_HOME=/tina, TINA_SERVICE_NAME=tina, TINA_RMAN_CATALOG=catalog, TINA_RMAN_FOLDER=backupfolder, LD_LIBRARY_PATH=$ORACLE_HOME/lib:/tina/Lib, TINA_APP_LIB_PATH=/tina/Lib/libtina_rman.so, TINA_RMAN_USER=the_user)"; release channel c1; } allocated channel: c1 channel c1: sid=23 devtype=SBT_TAPE channel c1: Time Navigator Media Management released channel: c1 b) configure channel: RUN { CONFIGURE CHANNEL DEVICE TYPE 'sbt_tape' parms="SBT_LIBRARY=$ORACLE_HOME/lib/libobk.so, ENV=( TINA_HOME=/tina, TINA_SERVICE_NAME=tina, TINA_RMAN_CATALOG=catalog, TINA_RMAN_FOLDER=backupfolder, LD_LIBRARY_PATH=$ORACLE_HOME/lib:/tina/Lib, TINA_APP_LIB_PATH=/tina/Lib/libtina_rman.so, TINA_RMAN_USER=the_user) "; } RMAN-00571: ================================================== ========= RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: ================================================== ========= RMAN-03009: failure of allocate command on c1 channel at 09/03/2004 13:32:54 ORA-19554: error allocating device, device type: SBT_TAPE, device name: ORA-27211: Failed to load Media Management Library Additional information: 2 The RMAN User Guide http://download-west.oracle.com/docs...nfg.htm#453279 shows only an example with one parameter <quote> CONFIGURE CHANNEL DEVICE TYPE # sets parameters for all channels PARMS 'ENV=(NSR_DATA_VOLUME_POOL=oracle_tapes)' FORMAT '%U_backup'; </quote> I switched the order of parameters, first ENV(...) then SBT_LIBRARY but without success: RUN { CONFIGURE CHANNEL DEVICE TYPE 'sbt_tape' parms="ENV=( TINA_HOME=/tina, TINA_SERVICE_NAME=tina, TINA_RMAN_CATALOG=catalog, TINA_RMAN_FOLDER=backupfolder, LD_LIBRARY_PATH=$ORACLE_HOME/lib:/tina/Lib, TINA_APP_LIB_PATH=/tina/Lib/libtina_rman.so, TINA_RMAN_USER=the_user), SBT_LIBRARY=$ORACLE_HOME/lib/libobk.so"; } This is the first time I perform backups on tape. Maybe I am missing something obvious? Any suggestions are welcome. Thanks in advance and have a nice day Manuela Mueller |
| |||
| manuela mueller <mueller_m@fiz-chemie.de> wrote in message news:<2pr7p6FnvrfeU1@uni-berlin.de>... > Dear All, > > Environment > OS: linux, SuSE SLES-8 > Kernel: 2.4.21-215-smp > RDBMS: Oracle EE + RAC 9.2.0.5 > RMAN configured with recover catalog database. > Backup Software: Time Navigator Media Management 3.7 > > Maybe this is an easy question, but I can't find the solution yet. > I'm trying to configure RMAN automatic channels with multiple parms. > > a) manually allocating an sbt channel works fine: > (I abbreviated the pathnames and included line breaks for better > readability) > > RUN > { > allocate channel c1 type 'sbt_tape' > parms="SBT_LIBRARY=$ORACLE_HOME/lib/libobk.so, > ENV=(TINA_HOME=/tina, > TINA_SERVICE_NAME=tina, > TINA_RMAN_CATALOG=catalog, > TINA_RMAN_FOLDER=backupfolder, LD_LIBRARY_PATH=$ORACLE_HOME/lib:/tina/Lib, > TINA_APP_LIB_PATH=/tina/Lib/libtina_rman.so, > TINA_RMAN_USER=the_user)"; > release channel c1; > } > > allocated channel: c1 > channel c1: sid=23 devtype=SBT_TAPE > channel c1: Time Navigator Media Management > > released channel: c1 > > b) configure channel: > > RUN > { > CONFIGURE CHANNEL DEVICE TYPE 'sbt_tape' > parms="SBT_LIBRARY=$ORACLE_HOME/lib/libobk.so, > ENV=( TINA_HOME=/tina, > TINA_SERVICE_NAME=tina, > TINA_RMAN_CATALOG=catalog, > TINA_RMAN_FOLDER=backupfolder, LD_LIBRARY_PATH=$ORACLE_HOME/lib:/tina/Lib, > TINA_APP_LIB_PATH=/tina/Lib/libtina_rman.so, > TINA_RMAN_USER=the_user) "; > } > > RMAN-00571: ================================================== ========= > RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== > RMAN-00571: ================================================== ========= > RMAN-03009: failure of allocate command on c1 channel at 09/03/2004 13:32:54 > ORA-19554: error allocating device, device type: SBT_TAPE, device name: > ORA-27211: Failed to load Media Management Library > Additional information: 2 > > The RMAN User Guide > http://download-west.oracle.com/docs...nfg.htm#453279 > shows only an example with one parameter > <quote> > CONFIGURE CHANNEL DEVICE TYPE # sets parameters for all > channels > PARMS 'ENV=(NSR_DATA_VOLUME_POOL=oracle_tapes)' FORMAT '%U_backup'; > </quote> > > I switched the order of parameters, first ENV(...) then SBT_LIBRARY but > without success: > > RUN > { > CONFIGURE CHANNEL DEVICE TYPE 'sbt_tape' > parms="ENV=( TINA_HOME=/tina, > TINA_SERVICE_NAME=tina, > TINA_RMAN_CATALOG=catalog, > TINA_RMAN_FOLDER=backupfolder, LD_LIBRARY_PATH=$ORACLE_HOME/lib:/tina/Lib, > TINA_APP_LIB_PATH=/tina/Lib/libtina_rman.so, > TINA_RMAN_USER=the_user), > SBT_LIBRARY=$ORACLE_HOME/lib/libobk.so"; > } > > This is the first time I perform backups on tape. > Maybe I am missing something obvious? > Any suggestions are welcome. > Thanks in advance and have a nice day > > Manuela Mueller RUN { CONFIGURE CHANNEL DEVICE TYPE 'sbt_tape' parms="ENV=( TINA_HOME=/tina, TINA_SERVICE_NAME=tina, TINA_RMAN_CATALOG=catalog, TINA_RMAN_FOLDER=backupfolder, LD_LIBRARY_PATH=$ORACLE_HOME/lib:/tina/Lib, TINA_APP_LIB_PATH=/tina/Lib/libtina_rman.so, TINA_RMAN_USER=the_user,SBT_LIBRARY=$ORACLE_HOME/lib/libobk.so)"; } should work regards s.kapitza |
| |||
| s.kapitza wrote: > manuela mueller <mueller_m@fiz-chemie.de> wrote in message news:<2pr7p6FnvrfeU1@uni-berlin.de>... > >>Dear All, >> >>Environment >>OS: linux, SuSE SLES-8 >>Kernel: 2.4.21-215-smp >>RDBMS: Oracle EE + RAC 9.2.0.5 >>RMAN configured with recover catalog database. >>Backup Software: Time Navigator Media Management 3.7 >> >>Maybe this is an easy question, but I can't find the solution yet. >>I'm trying to configure RMAN automatic channels with multiple parms. >> >>a) manually allocating an sbt channel works fine: >>(I abbreviated the pathnames and included line breaks for better >>readability) >> >>RUN >>{ >>allocate channel c1 type 'sbt_tape' >>parms="SBT_LIBRARY=$ORACLE_HOME/lib/libobk.so, >>ENV=(TINA_HOME=/tina, >>TINA_SERVICE_NAME=tina, >>TINA_RMAN_CATALOG=catalog, >>TINA_RMAN_FOLDER=backupfolder, LD_LIBRARY_PATH=$ORACLE_HOME/lib:/tina/Lib, >>TINA_APP_LIB_PATH=/tina/Lib/libtina_rman.so, >>TINA_RMAN_USER=the_user)"; >>release channel c1; >>} >> >>allocated channel: c1 >>channel c1: sid=23 devtype=SBT_TAPE >>channel c1: Time Navigator Media Management >> >>released channel: c1 >> >>b) configure channel: >> >>RUN >>{ >>CONFIGURE CHANNEL DEVICE TYPE 'sbt_tape' >>parms="SBT_LIBRARY=$ORACLE_HOME/lib/libobk.so, >>ENV=( TINA_HOME=/tina, >>TINA_SERVICE_NAME=tina, >>TINA_RMAN_CATALOG=catalog, >>TINA_RMAN_FOLDER=backupfolder, LD_LIBRARY_PATH=$ORACLE_HOME/lib:/tina/Lib, >>TINA_APP_LIB_PATH=/tina/Lib/libtina_rman.so, >>TINA_RMAN_USER=the_user) "; >>} >> >>RMAN-00571: ================================================== ========= >>RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== >>RMAN-00571: ================================================== ========= >>RMAN-03009: failure of allocate command on c1 channel at 09/03/2004 13:32:54 >>ORA-19554: error allocating device, device type: SBT_TAPE, device name: >>ORA-27211: Failed to load Media Management Library >>Additional information: 2 >> >>The RMAN User Guide >>http://download-west.oracle.com/docs...nfg.htm#453279 >>shows only an example with one parameter >><quote> >>CONFIGURE CHANNEL DEVICE TYPE # sets parameters for all >>channels >> PARMS 'ENV=(NSR_DATA_VOLUME_POOL=oracle_tapes)' FORMAT '%U_backup'; >></quote> >> >>I switched the order of parameters, first ENV(...) then SBT_LIBRARY but >>without success: >> >>RUN >>{ >>CONFIGURE CHANNEL DEVICE TYPE 'sbt_tape' >>parms="ENV=( TINA_HOME=/tina, >>TINA_SERVICE_NAME=tina, >>TINA_RMAN_CATALOG=catalog, >>TINA_RMAN_FOLDER=backupfolder, LD_LIBRARY_PATH=$ORACLE_HOME/lib:/tina/Lib, >>TINA_APP_LIB_PATH=/tina/Lib/libtina_rman.so, >>TINA_RMAN_USER=the_user), >>SBT_LIBRARY=$ORACLE_HOME/lib/libobk.so"; >>} >> >>This is the first time I perform backups on tape. >>Maybe I am missing something obvious? >>Any suggestions are welcome. >>Thanks in advance and have a nice day >> >>Manuela Mueller > > > RUN > { > CONFIGURE CHANNEL DEVICE TYPE 'sbt_tape' > parms="ENV=( TINA_HOME=/tina, > TINA_SERVICE_NAME=tina, > TINA_RMAN_CATALOG=catalog, > TINA_RMAN_FOLDER=backupfolder, LD_LIBRARY_PATH=$ORACLE_HOME/lib:/tina/Lib, > TINA_APP_LIB_PATH=/tina/Lib/libtina_rman.so, > TINA_RMAN_USER=the_user,SBT_LIBRARY=$ORACLE_HOME/lib/libobk.so)"; > } > > should work > > regards > > s.kapitza Dear S. Kapitza, I tried your suggestion, but still receive ORA-27211: Failed to load Media Management Library. I have an uneasy feeling about a trivial error. Further information about the setup: The catalog and the target db are on the same machine, two different ORACLE_HOMEs and different OS users. We choose this layout for easy backup of the catalog db (shutdown the catlog db, tar cvzf rman_os_users_home and copy to tape). We have a soft link from catalog ORACLE_HOME libobk.so -> /tina/Lib/libtina_rman.so. Permissions of libtina_rman.so: ls -lh /tina/Lib/libtina_rman.so -rwxr-xr-x 1 root root 4.6M 2004-07-09 17:50 /tina/Lib/libtina_rman.so We cleared the configured channel with 'CONFIGURE CHANNEL DEVICE TYPE 'sbt_tape' clear;' and reconfigured it with your configure channel command, SBT_LIBRARY='catalog_db_ORACLE_HOME'/lib/libobk.so During subseqent testing with RMAN> run { 2> allocate channel c1 type 'sbt_tape'; 3> release channel c1; 4> } we receive the same error: ORA-27211: Failed to load Media Management Library In the bdump direcory of the target db we find a trace file with: *** SESSION ID Failed to load SBT library libobk.so My understanding of the documentation was, to set SBT_LIBRARY='catalog_db_ORACLE_HOME'/lib/libobk.so. Just to clarify this, i performed another test. I removed the softlink from catalog ORACLE_HOME libobk.so -> /tina/Lib/libtina_rman.so and set a new link from target ORACLE_HOME libobk.so -> /tina/Lib/libtina_rman.so. I cleared the configured channel, and reconfigured it with SBT_LIBRARY='target_db_ORACLE_HOME'/lib/libobk.so Allocation of the channel shows in the alert log of the target db: ORA-07445: exception encountered: core dump [strncpy()+33] [SIGSEGV] [Address not mapped to object] [0x0] [] [] Any further suggestions what I am doing wrong? Thanks for your input and your time. Manuela Mueller |
| |||
| comments embedded <snip> > > Dear S. Kapitza, > I tried your suggestion, but still receive ORA-27211: Failed to load > Media Management Library. > > I have an uneasy feeling about a trivial error. > Further information about the setup: > The catalog and the target db are on the same machine, two different > ORACLE_HOMEs and different OS users. We choose this layout for easy > backup of the catalog db (shutdown the catlog db, tar cvzf > rman_os_users_home and copy to tape). funny layout, looks fine for a happy desaster recovery day IMO get rid of that. If possible host the catalog on another machine. > > We have a soft link from catalog ORACLE_HOME libobk.so -> > /tina/Lib/libtina_rman.so. link is needed for the database you backup via RMAN (target) > > Permissions of libtina_rman.so: > ls -lh /tina/Lib/libtina_rman.so > -rwxr-xr-x 1 root root 4.6M 2004-07-09 17:50 > /tina/Lib/libtina_rman.so Link should be setup as Oracle Owner. Something like : lrwxrwxrwx 1 oracle dba 20 Jan 1 2004 libobk.so -> /usr/lib/libnwora.so > > We cleared the configured channel with 'CONFIGURE CHANNEL DEVICE TYPE > 'sbt_tape' clear;' > and reconfigured it with your configure channel command, > SBT_LIBRARY='catalog_db_ORACLE_HOME'/lib/libobk.so > > During subseqent testing with > RMAN> run { > 2> allocate channel c1 type 'sbt_tape'; > 3> release channel c1; > 4> } > > we receive the same error: > > ORA-27211: Failed to load Media Management Library > > In the bdump direcory of the target db we find a trace file with: > *** SESSION ID > Failed to load SBT library libobk.so as the target don't know where to find libobk.so > > My understanding of the documentation was, to set > SBT_LIBRARY='catalog_db_ORACLE_HOME'/lib/libobk.so. If you backup the Catalog via RMAN then yes > > Just to clarify this, i performed another test. > I removed the softlink from catalog ORACLE_HOME libobk.so -> > /tina/Lib/libtina_rman.so and set a new link from target ORACLE_HOME > libobk.so -> /tina/Lib/libtina_rman.so. > > I cleared the configured channel, and reconfigured it with > SBT_LIBRARY='target_db_ORACLE_HOME'/lib/libobk.so > > Allocation of the channel shows in the alert log of the target db: > > ORA-07445: exception encountered: core dump [strncpy()+33] [SIGSEGV] > [Address not mapped to object] [0x0] [] [] Probably the Permission Error > > Any further suggestions what I am doing wrong? > Thanks for your input and your time. > > Manuela Mueller regards stefan kapitza |
| |||
| On Mon, 06 Sep 2004 11:17:25 -0700, s.kapitza wrote: >> >> ORA-07445: exception encountered: core dump [strncpy()+33] [SIGSEGV] >> [Address not mapped to object] [0x0] [] [] > > Probably the Permission Error Probably version error or corrupt library. That means that library is found, but the necessary symbols aren't found. Try checking the library with "nm". -- A city is a large community where people are lonesome together. |
| |||
| Dear Stephan, sorry for the long post. comments embedded <snip> > link is needed for the database you backup via RMAN (target) > Link should be setup as Oracle Owner. Something like : > lrwxrwxrwx 1 oracle dba 20 Jan 1 2004 libobk.so -> /usr/lib/libnwora.so removed the old false link and set a new: lrwxrwxrwx 1 oracle oinstall 25 2004-09-07 09:39 libobk.so -> /tina/Lib/libtina_rman.so again, did reconfigure: RMAN> run { CONFIGURE CHANNEL DEVICE TYPE 'sbt_tape' parms="ENV=(TINA_HOME=/tina, TINA_SERVICE_NAME=tina, TINA_RMAN_CATALOG=catalog, TINA_RMAN_FOLDER=backupfolder, LD_LIBRARY_PATH=ORACLE_HOME_TARGET_DB/9.2.0/lib:/tina/Lib, TINA_APP_LIB_PATH=/tina/Lib/libtina_rman.so, TINA_RMAN_USER=the_user, SBT_LIBRARY=ORACLE_HOME_TARGET_DB/lib/libobk.so)"; 4> 5> } <snip of output> new RMAN configuration parameters are successfully stored starting full resync of recovery catalog full resync complete RMAN> run { 2> allocate channel c1 type 'sbt_tape'; 3> release channel c1; 4> } RMAN-00571: ================================================== ========= RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: ================================================== ========= RMAN-03009: failure of allocate command on c1 channel at 09/07/2004 11:29:18 ORA-19554: error allocating device, device type: SBT_TAPE, device name: ORA-00447: fatal error in background process in alert log I notice the same error message as seen yesterday: ORA-07445: exception encountered: core dump [strncpy()+33] [SIGSEGV] [Address not mapped to object] [0x0] [] [] I performed another test, allocated a channel manually without SBT_LIBRARY and backuped 1 datafile: RMAN> run { allocate channel c1 type 'sbt_tape' parms="ENV=(TINA_HOME=/tina, TINA_SERVICE_NAME=tina, TINA_RMAN_CATALOG=catalog, TINA_RMAN_FOLDER=backupfolder, LD_LIBRARY_PATH=ORACLE_HOME_TARGET_DB/lib:/tina/Lib, TINA_APP_LIB_PATH=/tina/Lib/libtina_rman.so, TINA_RMAN_USER=the_user)"trace=1; 4> backup datafile '/u02/oracle/oradata/DBNAMR/drsys01.dbf'; 5> } allocated channel: c1 channel c1: sid=18 devtype=SBT_TAPE channel c1: Time Navigator Media Management Starting backup at 07-SEP-04 channel c1: starting full datafile backupset channel c1: specifying datafile(s) in backupset input datafile fno=00028 name=/u02/oracle/oradata/DBNAME/drsys01.dbf channel c1: starting piece 1 at 07-SEP-04 channel c1: finished piece 1 at 07-SEP-04 piece handle=NULL comment=NONE channel c1: backup set complete, elapsed time: 00:06:25 Finished backup at 07-SEP-04 Starting Control File and SPFILE Autobackup at 07-SEP-04 released channel: c1 RMAN-00571: ================================================== ========= RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: ================================================== ========= RMAN-03002: failure of Control File and SPFILE Autobackup command at 09/07/2004 13:34:53 RMAN-03014: implicit resync of recovery catalog failed RMAN-03009: failure of partial resync command on default channel at 09/07/2004 13:34:53 ORA-01400: cannot insert NULL into ("RMANDB"."BP"."HANDLE") On the target DB there is a trace file: <snip> krbbcb: starting conversation, stamp=536246907, count=22 krbbcb: type=1, incremental=0, level=0, nochecksum=0 Got krbibdf() krbbsbz: backup set logical blocksize = 8192 krbbbdf: added real file #28, name=/u02/oracle/oradata/DBNAME/drsys01.dbf Got krbibsta() Got krbisl() set limit for device type: "SBT_TAPE", name: "" device limit "duplex count for piece" set to 1 Got krbibpc() krbbpc: thread_count = 2 : input_count2 = 1 krbbpc: thread 0xae6d574: bufsize = 1048576, bufcnt = 16, blks/buf = 128 krbbpc: 09/07/2004 13:28:27: backup piece 1 started, outfname=0mfvcujr_1_1 krbcsi=0, krbcss=0, krbpfn=0, krbtra=0x1, krbpfl=0x10 krbdsd=0x0xae56268, krbbxp=0x0xae61a9c, krbrxp=0x(nil), krbnas=0 krbbsbct=0 krbbhdr: piece 1 header: filecnt=1, dircnt=1 krbb1de: Placing file 28 in directory, flags= 0 Directory block 1, count=1, size=76, offset=28 *** 2004-09-07 13:33:50.963 krbbtgb: end of file /u02/oracle/oradata/DBNAME/drsys01.dbf *** 2004-09-07 13:34:46.051 krbbpc: 09/07/2004 13:34:46: backup piece 1 finished, handle= elapsed time: 6:19 krbbpc: backup piece 1: logical blocks=159, header blocks=2 krbbpc: done with file: /u02/oracle/oradata/GUIDES/drsys01.dbf krbbcc: cleaning up conversation, context: 0xae61a9c <snip> de-allocating device type: "SBT_TAPE", name: "" The mentioned file: outfname=0mfvcujr_1_1 exists on tape. The recovery catalog is not in sync. Do you think it is safe to issue a resync catalog? Thanks in advance and have a nice day Manuela Mueller |
| |||
| Dear Mladen, tried your suggestion, receive a lot of output pwd: $ORACLE_HOME_target_db/lib nm libobk.so |less 003ac1a0 R ApiCvtDriveTypeTab 0041f680 d Atraiter.375 00078b94 t ByteSub ... Time Navigator write in its documentation the current version 3.7 is able to backup Oracle 9.2 with OCFS. How can I check a version error? Thanks in advance Manuela Mueller Mladen Gogala wrote: > On Mon, 06 Sep 2004 11:17:25 -0700, s.kapitza wrote: > > >>>ORA-07445: exception encountered: core dump [strncpy()+33] [SIGSEGV] >>>[Address not mapped to object] [0x0] [] [] >> >>Probably the Permission Error > > > Probably version error or corrupt library. That means that library is > found, but the necessary symbols aren't found. Try checking the library > with "nm". > |
| |||
| <snip> > The mentioned file: outfname=0mfvcujr_1_1 exists on tape. > The recovery catalog is not in sync. Do you think it is safe to issue a > resync catalog? > > Thanks in advance and have a nice day > Manuela Mueller Hello Manuela, you could try it, but i'm not shure if it helps. looks like something is wrong here which i'dont see. Maybe Mladen is on the right track and something is wrong with the installation. I'would review the installation (escp. the Enviroment of the target DB), and verify the Installation of the Media Managment. The trace reveals, that no Handle is generated. Possible you need Support. regards s.kpaitza |
| ||||
| <snip> > Hello Manuela, > > you could try it, but i'm not shure if it helps. > looks like something is wrong here which i'dont see. > Maybe Mladen is on the right track and something is > wrong with the installation. > > I'would review the installation (escp. the Enviroment of > the target DB), and verify the Installation of the Media Managment. > The trace reveals, that no Handle is generated. Possible > you need Support. > > regards > > s.kpaitza Dear Stefan and Mladen, just opened a TAR on this to verify the Oracle side first. Thank you for your input ahve a nice day Manuela Mueller |