Veritas Storage Foundation 5.0 for Oracle RAC Configuration Guide Extracts for HP Serviceguard Storage Management Suite, Second Edition, May 2008

Using Storage Checkpoints and Storage Rollback
Backing up and Recovering the Database Using Storage Checkpoints
Chapter 4
49
drwxr-xr-x3oracledba1024Nov 11 2000 .
drwxr-xr-x3oracledba512Nov 16 11:00 ..
-rw-r--r--1oracledba209747968 Nov 16 10:58 .tstmp
-rw-r--r--1oracledba209747968Nov 16 10:58 .tstab
lrwxrwxrwx1oracledba18Nov 11 2000 tstmp ->
.tstmp::cdev:vxfs:
lrwxrwxrwx1oracledba18Nov 11 2000 tstab ->
.tstab::cdev:vxfs:
3. Run dbv tool against Quick I/O file tstmp.
$ dbv file=/tmp/ckpt_ro/db01/tstmp
DBVERIFY: Release 9.2.0.2.0 - Production on Mon Mar 7 11:48:35 \
2005
Storage Checkpoints can only be used to restore from logical errors (for example, a
human error). Because all the data blocks are on the same physical device, Storage
Checkpoints cannot be used to restore files due to a media failure. A media failure
requires a database restore from a tape backup or a copy of the database files kept on a
separate medium. The combination of data redundancy (disk mirroring) and Storage
Checkpoints is recommended for highly critical data to protect them from both physical
media failure and logical errors.
Backing up using a Storage Checkpoint
You can back up a database by creating a Storage Checkpoint using the
dbed_ckptcreate command, mount the Storage Checkpoint as read-only using the
dbed_ckptmount command, and then back it up using tools such as tar or cpio.
In the example procedure, all the database datafiles reside on one VxFS file system
named /db01.
To back up a frozen database image using the command line:
1. Create a Storage Checkpoint using the dbed_ckptcreate command.
$ /opt/VRTS/bin/dbed_ckptcreate -S PROD -H /oracle/product \ -o online
Storage Checkpoint Checkpoint_903937870 created
2. Mount the Storage Checkpoint using the dbed_ckptmount command.
$ /opt/VRTS/bin/dbed_ckptmount -S PROD -c Checkpoint_903937870 \
-m /tmp/ckpt_ro
If the specified mount point directory does not exist, then dbed_ckptmount creates it
before mounting the Storage Checkpoint, as long as the Oracle DBA user has
permission to create it.
Table 4-2 Backup Storage Checkpoint Notes
Usage notes See the dbed_ckptcreate(1M), dbed_ckptmount(1M), tar(1), and
cpio(1) manpages for more information.