Creating or Validating the Snapplan Using dbed_vmchecksnap
You can use the VERITAS Storage Foundation for Oracle dbed_vmchecksnap command to create or validate a snapplan from the command line. You can also use the command to check the storage to make sure it is configured appropriately for the Database FlashSnap feature.
Note
You must have the VERITAS Database FlashSnap license installed in order to use this command.
Prerequisites
- The database must be up and running while executing the dbed_vmchecksnap command.
- If the SNAPSHOT_MODE parameter is online in the snapplan, the database must be in archivelog mode, which is set in the ora.init file, to successfully execute the dbed_vmchecksnap command.
Usage Notes
- The dbed_vmchecksnap command can only be used on the primary host.
- The dbed_vmchecksnap command must be run as the Oracle database administrator. However, the system administrator must prepare persistent FastResync on the existing database volumes and assign the disks for the snapshot volumes first.
- The dbed_vmchecksnap command does not interact with the user.
- It is recommended that you maintain different snapplans in a directory. If a snapplan is updated or modified, you must re-validate it.
- You have the option to use the dbed_checkconfig command to perform a validation.
- The snapplan must be re-validated after making structural changes, such as adding a tablespace, to your database.
- See the dbed_vmchecksnap(1M) manual page for more information.
Options -S | Specifies the ORACLE_SID, which is the name of the Oracle database, for which a snapshot image will be created. | -H | Specifies the Oracle home directory that corresponds to the ORACLE_SID. | -f snapplan | Indicates the name of the snapplan that you are creating. | -o setdefaults | Creates a default snapplan. This option can be used with the -o validate option to validate that the configuration is correct. | -o validate | Validates each parameter in the snapplan and checks whether the snapshot volumes have been configured correctly for creating snapshots. | -t | Specifies the name of the host to which the snapshot image will be deported. | -n | Disables the VxDBA repository refresh. The repository is refreshed by default unless you use the -n option. | -h | Displays help information for the dbed_vmchecksnap command. | -F | Forces the command to re-validate the snapplan. You must use the -F option if you have made structural changes to the database. |
To create a snapplan and set the default values
Use the dbed_vmchecksnap command as follows:
$ dbed_vmchecksnap -S PROD -H $ORACLE_HOME -f snapplan \
-o setdefaults -t host2
Snapplan-snapplan for PROD
===============================
PRIMARY_HOST=host1
SECONDARY_HOST=host2
PRIMARY_DG=PRODdg
SNAPSHOT_DG=SNAP_PRODdg
ORACLE_SID=PROD
ORACLE_HOME=/local/oracle/links
ARCHIVELOG_DEST=/prod_ar
SNAPSHOT_ARCHIVE_LOG=yes
SNAPSHOT_MODE=online
SNAPSHOT_PLAN_FOR=database
TABLESPACES=""
TABLES=""
SNAPSHOT_ORACLE_HOME=no
SNAPSHOT_VOL_PREFIX=SNAP_
To validate a snapplan
Use the dbed_vmchecksnap command as follows:
$ dbed_vmchecksnap -S PROD -H /oracle/product/8.1.6 -o validate \
-f snapplan
Examining the validation of parameter setting in snapplan
for the database instance PROD.
PRIMARY_HOST is host1
SECONDARY_HOST is host2
The version of PRODdg is 90.
SNAPSHOT_DG is SNAP_PRODdg.
Examining Oracle volume and disk layout for snapshot.
SNAPSHOT_MODE is online
The database is running in archivelog mode.
ARCHIVELOG_DEST is /prod_ar
SNAPSHOT_PLAN_FOR is database.
/etc/vx/vxdba is mount on /dev/vx/dsk/PRODdg/vxdba01.
SNAPSHOT_ARCHIVE_LOG is yes.
ARCHIVELOG_DEST=/prod_ar is mount on /dev/vx/dsk/PRODdg/prod_ar.
Volume ORACLE1 on PRODdg is ready for snapshot
Volume ORACLE1 is located on PRODdg01 PRODdg02 PRODdg03 PRODdg05
Snapshot volume for ORACLE1 is on PRODdg05.
Volume vxdba01 on PRODdg is ready for snapshot
Volume vxdba01 is located on PRODdg01 PRODdg02 PRODdg03 PRODdg04
Snapshot volume for vxdba01 is on PRODdg04.
Volume prod_ar on PRODdg is ready for snapshot
Volume prod_ar is located on PRODdg01 PRODdg03 PRODdg04
Snapshot volume for prod_ar is on PRODdg04.
SNAP_PRODdg for snapshot will include: PRODdg04 PRODdg05
|
