Q
Problem solve Get help with specific problems with your technologies, process and projects.

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.

Brian Peasland
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 last published in August 2005

Dig Deeper on Oracle database backup and recovery

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.

Meet all of our Oracle Database / Applications experts

View all Oracle Database / Applications questions and answers

Start the conversation

Send me notifications when other members comment.

Register

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

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close