Skip to Main Content
  • Questions
  • What does this command do "Recover database using backup controlfile until cancel "

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Fahd.

Asked: August 16, 2023 - 8:31 am UTC

Last updated: August 25, 2023 - 4:45 am UTC

Version: 11.2.0.4

Viewed 10K+ times! This question is

You Asked

Hi Team,

i want to know in detail what does above the above command do?


i was getting this error "ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr]" and database was stuck in Mount mode. i followed following steps and was able to Open the database, but i don't understand what this command did actually do. please help explain.

SQL> recover database using backup controlfile until cancel ;
D:\APP\SONI\ORADATA\ORCL\REDO02.LOG
Log applied.
Media recovery complete.

SQL> Alter database open resetlogs ;

Database altered.

and Connor said...

When you recover a database, the database needs to know "what it is", ie, what are the datafiles that comprise my database, how up to date are they, etc. It gets all of this from the controlfile.

The "kcratr_nab_less_than_odr" indicates a potential controlfile corruption (pro tip: if you get an ora-600, call Support *before* doing anything to make sure you don't get yourself into a worse spot).

Because of that potential corruption, we are telling the database to use a We are using a BACKUP (ie, not current) controlfile. That means we can use it to locate the datafiles but you CANNOT rely on the controlfile to indicate how up to date the datafiles are, or where potential archivelogs could be located for recovery etc, and we cannot rely on its contents to tell us when the recovery is complete DONE.

So now we will start with the datafiles as is, and use the init.ora parameters to locate archive logs and keep recovering until you say stop (cancel). We cant automatically work out when the stop, because are cannot rely on that information from the backup controlfile.

Rating

  (2 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

which backup control file ?

A reader, August 21, 2023 - 6:25 am UTC

There may be many RMAN backups of control file available, which backup of the control file will be used ? or there maybe no backup of control file
Connor McDonald
August 25, 2023 - 4:44 am UTC

its picked up from your spfile

read content of control file

A reader, August 21, 2023 - 6:42 am UTC

Controlfile is kind of a black box to us, can we see the content of controlfile in human readable format? it will help us to understand backup and recovery.
Connor McDonald
August 25, 2023 - 4:45 am UTC

alter database backup controlfile to trace

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database