ORA-00313 | Getting Logfile Error on Oracle Database Startup
This was the unexpected error that I faced while starting up my database running on one of my office servers and I was shocked to find out why I got this error.
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'J:\DATABASE\TEXDEC13\REDO011.LOG'
ORA-00312: online log 1 thread 1: 'J:\DATABASE\TEXDEC13\REDO021.LOG'
ORA-00312: online log 1 thread 1: 'J:\DATABASE\TEXDEC13\REDO031.LOG'
Immediately, I checked my alert.log and it was cofirmed that my database was unable to find the Redolog files and hence displayed this error. I looked for the physical existence of the files but as expected, they were also missing from the drive location.
The one thing I didn't get was how these redologs got removed on their own as nobody in my team does that. It's still a mystery to me and I am looking forward for the deep explanation for why this happened but let's just leave it for later.
Solution:
To overcome the above mentioned situation, I simply shutdown the database using command
SQL> shutdown immediate
then startup the database in MOUNT mode
SQL> Startup mount
Then using the below mentioned command to recreate the logfiles
SQL> recover database until cancel;
Database recovery complete.
Finally open the database using resetlogs.
SQL> alter database open resetlogs;
At this point, your new redologs have been automically created and you'll be able to open the database in READ-WRITE mode.
No comments:
Post a Comment