Error while recovering Current Online redo log file
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Error while recovering Current Online redo log file

  1. #1
    Join Date
    May 2002
    Posts
    163

    Error while recovering Current Online redo log file

    Hi,

    I lost my current redo log file.

    1. At the time of starting my database I got this error
    ORA-00313: open failed for members of log group 2 of thread 1
    ORA-00312: online log 2 thread 1: 'D:\ORACLE\ORADATA\TEST\REDO02.LOG'

    2. I did startup mount and query the same in below.
    SQL> select * from v$log;

    GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM
    ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------
    1 1 474 1048576 1 YES INACTIVE 132773 30-APR-03
    2 1 476 1048576 1 NO CURRENT 152776 30-APR-03
    3 1 475 1048576 1 YES INACTIVE 132774 30-APR-03

    3. Though it was a current logfile I did the following

    SQL> recover automatic database until cancel;
    Media recovery complete.

    4. My database is now showing the following

    SQL> select * from v$logfile;

    GROUP# STATUS MEMBER
    ---------- ------- ---------------------------------------------------------------------------------
    1 D:\ORACLE\ORADATA\TEST\REDO01.LOG
    2 D:\ORACLE\ORADATA\TEST\REDO02.LOG
    3 STALE D:\ORACLE\ORADATA\TEST\REDO03.LOG

    SQL> select * from v$log;

    GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM
    ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------
    1 1 474 1048576 1 YES INACTIVE 132773 30-APR-03
    2 1 476 1048576 1 NO CURRENT 152776 30-APR-03
    3 1 475 1048576 1 YES INACTIVE 132774 30-APR-03


    5. But when I tried to open my database I am getting the following error ***** but I can assure that my log directory is perfectly existing.

    SQL> alter database open resetlogs;
    alter database open resetlogs
    *

    ERROR at line 1:
    ORA-00344: unable to re-create online log 'D:\ORACLE\ORADATA\TEST\REDO03.LOG'
    ORA-27086: skgfglk: unable to lock file - already in use
    OSD-04002: unable to open file
    O/S-Error: (OS 5) Access is denied.

    WHAT CAN BE THE REASON? WHAT TO DO NOW?

    Regards
    Nwcomer
    Student

  2. #2
    Join Date
    Feb 2002
    Posts
    70
    Check up with your operating system. By looking at the error it seems like the problem is at OS level. OS is not allowing to gain access on the log file.

    HTH
    ________________
    ShanDJ

  3. #3
    Join Date
    May 2001
    Posts
    736
    Use ALTER DATABASE DROP LOG GROUP the one which is giving u problem and use ALTER DATABASE ADD LOG GROUP to recreate the new one.

  4. #4
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    Hi,
    It could be one of the following reason

    from v$log you can see that from status column the file
    'D:\ORACLE\ORADATA\TEST\REDO03.LOG' is "STALE'.
    This means that LGWR cannot write into this file.
    It could be because
    1.when a log switch occurs and if the log file is not accessable since its been archived then oracle instance stops till its active again.

    From the below error message i feel the above reason is more valid because of 'D:\ORACLE\ORADATA\TEST\REDO03.LOG'
    ORA-27086: skgfglk: unable to lock file - already in use"

    Please do a log switch and trying opening the db.

    regards
    anandkl
    anandkl

  5. #5
    Join Date
    May 2001
    Posts
    736
    Before u go through the steps mentioned by me follow the commands bellow

    ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3;

    If this option is also not solving your problem then u have to drop that group and create new one.

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