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: