恢复数据,数据块恢复

10231 忽略受损的数据块.

1>alter session set events '10231 trace name context forever,level 10'

instanse 级别 :

parameter :

event='10231 trace name context forever ,level 10'

方法2:

execute dbms_repair.skip_corrupt_blocks('system','table_1')

2>检查数据块错误:

rman>backup check logical validate datafile1,2

rman>restore validate database

rman>restore validate controlfile to '/001.ctl'

rman>restore validate archivelog from sequence ??? to sequence xxxxx.

3>数据块恢复:

rman>blockrecover datafile1 block 28618

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/8568259/viewspace-2120292/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/8568259/viewspace-2120292/