recover tablespace /database出现错误ORA-10561: block type 'TRANSACTION MANAGED DATA BLOCK', data object#

ORA-10561: block type 'TRANSACTION MANAGED DATA BLOCK', data object# 94252
错误原因：重做日志和数据块不一致导致的问题。

问题欢迎过程：

    1.首先我对表空间进行了一次备份backup  tablespace t1

    2.模拟表空间的数据文件丢失rm -f  xxx.dbf

    3.强制关闭数据库

    4.启动到mount状态

    5.restore tablespace t1

    --这里忘记recover tableapce t1了，直接open数据库了（误操作，没做这一步）

    6.alter database open   发现表中数据有丢失，就是没有执行 recover tablespace t1的原因

    7.切换日志，重新模拟数据文件丢失rm -f xxx.dbf

    8.此时重启前面的恢复过程，使用第一次备份进行恢复，在recover tablespace t1的时候出现改错误

思考：为啥在这种情况下会导致重做日志和数据块不一致的问题？

 

RMAN> recover tablespace t1;

Starting recover at 13-MAR-19
using channel ORA_DISK_1

starting media recovery
media recovery failed
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 03/13/2019 18:04:09
RMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed
 start
ORA-00600: internal error code, arguments: [3020], [5], [135], [20971655], [], [], [], [], [], [], [], []
ORA-10567: Redo is inconsistent with data block (file# 5, block# 135, file offset is 1105920 bytes)
ORA-10564: tablespace T1
ORA-01110: data file 5: '/oradata/rzxerp/t1.dbf'
ORA-10561: block type 'TRANSACTION MANAGED DATA BLOCK', data object# 94252

解决方案：

然后我就按照官方文档使用recover database allow 1 corruption 将不一致的块标记为损坏，然后可以执行进一步的恢复尝试来恢复数据库。恢复过程中，发现不一致性的数据块数量不止一个，反复执行下面命令，终于熬到了Media recovery complete了。

RMAN> recover database allow 1 corruption
2> ;

Starting recover at 13-MAR-19
using channel ORA_DISK_1

starting media recovery
media recovery failed
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 03/13/2019 18:09:25
ORA-00283: recovery session canceled due to errors
RMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed
 start allow 1 corruption
ORA-00283: recovery session canceled due to errors
ORA-00600: internal error code, arguments: [3020], [5], [131], [20971651], [], [], [], [], [], [], [], []
ORA-10567: Redo is inconsistent with data block (file# 5, block# 131, file offset is 1073152 bytes)
ORA-10564: tablespace T1
ORA-01110: data file 5: '/oradata/rzxerp/t1.dbf'
ORA-10561: block type 'TRANSACTION MANAGED DATA BLOCK', data object# 94252

RMAN> recover database allow 1 corruption;

Starting recover at 13-MAR-19
using channel ORA_DISK_1

starting media recovery
media recovery complete, elapsed time: 00:00:01

Finished recover at 13-MAR-19

RMAN> alter database open;

database opened