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

Thread: HOW to Recover online REDO LOG ?

  1. #1
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    688

    Angry

    Hi guys, by some reasons log file '/home/oracle/netshare/redo2g02.log' has wrong size - 7M instead of 25M, and that is why I am getting error in the alert.log
    I just would like you to confirm: will it be OK if I rename and replace corrupted redo2g02.log with redo2g01.log ?
    Thanks a lot.

    LOGFILE
    GROUP 1 (
    '/home/oracle/oradata/nuance/redo1g01.log',
    '/home/oracle/netshare/redo1g02.log',
    '/home/oracle/backup/nuance/redo1g03.log'
    ) SIZE 25M,
    GROUP 2 (
    '/home/oracle/oradata/nuance/redo2g01.log',
    '/home/oracle/netshare/redo2g02.log',
    '/home/oracle/backup/nuance/redo2g03.log'
    ) SIZE 25M,
    GROUP 3 (
    '/home/oracle/oradata/nuance/redo3g01.log',
    '/home/oracle/netshare/redo3g02.log',
    '/home/oracle/backup/nuance/redo3g03.log'
    ) SIZE 25M

    [Edited by kgb on 05-28-2002 at 04:52 AM]
    Best wishes!
    Dmitri

  2. #2
    Join Date
    Aug 2001
    Posts
    36
    If you have mirrored the logfile then replace the corrupted one with it ..

  3. #3
    Join Date
    Aug 2001
    Posts
    36
    Yes will do

  4. #4
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Copy the member of the same group to the location and rename it.

    Sanjay

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