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
-
Note
If you are using Oracle Standard Edition database, set the number of restore streams (number of channels specified in the RMAN script) to 1. By default, the Commvault software sets the number of restore streams to 2. Because Oracle Standard Edition only supports one stream, the restore will fail if the number of restore streams is set to 2 or more.
Related Content
You can watch the following videos:
