OCP notes. Thank you very much for the blog. Thank you.

Source: Internet
Author: User

The database has opened OCP notes. Thank you very much for the blog. Thank you.

I _like_cpp http://blog.csdn.net/ I _like_cpp
 

Among them, OCP has a question like this:

Q606. you realize that the control file is damaged in your production database. After restoring the control file from autobackup, what is the next step that you must do to proceed with the database recovery?

 

A. Mount the database

B. Open the database in Normal Mode

C. Open the database in restricted mode

D. Open the database with the resetlogs Option

 

Answer:

Recovering using RMAN backups restoring the control file from the autobackup

Restoring the control file from an autobackup is similar to the steps you use to restore an spfile from an autobackup.

RMAN> startup nomount;

RMAN> restore controlfile from autobackup;

RMAN> alter database Mount;

RMAN> recover database;

RMAN> alter database open resetlogs;

Note that since there is no control file, you have to open the database with nomount and then restore the control file. after you mount the database, you must recover the database, because the backup control file contains information about an older version
Of the database. for the same reason, you must open the database with resetlogs. RMAN restores the control file to all locations specified by theinitialization parameter control_files. if one or more of those locations are still not available, you will have
To edit the control_files parameter to specify alternative locations or temporarily restore the control file to adifferent location;

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.