Receiving ORA-313 and ORA-312 errors when trying to open database
I already have a cold backup of my Oracle 9i database. Recently, I tried to start it up but the database was not able to reach open state (it can only be in mount state). So I decided to use the cold backup to restore the database. I shut down the database, then I removed all dbf, ctl and redo files from their location, then I copied them back from the cold backup. Unfortunately, when I tried to start up the database, the problem remained and the database could not be opened.
This is the output I've got:
SQL> startup ORACLE instance started.
Total System Global Area 135352820 bytes
Fixed Size 455156 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 679936 bytes
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/oracle/oradata/SIEMENS/redo01.log'
Thank you for your help.
The following is the cause of your problem. The ORA-313 error is simply telling you that a redo log file cannot be accessed. The ORA-312 message is telling you which file cannot be opened. There could be a couple of reasons why you are getting this error.
- The file simply does not exist.
- There is a hardware error stopping Oracle from accessing this file.
- Oracle does not have appropriate permissions to read the file or its directory.
- There is corruption in the log file.
You'll have to determine which one of these causes is the real problem and solve it appropriately.
This was first published in August 2005