root> su - oracle
oracle> export ORACLE_SID=venu
oracle> sqlplus / as sysdba
SQL> startup
oracle> cd /u01/app/oracle/venu
oracle venu> ls
oracle venu> cp *.* /u01/coldbkp
SQL> select name from v$controlfile;
oracle venu> rm controlo1.ctl
SQL> conn scott/tiger
SQL> shut abort
oralce coldbkp> ls
oracle coldbkp> cp control01.ctl /u01/app/oracle/venu
SQL> startup mount
SQL> recover database using backup controlfile until cancel;
specify log : auto
SQL> recover cancel;
SQL> select member from v$logfile;
SQL> select group#,status from v$log;
SQL> recover database using backup controlfile until cancel;
specify log : /u01/app/oracle/venu/redo02.log
We need to apply the current log first, if failed then apply the active log.
SQL> select open_resetlogs from v$database;
This will show either to open the database with resetlogs or not.
SQL> alter database open resetlogs;
SQL> shut immediate
Dont forget to take the backup of the database after recovery when the database is opened with resetlogs.
oracle venu> ls
oracle venu> cp *.* /u01/coldbkp
