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
Database mounted.
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.

    Requires Free Membership to View

    Login

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.

  1. The file simply does not exist.
  2. There is a hardware error stopping Oracle from accessing this file.
  3. Oracle does not have appropriate permissions to read the file or its directory.
  4. 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

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top