Advanced Restore - FlexFrame for Oracle
- Restoring and Recovering an Entire Database
- To the Same Host
- To a New Host with the Same Directory Structure
- To a New Host with a Different Directory Structure
- To a Previous Point-in-Time
- Restoring from an Offline Backup
- Restoring Individual Datafiles and Tablespaces
- Restoring Archive Logs
- Restoring Control and SP Files
- Recovering a Database
- Restoring Container and Pluggable Databases
- Creating a Duplicate Database
- Creating a Standby Database
- Restoring Database Tables
- Command Line Restores Using RMAN
- Restoring to a Disk (App Free Restore)
- Scheduling a Restore
- Managing Restore Jobs
- Additional Restore Options
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).
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.
Use the following steps to restore and recover a database to the same host:
- From the CommCell Browser, expand Client Computers > client > Oracle.
- Right-click the instance, point to All Tasks and then click Browse and Restore.
- Select Latest Backup and click View Content.
- Optional: Use non-default Browse and Restore options. See Browse and Restore.
- In the right pane of the CommCell Browser window, select the database, and click Recover All Selected.
- On the General tab of the Restore Options dialog box:
- Select the name of the client computer from the Destination Client list.
- Select the Restore Control File check box.
- Click OK to close the Restore Options dialog box and start the restore.
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.
For information, see Restoring an Oracle Database to a Point-in-Time.
For information on how to restore an offline backup, see Restoring from an Oracle Offline Backup.
For information on how to restore datafiles and tablespaces, see Datafiles and Tablespaces Restores for Oracle
For information on how to restore a log files, see Restoring Archive Logs for Oracle
For information on how to restore a control file or an SP file, see Restoring Control and Server Parameter Files for Oracle.
For information on how to recover a database, see Recovering an Oracle Database
For information on how to restore container and pluggable databases, see Restoring Oracle Container and Pluggable Databases.
For information on how to create a standby database, see Database Duplication for Oracle.
For information on how to duplicate a database see Creating an Oracle Standby Database.
For information on how to restore Oracle tables, see Oracle Table Restores.
See Restore Using the Application Command Line Interface (RMAN Scripts) for details.
For information on how to perform an application-free restore, see Restoring an Oracle Database to Disk (Application-Free Restore).
For information on configuring a restore schedule, see Schedule Restores.
For information on how to manage the job, see Job Controller Overview.
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.
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:
|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:
|Refer to Change Data Path.|
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:
|Refer to Data Encryption.|
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:
|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:
|Refer to Restore Job Summary Report.|