Block corrupt, how to fix?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Block corrupt, how to fix?

Threaded View

  1. #1
    Join Date
    Apr 2003
    Location
    Kuala Lumpur
    Posts
    59

    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 9.2.0.1.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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width