-
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
-
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
-
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.
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|