VERITAS Storage Foundation 4.1 Oracle Administrator's Guide

Chapter 8, Using Storage Checkpoints and Storage Rollback
Prerelease 8 September 2005, 8:55am Backing Up and Recovering the Database Using Storage Checkpoints
177
$ /opt/VRTS/bin/dbed_ckptmount -S PROD \
-c Checkpoint_903937870 -m /tmp/ckpt_ro
Note 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.
2. Examine the content of the Storage Checkpoint:
$ ls -l /tmp/ckpt_ro/dbvol_82/dbinst1
drwxr-xr-x 3 oracle dba 1024 Nov 11 2000 .
drwxr-xr-x 3 oracledba512 Nov 16 11:00 ..
-rw-r--r-- 1 oracle dba 209747968 Nov 16 10:58 .tstmp
-rw-r--r-- 1 oracledba209747968Nov 16 10:58 .tstab
lrwxrwxrwx 1 oracledba18 Nov 11 2000 tstmp -> \
.tstmp::cdev:vxfs:
lrwxrwxrwx 1 oracledba 18 Nov 11 2000 tstab -> \
.tstab::cdev:vxfs:
3. Run dbv tool against Quick I/O file 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.