Regarding Full online Backup failed

[Former Member]

Dear All,

I have faceing one issue related to SAP system backup, i have shedule sap backup by DB13(full online backup) but frequently it will failed and showing same return code 005. Bellow mentioned is log details pls. check:-

datafile copy filename=/oracle/P01/sapbackup/behgluac.spa/p01.data26 recid=40001 stamp=767722216

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03009: failure of catalog command on default channel at 11/20/2011 16:10:16

ORA-19665: size 517120 in file header does not match actual file size of 514560

ORA-19664: file type: datafile copy, file name: /oracle/P01/sapbackup/behgluac.spa/p01.data27RMAN>

Recovery Manager complete.

BR0280I BRBACKUP time stamp: 2011-11-20 16.10.17

*BR0279E Return code from 'SHELL=/bin/sh /oracle/P01/102_64/bin/rman nocatalog': 1*

BR0536E RMAN call for database instance P01 failedBR0280I BRBACKUP time stamp: 2011-11-20 16.10.17

BR0532E Cataloging backups of all database files failedBR0056I End of database backup: behgluac.fnt 2011-11-20 16.10.17

BR0280I BRBACKUP time stamp: 2011-11-20 16.10.17

BR0054I BRBACKUP terminated with errors

Pls. guide me and help me to reslove this issue.

Our server OS is solaries 10 and DB is Oracle 10g.

Regards,

Sweetdiya.

[former_member188883 · Accepted solution]

Hi,

There seems to be a corruption in the datafile. Could you run dbverify command and provide more details on this.

Regards,

Deepak Kori

[Former Member · Accepted solution]

Hii,

Can you tell me option to take backup again on same day if 1st bakup will failure? Bcoz we have try to take backup on same day on same tape when 1st backup had terminated due to error sytem is not take backup. e.g if today tuesday i have take(sunday S01B01,mon S01B02 likethis) tape name S01B03 our backup is failed due to error RC:- 005. we can re-execute bakup or shedule bckup in DB13 again it is agin failed.

so can any body can guide us on this issue plz..

Thanks in advance.

Regards,

Sweetdiya

Edited by: sweetdiya on Nov 22, 2011 10:11 AM

[former_member188883 · Accepted solution]

Hi,

In case you want to take 2nd attempt of backup on the same tape which failed during 1st attempt you need to do the following

1) force initialize the tape with volume name scratch or the volume name you need

2) Then initiate the brbackup command.

Hope this helps.

Regards,

Deepak Kori