Restoring the SAP Oracle 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.

Before You Begin

1. Perform a full backup for SAP for Oracle 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 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	MOUNT

Procedure

1. From the CommCell Browser, go to 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 then click Time Range.

4. Select Absolute Time and, then enter the End Time date and time.

   For 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, in the right pane, select the data to restore, and then click Recover All Selected.

6. On the General tab of the Restore Options dialog box:

   1. From the Destination Client list, select the client computer.

   2. Select the Restore Control File check box.

   3. Click Advanced.

      The Advanced Restore Options dialog box appears.

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

   Note

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

8. On the Recover tab, select To Point-in-Time, and then enter the date and time.

9. When you restore the control file, on the Ctrl Files tab, do the following:

   • Select the Restore Control File check box.

   • Select Point-in-Time, and then enter the date and time.

     You must restore the control files to a point-in-time later than or equal to the point-in-time set in the Restore tab.

10. When the time zone is different for the client and the CommServe computer, on the Options tab, in the Time Zone box, select the time zone of the client computer.

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

12. Click OK to close the Advanced Restore Options dialog box.

13. Click OK to close the Restore Options dialog box and start the restore.

Example: SAP Oracle Database Volumes for Revert Snapshot Operation

You must exclusively use the SAPDATA Volume Group for SAPDATA<n> volumes and verify that the Volume Group does not host other LVs or mount points in the Volume Group.The following example is the SAP Oracle database volumes layout for revert snapshot operation.

VG sapdata  LV sapdata-sapdata1      /oracle/Z88/sapdata1
VG sapdata  LV sapdata-sapdata2      /oracle/Z88/sapdata2
VG sapdata  LV sapdata-sapdata3      /oracle/Z88/sapdata3
VG sapdata LV sapdata-sapdata4      /oracle/Z88/sapdata4
VG sapapp   LV sapapp-oracle_lv        /oracle
VG sapapp   LV sapapp-sapbackup_lv   /oracle/Z88/sapbackup
VG oraclelogs  LV oraclelogs-origlogB   /oracle/Z88/origlogB
VG oraclelogs  LV oraclelogs-origlogA   /oracle/Z88/origlogA
VG oraclelogs  LV oraclelogs-mirrlogA   /oracle/Z88/mirrlogA
VG oraclelogs  LV oraclelogs-mirrlogB   /oracle/Z88/mirrlogB
VG oraclelogs  LV oraclelogs-orarach   /oracle/Z88/oraarch
VG oraclelogs  LV oraclelogs-saparch   /oracle/Z88/saparch