摘要:物理STANDBY环境在进行恢复时碰到这个错误。详细错误信息为:<prelang=’SQL’SunSep1106:59:472011...
问题描述
物理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,那么考虑临时关闭并行恢复应该也是一个解决方法。
「喜欢文章,快来给作者赞赏墨值吧」
评论
请登录后发表评论
0
0
Oracle
订阅
欢迎订阅Oracle频道,订阅之后可以获取最新资讯和更新通知。
墨值排行
今日本周综合
近期活动
全部
相关课程
全部