VERITAS Storage Foundation 4.1 for Oracle RAC HP Serviceguard Storage Management Suite Extracts, December 2005

Backing Up and Recovering the Database Using Storage Checkpoints
Verifying a Storage Checkpoint Using the Command Line
After creating a Storage Checkpoint, you may verify that it is free of errors using the
procedure below.
Usage Notes
See the sfrac_ckptcreate(1M) and sfrac_ckptmount(1M) manual pages for more
information. Also refer to the examples, “Creating Storage Checkpoints Using
sfrac_ckptcreate” on page 144 and “Mounting Storage Checkpoints Using
sfrac_ckptmount” on page 148.
▼ To verify that a Storage Checkpoint is error-free using the command line
1. Create and mount a Storage Checkpoint:
$ sfrac_ckptcreate -S DB12 -H $ORACLE_HOME
Storage Checkpoint Checkpoint_903937870 created.
$ sfrac_ckptmount -S DB12 -c Checkpoint_903937870 \
-m /ckptmnt
2. Examine the content of the Storage Checkpoint:
$ ls -l /ckptmnt/db01/DB12
-rw-r----- 1 oracle dba 12247040 Nov 13 15:28 control01.ctl
-rw-r----- 1 oracle dba 12247040 Nov 13 15:28 control02.ctl
-rw-r----- 1 oracle dba 12247040 Nov 13 15:28 control03.ctl
.
.
-rw-r----- 1 oracle dba 41951232 Oct 29 17:30 temp01.dbf
-rw-r----- 1 oracle dba 10493952 Nov 13 15:28 tools01.dbf
-rw-r----- 1 oracle dba 209723392 Nov 13 15:28 undotbs01.dbf
-rw-r----- 1 oracle dba 209723392 Nov 13 15:28 undotbs02.dbf
-rw-r----- 1 oracle dba 26222592 Nov 13 15:28 users01.dbf
3. Run the dbv tool against the datafile (for example, undotbs01.dbf):
$ dbv file=/ckptmnt/db01/db12/undotbs01.dbf blocksize=8192
DBVERIFY: Release 9.2.0.4.1 - Production on Thu Nov 13 15:46:10
2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights
reserved.
DBVERIFY - Verification starting : FILE =
/ckptmnt/db1/db1/undotbs01.dbf
Chapter 7, Using Storage Checkpoints and Storage Rollback 137