VERITAS Storage Foundation 4.1 Oracle Administrator's Guide
Backing Up the Database from Snapshot Volumes (dbed_vmclonedb) Prerelease 8 September 2005, 8:55am
240 VERITAS Storage Foundation for Oracle Administrator’s Guide
Example
In this example, snapshot volumes are mounted.
$ /opt/VRTS/bin/dbed_vmclonedb -S PROD -g SNAP_PRODdg \
-o mount,new_SID=NEWPROD -f snap1 -r /clone/single
dbed_vmclonedb started at 2004-04-02 15:35:41
Mounting /clone/single/prod_db on
/dev/vx/dsk/SNAP_PRODdg/SNAP_prod_db.
Mounting /clone/single/prod_ar on
/dev/vx/dsk/SNAP_PRODdg/SNAP_prod_ar.
dbed_vmclonedb ended at 2004-04-02 15:35:50
▼ To mount a Storage Checkpoint carried over from the snapshot volumes to a secondary host
1. On the secondary host, list the Storage Checkpoints carried over from the primary database
using:
$ /opt/VRTS/bin/dbed_ckptdisplay -S ORACLE_SID -n
2. You can mount one of the listed Storage Checkpoints using:
$ /opt/VRTS/bin/dbed_ckptmount -S ORACLE_SID -c CKPT_NAME \
-m MOUNT_POINT
Limitations
◆ Any mounted Storage Checkpoints must be unmounted before running the following
commands:
$ /opt/VRTS/bin/dbed_vmclonedb -o umount,new_sid=new_sid \
-f SNAPPLAN
◆ It is only possible to mount a Storage Checkpoint carried over with the snapshot volumes in a
two-host configuration if the snapshot volumes were mounted with the dbed_vmclonedb
command with the -o mount option without the use of -r relocate_path.
◆ Storage Checkpoints carried over with the snapshot volumes can be mounted before a clone
database is created using dbed_vmclonedb with the -o mount option. After a clone
database is created using dbed_vmclonedb with the -o recoverdb option, however,
Storage Checkpoints are no longer present.
▼ To backup the database using the snapshot
Copy the snapshot volumes to tape or other appropriate backup media.