[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
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- [Veritas-bu] RMAN / Oracle Backup Query, Weber, Philip
- [Veritas-bu] RMAN / Oracle Backup Query, Rickus John
- [Veritas-bu] RMAN / Oracle Backup Query, Weber, Philip
- [Veritas-bu] RMAN / Oracle Backup Query, Rickus John
- [Veritas-bu] RMAN / Oracle Backup Query, Weber, Philip
- [Veritas-bu] RMAN / Oracle Backup Query, Penelope Carr
- [Veritas-bu] RMAN / Oracle Backup Query, Penelope Carr
- [Veritas-bu] RMAN / Oracle Backup Query,
Nigel A Phillips <=
- [Veritas-bu] RMAN / Oracle Backup Query, Penelope Carr
- [Veritas-bu] RMAN / Oracle Backup Query, Nigel A Phillips
- [Veritas-bu] RMAN / Oracle Backup Query, Weber, Philip
|
|
|