dbv

The DBVERIFY utility, available since in oracle 7.3, Check the logical integrity of an offline database. The file can only be datafiles. DEVERIFY can't analyze online redo log files or archived redo log files. In pervious version of Oracle DBV could analyze all of TS Datafiles in parallel by spawning multiple DBV cmd's. However, becuase Bigfile TS has only one datafile, DBV has been
enhanced to analyze parts of a bigfile TS's Datafiles in parallel.

SQL> host dbv help=y

DBVERIFY: Release 9.0.1.1.1 - Production on Fri Jul 13 22:30:36 2007

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

Keyword Description (Default)
----------------------------------------------------

FILE File to Verify (NONE)

START Start Block (First Block of File)

END End Block (Last Block of File)

BLOCKSIZE Logical Block Size (2048)

LOGFILE Output Log (NONE)

FEEDBACK Display Progress (0)

PARFILE Parameter File (NONE)

USERID Username/Password (NONE)

SEGMENT_ID Segment ID (tsn.relfile.block) (NONE)

SQL> select file#,blocks,name from v$datafile;

FILE# BLOCKS NAME
---------- ---------- ---------------------------------------------------------
1 83200 E:\SP2\ORACLE\ORADATA\ORCL\SYSTEM01.DBF
2 51200 E:\SP2\ORACLE\ORADATA\ORCL\UNDOTBS01.DBF
3 5120 E:\SP2\ORACLE\ORADATA\ORCL\CWMLITE01.DBF
4 5120 E:\SP2\ORACLE\ORADATA\ORCL\DRSYS01.DBF
5 39040 E:\SP2\ORACLE\ORADATA\ORCL\EXAMPLE01.DBF
6 6400 E:\SP2\ORACLE\ORADATA\ORCL\INDX01.DBF
7 2560 E:\SP2\ORACLE\ORADATA\ORCL\TOOLS01.DBF
8 6400 E:\SP2\ORACLE\ORADATA\ORCL\USERS01.DBF

8 rows selected.

SQL> host dbv file=E:\SP2\oracle\oradata\orcl\UNDOTBS01.DBF BLOCKSIZE=4096

DBVERIFY: Release 9.0.1.1.1 - Production on Fri Jul 13 22:46:46 2007

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

DBVERIFY - Verification starting : FILE = E:\SP2\oracle\oradata\orcl\UNDOTBS01.D
BF


DBVERIFY - Verification complete

Total Pages Examined : 51200
Total Pages Processed (Data) : 0
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 0
Total Pages Failing (Index): 0
Total Pages Processed (Other): 30224
Total Pages Processed (Seg) : 0
Total Pages Failing (Seg) : 0
Total Pages Empty : 20976
Total Pages Marked Corrupt : 0
Total Pages Influx : 0