Veritas-bu

[Veritas-bu] RMAN / Oracle Backup Query

2002-05-22 07:41:04
Subject: [Veritas-bu] RMAN / Oracle Backup Query
From: Penelope.Carr AT veritas DOT com (Penelope Carr)
Date: Wed, 22 May 2002 07:41:04 -0400
Gentlemen,

Was this the only parameter that did not get passed correctly??  It seems
odd that the parameter was not passed.  I would like to see the script(s)
you are using to verify what is going on along with the rman .out file if
you don't mind.   

I would think if you run one or 100 database backups they should all handle
the same.  You can feed this parameter within the script by using SEND="" or
PARMS="".  It is odd that this did not work.

NBU only provides the api to send the data to tape and to run the backup
through a automated  schedule.  I would like to find out why this particular
backup did not work.  Is it just this one or others and is it all the
time???

Penelope

-----Original Message-----
From: Nigel A Phillips [mailto:nphillip AT csc DOT com]
Sent: Wednesday, May 22, 2002 4:56 AM
To: veritas-bu AT mailman.eng.auburn DOT edu
Cc: Philip.Weber AT egg DOT com
Subject: [Veritas-bu] RMAN / Oracle Backup Query


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

_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu