Enter value for file_id: 6
old 3: WHERE header_file =&file_id
new 3: WHERE header_file =6
Enter value for block_id: 59
old 4: and header_block=&block_id
new 4: and header_block=59
no rows selected
由于出现这个错误，恢复中断
Metalink上解释：
This is called a 'STUCK RECOVERY'.
There is an inconsistency between the information stored in the redo and the information stored in a database block being recovered
+++从以上信息，我们可以大概猜测，oracle在做恢复时（0x0180003b (6/59)），发现redo信息与要恢复的数据块信息不一致，导致恢复无法继续
SCNs: scn: 0x0000.00158d60 (1412448) thru scn: 0x0000.001e3b9c (1981340)
由于测试库没有备份，只能损失部分数据来恢复数据库
SQL> recover datafile 6 allow 1 corruption;
ORA-00279: change 1981277 generated at 01/03/2014 14:24:15 needed for thread 1
ORA-00289: suggestion : /opt/arch/archive_1_45_834576965.arc
ORA-00280: change 1981277 for thread 1 is in sequence #45
Specify log: {
auto
ORA-00279: change 1981343 generated at 01/03/2014 14:25:15 needed for thread 1
ORA-00289: suggestion : /opt/arch/archive_1_46_834576965.arc
ORA-00280: change 1981343 for thread 1 is in sequence #46
Log applied.
Media recovery complete.
SQL>
SQL> alter database datafile 6 online;
Database altered.
相关阅读：