Recovery from complete loss of all online redo log files using RMAN

Database name and version 

Member logfile Name

Remove redo log file for safer side I'm taking as backup.

Note: - If one or all of the online redo logfiles are delete then the database hangs and in the alert log file we can see the following error message:

Shutdown the database

Mount the database!

Using RMAN connect to the target database.

Recover database!

run {

set until sequence 12;

restore database;

recover database;

alter database open resetlogs;

}

Caution: Your use of any information or materials on this website is entirely at your own risk. It is provided for educational purposes only.