Differences between restore and recover in Oraclerman

Source: Internet
Author: User
Difference between recover and restore in Oraclerman: restorejustcopythephysicalfile, recoverwillconsistentthedatabase. restore is

Differences between recover and restore in Oracle rman: restore just copy the physical file, recover will consistent the database. restore is

Differences between recover and restore in Oracle rman:

Restore just copy the physical file, recover will consistent the database.

Restore is a file-level restoration. Physical file restoration.
A recover is a data-level recovery. Logical recovery, such as archiving and redo logs of applications, must be synchronized to ensure consistency.

In my own words, we use restore to copy the backup file to the database directory for replacement, and then use recover for some processing, so that the database will return to normal.

1. restore command: Used to restore data files that have been backed up.
(1) restore all data files in the restore database.
(2) restore tablespace to restore data files in a specific tablespace.
(3) restore datafile to restore a specific data file.
(4). restore controlfile restores the control file.
(5) restore archivelog to restore archived log files.

2. recover command: Use the recover command when the database needs to apply archive log files to restore data files. Using this command, the database system automatically applies archived log files.
(1) recover all data files in the database.
(2) recover tablespace to restore data files in a specific tablespace.
(3) recover datafile to restore a specific data 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.