Yves, Have you had the opportunity to use the blockrecover statement and if so were you successful most of the times you used it?
I was caught in a similar situation recently and I tried using dbms_repair.fix_corrupt_block procedure but it didn't really fix the corrupt block for me and instead I had to make the corrupt block SKIP everytime the adjacent blocks would be read. I am really interested in knowing what truly can fix a corrupt block. I have opened up a tar with oracle on this issue and can share my experience and observation when I think I will have resolved my problem.
merci beaucoup,
Gurmohan
www.onlymath.com - Place to learn and teach math.
-----Original Message-----
From: Yves
[mailto:oracledba-ezmlmshield-x5660214.[Email address protected]
Sent: Tuesday, November 01, 2005 9:21 AM
To: LazyDBA Discussion
Subject: RE: Have RMAN Fix Bad Blocks?
RMAN> Blockrecover datafile <filenum> block <blocknum>;
>Merci / Thanks
>Yves Leonard,
>Chef de Projet / Project Leader,
>DDS / SDD,
>RH Coats, 13-I
>Télép>ĥ>one / phone : 613-951-3233,
>couriel / email : yves.[Email address protected]
>
-----Original Message-----
From: Effie Jennings [mailto:oracledba-ezmlmshield-x12262368.[Email address protected]
Sent: October 31, 2005 7:51 PM
To: LazyDBA Discussion
Subject: Have RMAN Fix Bad Blocks?
Hello,
I am using Oracle9i. I have heard that RMAN can be used to fix block
corruption in a way that the database does not have to be taken
offline. Can anyone please share what the RMAN steps and commands are
to do this?
Thanks,
Effie
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page