When reverting snapshots or local replications created by a policy containing an Oracle Database classification, Protector will first display the following wizard page that allows application specific options to be configured.
Note: If an Oracle app node is of type DataGuard Standby then snapshot cannot be reverted.
Figure. Revert Wizard - Configure Oracle Recovery Options
| Control | Description | Logs Reset Post Recovery |
|---|---|---|
| Restore only | The database is simply reverted and it is left to the database administrator to recover manually. | No |
| Recover to last consistent state in backup | The database is recovered to the consistent state which was captured by the backup. The database is brought online. This type of revert can be performed with the data in the backup alone; no RMAN catalogue is required. | Yes |
| Recover to point in time | A timestamp is entered (in 24 hour format: YYYY-MM-DD:HH:MM:SS), which defines the point in time to recover. The time entered must be after the time the snapshot was created and before the last available transaction. This option requires a connection to the RMAN catalog and logs which are shared with/available to the host. | Yes |
| Recover to system change number (SCN) | A system change number is entered which defines the change point to recover. The SCN entered must be after the snapshot was created and before the last available transaction. This option requires a connection to the RMAN catalog and logs which are shared with/available to the host. | Yes |
| Recover to current position | The database is recovered to the most current position possible. Because access to the latest redo logs is available, it is possible to recover to the last transaction. This requires a connection to the RMAN catalog and logs which are shared with/available to the host. | No |
Figure. Revert Wizard - Post Recovery Options
| Control | Description |
|---|---|
| Open Database | If selected, then after recovery the database will placed in the OPEN state using the RESETLOGS or NORESETLOGS option, as per the requirements of the database. Otherwise the database will be left in the MOUNT state. |
Figure. Revert Wizard - Specify RMAN Credentials
This page of the wizard is not displayed if Restore only or Recover to last consistent state in backup is selected in a previous step.
| Control | Description |
|---|---|
| RMAN Catalog Name | For RMAN only. Enter the RMAN Catalog Name as it is entered in the SQL*Net connect string to connect to the RMAN catalog. |
| Username | For RMAN only. Enter the username for the RMAN catalog. |
| Password | For RMAN only. Enter the password for the RMAN catalog. |