RMAN configure channel with multiple parameters
manuela mueller
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/cd/B10501_01/server.920/a96566/rcmconfg.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
s.kapitza
TINA_RMAN_USER=the_user,SBT_LIBRARY=$ORACLE_HOME/lib/libobk.so)";
}
should work
regards
s.kapitza
manuela mueller
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:(24.12457) 2004-09-06 12:42:11.549
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
s.kapitza
<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:(24.12457) 2004-09-06 12:42:11.549
> 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
Mladen Gogala
>>
>> 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.
manuela mueller
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?
manuela mueller
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
s.kapitza
> 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
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
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