Re: RMAN configure channel with multiple parameters

From: manuela mueller <mueller_m_at_fiz-chemie.de>
Date: Mon, 06 Sep 2004 13:10:05 +0200
Message-ID: <2q2usfFq75pdU1@uni-berlin.de>

s.kapitza wrote:

> manuela mueller <mueller_m_at_fiz-chemie.de> wrote in message news:<2pr7p6FnvrfeU1_at_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/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

> 
> 
> 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:(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 Received on Mon Sep 06 2004 - 06:10:05 CDT