ORA-19566: exceeded limit of 0 corrupt blocks for file +DATA/DB/DATAFILEdatafile.772.1051794089
Find corrupted blocks for datafile and set maxcorrupt for datafile.
dbv file=+DATA/DB/DATAFILE/datafile.772.1051794089 blocksize=8192
...
Page 2454409 is marked corrupt
Corrupt block relative dba: 0x64a57389 (file 402, block 2454409)
Bad header found during dbv:
Data in bad block:
type: 6 format: 2 rdba: 0x64a57609
last change scn: 0x0000.000b.86f75786 seq: 0x2 flg: 0x04
spare3: 0x0
consistency value in tail: 0x57860602
check value in block header: 0x1792
computed block checksum: 0x0
DBVERIFY - Verification complete
Total Pages Examined : 2752512
Total Pages Processed (Data) : 8184
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 1020
Total Pages Failing (Index): 0
Total Pages Processed (Lob) : 2737986
Total Pages Failing (Lob) : 0
Total Pages Processed (Other): 2993
Total Pages Processed (Seg) : 0
Total Pages Failing (Seg) : 0
Total Pages Empty : 2317
Total Pages Marked Corrupt : 12
Total Pages Influx : 0
Total Pages Encrypted : 0
Highest block SCN : 7139905759 (1.2844938463)
Add your backup script;
set maxcorrupt for datafile 402 to 12;
Etiketler :
Oracle Troubleshooting