How to find Block Corruption
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: How to find Block Corruption

  1. #1
    Join Date
    Sep 2000
    Posts
    384
    1.Will export will be able to detect block corruption ???

    or

    2.Analyze table validate structure will detect block corruption

    If second option is the best For Very big tables (One of my table is 9GB )How to do a Ananlyze table ..for finding block corruption

    3.Will RMAN backups will detect block corruption ???

    Or any easy and simple method to detect block corruption
    Radhakrishnan.M

  2. #2
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    1. if block corruption is detected, the export will fail, dunno about 2 or 3.
    2. second option, run dbv on all dbf

  3. #3
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,136
    RMAN updates V$BACKUP_CORRUPTION table.
    You can query from this table/view for corrupted file and block.


  4. #4
    Join Date
    Sep 2000
    Posts
    384
    Thanks Halo and Tamil ..

    This is what I read from Metalink ...


    Export will read all the data and report errors at the block level and data level without obtaining any locks. However, it will not perform index/block cross checking. Only analyze table validate structure with the cascade option will do that. The best combination to detect problems would be to (analyze with validate structure cascade) and then use export.


    Once In a month I just want to cross check my DB for Block corruption .

    1.The physical backups is done by RMAN ...
    So will v$backup_corruption will be just enough

    or if need to cross check with export what is the best method ..
    Radhakrishnan.M

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