A database restore might be necessary when the data area or the log area is damaged, to recover from a logical error, or to copy the database.
Oracle restores consist of the following main categories:
-
Full database restore: This is an in-place or out-of-place restore of all database files, the control file, and the server parameter file.
-
Database subset: This is a combination of a restore of any of the following files:
-
Archive logs
-
Oracle control file
-
Database archived redo logs
-
-
Database clones: Create a clone so that you can:
-
Duplicate large databases in a short amount of time
-
Create test environments
-
Retrieve data quickly without intensive resource use on the production environment
-
Alleviate the load on production servers
-
Related Content
You can watch the following videos: