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.
This is the output I've got:
Continue Reading This Article
Enjoy this article as well as all of our content, including E-Guides, news, tips and more.
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 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.
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.
Meet all of our Oracle Database / Applications experts
View all Oracle Database / Applications questions and answers
Start the conversation
0 comments