RMAN recovery using redo logs

Note down current redo log if possible

Archive redo log if possible using alter system switch logfile;

Finally Recover redo logs if needed before opening database in resetlogs:

If not able to recover the redo logs, try logminer to get transactions.

SQL> RECOVER DATABASE using BACKUP CONTROLFILE UNTIL CANCEL;

ORA-00279: change 27615990 generated at 10/02/2013 15:08:30 needed for thread 1

ORA-00289: suggestion :

/u00/app/oracle/product/11.2.0.3/dbs/arch1_1513_813415794.dbf

ORA-00280: change 27615990 for thread 1 is in sequence #1513

Specify log: {=suggested | filename | AUTO | CANCEL}

/u01/oradata/hr91cap/redo03.dbf

ORA-00310: archived log contains sequence 1512; sequence 1513 required

ORA-00334: archived log: '/u01/oradata/hr91cap/redo03.dbf'

SQL> RECOVER DATABASE using BACKUP CONTROLFILE UNTIL CANCEL;

ORA-00279: change 27615990 generated at 10/02/2013 15:08:30 needed for thread 1

ORA-00289: suggestion :

/u00/app/oracle/product/11.2.0.3/dbs/arch1_1513_813415794.dbf

ORA-00280: change 27615990 for thread 1 is in sequence #1513

Specify log: {=suggested | filename | AUTO | CANCEL}

/u01/oradata/hr91cap/redo01.dbf

Log applied.

Media recovery complete.

SQL>

SQL>

SQL>

SQL> RECOVER DATABASE using BACKUP CONTROLFILE UNTIL CANCEL;

ORA-00279: change 27616065 generated at 10/02/2013 15:11:04 needed for thread 1

ORA-00289: suggestion :

/u00/app/oracle/product/11.2.0.3/dbs/arch1_1513_813415794.dbf

ORA-00280: change 27616065 for thread 1 is in sequence #1513

Specify log: {=suggested | filename | AUTO | CANCEL}

/u01/oradata/hr91cap/redo02.dbf

ORA-00310: archived log contains sequence 1511; sequence 1513 required

ORA-00334: archived log: '/u01/oradata/hr91cap/redo02.dbf'

SQL> alter databse open read only;