QUESTION POSED ON: 08 August 2005
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.
|
