Databases Reference
In-Depth Information
At this point, a dbv command is issued from the command line prompt to find out
the status of datafile 5 . DBV here stands for Database File Verifier. .
$ dbv file='/u01/oracle/oradata/beta/example01.dbf'
DBVERIFY - Verification starting : FILE = /u01/oracle/oradata/beta/
example01.dbf
Page 16 is marked corrupt
Corrupt block relative dba: 0x01400010 (file 5, block 16)
Bad header found during dbv:
Data in bad block:
type: 67 format: 7 rdba: 0x0a545055
last change scn: 0x0000.0006d15a seq: 0x1 flg: 0x06
spare1: 0x52 spare2: 0x52 spare3: 0x0
consistency value in tail: 0xd15a0601
check value in block header: 0xcb3b
computed block checksum: 0xe446
Several other pages were found to be corrupt:
DBVERIFY - Verification complete
Total Pages Examined : 12800
Total Pages Processed (Data) : 4405
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 1279
Total Pages Failing (Index): 0
Total Pages Processed (Other): 1581
Total Pages Processed (Seg) : 0
Total Pages Failing (Seg) : 0
Total Pages Empty : 5515
Total Pages Marked Corrupt : 20
Total Pages Influx : 0
Highest block SCN : 4860803 (0.4860803)
 
Search WWH ::




Custom Search