recovertablespacedatabase出现错误ORA-10561：blockt。。
。
ORA-10561: block type 'TRANSACTION MANAGED DATA BLOCK', data object# 94252
错误原因：重做⽇志和数据块不⼀致导致的问题。
问题欢迎过程：
1.⾸先我对表空间进⾏了⼀次备份backup tablespace t1
2.模拟表空间的数据⽂件丢失rm -f xxx.dbf
3.强制关闭数据库
4.启动到mount状态
--这⾥忘记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
session数据错误是什么意思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
版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。
发表评论