Veritas Storage Foundation for Oracle 5.0 Administrator's Guide, HP-UX 11i v3, Second Edition, December 2008

To verify that a Storage Checkpoint is error-free using the command line
1
Create and mount a Storage Checkpoint:
$ /opt/VRTS/bin/dbed_ckptcreate -S PROD -H /oracle/product \
-o online
Storage Checkpoint Checkpoint_903937870 created.
$ mkdir /tmp/ckpt_ro
$ /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.
2
Examine the contents 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 oracle dba 512 Nov 16 11:00 ..
-rw-r--r-- 1 oracle dba 209747968 Nov 16 10:58 .tstmp
-rw-r--r-- 1 oracle dba 209747968 Nov 16 10:58 .tstab
lrwxrwxrwx 1 oracle dba 18 Nov 11 2000 tstmp -> .tstmp::cdev:vxfs:
lrwxrwxrwx 1 oracle dba 18 Nov 11 2000 tstab -> .tstab::cdev:vxfs:
3
Run the 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.
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
167Using Storage Checkpoints and Storage Rollback
Backing up and recovering the database using Storage Checkpoints