V11 SP8
Loading...

Advanced Restore - FlexFrame for Oracle

Table of Contents

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

Use the following steps to restore and recover a database to the same host:

  1. From the CommCell Browser, expand Client Computers > client > Oracle.
  2. Right-click the instance, point to All Tasks and then click Browse and Restore.
  3. Select Latest Backup and click View Content.
  4. Optional: Use non-default Browse and Restore options. See Browse and Restore.
  5. In the right pane of the CommCell Browser window, select the database, and click Recover All Selected.
  6. On the General tab of the Restore Options dialog box:
    1. Select the name of the client computer from the Destination Client list.
    2. Select the Restore Control File check box.
  7. Click OK to close the Restore Options dialog box and 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 Restoring Oracle Container and Pluggable Databases.

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).

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:

  1. From the CommCell Browser, navigate to Client Computers | <Client> | Oracle.
  2. Right-click the <Instance>, point to All Tasks and then click Browse and Restore.
  3. Select Latest Backup and click View Content.
  4. Optional: Use non-default Browse and Restore options. See Browse and Restore.
  5. From the Browse window, select the data you want to restore in the right pane and click Recover All Selected.
  6. Click Advanced.
  1. Click Startup tab.
  2. Select Change Priority.
  3. Select a priority number - 0 is the highest priority and 999 is the lowest priority.
  4. Select the Start up in suspended State check box to start the job in a suspended state.
  5. 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:

  1. From the CommCell Browser, navigate to Client Computers | <Client> | Oracle.
  2. Right-click the <Instance>, point to All Tasks and then click Browse and Restore.
  3. Select Latest Backup and click View Content.
  4. Optional: Use non-default Browse and Restore options. See Browse and Restore.
  5. From the Browse window, select the data you want to restore in the right pane and click Recover All Selected.
  6. Click Advanced.
  7. Click Data Path tab.
  8. Select the MediaAgent from Use MediaAgent list.
  9. Select the Library from Use Library list.
  10. Select the drive pool and drive from Use Drive Pool and Use Drive lists for tape library.
  11. Select the name of the Proxy server  from Use Proxy list, if you wish to restore using a proxy server.
  12. 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:

  1. From the CommCell Browser, navigate to Client Computers | <Client> | Oracle.
  2. Right-click the <Instance>, point to All Tasks and then click Browse and Restore.
  3. Select Latest Backup and click View Content.
  4. Optional: Use non-default Browse and Restore options. See Browse and Restore.
  5. From the Browse window, select the data you want to restore in the right pane and click Recover All Selected.
  6. Click Advanced.
  7. Click Encryption tab.
  8. Type the pass phrase in Pass Phrase box.
  9. Re-type the pass phrase in Re-enter Pass Phrase box.
  10. 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:

  1. From the CommCell Browser, navigate to Client Computers | <Client> | Oracle.
  2. Right-click the <Instance>, point to All Tasks and then click Browse and Restore.
  3. Select Latest Backup and click View Content.
  4. Optional: Use non-default Browse and Restore options. See Browse and Restore.
  5. From the Browse window, select the data you want to restore in the right pane and click Recover All Selected.
  6. Click Advanced.
  7. Click Alerts tab.
  8. Click Add Alert.
  9. From the Add Alert Wizard box, select the required threshold and notification criteria and click Next.
  10. Select the required notification types and click Next.
  11. Select the recipients and click Next.
  12. Click Finish.
  13. 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:

  1. On the CommCell Console menu bar, select the Reports tab.
  2. Click Summary.

    The Report Selection dialog box appears.

  3. If necessary, select Reports | Jobs | Job Summary in the left pane.
  4. On the General tab, select Data Recovery Jobs.
  5. Select the Computers tab.
  6. Select the appropriate client and the appropriate agent.
  7. Click Run.

    The report appears in your default Web browser.

Refer to Restore Job Summary Report.