lost current redo log
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: lost current redo log

  1. #1
    Join Date
    Apr 2001
    Posts
    46

    Angry

    Hi
    I need some help

    I lost the current logfile. In the group I have 2 files, one of the 2 files is corrupted. My database is mount.
    I try to recover database but oracle doesn't want to open with resetlogs.

    I try to open the database with oracle's docs but no one
    works.

    Is there someone who have a little idea, please.

    YT
    yt

  2. #2
    Join Date
    Nov 2000
    Posts
    212
    not a big deal IF NOT ALL GROUP MEMBERS LOST:
    drop corrupted log file:

    ALTER DATABASE DROP LOGFILE MEMBER '/oracle/dbs/log2b.f';

    add new
    ALTER DATABASE ADD LOGFILE MEMBER '/oracle/dbs/log2b.f' REUSE TO GROUP 2;

    Read backup and recovery guide, media recovery scenarious chapter.

  3. #3
    Join Date
    Apr 2001
    Posts
    46
    I try to follow your method but it sent this message
    ORA-00362: member is required to form a valid logfile in group 1

    In fact , I 've lost the 2 current redo log file. I manage to have a backup, but only one of the 2 redo log.

    I tried to recover database until cancel but Oracle doesn't want it says :
    ORA-01194: file 1 needs more recovery to be consistent

    I tried to switch the redo log, but I can't the database is mount.

    I tried to drop the group, but I can't because it is the current group.

    yt
    yt

  4. #4
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    This is a delicate issue. Generally, when 1 of the members is corrupted, Oracle suggests you 'clear' the log member. If both are corrupted, you probably would have to perform an incomplete recovery until the most recent arch redo log file. I strongly suggest you call Tech Support.

  5. #5
    Join Date
    Nov 2000
    Posts
    212
    if you REALLY lost ALL CURRENT log files and HAVE NO BACKUPS, then there is one parameter

    _ALLOW_RESETLOGS_CORRUPTION = TRUE

    but just try to get over w/o this parameter. After you open db using it, it is recomended to exp/imp into new database.

  6. #6
    Join Date
    Feb 2001
    Posts
    44
    You are getting the error 00362 because any group must have at least 2 members.Try to create a third one and them try to drop the corrupted one.
    Best of Luck

  7. #7
    Join Date
    Apr 2001
    Posts
    46

    Wink

    Originally posted by vishywish
    You are getting the error 00362 because any group must have at least 2 members.Try to create a third one and them try to drop the corrupted one.
    Best of Luck
    thank you everybody

    I managed to open the database.
    I 've added a third member, It was OK
    I've shut down the database then open it.
    The database was mounted, it couldn't open. So I've clear the logfile group and then tried to open it with option resetlogs.
    Now it is opened.

    Thank you very much becasuse I hadn't a cold backup, but only one backup of a redo log file.

    YT

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