Lost current redolog files
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Lost current redolog files

  1. #1
    Join Date
    Jan 2001
    Posts
    642

    Lost current redolog files

    Hi,

    Today, I lost all my redologs and obviously,I made an incomplete recovery this way:
    As I didn't had the redo log files(including the current log file), I faked up the redo logfiles using 'mkfile'command:

    shutdown abort
    restored the backup datafiles and control files
    mkfile 10485760 redo01.log
    mkfile 10485760 redo02.log
    mkfile 10485760 redo03.log

    startup mount
    recover database until cancel using backup controlfile

    alter database open resetlogs;

    I was under the impression that I might need to use _allow_redolog_corruption = TRUE to recover from this type of disaster but just faking the redo logs helped.

    I am just wondering why oracle did not complain about the missing current redolog and about the 'NEW' redolog files which are not in the 'ORACLE' format.

    Any thoughts.

    Badrinath
    There is always a better way to do the things.

  2. #2
    Join Date
    Jul 2002
    Location
    California
    Posts
    128
    Badrinathn,

    "Congrats"... You will pick the lottery numbers...

    Your redo logs did not have any information in them that was necessary for recovery (i.e. The last checkpoint # was contained in an archive redo log). Oracle just needs to start overwriting the redo logs when the database is opened, it does not verify their structure.
    alapps

    Fast, Cheap, Reliable... Pick Two(2)

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    why on earth you need to fake redo logs when you are doing an incomplete recovery????

  4. #4
    Join Date
    Jul 2002
    Location
    California
    Posts
    128
    Good catch Pando...

    Thought it was a complete recovery...

    the redo's won't be missed until after the INCOMPLETE recovery when the ALTER DATABASE OPEN RESETLOGS was issued...
    alapps

    Fast, Cheap, Reliable... Pick Two(2)

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