Being a DBA we must have knowledge on all kind of situation come across database’s life maintenance. We all are aware that CDR  (Controlfile, Datafile, Redologfile) plays a most important role in Oracle database. With the help of backup, we can restore the database .

In this article, we are going to learn about the recovery from controlfile in noarchivelog mode. As per my interviews, the experienced interviewer wants to dig out your knowledge of  CDR (Controlfile, Datafile, Redologfile) in the Backup and Recovery section. I hope this content will help you to solve database issues.

This approach, using the controlfile coming from the autobackup, is different compared with the copy of an available multiplexed copy of a current controlfile because there you have to perform an incomplete recovery of your database while using the auto backup controlfile you have already a controlfile with SCN consistent with all your datafiles

I shut down my database…

and then removed all my datafiles, redolog and current controlfile

From rman console I typed the following commands:

And now I’m able to at least mount my database

and check that my database is using a backup controlfile

From the rman console issue the restore command.

Finally open your database with the resetlogs option

Your database is now available again.

Source

Leave a Reply