VERITAS Storage Foundation 4.1 Oracle Administrator's Guide

Summary of Database Snapshot Steps Prerelease 8 September 2005, 8:55am
216 VERITAS Storage Foundation for Oracle Administrator’s Guide
The snapplan contains detailed database and volume configuration information that is needed
for snapshot creation and resynchronization. You can modify the snapplan template with a text
editor.
The dbed_vmchecksnap command can also be used to:
- List all snapplans associated with a specific ORACLE_SID (dbed_vmchecksnap -o
list).
- Remove the snapplan from the VxDBA repository (dbed_vmchecksnap -o
remove -f SNAPPLAN).
- Copy a snapplan from the VxDBA repository to your local directory
(dbed_vmchecksnap -o copy -f SNAPPLAN).
For information about the snapplan file, see “Creating a Snapplan (dbed_vmchecksnap)” on
page 222.
3. Use the dbed_vmsnap command to create snapshot volumes for the database. See “Creating
a Snapshot (dbed_vmsnap)” on page 235 for more information.
4. On the secondary host, use the dbed_vmclonedb command to create a clone database using
the disk group deported from the primary host. See “Cloning a Database (dbed_vmclonedb)”
on page 244 for more information.
If the primary and secondary hosts specified in the snapplan are different, the
dbed_vmclonedb command imports the disk group that was deported from the primary
host, recovers the snapshot volumes, mounts the file systems, recovers the database, and brings
the database online with a different Oracle SID name than the primary host. If the secondary
host is different, the database name can be same. You can use the -o recoverdb option to
let dbed_vmclonedb perform an automatic database recovery, or you can use the -o
mountdb option to perform your own point-in-time recovery and bring up the database
manually. For a point-in-time recovery, the snapshot mode must be online.
You can also create a clone on the primary host. Your snapplan settings specify whether a clone
should be created on the primary or secondary host.
5. You can now use the clone database to perform database backup and other off-host processing
work.
6. The clone database can be used to reverse resynchronize the original volume from the data in
the snapshot, or can be discarded by rejoining the snapshot volumes with the original volumes
(that is, by resynchronizing the snapshot volumes) for future use.
The following flow chart depicts the sequence of steps leading up to taking a snapshot using
Database FlashSnap.