Displaying, Copying, and Removing a Snapplan (dbed_vmchecksnap)

This section explains how to list all snapplans for a specific Oracle database, display a snapplan file, and copy and remove snapplans.

Usage Notes

If the local snapplan is updated or modified, you must re-validate it.
If the database schema or disk group is modified, you must revalidate.

To list all available snapplans for a specific Oracle database

Use the dbed_vmchecksnap command as follows:

$ /opt/VRTS/bin/dbed_vmchecksnap -S ORACLE_SID -o list

Example

In the following example, all available snapplans are listed for the database PROD.

$ /opt/VRTS/bin/dbed_vmchecksnap -S PROD -o list
The following snapplan(s) are available for PROD:
SNAP_PLAN          SNAP_STATUS            DB_STATUS          SNAP_READY
snap1         init_full           init          yes
snap2         init_full           init          yes

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

To display detailed information for a snapplan

Use the dbed_vmchecksnap command as follows:

$ /opt/VRTS/bin/dbed_vmchecksnap -S \
ORACLE_SID -f SNAPPLAN -o list

Example

In the following example, the snapplan snap1 is displayed.

$ /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_ar-02
STATUS_INFO
SNAP_STATUS=init_full
DB_STATUS=init
LOCAL_SNAPPLAN=/export/snap_dir/snap1

To copy a snapplan from the VxDBA repository to your current directory

If you want to create a snapplan similar to an existing snapplan, you can simply create a copy of the existing snapplan and modify it. To copy a snapplan from the VxDBA repository to your current directory, the snapplan must not already be present in the current directory.

Use the dbed_vmchecksnap command as follows:

$ /opt/VRTS/bin/dbed_vmchecksnap -S ORACLE_SID \
-f SNAPPLAN -o copy

Example

In the following example, the snapplan, snap1, is copied from the VxDBA repository to the current directory.

$ /opt/VRTS/bin/dbed_vmchecksnap -S PROD \
-f snap1 -o copy
Copying 'snap1' to '/export/snap_dir'

To remove a snapplan from the VxDBA repository

A snapplan can be removed from a local directory or repository if the snapplan is no longer needed.

Use the dbed_vmchecksnap command as follows:

$ /opt/VRTS/bin/dbed_vmchecksnap -S ORACLE_SID -f\
SNAPPLAN -o remove

Example

In the following example, the snapplan, snap1, is removed from the VxDBA repository.

$ /opt/VRTS/bin/dbed_vmchecksnap -S PROD -f snap1 -o remove
The snapplan snap1 has been removed.


^ Return to Top	< Previous \| Next >

Product: Storage Foundation for Databases Guides
Manual: Storage Foundation 4.1 for Oracle Administrator's Guide
VERITAS Software Corporation www.veritas.com