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
