ORACLE 12C - RECOVER ALL ONLINE REDO LOG FILES USING RMAN

 STEP 1:

 Startup the database and check the members in the logfile.

STEP 2:

 Simulate the failure

                                                      

STEP 3:

 Startup the database in mount stage ,connect it to the rman and execute

The command.

                                                          

STEP 4:

 Now you can see the no copy datafile in the spcified location.so rman

Does not know where the files are located.so now we have to catalog

The backup files in the dbs location. 

                                                         

You will see all the files in the dbs location will be corrupted on his

Header.

 STEP 5:

 You can mount the database in nomount mode using pfile and connect

It to the rman.

                                                       

STEP 6:

 The database is in nomount stage on RMAN.so we could restore the

Control file from the backup.

                                                 

STEP 7:

 You can restore the database using rman backup.

                                                            

STEP 8;

And then recover the database,here you can find the error in the log files 

which was log sequence number would be mismatched.

STEP 9:

Disconnect the rman utility and connect to the sql prompt by issue the following command in the pic