Q

Receiving ORA-313 and ORA-312 errors when trying to open database

I have a cold backup of my Oracle 9i database. Recently, I tried to start it up but the database could not be opened. I decided to use the cold backup to restore the database, but the problem remained.

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.

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

Dig deeper on Oracle database backup and recovery

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

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:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close