Veritas-bu

[Veritas-bu] RMAN / Oracle Backup Query

2002-05-22 04:55:43
Subject: [Veritas-bu] RMAN / Oracle Backup Query
From: nphillip AT csc DOT com (Nigel A Phillips)
Date: Wed, 22 May 2002 09:55:43 +0100
Philip,

Not sure if this is the exact problem you're getting, but sounds similar
output from bpimagelist

Backed Up         Expires       Files       KB  C  Sched Type   Class
----------------  ---------- -------- --------  -  ------------ ------------
11/14/2001 22:14  12/15/2001        1    58016  N  User Backup  
maiusda1_CCDMREPL_ora_cold_E
11/14/2001 22:09  12/15/2001        1   446048  N  User Backup  
maiusda1_CCDMREPL_ora_cold_E
11/14/2001 22:05  12/15/2001        1   108896  N  User Backup  
maiusda1_CCDMREPL_ora_cold_E
11/14/2001 22:00  12/15/2001        1   168928  N  User Backup  
maiusda1_CCDMREPL_ora_cold_E
11/14/2001 21:56  12/15/2001        1   135392  N  User Backup  
maiusda1_CCDMREPL_ora_cold_E
11/14/2001 21:52  12/15/2001        1   114272  N  User Backup  
maiusda1_CCDMREPL_ora_cold_E
11/14/2001 21:46  12/15/2001        1   158624  N  User Backup  
maiusda1_CCDMREPL_ora_cold_E
11/14/2001 21:42  12/15/2001        0        0  N  Full Backup  
maiusda1_CCDMWHRL_ora_cold_E
11/14/2001 21:40  12/15/2001        1    84512  N  User Backup  
maiusda1_CCDMREPL_ora_cold_E
11/14/2001 21:37  12/15/2001        1    21088  N  User Backup  
maiusda1_CCDMREPL_ora_cold_E
11/14/2001 21:34  12/15/2001        1    75168  N  User Backup  
maiusda1_CCDMREPL_ora_cold_E
11/14/2001 21:30  12/15/2001        1    21600  N  User Backup  
maiusda1_CCDMREPL_ora_cold_E
11/14/2001 21:26  12/15/2001        1    66272  N  User Backup  
maiusda1_CCDMREPL_ora_cold_E
11/14/2001 21:23  12/15/2001        0        0  N  Full Backup  
maiusda1_CCDMREPL_ora_cold_E

Running separate RMAN jobs seemed to merge one into the other CCDMREPL and 
CCDMWHRL - no User Backup
for CCDMWHRL (each database restored okay)
Answer from Veritas below:

The problem that we had here is that RMAN did not pick up the environment
variable NB_ORA_CLASS from the environment, even though it was correctly
exported. This was not a scripting issues. This was proven by running rman
outside the script with NB_ORA_CLASS exported.

RMAN calls our "libobk" library to perform the backup, it is this library
that picks up the NB_ORA_CLASS variable. If it cannot find this variable,
then it picks up that class name that is passed to it by the NetBackup
scheduler. However this mechanism is not designed for multiple concurrent
jobs (that is meant to be handled by the passing of environment variables)
and caused the two class names to get confused.

The reason that the environment was not being passed was that rman was
being
called with a "connect string" as the "target database" to be backed up.
Even though this database is on the same machine as the rman executable,
rman passes the oracle back-end a message telling it to backup, this
message
does not pass on any environment variables. When the approved mechanism of
using "/" as the target database, rman performs the backup itself,
utilising
the environmental variables that it has been given.

Hope this helps

Nigel Phillips
UNIX System Administrator