Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

Oracle cold backup failed with error code 6

Created: 13 Aug 2012 | 9 comments

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 CommentsJump to latest comment

Will Restore's picture

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

shinnet's picture

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. 

AttachmentSize
dbclient.tar 14.19 MB
rman_cold_bkp_JDESPNPD_log.zip 2.13 KB
rman_cold_bkp_JDESPNPY_log.zip 2 KB
Marianne's picture

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

Marianne's picture

Just had a look at the Rman log file.

 

released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of sql command at 08/12/2012 06:41:07
RMAN-06004: ORACLE error from recovery catalog database: ORA-03114: not connected to ORACLE
 
RMAN>
 
Recovery Manager complete.
 
Script /usr/openv/netbackup/ext/db_ext/oracle/rman_cold_bkp_JDESPNPD.sh
 
Please double-check your script.
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

shinnet's picture

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.

 

 

 

Marianne's picture

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

Will Restore's picture

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

Will Restore's picture

shin, any update on this?

 

Will Restore -- where there is a Will there is a way

shinnet's picture

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