Restoring data with remote mirroring

Restore data on a remote site with IBM® Storage Protect Snapshot.

Before you begin

The restore operations for the remote site must meet the following environment conditions:

  • Data is successfully backed up and the backup copy of data is accessible on the remote site.
  • A takeover host is running with the same operating system level as the production host.
  • The takeover host is configured on the remote side.
  • The database instance is created on the takeover host.
  • IBM Storage Protect Snapshot software is installed on the takeover host. The software level on the production host and on the takeover host are the same.
Note: Never edit the existing DEVICE_CLASS parameters in the profile. For takeover operations, always add new DEVICE_CLASSES for the new local and new remote sites.

Restoring data in an Oracle in an SAP environment environment

About this task

The takeover operation is complete, and the reversal of roles and remote relationships are already in place. If not already included in the takeover operation, stop the acsd daemon on the primary production host, and transfer all the repository files from the primary production host to the takeover host. The repository files are in the directory defined by the parameter ACS_REPOSITORY in the ACSD section of the profile.
Note: The snapshot restore operation requires sufficient available space on the target storage pool so that it can restore the necessary volume. Increase the capacity on the requested storage pool or free up some items that are using existing capacity in cases where there is insufficient space.
The IBM Storage Protect Snapshot snapshot local repository and the SAP backup directory, /oracle/<SID>/sapbackup, are restored to the takeover host at a point in time after the remote backup. When you are restoring data in a maintenance scenario, not a disaster recovery scenario, the IBM Storage Protect Snapshot repository and the SAP backup repository can be shared by NFS. Complete the following steps:

Procedure

  1. Update the IBM Storage Protect Snapshot configuration parameters with the setup script wizard. Specifically, set the ACSD parameter to use the acsd on the takeover host in the GLOBAL section. Do not use the acsd of the production host.
  2. In the init<SID>.utl file, set the ACSD parameter to use the acsd on the takeover host. Do not use the acsd of the production host.
  3. Start the IBM Storage Protect Snapshot acsd daemon on the takeover host.
  4. From the backups that are displayed, select the remote backup to use for the restore. The backups are displayed when you enter the query command on the takeover host.
    For example, fcmcli -f inquire_detail
  5. Start the restore by entering the following command:
    BR_NSC=1 brrestore -m full -p <dir>/init<SID>.sap -b <sap backup log id> 
    	-d util_vol -r <dir>/init<SID>.utl

Results

The remote mirroring relationships are stopped. The volume groups with the file systems that contain the table spaces are restored from the FlashCopy® targets to the remote mirroring targets. The file systems that contain the table spaces are mounted.

You must restart the remote relationships before taking another snapshot of remote mirroring targets. For IBM XIV® Storage System, the remote relationships are removed. You must re-create the remote relationships before taking another snapshot of remote mirroring targets.