Advanced Restore - FlexFrame for Oracle

Restoring and Recovering an Entire Database

When the database is corrupted or lost, you can restore and recover it from the latest offline or online full backup (depending on how the subclient was configured for backups).

To the Same Host

By default, the database is restored to the same location from where it was backed up. Once the database is restored, it is recovered to the current time.

Before You Begin

Place the database in MOUNT mode.

Procedure

From the CommCell Browser, go to Client Computers > client > Oracle.
Right-click the instance, then go to All Tasks > Browse and Restore.

The Browse and Restore Options dialog box appears.
Select Latest Backup, and then click the View Content button.
Optional: Use non-default browse and restore options. For more information, see Browse and Restore.
Select the database, and then click the Recover All Selected button.

The Oracle Restore Options dialog box appears.
Click Restore in place, and then click Next.

The Oracle In Place Restore Options dialog box appears.
On the General tab select the name of the client computer from the Destination Client list.
Select the Restore Control File check box.
Click OK to start the restore.

To a New Host with the Same Directory Structure

If the computer on which you hosted a database is damaged or destroyed, you can restore and recover the lost database with the same directory structure on to a new host. For information, see Restoring an Oracle Online Backup to a New Host (Cross-Machine Restore) with the Same Directory Structure.

To a New Host with a Different Directory Structure

For information, see Restoring an Oracle Online Backup to a New Host (Cross-Machine Restore) with a Different Directory Structure.

To a Previous Point-in-Time

For information, see Restoring an Oracle Database to a Point-in-Time.

Restoring from an Offline Backup

For information on how to restore an offline backup, see Restoring from an Oracle Offline Backup.

Restoring Individual Datafiles and Tablespaces

For information on how to restore datafiles and tablespaces, see Datafiles and Tablespaces Restores for Oracle

Restoring Archive Logs

For information on how to restore a log files, see Restoring Archive Logs for Oracle.

Restoring Control and SP Files

For information on how to restore a control file or an SP file, see Restoring Control and Server Parameter Files for Oracle.

Recovering a Database

For information on how to recover a database, see Recovering an Oracle Database

Restoring Container and Pluggable Databases

For information on how to restore container and pluggable databases, see the "Restoring Oracle Container and Pluggable Databases" section on this page.

Creating A Duplicate Database

For information on how to create a standby database, see Database Duplication for Oracle.

Creating a Standby Database

For information on how to duplicate a database see Creating an Oracle Standby Database.

Restoring Database Tables

For information on how to restore Oracle tables, see Oracle Table Restores.

Command Line Restores Using RMAN

See Restore Using the Application Command Line Interface (RMAN Scripts)for details.

Restoring to Disk (App Free Restore)

For information on how to perform an application-free restore, see Restoring an Oracle Database to Disk (Application-Free Restore).

Restoring Oracle Container and Pluggable Databases

Commvault supports the restore of container and pluggable databases.

If you have backed up an entire container database you can restore the entire container database, a single pluggable database, or multiple pluggable databases.

For more information, see Restoring Oracle Pluggable Databases.

Scheduling a Restore

For information on configuring a restore schedule, see Schedule Restores.

Managing Restore Jobs

For information on how to manage the job, see Job Controller Overview.

Additional Restore Options

Several additional options are available to further refine your restore operations. The following table describes these options, as well as the steps to implement them.

Option	Description	Related Topics
Startup Options	The Startup Options are used by the Job Manager to set priority for resource allocation. This is useful to give higher priority to certain jobs. You can set the priority as follows: From the CommCell Browser, go to Client Computers > client > Oracle. Right-click the instance, then go to All Tasks > Browse and Restore. The Browse and Restore Options dialog box appears. Select Latest Backup, and then click the View Content button. Optional: Use non-default browse and restore options. For more information, see Browse and Restore. Select the database, and then click the Recover All Selected button. The Oracle Restore Options dialog box appears. Select the option for the type of restore operation, and then click Next. An Oracle restore options dialog box appears. Click Advanced. Click Startup tab. Select Change Priority. Select a priority number - 0 is the highest priority and 999 is the lowest priority. Select the Start up in suspended State check box to start the job in a suspended state. Click OK.	Refer to Job Priority and Priority Precedence.
Data Path Options	The data recovery operations use a default Library, MediaAgent, Drive Pool, and Drive as the Data Path. You can use this option to change the data path if the default data path is not available. Follow the steps given below to change the default data path: From the CommCell Browser, go to Client Computers > client > Oracle. Right-click the instance, then go to All Tasks > Browse and Restore. The Browse and Restore Options dialog box appears. Select Latest Backup, and then click the View Content button. Optional: Use non-default browse and restore options. For more information, see Browse and Restore. Select the database, and then click the Recover All Selected button. The Oracle Restore Options dialog box appears. Click Advanced. Click Data Path tab. Select the MediaAgentfrom Use MediaAgent list. Select the Library from Use Library list. Select the drive pool and drive from Use Drive Pool and Use Drive lists for tape library. Select the name of the Proxy server from Use Proxy list, if you wish to restore using a proxy server. Click OK.	Refer to Change Data Path.
Encryption	If the client's data is encrypted with a pass phrase, you must enter the pass-phrase to start the data recovery operation. Follow the steps given below to enter the pass-phrase: From the CommCell Browser, go to Client Computers > client > Oracle. Right-click the instance, then go to All Tasks > Browse and Restore. The Browse and Restore Options dialog box appears. Select Latest Backup, and then click the View Content button. Optional: Use non-default browse and restore options. For more information, see Browse and Restore. Select the database, and then click the Recover All Selected button. The Oracle Restore Options dialog box appears. Select the option for the type of restore operation, and then click Next. An Oracle restore options dialog box appears. Click Advanced. Click Encryption tab. Type the pass phrase in Pass Phrase box. Re-type the pass phrase in Re-enter Pass Phrase box. Click OK.	Refer to Data Encryption.
Alerts	This option enables users or user groups to get automatic notification on the status of the data recovery job. Follow the steps given below to set up the criteria to raise notifications/alerts: From the CommCell Browser, go to Client Computers > client > Oracle. Right-click the instance, then go to All Tasks > Browse and Restore. The Browse and Restore Options dialog box appears. Select Latest Backup, and then click the View Content button. Optional: Use non-default browse and restore options. For more information, see Browse and Restore. Select the database, and then click the Recover All Selected button. The Oracle Restore Options dialog box appears. Select the option for the type of restore operation, and then click Next. An Oracle restore options dialog box appears. Click Advanced. Click the Alerts tab. Click Add Alert. From the Add Alert Wizard box, select the required threshold and notification criteria and click Next. Select the required notification types and click Next. Select the recipients and click Next. Click Finish. Click OK.	Refer to Alerts and Notifications.
CommCell Readiness Report		Refer to CommCell Readiness Report.
Restore Job Summary Report	The Restore Job Summary Report provides you with information about all the data recovery jobs that are run in last 24 hours for a specific client and agent. You can get information such as failure reason, failed objects, job options, and so on. It is useful to run this report after performing the restore. Follow the steps given below to generate the report: On the CommCell Console menu bar, select the Reports tab. Click Summary. The Report Selection dialog box appears. If necessary, select Reports \| Jobs \| Job Summary in the left pane. On the General tab, select Data Recovery Jobs. Select the Computers tab. Select the appropriate client and the appropriate agent. Click Run. The report appears in your default Web browser.	Refer to Restore Job Summary Report.