Using DBV(DB Verify utility)

NOTE:

Can be used to identify block corruption

Need to identify and pass the block size argument

Can be directly run on the file from the OS Prompt

Finding Block size

SELECT tablespace_name, block_size FROM dba_tablespaces;

Examples

dbv file='/SID/oradata/data01/apps_ts_tx_data02.dbf' blocksize=8192

dbv file='/SID/oradata/data01/apps_ts_queues01.dbf' blocksize=8192

dbv file='/SID/oradata/data02/sysaux01.dbf' blocksize=8192

dbv file='/SID/oradata/data02/system01.dbf' blocksize=8192

dbv file='/SID/oradata/data01/apps_ts_seed01.dbf' blocksize=8192

dbv file='/SID/oradata/data02/system05.dbf' blocksize=8192

dbv file='/SID/oradata/data02/system07.dbf' blocksize=8192

dbv file='/data/d01/SID/SID_system_01.dbf' blocksize=8192

dbv file='UBSM_VALIDATED_DATA_01.dbf' blocksize=8192