Dan
Your tape device is not set. You have to make sure the environment variable
LD_LIBRARY_PATH is set in the oracle user .profile, .cshrc, .login, whatever
you use to set the variable when the oracle user logs into the system to do
the backups.
Here is what has to be done:
Install NBU for 32 bit or 64 bit OS
Install NBU for Oracle Extension for 32 or 64 bit Oracle
Install NBU patches
Install NBU for Oracle patch
If and only if, you have 64 bit environment you have to add the following
touch /usr/openv/netbackup/NOSHM
as root cd /usr/openv/netbackup/bin
ln -s libobk.so.1 libobk.so (make sure you have the right binary for 32 or
64 bit)
as oracle user
vi .profile (.profile, .oraenv, .cshrc, .login, whatever you use to set
the oracle environment)
LD_LIBRARY_PATH=/app/oracle/product/8.1.7/lib(the first entry must be your
$ORACLE_HOME path):rest of path
shutdown the databases on the server
now enforce the new parameter . ./.profile
cd $ORACLE_HOME/bin
cp oracle oracle.orig (just in case)
cd $ORACLE_HOME/lib
mv any libobk.so.XXX to libobk.so.old
ln -s /usr/openv/netbackup/bin/libobk.so libobk.so
startup the databases
cd $ORACLE_HOME/bin
ldd oracle
it should show libobk.so -> $ORACLE_HOME/lib/libobk.so
There is no relinking necessary with 8.1.7 (no remake of the oracle
executable). Your environment must show this or it will not work.
Penelope
-----Original Message-----
From: Dan Chrastil [mailto:dchrastil AT bcbsga DOT com]
Sent: Monday, March 25, 2002 12:39 PM
To: veritas-bu AT mailman.eng.auburn DOT edu
Subject: [Veritas-bu] Oracle hotbackup error
Anyone seen this oracle error before, possibly tell me what or where I
should look to fix?
Thanks,
Recovery Manager: Release 8.1.7.3.0 - Production
RMAN-06005: connected to target database: HPRD (DBID=992246278)
RMAN-06008: connected to recovery catalog database
RMAN> run {
2> allocate channel ch1 type 'SBT_TAPE';
3> allocate channel ch2 type 'SBT_TAPE';
4> sql 'alter system archive log current';
5> backup filesperset 10 format 'df_%u_%s_%p'
6> (database include current controlfile);
7> backup filesperset 10 format 'lf_%u_%s_%p'
8> (archivelog all delete input); }
9>
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03007: retryable error occurred during execution of command: allocate
RMAN-07004: unhandled exception during command execution on channel ch1
RMAN-10035: exception raised in RPC: ORA-19554: error allocating device,
device type: SBT_TAPE,
device name:
ORA-19557: device error, device type: SBT_TAPE, device name:
ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer
Additional information: 4110
ORA-19511: SBT error = 4110, errno = 0, BACKUP_DIR environment variable is
not set
RMAN-10031: ORA-19624 occurred during call to
DBMS_BACKUP_RESTORE.DEVICEALLOCATE
Recovery Manager complete.
*****************************
|