Results 1 to 2 of 2

Thread: Redo log

  1. #1
    Join Date
    Jun 2003

    Unanswered: Redo log

    Hi all,

    I've lost my current online redolog file.What should I do the next step?

    That means I've lost the data within that log file?


  2. #2
    Join Date
    Jan 2004
    If you didn't have the logfile mirrored then yes, you will have lost data.

    Assuming you are in archivelog mode, you will need to restore the datafiles and recover up to the lost redo log and then open resetlogs.

    You should then shutdown normal and take a full backup (because of the resetlogs). And mirror your redo logs.

Posting Permissions

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