Veritas InfoScale™ 8.0.2 Storage and Availability Management for Oracle Databases - AIX, Linux, Solaris

To create third-mirror break-off snapshots in a VVR setup

1. On the primary host, generate the snapshot configuration for the secondary host.

   $ opt/VRTSdbed/bin/vxsfadm -a oracle -o getvvrinfo
   Gathering offline data...                        Done
   
   ORACLE_SID           = sfaedb
   REPLICATION_ROLE     = secondary
   REPLICATION_DG_VOL   = orasecondarydg,orasecondarydg2:datavol
   SNAPSHOT_TIME        = Wed Feb 15 09:50:17 2012
   
   Configuration file /tmp/config.aTKYn is ready.
   Use this configuration file on replication
   secondary site for cloning application instance.

   Note:

   You do not need to specify the configuration name and the replication role. The same configuration file can be used on any secondary host for online mode or instant mode snapshots.

2. Copy the newly generated snapshot configuration from the primary host to the secondary host.
3. On the secondary host, validate the snapshot configuration.

   $ /opt/VRTS/bin/vxsfadm -s flashsnap -a oracle \
   --name flash3 -o valid -c config.aTKYn
   Validating database configuration for third-mirror-break-off snapshot:
   ORACLE_SID                  = sfaedb
   ORACLE_HOME                 = /home/ora11gr2/app/ora11gr2/product
   																														/11.2.0/dbhome_1
   APP_MODE                    = online
   SNAPSHOT_ARCHIVE_LOG        = yes
   Validating database volume layout for space-optimized snapshot:
   REPLICATION_DG_VOL          = orasecondarydg:datavol
   CACHE_OBJECT                = co
   Replicated volumes ready for snapshot:
   Volume/volume-set datavol of diskgroup orasecondarydg.
   Volume/volume-set archvol of diskgroup orasecondarydg.
   SNAPSHOT_VOL_PREFIX         = SNAP_
   SNAPSHOT_DG_PREFIX          = SNAP_
   Database volume layout validated successfully.

   After validating the snapshot configuration on the secondary host, you can perform operations such as clone and destroy, locally on the secondary host.

4. On the secondary host, create a third-mirror break-off snapshot.

   $ /opt/VRTS/bin/vxsfadm -s flashsnap -a oracle \
   --name flash3 -o snap -c config.aTKYn
   snapshot started at Wed Feb 15 14:02:34 2012.
   Initiating snapshot from Primary site ...
   Message from Primary:
   Putting database in backup mode ...                          Done
   Message from Primary:
   Taking database out of backup mode ...                       Done
   Flushing online redo logs ...                                Done
   Sending IBC message to Secondary ...                         Done
   Message from Host system1.example.com:
   Creating snapshot volumes for data volumes ...               Done
   Message from Host system1.example.com:
   Receiving IBC message from Primary ...                       Done
   Creating snapshot volume for archivelog volume ...           Done
   Copying snapshot information to snapshot volume ...          Done
   Creating snapshot diskgroups ...                             Done
   Deporting snapshot diskgroups ...                            Done
   SNAP_orasecondarydg 
   snapshot ended at Wed Feb 15 14:02:55 2012.

   You can use the following command to resynchronize snapshot volumes to original volumes.

   $ /opt/VRTS/bin/vxsfadm -s flashsnap -a oracle \
   --name flash3 -o resync -c config.aTKYn 
   resync started at Wed Feb 15 14:16:47 2012.
   Importing snapshot diskgroups ...                            Done
   Joining snapshot diskgroups to original diskgroups ...       Done
   Reattaching snapshot volumes to original volumes ...         Done
   resync ended at Wed Feb 15 14:16:58 2012.

   Note:

   You cannot resynchronize a FlashSnap snapshot while there exist space-optimized snapshots created by using that FlashSnap snapshot as a golden image.

   See Creating multiple clones using FlashSnap snapshots.