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 .
Thursday, March 09, 2006
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment