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 and Mounting Storage Checkpoints Using sfrac_ckptmount.
To verify that a Storage Checkpoint is error-free using the command line
-
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
-
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
-
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
DBVERIFY - Verification complete
Total Pages Examined : 25600
Total Pages Processed (Data) : 0
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 0
Total Pages Failing (Index): 0
Total Pages Processed (Other): 8880
Total Pages Processed (Seg) : 0
Total Pages Failing (Seg) : 0
Total Pages Empty : 16720
Total Pages Marked Corrupt : 0
Total Pages Influx : 0
|