Restoring Oracle in an SAP environment databases

Edit online

Specific command entries are used when you restore an Oracle in an SAP environment database from a snapshot or from IBM® Storage Protect.

Prerequisite

Confirm with IBM FlashSystem storage administrator that the host location refers to the backup site.

Execute the lshost command.
Figure 1. Confirming site location
The output indicates that the host location (location_system) refers to the backup site.
If the location of the host is different than the backup site, issue the following commands from any site:
```
# chhost -location <site-2-name> <hostname>
```
Refer IBM FlashSystem documentation for more details.
If you want to restore the snapshot backup from site2, issue the following command from any site, before restore operation:
```
# chhost -location <site-2-name> <hostname>
```
Note: Only supported on the AIX platform.

The SAP BR*Tools BRRECOVER for Oracle databases is used as a database administration tool to help recover your database. BRRECOVER can be used from these interfaces:

BRRECOVER command-line interface
BRTOOLS with character-based menus or GUI

BRRECOVER can be used for these tasks:

Complete database recovery
Database point-in-time (PIT) recovery
Tablespace PIT recovery
Whole database reset
Restore of individual backup files
Restore and application of offline redo log files
Disaster recovery

See the SAP BR*Tools documentation for information about restore and recovery strategies.

The following table summarizes the command entries according to the type of restore:

Table 1. Summary of Restore Commands for Oracle in an SAP environment
Snapshot Restore	Restore from IBM Storage Protect
brrestore -d util_vol ......	brrestore -d util_file
brrecover	brrecover