03-25-2013 05:27 AM
Hi All,
We are running netbackup for oracle agent. The oracle clients has four instance and each instance has its own backup policy.
The backup is successful for all instances. But when it comes to restore, only one instance restore succeeds and 3 fails. below is the rman output:
Solved! Go to Solution.
03-25-2013 08:00 AM
Did you remember to specify ORACLE_SID variable?
Is user Id the same as user who performed the backup?
In addition to dbclient log, also ensure that bprd log folder exists on the master server.
If not, create folder and restart NBU.
Retry the restore, then copy logs to .txt files (dbclient.txt, bprd.txt) and post as File attachments.
03-25-2013 07:35 AM
03-25-2013 08:00 AM
Did you remember to specify ORACLE_SID variable?
Is user Id the same as user who performed the backup?
In addition to dbclient log, also ensure that bprd log folder exists on the master server.
If not, create folder and restart NBU.
Retry the restore, then copy logs to .txt files (dbclient.txt, bprd.txt) and post as File attachments.
03-25-2013 09:09 AM
I am using a script file for oracle policy backup selection with the below paramters for TRNG instance. For the other instances, i change the "ORACLE_SID" paramter according to the instance name.
ORACLE_HOME=/u02/app/oracle/product/10.2.0
ORACLE_SID=TRNG
ORACLE_USER=oracle
TARGET_CONNECT_STR=/
I login to the server as oracle user and specify the ORACLE_SID for the instance i want to restore. the restore is succeeding for the instance TRNG but not for the other 3 instances. Although the configuration is exactly the same for all 4 instances.
Later i'll check the log files and post them.
Many Thanks
03-27-2013 03:32 AM
kindly find attached the log files. I also attached output for the contents of the netbackup and RMAN catalogs.
The rman restore is requesting the file "<cntrl_18_1_810725846>"
The file is found in RMAN catalog but not in netbackup catalog.
It seems that the RMAN catalog is not syncing with the NBU catalog.
Regards,
03-27-2013 04:04 AM
cntrl_18_1_810725846 is not listed in bplist.
Please check with which client name you took the backup of control file for this instance. Post "bppllist policyname -U", and "bpimagelist -policy policyname -hoursago 240"
03-27-2013 07:21 AM
The problem is solved. Had the wrong ORACLE_SID parameter in the rman script files.
Thank you all
03-27-2013 03:45 PM
Please mark Marianne's post as a solution as she mentioned to ORACLE_SID.
03-26-2018 04:01 PM