rman crosscheck archivelog all

If archived redo logs are (wrongly) deleted/moved/compressed from disk without being backed up, the rman catalog will not know this has happened, and will keep attempting to backup the missing archived redo logs. That will cause rman archived redo log backups to fail altogether with an error like:

RMAN-06059: expected archived log not found, lost of archived log compromises recoverability

If you can, you should bring back the missing archved redo logs to their original location and name, and let rman back them up. But if that is impossible, the workaround is to “crosscheck archivelog all”, like:

rman <<e1
connect target /
connect catalog username/password@catalog
run {
allocate channel c1 type disk ;
crosscheck archivelog all ;
release channel c1 ;
}
e1

You’ll get output like this:

validation succeeded for archived log
archive log filename=D:REDOARCHARCH_1038.DBF recid=1017 stamp=611103638

for every archived log as they are all checked on disk. That should be the catalog fixed, run an archivelog backup to make sure.

[Ref: Metalink ]

January 12, 2007

  • If rman back to tape directly and keep 30 days, crosscheck database will take long time.
    How to reduce the time for crosscheck?
    If delete expired, or delete expired after 15 days, can we still be able to restore backups after 15 days(within 30 days) since the backup information in recover catalog more than 15 day will be deleted?
    Thanks for your help.

  • I need your Help Andrew!!1

    Q) I have taken complete RMAN backup at night 12:00am, then tx happened and at morning 4:00am the archivelog that was generated at that time is lost due to some reason even after that tx were contuinued and more archives were generated at morning 11:00am i get ticket stating restore the previous backup… How will I do that as one archivelog is missing…..
    Your help will be appreciated

  • Saw a visitor from your site into my blogsite (www.jhdba.wordpress.com) and came to have a look. I like the look and feel of the site and the content seems very good.

    John

  • Leave a Reply

    Your email address will not be published. Required fields are marked *