Oracle cold backup failed with error code 6
Hi All,
I have moved the a Unix server host with Oracle DB from a master server to new master server after that receiving error 6.
Old master server version is Netbackup 6.5.6
New Master server version is Netbackup 7.1.0
After movement all Hot backups and the child jobs of cold backup also successfull, but the parent job of the cold backup was failed with 6
Error message: {the backup failed to back up the requested files(6)}
how will this child jobs are completing successfully but parent job not.
i have configured exact replica of old policies and there is no issues with script or policy.
Not sure what is wrong. Please find the detailed status tab below.
8/12/2012 8:16:03 AM - Info nbjm(pid=3704) requesting MEDIA_SERVER_WITH_ATTRIBUTES resources from RB for backup job (jobid=39621, request id:{0D447CC2-FF46-4A7D-A7D6-7712F6DC0CC1})
8/12/2012 8:16:03 AM - requesting resource ATMOS_CIFS_HCEAN427_TEST
8/12/2012 8:16:03 AM - requesting resource hcean427.NBU_CLIENT.MAXJOBS.HHEAU401-555
8/12/2012 8:16:03 AM - requesting resource hcean427.NBU_POLICY.MAXJOBS.RMAN_Cold_Backup_JDESPNPD
8/12/2012 8:16:03 AM - granted resource hcean427.NBU_CLIENT.MAXJOBS.HHEAU401-555
8/12/2012 8:16:03 AM - granted resource hcean427.NBU_POLICY.MAXJOBS.RMAN_Cold_Backup_JDESPNPD
8/12/2012 8:16:03 AM - granted resource ATMOS_CIFS_HCEAN427_TEST
8/12/2012 8:16:03 AM - estimated 0 Kbytes needed
8/12/2012 8:16:03 AM - Info nbjm(pid=3704) started backup job for client HHEAU401-555, policy RMAN_Cold_Backup_JDESPNPD, schedule RMAN_Cold_Backup_JDESPNPD on storage unit ATMOS_CIFS_HCEAN427_TEST
8/12/2012 8:16:05 AM - started process bpbrm (8364)
8/12/2012 8:16:08 AM - Info bpbrm(pid=8364) HHEAU401-555 is the host to backup data from
8/12/2012 8:16:08 AM - Info bpbrm(pid=8364) reading file list from client
8/12/2012 8:16:08 AM - connecting
8/12/2012 8:16:14 AM - Info bpbrm(pid=8364) starting bphdb on client
8/12/2012 8:16:14 AM - Info bphdb(pid=0) Backup started
8/12/2012 8:16:14 AM - connected; connect time: 00:00:06
8/12/2012 11:36:40 AM - end writing
the backup failed to back up the requested files(6)
8/12/2012 11:36:45 AM - Info bphdb(pid=0) done. status: 6: the backup failed to back up the requested files
Please help me to resolve this issue.
Please let me know for more info.
Thanks
shin
Comments 9 Comments • Jump to latest comment
For Oracle trouble, you need to look at client RMAN .out file and dbclient log.
will restore -- where there is a Will there is a way
i have verified and couldnt able to find out the cause for this failure. I have attached both the logs could you please check the logs an help me out.
We need the client's dbclient log that matches Job Details in your opening post.
The date in Job details is 8/12/2012. Job starts at 8:16:03 AM and ends 11:36:45 AM.
You have given us 13 dbclient logs from 30 July up to 12 August.
log.081212 starts at 00:00:03 and ends at 06:41:07.
Please give us dbclient log that matches the date and time in Job details.
Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links
Just had a look at the Rman log file.
Seems you have some sql command in the script that does not work while database is down.
Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links
Hi Maria,
Timestamp is different because the client and master server time are different. Around 5 hrs difference is there between these servers
Client server is 5 hrs behind master server.
NOT GOOD!!
Client and server should not differ by that much.
Client will check with master for successful backup based on client's local time.
Restore may become an issue...
Couple of minutes time difference should be fine.
Please see my previous post about Oracle error: https://www-secure.symantec.com/connect/forums/oracle-cold-backup-failed-error-code-6#comment-7536091
Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links
what is the sql command that it's trying to execute at the end there?
after the BACKUP DATABASE it should be
sql 'alter database open';
will restore -- where there is a Will there is a way
shin, any update on this?
will restore -- where there is a Will there is a way
Hi Maria,
As i said earlier, i have successfull hot backups for the same databases..
We have found out that there is a packet drop between database server and RMAN catalog server at the time of failure
Would you like to reply?
Login or Register to post your comment.