08-13-2012 06:34 AM
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
08-13-2012 07:00 AM
For Oracle trouble, you need to look at client RMAN .out file and dbclient log.
08-13-2012 07:54 AM
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.
08-14-2012 01:45 AM
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.
08-14-2012 01:52 AM
Just had a look at the Rman log file.
released channel: c1RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03002: failure of sql command at 08/12/2012 06:41:07RMAN-06004: ORACLE error from recovery catalog database: ORA-03114: not connected to ORACLERMAN>Recovery Manager complete.Script /usr/openv/netbackup/ext/db_ext/oracle/rman_cold_bkp_JDESPNPD.sh
08-14-2012 11:27 AM
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.
08-14-2012 11:43 AM
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-753609...
08-14-2012 12:30 PM
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';
08-22-2012 01:24 PM
shin, any update on this?
09-06-2012 07:55 AM
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