After creating a snapplan, the next steps are to validate the snapplan parameters and check whether the snapshot volumes have been configured correctly for creating snapshots. If validation is successful, the snapplan is copied to the repository. The snapplan is validated using the dbed_vmchecksnap
command with the -o validate
option.
Consider the following prerequisites and notes before validating a snapplan:
dbed_vmchecksnap
command:
$ /opt/VRTS/bin/dbed_vmchecksnap -S-D
ORACLE_SID
\
-H
ORACLE_HOME
-f
SNAPPLAN
-o validate
Note In HA environment, you must modify the default snapplan, use the virtual host name defined for the resource group for the PRIMARY_HOST and/or SECONDARY_HOST, and run validation.
In the following example, a snapplan, snap1, is validated for a snapshot image in a single-host configuration. The primary host is host1 and the working directory is /export/snap_dir.
$ /opt/VRTS/bin/dbed_vmchecksnap -S PROD -H /oracle/product/9i \
The version of PRIMARY_DG-PRODdg is 110.
The primary diskgroup PRODdg is a shared disk group
The database is running in archivelog mode.
ARCHIVELOG_DEST=/prod_ar is mount on /dev/vx/dsk/PRODdg/prod_ar.
Examining Oracle volume and disk layout for snapshot
Volume prod_db on PRODdg is ready for snapshot.
Original plex and DCO log for prod_db is on PRODdg01.
Snapshot plex and DCO log for prod_db is on PRODdg02.
SNAP_PRODdg for snapshot will include: PRODdg02
The snapplan snap1 has been created.
In the following example, a snapplan, snap2, is validated for a snapshot image in a two-host configuration. The primary host is host1, the secondary host is host2, and the working directory is /export/snap_dir.
$ /opt/VRTS/bin/dbed_vmchecksnap -S PROD -H \
/oracle/product/9i -f snap2 -o validate
The version of PRIMARY_DG-PRODdg is 110.
The primary diskgroup PRODdg is a shared disk group
The database is running in archivelog mode.
ARCHIVELOG_DEST is /mytest/arch
ARCHIVELOG_DEST=/mytest/arch is mount on /dev/vx/dsk/PRODdg/arch.
Examining Oracle volume and disk layout for snapshot.
Volume arch on PRODdg is ready for snapshot.
Original plex and DCO log for arch is on PRODdg01.
Snapshot plex and DCO log for arch is on PRODdg02.
Volume prod_db on PRODdg is ready for snapshot.
Original plex and DCO log for prod_db is on PRODdg01.
Snapshot plex and DCO log for prod_db is on PRODdg04.
SNAP_PRODdg for snapshot will include: PRODdg02
The snapplan snap2 has been created.