Search This Blog

Total Pageviews

Friday 18 March 2011

Oracle dbv database verify Utility

15:57:07 SQL> set linesize 100
15:57:13 SQL> show parameter block
NAME_COL_PLUS_SHOW_PARAM TYPE VALUE_C
-------------------------------------------------------------------------------- ----------- -------
db_block_buffers integer 0
db_block_checking string FALSE
db_block_checksum string TRUE
db_block_size integer 8192
db_file_multiblock_read_count integer 16




15:58:09 SQL> !dbv file=/opt/oracle/oradata/orcl/dmdocbase01.dbf blocksize=8192 feedback=3200

DBVERIFY: Release 10.2.0.4.0 - Production on Fri Mar 18 15:58:12 2011

Copyright (c) 1982, 2007, Oracle. All rights reserved.

DBVERIFY - Verification starting : FILE = /opt/oracle/oradata/orcl/dmdocbase01.dbf
................................................................................
........................

DBVERIFY - Verification complete

Total Pages Examined : 331776
Total Pages Processed (Data) : 184373
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 121327
Total Pages Failing (Index): 0
Total Pages Processed (Other): 8360
Total Pages Processed (Seg) : 0
Total Pages Failing (Seg) : 0
Total Pages Empty : 17716
Total Pages Marked Corrupt : 0
Total Pages Influx : 0
Highest block SCN : 2909064 (0.2909064)

1 comment:

Anuj Singh said...


http://anuj-singh.blogspot.com/2010/04/dbv-for-asm-disk.html

Oracle DBA

anuj blog Archive