After creating a Storage Checkpoint and before using it to back up or restore a database, you can verify that the Storage Checkpoint is free of errors using the procedure below.
To verify that a Storage Checkpoint is error-free using the command line
$ /opt/VRTS/bin/dbed_ckptcreate-S PROD -H /oracle/product -o online
Creating online Storage Checkpoint of database PROD.
Storage Checkpoint Checkpoint_903937870 created.
$ /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.
$ 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 -> \
lrwxrwxrwx 1 oracle dba 18 Nov 11 2000 tstab -> \
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.