> CommCell Console > Backup and Restore Agents > Databases > SAP > SAP for Oracle > SAP on Oracle Restores > SAP on Oracle Restores from the CommCell Console > Full or Entire SAP on Oracle Database Restores

Restoring from a SAP for Oracle 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 online redo logs are available.

If you only have the offline redo logs, recover the database to a point-in-time.

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 Commvault 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

    dMOUNT

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. 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 is displayed.

  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. 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 is displayed.

  7. To set the Commvault 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.

    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.

    Open the database after the restore

    After a restore, set the Commvault 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 Commvault 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 Commvault 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 and start the restore.

Page contents

×

Loading...