Ask the Expert

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

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: