Recover database using Backup Controlfile until cancel

Source: Internet
Author: User

Http://searchoracle.techtarget.com/answer/Recover-database-using-backup-controlfile-until-cancel

What's checked or what happens when we "run recover database using Backup controlfile until cancel;"? What is the does this command?

If you were to recover the database with a current control file, Oralce'll know the last SCN of the last checkpoint. So, Oracle can use the information on the archived and online redo logs to apply recovery up to that SCN. This was called a "complete" recovery.

The

If do not has the current control file, your option was to use a backup controlfile. Which means Oracle does not know the SCN to stop applying recovery. So we tell Oracle that is using a "backup Controlfile" and that you'll tell it when to stop applying redo by reply ing "Cancel." When Oracle starts recovery, it looks at the datafiles to know the last time a checkpoint is performed on the datafile. Oracle now knows to start applying recovery to the datafile for all Scns after the SCN in the datafile header. Oracle rolls forward transactions. But the Oracle does not know if to stop, and eventually, the Oracle applies recovery in all of your archived redo logs. You can then tell Oracle to use the redo in the online redo logs. Oracle would ask you where to find more redo. At the this point, the it to quit applying redo by replying CANCEL.

Hopefully, you never has to use the This command. This is because multiplex your control files and has three copies of the control file, all on different disk units. If you lose a disk unit, you use the control files on the other disk units. The only time you need this command was when you lose all of the your control files. Either use a binary backup of the control file or re-create the control file with the Create Controlfile Command and then recover with the backup control file.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.