Can I skip a corrupt archivelog in a restore?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: Can I skip a corrupt archivelog in a restore?

  1. #1
    Join Date
    Mar 2001
    Posts
    10

    Can I skip a corrupt archivelog in a restore?

    We are running an Oracle 8.1.7.4 EE instance on a server which lost its data RAID partition. I restored all the datafiles from an old backupset and upon applying the archivelogs (svrmgrl>>recover database until cancel using backup controlfile). I recieved the following:

    ORA-00300: cannot open archived log 'nameoflogfile'
    ORA-27047: unable to read the header block of file
    OSD-04001: invalid logical block size (OS 47608)

    Upon inspection we concluded that the archive log is corrupt and we have no other copies of it.

    Is there a way I can skip this log file and apply the next 50 or so archivelogs I still have?

    thanks in advance

  2. #2
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    nope
    I'm stmontgo and I approve of this message

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    No way dude. You are limited to recover through your last valid archived redo log.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  4. #4
    Join Date
    Mar 2001
    Posts
    10
    Not the answer I wanted to hear but thanks for the responses fellas.

  5. #5
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Does anyone know of a way of validating the integrity of an archived log file, other than trying to restore it?
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  6. #6
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796

    Re: Can I skip a corrupt archivelog in a restore?

    Originally posted by eddieh
    We are running an Oracle 8.1.7.4 EE instance on a server which lost its data RAID partition. I restored all the datafiles from an old backupset and upon applying the archivelogs (svrmgrl>>recover database until cancel using backup controlfile). I recieved the following:

    ORA-00300: cannot open archived log 'nameoflogfile'
    ORA-27047: unable to read the header block of file
    OSD-04001: invalid logical block size (OS 47608)

    Upon inspection we concluded that the archive log is corrupt and we have no other copies of it.

    Is there a way I can skip this log file and apply the next 50 or so archivelogs I still have?

    thanks in advance
    Quote from metalink.

    Error: ORA 300
    Text: illegal redo log block size specified - exceeds limit of
    -------------------------------------------------------------------------------
    Cause: The specified block size of the redo log file is greater than the
    maximum block size for the operating system.
    Action: Create the redo log on a device with a smaller block size.
    By any chance was the new RAID filesystem created with different OS block size, as you have mentioned that you have lost the RAID???
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  7. #7
    Join Date
    Mar 2001
    Posts
    10
    We are using the default Win2k block size which has worked fine. The corrupt archivelog was actually a deleted file that I recovered using a disk recovery tool.

  8. #8
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by slimdave
    Does anyone know of a way of validating the integrity of an archived log file, other than trying to restore it?
    I know RMAN validates blocks on the way in for datafiles, but I'm not sure for redo entries.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  9. #9
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by marist89
    I know RMAN validates blocks on the way in for datafiles, but I'm not sure for redo entries.
    RMAN will not backup a corrupted archive log file.

    In Oracle9i, there can be up to 10 archived log destinations, so if an error occurs while reading one of them, Oracle will switch to another copy of that file.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

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