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:
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.