RMAN configure channel with multiple parameters

From: manuela mueller <mueller_m_at_fiz-chemie.de>
Date: Fri, 03 Sep 2004 14:52:53 +0200
Message-ID: <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.

1. 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 Received on Fri Sep 03 2004 - 07:52:53 CDT