corrupt redolog
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: corrupt redolog

  1. #1
    Join Date
    May 2003
    Location
    Pretoria, Rep of South Africa
    Posts
    191

    corrupt redolog

    I corrupted a redolog on purpose on a test service 4 some exercise.
    I made a coldback of the redo this morning. I then replaced the corrupted redo with the backup redo. No archive enabled

    Problem: Database in mount,not open mode.
    Can anyone assist me in recovering this db (if possible).

    Note: This is an area that I'm very bad at because I never get to practice

    my guess its a media recovery and that I'm screwed!!

    ORA-00322:log 3 of thread 1 is not current copy
    ORA-00322nline log 3 thread 1:'C:\ORACLE\ORADATA\IAMMV3\REDO03.LOG

    Please help if possible
    Able was I ere I saw Elba

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    drop the group and open the database, or copy a good member of that group over the top

  3. #3
    Join Date
    May 2003
    Location
    Pretoria, Rep of South Africa
    Posts
    191
    This was the only way. Incomplete recovery



    SQL> recover database until time '2005-11-17:10:00:00'
    Media recovery complete.
    SQL> alter database open resetlogs
    2 ;

    Database altered.

    SQL>
    Able was I ere I saw Elba

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