Block Corruption
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Block Corruption

Hybrid View

  1. #1
    Join Date
    Sep 2000
    Posts
    305
    I some how find out that one of my Index in the system tablespace is corrupt what will happen if I drop and recreate that Index.

    please try to give reply as soon as possible.
    Shailendra

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    What makes you to suspect the index?
    Dropping and recreating the index will get rid of block corruption.

    Sanjay

  3. #3
    Join Date
    Sep 2000
    Posts
    305
    Thanks sanjay

    I have got this error

    ORA-01115: IO error reading block from file 1 (block # 14022)
    ORA-01110: data file 1: '/home/oracle8/OraHome1/oradata/oradata/hungama/system01.dbf'
    ORA-27091: skgfqio: unable to queue I/O
    Linux Error: 5: Input/output error
    Additional information: 14021

    file 1 = is system data file
    and the block_id is 14022 but when I query for this block to find out its segment it is giving me an error but when I query for 14021 block_id it is giving that this block is for Index I_obj2

    now what should I do? Should I drop that Index and recreate it?
    Shailendra

  4. #4
    Join Date
    Feb 2001
    Location
    UAE
    Posts
    304
    If the corrupted block contains user object, then you are safe.
    You can drop that object and recreate in a different tablespace.

    Execute following query to finedout which object occupies the
    corrupt block.

    SELECT SEGMENT_NAME, SEGMENT_TYPE FROM DBA_EXTENTS WHERE FILE_ID = 1 and 14022 BETWEEN BLOCK_ID AND BLOCK_ID + BLOCKS - 1;
    Agasimani
    OCP(10g/9i/8i/8)

  5. #5
    Join Date
    Jun 2002
    Posts
    73
    Don't worry, recreating an index will not harm you. Use REBUILD command.
    You cannot succeed if you fear to face challenges.
    MAS
    BE(CS) , OCP 8/8i.



  6. #6
    Join Date
    May 2001
    Location
    New Zealand
    Posts
    123
    Hi

    I think you should look at this document as well

    http://metalink.oracle.com/metalink/...T&p_id=28814.1

    Cheers
    Afshin

  7. #7
    Join Date
    Sep 2000
    Posts
    305
    When I tried to rebuild, It is giving Error

    ERROR at line 1:
    ORA-00604: error occurred at recursive SQL level 1
    ORA-00060: deadlock detected while waiting for resource

    Shailendra

  8. #8
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    No, no.
    If that index belongs to SYS then don't rebuild it. Possibly you will have to restore and recover the SYSTEM datafile.

    Sanjay

  9. #9
    Join Date
    Sep 2000
    Posts
    305
    Sanjay can you write down the steps to recover the system datafile


    Shailendra

  10. #10
    Join Date
    Sep 2000
    Posts
    305
    what is the drawback if I recreate the Index I mean first I drop it and recreate it will it effect somewhere, it is in system tablespace.

    Shailendra Singh

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