DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: data block corruption urgent plz....

Threaded View

  1. #4
    Join Date
    Feb 2007
    Location
    UNDER MOON
    Posts
    44
    1st find out which block are corrupted by using DBVERIFY utility.

    C:\>dbv file =''your file name'' example =e:\oracle\oradata\test\hr.dbf

    Than you realize which block are corrupted.

    Suppose "datafile 13 block 50000 and 5505"


    Go to RMAN prompt

    RMAN> blockrecover datafile 13 block 5000,5505;

    Those step only work if you have physical backup.
    Last edited by liakat; 07-27-2007 at 01:39 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