Database recovery controlfile
Scenario :
- 10 day old backup of database
- Archive logs as of yesterday
Database crashed.
I will now restore the datafiles and create a new controlfile because the 10 day old controlfile will not pick up info of the new archive logs.
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 289406976 bytes
Fixed Size 1248576 bytes
Variable Size 113246912 bytes
Database Buffers 167772160 bytes
Redo Buffers 7139328 bytes
SQL> alter database backup controlfile to trace;
alter database backup controlfile to trace
*+
ERROR at line 1:
ORA-01507: database not mounted
SQL> alter database mount;
alter database mount
*+
ERROR at line 1:
ORA-00205: error in identifying control file, check alert log for more info
I can't mount because no controlfile exists and I can't backup controlfile to trace because the database is not mounted.
What to do now ?