ORA-00600 [2662][][][][][] 错误解决

今天给客户做数据恢复，发现必须使用隐藏参数_allow_resetlogs_corruption，结果一用报出了ORA-00600 2662的错误。客户那边说丢失了一个数据文件CUUG.DBF，只有一个以前的冷备份（结果就备份了这一个数据文件............#@#@￥...）。接管客户系统时，那边dba已经将控制文件重建了。无语中......将以前的数据文件拷贝回来，重新注册归档日志后，开始恢复。报错：

提示ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: "/opt/Oracle/product/10.2.0/oradata/orcl1/system01.dbf"

看下数据文件的SCN：

SQL> select CHECKPOINT_CHANGE# from v$datafile_header;
CHECKPOINT_CHANGE#
------------------
591931
591931
591931
591931
505927

然后看下归档日志：

/opt/oracle/product/10.2.0/flash_recovery_area/ORCL1/archivelog/2012_05_19/o1_mf_1_9_7vh78q75_.arc 591800 591805
/opt/oracle/product/10.2.0/flash_recovery_area/ORCL1/archivelog/2012_05_19/o1_mf_1_8_7vh78gwc_.arc 590306 591800
/opt/oracle/product/10.2.0/flash_recovery_area/ORCL1/archivelog/2012_05_19/o1_mf_1_10_7vh7b2xs_.arc 591805 591931

这眼看普通恢复没戏了.....归档日志不连续。开启隐藏参数sql> alter system set "_allow_resetlogs_corruption"=true scope=spfile;再次尝试打开数据库，开始提示ORA-00600错误了。

Wed May 23 15:06:44 2012
SMON: enabling cache recovery
Wed May 23 15:06:44 2012
Errors in file /opt/oracle/product/10.2.0/admin/orcl1/udump/orcl1_ora_4268.trc:
ORA-00600: internal error code, arguments: [2662], [0], [545944], [0], [590505], [4194313], [], []
Wed May 23 15:06:44 2012
Incremental checkpoint up to RBA [0x1.3.0], current log tail at RBA [0x1.3.0]
Wed May 23 15:06:44 2012
Errors in file /opt/oracle/product/10.2.0/admin/orcl1/udump/orcl1_ora_4268.trc:
ORA-00600: internal error code, arguments: [2662], [0], [545944], [0], [590505], [4194313], [], []
Wed May 23 15:06:44 2012
Error 600 happened during db open, shutting down database
USER: terminating instance due to error 600
Instance terminated by USER, pid = 4268

ORA-00600[kcratr1_lastbwr][][][][] 错误解决64位Redhat（RHEL）成功安装Oracle 9i相关资讯 Oracle错误代码 ORA-00600 ORA-00600错误代码

ORA-00600（13013）错误解决方法（今 07:47）
ORA-00600: internal error code, （04月19日）
ORA-00600 错误解决一例（10/21/2015 20:56:11）

一个SQL语句引发的ORA-00600错误排（07月21日）
cursor_sharing引发的ORA-00600错（01月09日）
遭遇 ORA-00600: internal error （09/17/2015 19:21:46）

本文评论查看全部评论（0）

表情：姓名：匿名字数

<button class="layui-btn layui-bg-purple" id="dofav">收藏该网址</button>
        </div>
    </div>
</div>
<div class="copyright">
    <div id="footbar">
        版权所有©石家庄振强科技有限公司2024 <a href="https://beian.miit.gov.cn" target="_blank">冀ICP备08103738号-5</a> <a href="/storage/sitemap.xml">网站地图</a>
    </div>
</div>
<script> var _mtj = _mtj || [];
(function () {
    var mtj = document.createElement("script");
    mtj.src = "https://node12.aizhantj.com:21233/tjjs/?k=p2tceukth5c";
    var s = document.getElementsByTagName("script")[0];
    s.parentNode.insertBefore(mtj, s);
})(); </script>
<script src="/static/lib/layui/layui.js"></script>
<script src="/static/lib/jquery/jquery.js"></script>
<script src="/static/lib/ajax.js"></script>
<script>
    layui.use(function () {
        var layer = layui.layer;
        var $ = layui.jquery;
        $("#dofav").click(function () {
            var artid = $(".article").attr("artid");
            var params={
                artid:artid,
                addtype:'escdns_article',
                t:Math.random()
            };
            if(artid>0){
                ajax.request({
                    method: "/index/article/addfavorite", type: "post", callback: function (res) {
                        layer.msg(res.msg);
                    }
                },params);
            }
        })
    })
</script>
</body>
</html>