DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Recovery is repairing media corrupt block

  1. #1

    Recovery is repairing media corrupt block

    Hi all,

    I need some advice regarding this media corrup block. When I apply our archived log, I got a message like below:

    Media Recovery Log /archive/P/arch0000001858.arc
    Recovery is repairing media corrupt block 29701 of file 2
    Recovery is repairing media corrupt block 29702 of file 2
    Recovery is repairing media corrupt block 29703 of file 2
    Recovery is repairing media corrupt block 29704 of file 2
    Recovery is repairing media corrupt block 29705 of file 2
    Tue Feb 3 15:01:37 2004
    Media Recovery Log /archive/P/arch0000001859.arc
    Recovery is repairing media corrupt block 42186 of file 2
    Recovery is repairing media corrupt block 42187 of file 2
    Recovery is repairing media corrupt block 42188 of file 2
    Recovery is repairing media corrupt block 42189 of file 2
    Recovery is repairing media corrupt block 42190 of file 2
    Tue Feb 3 15:02:04 2004
    Media Recovery Log /archive/P/arch0000001860.arc
    Tue Feb 3 15:03:01 2004

    Is my standby database still intact? Should I worry about this recovery message in future? Looks like some or our archived log are fine. I wonder it got corrupted during tranfer. Hopefully I dont have to re-create standby.

    Thank you in advance.

    feroz

  2. #2
    This means the segment that those blocks belongs to have been done with nologging operations.
    You'd better copy the datafile from primary site.
    www.cnoug.org

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