Skip to Content
author's profile photo Former Member
Former Member

Regarding Full online Backup failed

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Nov 20, 2011 at 03:10 PM

    Hi,

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

    Regards,

    Deepak Kori

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.