Database full recovery and restore right upto the last online redolog transaction:

 

Database full recovery and restore right upto the last online redolog transaction:

Verify which backup you have:

Rman target /

List backup;

Inr 0

Incr 1

               

    

Spool remove_database_files.sh

/

Spool off

Exit

Vi remove_database_files.sh

:wq

Sh ./remove_database_files.sh

At this point the database data files got completely deleted from os level

How to restore and recover full database at this point:

List backup:

RMAN>restore database;

Here it will restore from incr 0

 

As you see it will restore from _c2kxcltc_bkp

Which has incr 0 backup

2.

RMAN>recover database;

Note: here recover database will recover from incr 1

See it includes incr 1

Finally

RMAN>Alter database open;

Exit

Sqlplus / as sysdba

Exit

To check trace log

Cd /home/oracle/diag/rdbms/orcl/trace

Vi ale*.log

You can see

Recovery of online redo log