Block corrupt, how to fix?
I got the following errors continuously when I run dbv on the datafile. However production database is working fine. How could I fix it? Is it serious? Tks.
OS: Solari 9
DB: Oracle 9i 188.8.131.52.0
Page 3 is marked corrupt
Corrupt block relative dba: 0x00000003 (file 0, block 3)
Completely zero block found during dbv:
Page 4 is marked corrupt
Corrupt block relative dba: 0x00000004 (file 0, block 4)
Bad header found during dbv:
Data in bad block -
type: 11 format: 2 rdba: 0x02c00001
last change scn: 0x0000.00000000 seq: 0x1 flg: 0x04
consistency value in tail: 0x00000000
check value in block header: 0xff84, computed block checksum: 0xb01
spare1: 0x0, spare2: 0x0, spare3: 0x0
Last edited by richyip; 08-02-2003 at 12:33 AM.
Click Here to Expand Forum to Full Width