rman 备份报数据块错误，求教如何修复，能正常执行rman

jackcc_csdn 2018-03-25 09:19:02

Starting backup at 25-MAR-18
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/db12c/system01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/db12c/sysaux01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/db12c/undotbs01.dbf
input datafile file number=00007 name=/u01/app/oracle/oradata/db12c/users01.dbf
channel ORA_DISK_1: starting piece 1 at 25-MAR-18
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 03/25/2018 20:51:04
ORA-19566: exceeded limit of 10 corrupt blocks for file /u01/app/oracle/oradata/db12c/sysaux01.dbf
----
找原因：执行： dbv file=/u01/app/oracle/oradata/db12c/sysaux01.dbf
发现file 3 有 corrupt block ，但查询 SELECT segment_type, owner, segment_name
FROM dba_extents
WHERE file_id = 3
and 69120 between block_id AND block_id + blocks - 1; 都是 no row
...
Page 69117 is marked corrupt
Corrupt block relative dba: 0x00c10dfd (file 3, block 69117)
Completely zero block found during dbv:

Page 69118 is marked corrupt
Corrupt block relative dba: 0x00c10dfe (file 3, block 69118)
Completely zero block found during dbv:

Page 69119 is marked corrupt
Corrupt block relative dba: 0x00c10dff (file 3, block 69119)
Completely zero block found during dbv:

Page 69120 is marked corrupt
Corrupt block relative dba: 0x00c10e00 (file 3, block 69120)
Completely zero block found during dbv:

...全文