rman crosshcheck (validation failed message)
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: rman crosshcheck (validation failed message)

  1. #1
    Join Date
    Jul 2006
    Posts
    195

    rman crosshcheck (validation failed message)

    I had some .arc files that were missing from disk and I ran the following to
    fix the issue:

    CHANGE ARCHIVELOG ALL CROSSCHECK;

    When I run the same command again, I see validation failed messages for old .arc files (see below) for an example. Is there a RMAN command I can
    run that will remove thsese messages. As mentioned, they appeary to be
    innocuous but I would like to clean up so things are a bit more ledgible.

    validation failed for archived log
    archived log file name=/archive/cdrtest/cdrtest_76_1_740904300.arc RECID=76 STAMP=741513745

    Thanks to all who answer

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    Is the file there in the location shown? If not, can you retrieve it and try again? Is it obsolete or expired?

  3. #3
    Join Date
    Jul 2006
    Posts
    195
    Quote Originally Posted by stecal View Post
    Is the file there in the location shown? If not, can you retrieve it and try again? Is it obsolete or expired?
    The file is not there nor do I need it. I will see if I can remove it from rman DB. Thanks

  4. #4
    Join Date
    May 2002
    Posts
    2,645
    delete obsolete.

    It's almost never a matter of whether or not you need it, but more along the lines that RMAN "needs" it (until you tell it otherwise: delete obsolete or uncatalog).

  5. #5
    Join Date
    Apr 2006
    Posts
    377
    A DELETE EXPIRED ARCHIVELOG ALL will alleviate the VALIDATION FAILED messages.

  6. #6
    Join Date
    Jul 2006
    Posts
    195
    Brian thanks...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width