This is only for the proof of concept: Using a binary backup of controlfile to recover the database.
Here is what I have done:
1. The database is healthy, up and running.
2. alter database backup controlfile to '/export/home/oracle/bkp.ctl';
3. shutdown abort
4. rm /u01/oradata/control01.ctl (This is the only ctl file.)
5. cp /export/home/oracle/bkp.ctl /u01/oradata/control01.ctl
6. Startup mount;
SQL> alter database open;
alter database open
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
Please suggest , how should I approach the solution..??
You must use RESETLOGS clause when opening the DB, because by the time you backed up the control file and shut down the db, Oracle could have changed the log sequence number, thus needing it to be reset back to 1, archiving current logs if needed.