Off-host alternate client, FlashSnap method
Based on this FlashSnap configuration, the typical flow during the Snapshot Client backup for SAP is as follows:
The database shuts down or the tablespaces are put in backup mode in the production host.
The alternate client off-host takes the snapshot of the production database from primary disk D1 to mirror disk D2.
The production database in primary disk D1 is created online.
The mirror disk D2 is split to perform backup from the snapshot to the backup media.
The snapshot from the mirror disk D2 is then joined back to the volume in primary disk D1.
The user identification and group identification numbers (UIDs and GIDs) associated with the files to be backed up must be available to the primary client and the alternate backup client. The UID on the primary client and the alternate backup client must be the same. Similarly, the GID on the primary client and the alternate backup client must be the same.
To configure the local host snapshot method
Install and configure the following on the production database host:
Install NetBackup Client, NetBackup Snapshot Client, and the NetBackup for SAP Agent.
Configure the production database (Oracle).
You can install the NetBackup master server on a separate host.
Install the following on the alternate client (off-host):
Install NetBackup Client and NetBackup Snapshot Client. The NetBackup for SAP Agent is not required.
The NetBackup master server. You can install the master server on the same host or on a separate host where you want to attach the backup media.
The UID number can be different than the GID number.
- Attach the external disk D1 to the primary client (production database host) and create a VM disk group using the following command:
root@primary# vxdg init diskgroup [cds=on|off] diskname=devicename
- Create a volume in primary disk D using the following command:
root@primary# vxassist -g diskgroup make volume size
- Add a DCO log to the volume using the following command:
root@primary# vxassist -g diskgroup addlog volume logtype=dco
- Enable FastResync on the volume using the following command:
root@primary# vxvol -g diskgroup set fastresync=on volume
- Create a VxFS file system on this volume and mount it using the following commands:
root@primary# mkfs -F vxfs /dev/vx/rdsk/diskgroup/volume root@primary# mount -F vxfs /dev/vx/dsk/diskgroup/volume mnt
- Create the SAP production database on this volume.
- Connect the external mirror disk D2 to the primary client and the alternate client, so the disk is accessible to both hosts.
- Start the snapshot for the data volume in the primary client using the following command:
root@primary# vxassist -g diskgroup -b snapstart volume