VERITAS Storage Foundation 4.1 Oracle Administrator's Guide

Appendix A, VERITAS Storage Foundation for Oracle Command Line Interface
Prerelease 8 September 2005, 8:55am Examples of Using the Command Line Interface
459
Note The command output displays all available snapplans, their snapshot status
(SNAP_STATUS), database status (DB_STATUS), and whether a snapshot may be taken
(SNAP_READY). For explanations of the various statuses that may appear for
SNAP_STATUS and DB_STATUS, refer to “VERITAS Database FlashSnap Status
Information” on page 501.
▼ To view a snapplan
Use the dbed_vmchecksnap command as follows:
$ /opt/VRTS/bin/dbed_vmchecksnap -S PROD -f snap1 -o list
SNAPSHOT_VERSION=4.0
PRIMARY_HOST=host1
SECONDARY_HOST=host1
PRIMARY_DG=PRODdg
SNAPSHOT_DG=SNAP_PRODdg
ORACLE_SID=PROD
ARCHIVELOG_DEST=/prod_ar
SNAPSHOT_ARCHIVE_LOG=yes
SNAPSHOT_MODE=online
SNAPSHOT_PLAN_FOR=database
SNAPSHOT_PLEX_TAG=dbed_flashsnap
SNAPSHOT_VOL_PREFIX=SNAP_
ALLOW_REVERSE_RESYNC=yes
SNAPSHOT_MIRROR=1
STORAGE_INFO
PRODdg02
SNAP_PLEX=prod_db-02 prod_ar-02
STATUS_INFO
SNAP_STATUS=init_full
DB_STATUS=init
LOCAL_SNAPPLAN=/export/snap_dir/snap1
Copying or Removing a Snapplan Using dbed_vmchecksnap
▼ To copy a snapplan from the VxDBA repository to your local directory
To copy a snapplan from the VxDBA repository to your local directory, the snapplan must not
already be present in your local directory.
Use the dbed_vmchecksnap command as follows:
$ /opt/VRTS/bin/dbed_vmchecksnap -S PROD -f snap1 -o copy
Copying 'snap1' to '/export/snap_dir'