URGENT - Data Block corruption
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: URGENT - Data Block corruption

Hybrid View

  1. #1
    Join Date
    Apr 2001
    Location
    Vadodara, India
    Posts
    249

    URGENT - Data Block corruption

    When i try to take backup using RMAN (incremental level 0) it was terminated and showing block corruption in system datafile.

    I have check the dba_extents and the object is OBJ$

    and below message indicated in alert log file

    ----------------------------------------------------------------
    Corrupt block relative dba: 0x00403492 (file 1, block 13458)
    Bad check value found during backing up datafile
    Data in bad block -
    type: 6 format: 2 rdba: 0x00403492
    last change scn: 0x0000.0001a9d5 seq: 0x1 flg: 0x06
    consistency value in tail: 0xa9d50601
    check value in block header: 0x80a7, computed block checksum: 0x8656
    spare1: 0x0, spare2: 0x0, spare3: 0x0
    ***
    Reread of blocknum=13458, file=D:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF. found same corrupt data

    -----------------------------------------------------------

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    raise a TAR

  3. #3
    Join Date
    Apr 2001
    Location
    Vadodara, India
    Posts
    249
    Thanks

    But i do not have oracle support so i cannot raise TAR.


    Presently my database is running. i have not shutdown the DB after getting this error. If i bounce the DB then what will happen? will it opened??

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    restore from backup and roll forward then.

    And seeing as thought you don't have support, it cant be very important so you could just delete it and re-create it

  5. #5
    Join Date
    Apr 2001
    Location
    Vadodara, India
    Posts
    249
    Thanks for your reply

    I have taken offline backup yesterday night.

    So, i have restore SYSTEM tablespace's datafile and recover it??

  6. #6
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    Originally posted by davey23uk
    restore from backup and roll forward then.

    And seeing as thought you don't have support, it cant be very important so you could just delete it and re-create it
    Now that's funny! good call Davey lol!
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

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