物理STANDBY环境在进行恢复时碰到这个错误。
详细错误信息为：
<pre lang=’SQL’>Sun Sep 11 06:59:47 2011
alter database recover datafile list clear
Sun Sep 11 06:59:47 2011
Completed: alter database recover datafile list clear
Sun Sep 11 06:59:47 2011
alter database recover datafile list
1 , 2 , 3 , 4 , 5 , 6 , 7 , 8 , 9 , 10 , 11 , 12 , 13 , 14 , 15 , 16 , 17 , 18
Completed: alter database recover datafile list
1 , 2 , 3 , 4 , 5 , 6 , 7 , 8 , 9 , 10 , 11 , 12 , 13 , 14 , 15 , 16 , 17 , 18
Sun Sep 11 06:59:47 2011
alter database recover if needed
start until time ‘SEP 04 2011 06:00:54’ using backup controlfile
Media Recovery Start
Sun Sep 11 06:59:47 2011
Media Recovery failed with error 1124
ORA-283 signalled during: alter database recover if needed
start until time ‘SEP 04 2011 06:00:54′ using backup controlfile
…
Sun Sep 11 07:38:12 2011
Errors in file /oracle/admin/ccicmix/udump/ccicmix_ora_9699350.trc:
ORA-00600: internal error code, arguments: [krd_check_slaves_1], [], [], [],
[], [], [], []
Sun Sep 11 07:38:18 2011
Recovery interrupted!</pre>
显然这里的ORA-600错误和前面的恢复操作有直接关系。
<pre lang=’SQL’>ORA-00283 recovery session canceled due to errors
Cause: An
error during recovery was determined to be fatal enough to end the current
recovery session.
Action: More specific messages
will accompany this message. Refer to the other messages for the appropriate
action.
ORA-01124: cannot recover data file string – file is in use or recovery
Cause: An attempt to do media recovery found that the file was not available
for recovery. Either it is online and the database is open in some instance, or
another process is curently doing media recovery on the file.
Action: Do not do media recovery.</pre>
这是ORA-600错误中，ORA-283和ORA-1124错误的官方描述，这两个错误的信息都说明，在恢复过程中出现异常。
检查了metalink，发现这是一个bug，对应的文章信息为：Ora 600 Raised During Recover
Until Time When Archive Required Not Present [ID 406263.1]。
当对数据库进行基于时间的不完全恢复，开始并行恢复后，就可能碰到这个bug，而且是10.2.0.2以上的10g版本都有可能碰到。
如果不能通过应用补丁来解决这个bug，那么考虑临时关闭并行恢复应该也是一个解决方法。