Oracle full recovery database tutorial, oracle Database tutorial

Source: Internet
Author: User

Oracle full recovery database tutorial, oracle Database tutorial

Oracle full recovery database tutorial

Completely recover the data file rman target/list backup summary; check whether there is a backup. If there is no backup, perform full backup first (it should be backup database) now, you can simulate the deletion of data files in the oracle database to find the data file directory, for example,/u01/app/oracle/oradata/ORCL, and delete all the files with the dbf suffix sqlplus/as sysdbashutdown immediate in the folder; an error will be reported because all the data files have been deleted as shutdown abort. If you disable startup forcibly, you will be prompted that the data file cannot be found, and the rman target/restore database of the database cannot be opened normally; in this case, the dbf file in the ORCL folder has been restored to the recover database. Continue to restore the database.

Related Article

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.