Thursday, March 09, 2006

Block Corrupted on datafile

when you found some block corrupt, if you use 9i and 10G , you can use rman command for blockrecover


example you found this error from alert log

ORA-01578: ORACLE data block corrupted (file # 8, block # 13)
ORA-01110: data file 8: '/oracle/oradata/trgt/users01.dbf'
ORA-01578: ORACLE data block corrupted (file # 2, block # 19)
ORA-01110: data file 2: '/oracle/oradata/trgt/undotbs01.dbf'


you can resolve this problem by:

rman> BLOCKRECOVER DATAFILE 8 BLOCK 13 DATAFILE 2 BLOCK 19;


By don't need offline datafile .

No comments: