Oracle Table Restores

Restore Oracle tables when you need to recover tables that have been logically corrupted or lost or after the table structure has been modified.

You can restore the database tables from an online full backup, if the table browse option was enabled in the associated subclient before performing the backup.

When you restore database tables, the Commvault software automatically creates an auxiliary instance. For the restore to succeed, the host must have enough free disk space for the auxiliary instance.

You can configure the Commvault to perform a schema-level restore when a user selects all the tables in a schema. For information on configuring this option, see Configuring Oracle Schema-Level Restores.

When you perform a table level restore, the software creates a log file called restore.out in the job results directory that provides the details for the job. By default the directory is: /opt/Commvault/iDataAgent/jobResults/CV_JobResults/2/0/<jobid>.

If you use a catalog database, the Commvault software automatically uses a targetless connection for the table-level restore.

Note: If you use Oracle 12c or a more recent version, you can only use this procedure for databases that are not Container Databases (CDB). To restore tables in Container Databases, you must use the RMAN command line. For more information, see Restoring Tables in Container Databases using the RMAN Command Line.

Best Practice: Include the parent tables with all dependent tables so that the reference constraints remain intact.

Important: Install Oracle patch 21900992 before you perform a table-level restore without connecting to the target database so that the operation does not time out at the end of the operation.

Last modified: 1/27/2021 8:32:55 PM