< Previous  | TOC | Index | Next  >

Displaying, copying, and removing a snapplan (dbed_vmchecksnap)

Consider these notes before listing all snapplans for a specific Oracle database, displaying a snapplan file, or copying and removing 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 it after running dbed_update.

 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

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 Database FlashSnap status information, see the Veritas Storage Foundation for Oracle Administrator's Guide.

 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

In the following example, the snapplan snap1 is displayed.

$ /opt/VRTS/bin/dbed_vmchecksnap -S PROD -f snap1 -o list

SNAPSHOT_VERSION=5.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

 To copy a snapplan from the SFDB 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 SFDB 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 SFDB 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 SFDB 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 SFDB repository.

$ /opt/VRTS/bin/dbed_vmchecksnap -S PROD -f snap1 -o remove

The snapplan snap1 has been removed.