< Previous  | TOC | Index | Next  >

Verifying a Storage Checkpoint using the command line

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.

Usage Notes

• See the dbed_ckptcreate(1M) and dbed_ckptmount(1M) manual pages for more information.

 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

Creating online Storage Checkpoint of database PROD.

Storage Checkpoint Checkpoint_903937870 created.

$ mkdir /tmp/ckpt_ro

$ /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 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 dbv tool against Quick I/O file tstmp:

$ dbv file=/tmp/ckpt_ro/db01/tstmp

DBVERIFY: Release 8.1.5.0.0 - Production on Sun Nov 16 11:53:33 2014

(c) Copyright 1999 Oracle Corporation. All rights reserved.

DBVERIFY - Verification starting: FILE = \
/tmp/ckpt_ro/db01/PROD/tstmp

DBVERIFY - Verification complete

Total Pages Examined : 102400

Total Pages Processed (Data) : 5077

Total Pages Failing (Data) : 0

Total Pages Processed (Index): 2049

Total Pages Failing (Index): 0

Total Pages Processed (Other): 1681

Total Pages Empty : 93593

Total Pages Marked Corrupt : 0

Total Pages Influx : 0

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.