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.