CommCell Console SAP Oracle Restores

Table of Contents

Restoring Full Databases

You use a full database restore to restore all datafiles, and control files to a target database. You can restore from an offline or online backup to the original source or a new location.

Restoring from an Online Backup

Online backups require a further roll forward operation to get them to a consistent database state.

You can recover the database to the current time if all the archived online redo logs are available, otherwise recover the database to a point-in-time.

Note: After you restore the control file, you must reset the logs before you open the database.

Before You Begin

  1. Perform a full backup on a SAP for Oracle online subclient.
  2. Set the database to the correct mode defined in the table, or set the SnapProtect software to automatically move the database to the correct mode before the restore.
    Control File in the Restore Required Database Mode
    Control file is included in the restore NOMOUNT
    Control file not included in the restore MOUNT

Procedure

  1. From the CommCell Browser, expand Client Computers > client > SAP Oracle.
  2. Right-click the instance, point to All Tasks and then click Browse and Restore.
  3. On the Browse and Restore dialog box, 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 to restore in the right pane and click Recover All Selected.

    The Restore Options dialog box appears.

  6. On the General tab:
    1. Select the name of the client computer from the Destination Client list.
    2. Select the Restore Control File check box.
    3. Select the Restore Data check box.
    4. Select the Restore Archive Log check box.
    5. Optional: Select the Recover check box to recover the database.
    6. Verify that the status of the database is STARTED. Click Refresh to refresh the status.
    7. Click Advanced.

      The Advanced Restore Options dialog box appears.

  7. To set the SnapProtect software to automatically move the database to the correct mode before the restore, select the Switch Database mode for Restore check box.
  8. On the Restore tab, select the restore log option.
    Expand All

    Restore all logs

    Select the All option

    Restore logs by a specific log time

    Select By Log Time and enter the Start and End time in the boxes.

    If you only specify the start log time and not the end log time, the system restores all logs from the start time to the current time.

    If the restore includes the database, see Restoring to a Point-in-Time to restore the database to a specific point-in-time.

    Restore by specifying a serial number

    Select the By Log Serial Number option.

    Check the Start or End check boxes and enter the serial numbers.

    The following are the rules for specifying the serial number.

    • The end serial number must be greater than or equal to the start serial number
    • The start and the end serial number cannot be 0
    • The range of serial numbers restore can be from one or more backup jobs or from a part of a job and from one or more cycles
    • When you specify only the start sequence number, logs starting from that sequence number to the current sequence number are restored

    Restore logs to a different location

    Enter the new path in the Target Directory box.

  9. Optional: Select the restore options.
    Expand All

    Open the database after the restore

    After a restore, set the SnapProtect software to automatically open the database. When the database is open, it records transactions.

    On the Options tab, select the Open DB check box.

    Validate the restore

    Validation verifies that the backup copies of the data and logs are intact and usable for restores. BR*Tools simulates the restore job without the media to determine whether the restore can be successfully performed.

    When a validate job is complete, you can view the job log files to identify and correct any issues.

    On the Options tab, select the Backup Validations Only check box.

    Select one verification option.

    • DB Verify - The SnapProtect software performs a temporary database restore and then verifies the files for database block consistency.
    • RMAN Validate - The Oracle Recovery manager performs a temporary database restore and then verifies the files for database block consistency. The restored files are deleted after the verification.
    • Only Backup Inquiry - BACKINT displays the list of available backups to validate.

    Restore the control file to an alternate location

    You can use this option when the database is in the MOUNT state.

    The SnapProtect software restores the control file to the location you specify. The control file is not replicated to the database. You can manually replicate the files to the database.

    On the Ctrl Files tab:

    1. Select the Restore Control File As check box.
    2. Type the full path where you want to restore the control file.
  10. Click OK to close the Advanced Restore Options dialog box.
  11. Click OK to close the Restore Options dialog box and start the restore.

Restoring from an Offline Backup

Offline backups taken after the database is cleanly shutdown, and they do not require a roll forward operation to get them to a consistent database state.

You can apply the redo log or incremental backups for the latest database changes.

Note: After you restore the control file, you must reset the logs before you open the database.

Before You Begin

  1. Perform a full backup on a SAP for Oracle offline subclient.
  2. Set the database to the correct mode defined in the table, or set the SnapProtect software to automatically move the database to the correct mode before the restore.
    Control File in the Restore Required Database Mode
    Control file is included in the restore NOMOUNT
    Control file not included in the restore MOUNT

Procedure

  1. From the CommCell Browser, expand Client Computers > client > SAP for Oracle.
  2. Right-click the instance, point to All Tasks and then click Browse and Restore.
  3. On the Browse and Restore dialog box, select Latest Backup and click View Content.
  4. On the Browse view, select the data to restore in the right pane and click Recover All Selected.
  5. From the Browse window, select the data to restore in the right pane and click Recover All Selected.

    The Restore Options dialog box appears.

  6. On the General tab:
    1. Select the name of the client computer from the Destination Client list.
    2. Select the Restore Control File check box.
    3. Select the Restore Data check box.
    4. Optional: Select the Recover check box to recover the database.
    5. Verify that the status of the database is STARTED. Click Refresh to refresh the status.
    6. Click Advanced.

      The Advanced Restore Options dialog box appears.

  7. To set the SnapProtect software to automatically move the database to the correct mode before the restore, select the Switch Database mode for Restore check box.
  8. Reset the database. On the Options tab, select the Reset Database check box.
  9. Optional: Select the restore options.
    Expand All

    Open the database after the restore

    After a restore, set the SnapProtect software to automatically open the database. When the database is open, it records transactions.

    On the Options tab, select the Open DB check box.

    Reset the database and logs.

    By default, the database is automatically set to open, and the logs are reset.

    If you reset the logs to an open state, you can then reset the database.

    On the Options tab, select the Reset Database check box and one of the following Reset Log options:

    • To open the database without the RESETLOGS option, select None.
    • To open the database with the RESETLOGS option, select Yes.
    • To open the database with the NORESTLOGS option, select No.

    Validate the restore

    Validation verifies that the backup copies of the data and logs are intact and usable for restores. BR*Tools simulates the restore job without the media to determine whether the restore can be successfully performed.

    When a validate job is complete, you can view the job log files to identify and correct any issues.

    On the Options tab, select the Backup Validations Only check box.

    Select one verification option.

    • DB Verify - The SnapProtect software performs a temporary database restore and then verifies the files for database block consistency.
    • RMAN Validate - The Oracle Recovery manager performs a temporary database restore and then verifies the files for database block consistency. The restored files are deleted after the verification.
    • Only Backup Inquiry - BACKINT displays the list of available backups to validate.

    Restore the control file to an alternate location

    You can use this option when the database is in the MOUNT, SHUTDOWN or OPEN state.

    The SnapProtect software restores the control file to the location you specify. The control file is not replicated to the database. You can manually replicate the files to the database.

    On the Ctrl Files tab:

    1. Select the Restore Control File As check box.
    2. Type the full path where you want to restore the control file.
  10. Click OK to close the Advanced Restore Options dialog box.
  11. Click OK to close the Restore Options dialog box and start the restore.
  12. Optional: Recover the database.

Restoring the Database to a Point-in-Time

Use a point-in-time restore to revert the database to a state before an undesired transaction or before a point of failure.

Restore the control files when you restore and recover an entire database to a previous point-in-time from an online backup or offline backup to the original host.

Note: After you restore the control file, you must reset the logs before you open the database.

Before You Begin

  1. Perform an online full backup if one is not available.
  2. Set the database to the correct mode defined in the table, or select the Switch Database mode for Restore check box (Options tab), to set the SnapProtect software to automatically move the database to the correct mode before the restore.
    Control File in the Restore Required Database Mode
    Control file is included in the restore NOMOUNT
    Control file not included in the restore MOUNT

Procedure

  1. From the CommCell Browser, expand Client Computers > client > SAP for Oracle.
  2. Right-click the instance, point to All Tasks and then click Browse and Restore.
  3. On the Time Range tab, select Time Range.
  4. Select Absolute Time and then enter the Start Time and the End Time date and time.

    For SAP Oracle agents the default Time Zone is the client's time zone. For all other agents the default Time Zone is the CommServe computer's time zone.

  5. On the Browse view, select the data to restore in the right pane and click Recover All Selected.
  6. On the General tab:
    1. Select the name of the client computer from the Destination Client list.
    2. Select the Restore Control File check box.
    3. Select the Restore Archive Log check box.
    4. Select the Restore Data check box.
    5. Click Advanced.

      The Advanced Restore Options dialog box appears.

  7. On the Restore tab, select the To Point-in-Time option and enter the date and time.

    Note: The selected time is specific to the CommServe computer's time zone.

  8. On the Recover tab, select the To Point-in-Time option and enter the date and time.
  9. To set the SnapProtect software to automatically move the database to the correct mode before the restore, select the Switch Database mode for Restore check box.
  10. Click OK to close the Advanced Restore Options dialog box.
  11. Click OK to close the Restore Options dialog box and start the restore.

Restoring to a Different Client (Cross Machine Restore)

Perform a cross-machine restore when the original database host has been damaged or destroyed, and you need to restore the data to a different host from the backup.

Before You Begin

  1. Perform a full backup with an online or offline subclient.
  2. Verify the following in both the source and destination hosts:
    1. The connection specifications (host, service name, port) in the tnsnames.ora file on both the source and destination hosts must be different.
    2. There must be enough disk space on the destination host for the restored database.
    3. The source and destination hosts must have the same:
      • Operating systems
      • Oracle version
      • ORACLE_SID
      • ORACLE_HOME
      • init <SID>.ora file
      • Processor (32-bit or 64-bit)
      • Datafile directory structures
  3. On the destination host, install the SAP Oracle application and then create an empty instance in the same directory structure as the source host.
  4. On the destination host, create a SAP Oracle instance in the CommCell Console.
  5. On the destination client, create the $SAPDATA_HOME directory when it does not exist.
  6. Manually copy the init<SID>.sap and init<SID>.ora files from the source host to the destination host. On Windows platforms, the files are in the $ORACLE_HOME/database folder.

    You can use the BRRESTORE command as an alternative method.

    BR*Tools records this in the log file.

    The format is: SAP_<CommCell_number>_<Backup_job_ID> or <CommCell_Number>_<Backup_job_ID>

    brrestore -d util_file -b2 <backup_id> -m /oracle_setup/dbs/init<SID>.ora
    brrestore -d util_file -b2 <backup_id> -m /oracle_setup/dbs/init<SID>.sap

Procedure

  1. From the CommCell Browser, expand Client Computers > client > SAP for 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 to restore in the right pane and then click Recover All Selected.

    The Restore Options dialog box appears.

  6. On the General tab:
    1. From the Destination Client list, select the name of the client computer.
    2. Select the Restore Control File check box.
    3. Select the Restore Archive Log check box.
    4. Select the Restore Data check box.
    5. Select the Recover check box.
    6. Click Advanced.

      The Advanced Restore Options dialog box appears.

  7. On the Restore tab, select the Restore Archive Log check box.
  8. On the Options tab:
    • Select the Open DB check box.
    • Select Yes from the Reset Logs list.
    • When you restore from an offline backup, select the Reset Database check box.
  9. To set the SnapProtect software to automatically move the database to the correct mode before the restore, select the Switch Database mode for Restore check box.
  10. Click OK to close the Advanced Restore Options dialog box.
  11. Click OK to close the Restore Options dialog box.

After the restore optionally recover the database to a different time.

Restoring Archive Logs

You can restore archive logs separately or in addition to the database.

Restore an archive log when you are restoring any of the following data items:

  • A database to the most recent state after a database failure.
  • Logs from a specific time range that were lost due to a hard disk corruption. You can use a point-in-time option, to restore the archive logs.

Before You Begin

  1. Perform a full backup with a log file subclient.

Procedure

  1. From the CommCell Browser, expand Client Computers > client > SAP Oracle.
  2. Right-click the instance, point to All Tasks and then click Browse and Restore.
  3. On the Browse and Restore dialog box, 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 to restore in the right pane and click Recover All Selected.

    The Restore Options dialog box appears.

  6. On the General tab:
    1. Select the Restore Archive Log check box.
    2. To restore the log files without the database, clear the Restore Data check box.
    3. Click Advanced.

      The Advanced Restore Options dialog box appears.

  7. On the Restore tab, select the restore log option.
    Expand All

    Restore all logs

    Select the All option

    Restore logs by a specific log time

    Select By Log Time and enter the Start and End time in the boxes.

    If you only specify the start log time and not the end log time, the system restores all logs from the start time to the current time.

    If the restore includes the database, see Restoring to a Point-in-Time to restore the database to a specific point-in-time.

    Restore by specifying a serial number

    Select the By Log Serial Number option.

    Check the Start or End check boxes and enter the serial numbers.

    The following are the rules for specifying the serial number.

    • The end serial number must be greater than or equal to the start serial number
    • The start and the end serial number cannot be 0
    • The range of serial numbers restore can be from one or more backup jobs or from a part of a job and from one or more cycles
    • When you specify only the start sequence number, logs starting from that sequence number to the current sequence number are restored

    Restore logs to a different location

    Enter the new path in the Target Directory box.

  8. To set the SnapProtect software to automatically move the database to the correct mode before the restore, select the Switch Database mode for Restore check box.
  9. Optional: Select the restore options.
    Expand All

    Open the database after the restore

    After a restore, set the SnapProtect software to automatically open the database. When the database is open, it records transactions.

    On the Options tab, select the Open DB check box.

    Reset the database and logs.

    By default, the database is automatically set to open, and the logs are reset.

    If you reset the logs to an open state, you can then reset the database.

    On the Options tab, select the Reset Database check box and one of the following Reset Log options:

    • To open the database without the RESETLOGS option, select None.
    • To open the database with the RESETLOGS option, select Yes.
    • To open the database with the NORESTLOGS option, select No.

    Validate the restore

    Validation verifies that the backup copies of the data and logs are intact and usable for restores. RMAN simulates the restore job without the media to determine whether the restore can be successfully performed.

    When a validate job is complete, you can view the job log files to identify and correct any issues.

    On the Options tab, select the Backup Validations Only check box.

    Select one verification option.

    • DB Verify - The SnapProtect software performs a temporary database restore and then verifies the files for database block consistency.
    • RMAN Validate - The Oracle Recovery manager performs a temporary database restore and then verifies the files for database block consistency. The restored files are deleted after the verification.
    • Only Backup Inquiry - BACKINT displays the list of available backups to validate.

    Restore the control file to an alternate location

    You can use this option when the database is in the MOUNT, SHUTDOWN or OPEN state.

    The SnapProtect software restores the control file to the location you specify. The control file is not replicated to the database. You can manually replicate the files to the database.

    On the Ctrl Files tab:

    1. Select the Restore Control File check box.
    2. Select the Restore Control File As check box.
    3. Type the full path where you want to restore the control file.
  10. Click OK to close the Advanced Restore Options dialog box.
  11. Click OK to close the Restore Options dialog box.

Restoring Control Files

Control files are required to recover a database to the current state. Restore control files when the control file is lost and you need to restore the backup repository contained in the control file.

Configure an auto backup of control files to restore the control file from auto backup. The control file restore destroys all the previous backups.

If your database consists of multiple control files copies, you can replace a corrupted control file by manually copying an existing control file, and then restoring it.

Note: After you restore the control file, you must reset the logs before you open the database.

Before You Begin

  1. Perform a full backup with an online or offline subclient.
  2. Place the database in NOMOUNT mode, or set the SnapProtect software to automatically move the database to the correct mode before the restore.

Procedure

  1. From the CommCell Browser, expand Client Computers > client > SAP Oracle.
  2. Right-click the instance, point to All Tasks and then click Browse and Restore.
  3. On the Browse and Restore dialog box, 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 to restore in the right pane and click Recover All Selected.

    The Restore Options dialog box appears.

  6. To restore the latest backup to the same location, on the General tab, select the Restore Control File check box and click OK.
  7. For all other restore options, on the Restore Options dialog box, select the Restore Control File check box and then click Advanced.

    The Advanced Restore Options dialog box appears.

  8. On the Ctrl Files tab:
    1. Select the Restore Control File check box.
    2. Select the Restore Control File As check box.
    3. Type the full path where you want to restore the control file.
    4. Click OK to close the Advanced Restore Options dialog box.
  9. Click OK to close the Restore Options dialog box.

What to Do Next

  1. Place the database in MOUNT mode.
  2. Perform a full database restore.

Restoring Individual Datafiles and Tablespaces

Recover a missing or corrupted datafile and tablespace when:

  • A datafile or tablespace is corrupted after you have restored the database
  • A datafile or tablespace is the only lost data that must be restored. You can restore the datafile or tablespace instead of the entire database.

Before You Begin

  1. Perform a full backup with a subclient configured for datafiles and tablespaces.
  2. If you edited the init<SID>.sap file and changed the block size for the backup, edit the init<SID> .sap file and add the following line to set the BLKSIZE parameter to the value that you set for the backup.

    RMAN_PARMS="SBT_LIBRARY=/opt/ /Base/libobk.so,BLKSIZE=1048576,ENV=(CvClientName= client_name,CvInstanceName=Instance001)"

Procedure

  1. From the CommCell Browser, expand Client Computers > client > SAP for Oracle.
  2. Right-click the instance, point to All Tasks and then click Browse and Restore.
  3. On the Browse and Restore dialog box, select Latest Backup and click View Content.
  4. In the right pane of the CommCell Browser window, select the datafiles and tablespaces to restore, and click Recover All Selected.
  5. On the Restore Options dialog box:
    1. Select the Restore Data check box.
    2. Optional: Select the Restore Archive Logs check box.
    3. Optional: Select the Recover check box.
    4. Click Advanced.

      The Advanced Restore Options dialog box appears.

  6. On the Options tab, select the Switch Database mode for Restore check box.
  7. To set the SnapProtect software to automatically move the database to the correct mode before the restore, select the Switch Database mode for Restore check box.
  8. Optional: Select the restore options.
    Expand All

    Open the database after the restore

    After a restore, set the SnapProtect software to automatically open the database. When the database is open, it records transactions.

    On the Options tab, select the Open DB check box.

    Reset the database and logs.

    By default, the database is automatically set to open, and the logs are reset. If you reset the logs to an open state, you can then reset the database.

    On the Options tab, select the Reset Database check box and one of the following Reset Log options:

    • To open the database without the RESETLOGS option, select None.
    • To open the database with the RESETLOGS option, select Yes.
    • To open the database with the NORESTLOGS option, select No.

    Validate the restore

    Validation verifies that the backup copies of the data and logs are intact and usable for restores. RMAN simulates the restore job without the media to determine whether the restore can be successfully performed. When a validate job is complete, you can view the job log files to identify and correct any issues.

    On the Options tab, select the Backup Validations Only check box.

    Select one verification option.

    • DB Verify - The SnapProtect software performs a temporary database restore and then verifies the files for database block consistency.
    • RMAN Validate - The Oracle Recovery manager performs a temporary database restore and then verifies the files for database block consistency. The restored files are deleted after the verification.
    • Only Backup Inquiry - BACKINT displays the list of available backups to validate.

    Restore the control file to an alternate location

    You can use this option when the database is in the MOUNT, SHUTDOWN or OPEN state.

    The SnapProtect software restores the control file to the location you specify. The control file is not replicated to the database. You can manually replicate the files to the database.

    On the Ctrl Files tab:

    1. Select the Restore Control File check box.
    2. Select the Restore Control File As check box.
    3. Type the full path where you want to restore the control file.
  9. Click OK to close the Advanced Restore Options dialog box.
  10. Click OK to close the Restore Options dialog box.

If your restore includes SYSTEM tablespaces, switch the database mode to MOUNT.

Recovering the Database

By default, the database recovers to the current time.

You can recover the database to the current time, or to a point-in-time.

Procedure

  1. From the CommCell Browser, expand Client Computers > client > SAP for Oracle.
  2. Right-click the instance, point to All Tasks, and then click Browse and Restore.
  3. Click View Content.
  4. Optional: Use non-default Browse and Restore options. See Browse and Restore.
  5. From the Browse window, select the data to restore in the right pane, and click Recover All Selected.
  6. On the Restore Options dialog box, clear the Restore Data check box, select the Restore Control File check box and then click the Advanced button.
  7. On Recover tab of the Advanced Restore Options dialog box, select the database recover option:
    Choice Description
    Current Time Recover to the current time
    Point-in-Time Enter the date and time.

    Note: If the time zone is different on the CommServe computer and client, in the Time Zone box, select the client computer time zone.

  8. Optional: Select the restore options.
    Expand All

    Open the database after the restore

    After a restore, set the SnapProtect software to automatically open the database. When the database is open, it records transactions.

    On the Options tab, select the Open DB check box.

    Reset the database and logs.

    By default, the database is automatically set to open, and the logs are reset. If you reset the logs to an open state, you can then reset the database.

    On the Options tab, select the Reset Database check box and one of the following Reset Log options:

    • To open the database without the RESETLOGS option, select None.
    • To open the database with the RESETLOGS option, select Yes.
    • To open the database with the NORESTLOGS option, select No.

    Validate the restore

    Validation verifies that the backup copies of the data and logs are intact and usable for restores. RMAN simulates the restore job without the media to determine whether the restore can be successfully performed. When a validate job is complete, you can view the job log files to identify and correct any issues.

    On the Options tab, select the Backup Validations Only check box.

    Select one verification option.

    • DB Verify - The SnapProtect software performs a temporary database restore and then verifies the files for database block consistency.
    • RMAN Validate - The Oracle Recovery manager performs a temporary database restore and then verifies the files for database block consistency. The restored files are deleted after the verification.
    • Only Backup Inquiry - BACKINT displays the list of available backups to validate.

    Restore the control file to an alternate location

    You can use this option when the database is in the MOUNT, SHUTDOWN or OPEN state.

    The SnapProtect software restores the control file to the location you specify. The control file is not replicated to the database. You can manually replicate the files to the database.

    On the Ctrl Files tab:

    1. Select the Restore Control File As check box.
    2. Type the full path where you want to restore the control file.
  9. Click OK to close the Advanced Restore Options dialog box.
  10. Click OK to close the Restore Options dialog box.

Manage Restore Jobs

You can restart SAP Oracle restores that you performed from the CommCell Console. For more information on configuring job restarttability, see Job Restartability - Advanced.

The table provides the job status for the BR*Tools error codes. The BR*Tools Error Code and Description columns are from the Messages and Return Codes for BR*Tools page on the SAP Help website.

BR*Tools Error Code Description Job Status
0 Successful Completed
1 Warnings – all files were processed (for example, backed up or restored) Completed With Warning
2 Canceled during the initialization phase by a user or other signal Completed With One or More Errors
3 Errors occurred during the initialization phase, processing was not started Completed With One or More Errors
4 Canceled by a user or other signal during processing Completed With One or More Errors
5 Started, but not completed because errors occurred during processing Completed With One or More Errors
6 Internal termination Completed With One or More Errors
9 Successful, but did not finish. Details can be seen in the summary logs that are copied to the backup media Completed With One or More Errors

Additional Restore Options

Several additional options are available to further refine your restore operations. These options are available from the Advanced Backup Options window.

To access the Advanced Restore Options dialog box:

  1. From the CommCell Browser, expand Client Computers by double-clicking Client Computers | SAP for Oracle | <instance name>. The default and other subclients (if available) are displayed on the right-hand windowpane.
  2. To restore from the instance level, right-click the instance, and click Restore.
  3. From the SAP/Oracle Restore Options dialog box, click Advanced.

The following table describes the additional options:

Option Description Related Topic
Use hardware revert capability if available

This option allow you to revert the data to the time when the snapshot was created. Selecting this option brings back the entire LUN to the point when the snapshot was created, overwriting all the modifications to data since the snapshot creation. This option is available if the snapshot engine used for SnapProtect Backup supports the revert operation.

  1. From the CommCell Browser, expand Client Computers > client > instance.
  2. Right-click the instance, point to All Tasks and then click Browse and Restore.
  3. On the Browse and Restore dialog box, select Latest Backup and click View Content.
  4. On the Browse view, select the data to restore in the right pane and click Recover All Selected.
  5. From the Browse window, select the data to restore in the right pane and click Recover All Selected.

    The Restore Options dialog box appears.

  6. On the General tab, select the data that you want to restore:
    1. Select the name of the client computer from the Destination Client list.
    2. To restore the control file, select the Restore Control File check box.
    3. To restore the archive log, select the Restore Archive Log check box.
    4. To restore the data, select the Restore Data check box.
    5. To recover the database, elect the Recover check box.
    6. Click Advanced.

      The Advanced Restore Options dialog box appears.

  7. On the General tab, select the Use hardware revert capability if available check box.
  8. Click OK to close the Advanced Restore Options dialog box.
  9. Click OK to close the Restore Options dialog box and start the restore.
SAP Oracle SnapProtect
Startup Options

The Job Manager will use the startup priority setting when allocating the required resources. This is useful if you have jobs that are very important and must complete, or jobs that can be moved to a lower priority.

  1. From the CommCell Browser, click Client Computers | <agent> | <instance name>. The default and other subclients (if available) are displayed on the right-hand windowpane.
  2. From the CommCell Browser, right-click the instance that contains the data you want to restore. Click All Tasks and then click Browse Backup Data.
  3. From the Browse Options window, click OK.
  4. From the browse window, select the data to be restored and click Recover all Selected.
  5. From the Restore Options for All Selected Items dialog box, click Advanced.
  6. From the Advanced Restore Options (General) tab, select Use Default Priority option.
  7. Select Change Priority option to change the priority for a job, between 0 (highest priority) and 999 (lowest priority).
  8. Select Start up in Suspended State option to specify the selected job to start in the Job Controller in a suspended state.
  9. Click OK.
Refer to Job Priority and Priority Precedence.
Copy Precedence

When you select Restore from copy precedence option, the system recovers or retrieves data from the selected storage policy copy (Synchronous Copy or Selective Copy). If data does not exist in the specified copy, the data recovery or retrieve operation fails even if the data exists in another copy of the same storage policy.

When cleared, (or by default) the system recovers or retrieves data from the storage policy copy with the lowest copy precedence. If the data was pruned from the primary copy, the system automatically recovers or retrieves from the other copies of the storage policy in the lowest copy precedence to highest copy precedence order. Once the data is found, it is recovered or retrieved, and no further copies are checked.

  1. From the CommCell Browser, click Client Computers | <agent> | <instance name>. The default and other subclients (if available) are displayed on the right-hand windowpane.
  2. From the CommCell Browser, right-click the instance that contains the data you want to restore. Click All Tasks and then click Browse Backup Data.
  3. From the Browse Options window, click OK.
  4. From the browse window, select the data to be restored and click Recover all Selected.
  5. From the Restore Options for All Selected Items dialog box, click Advanced.
  6. From the Advanced Restore Options (General) tab, select Restore from copy precedence option.
  7. Select the number to change the selected copy's precedence. The numbers will move a copy to a higher or lower precedence in increments of 1.
  8. Click OK.
Refer to Recovering Data From Copies.
Data Path Options

Data Recovery operations use a specific data path (Library, MediaAgent, Drive Pool, and Drive) to perform the restore operations as configured in the CommCell. By default, the system automatically identifies the data path for the restore operations. You can change the data path at the restore level by selecting a specific MediaAgent, library, drive pool or drive in the Advanced Restore Options dialog.

The following are some of the important situations where you may need to change the data path:

  • To free heavily loaded resources such as MediaAgents and libraries.
  • A library suffers severe hardware damage and you need to move its media to a different library in order to access data secured by data protection operations.
  • A drive pool within a library is being used much more frequently than another, and a storage policy copy from the more active drive pool can be assigned to the less active one.
  1. From the CommCell Browser, click Client Computers | <agent> | <instance name>. The default and other subclients (if available) are displayed on the right-hand windowpane.
  2. From the CommCell Browser, right-click the instance that contains the data you want to restore. Click All Tasks and then click Browse Backup Data.
  3. From the Browse Options window, click OK.
  4. From the browse window, select the data to be restored and click Recover all Selected.
  5. From the Restore Options for All Selected Items dialog box, click Advanced.
  6. From the Advanced Restore Options (General) tab, select the MediaAgent and Library that you wish to perform the restore.
  7. Select the Drive Pool and Drive for tape library.
  8. Click OK.
Refer to Change Data Path.
Alerts The Alert option is used for setting up the criteria to raise notifications/alerts for job statuses such as failure, success, or any other conditions triggered by the restore job. Adding alerts helps the user or the user group to get the notification automatically about the status of the restore job.
  1. From the CommCell Browser, click Client Computers | <agent> | <instance name>. The default and other subclients (if available) are displayed on the right-hand windowpane.
  2. From the CommCell Browser, right-click the instance that contains the data you want to restore. Click All Tasks and then click Browse Backup Data.
  3. From the Browse Options window, click OK.
  4. From the browse window, select the data to be restored and click Recover all Selected.
  5. From the Restore Options for All Selected Items dialog box, click Advanced.
  6. From the Advanced Restore Options (General) tab, click Add Alert.
  7. From the Add Alert Wizard window, select the Threshold and Notification Criteria. Click  Next.
  8. Select the Notification Types. Click  Next.
  9. Select the Users and User Groups. Click  Next.
  10. Verify the Summary.
  11. Click Finish.
Refer to Alerts and Notifications.