简单记录一次ORA-00600: internal error code, arguments: [2662]
code Error 简单 记录 一次 internal arguments ORA
2023-09-11 14:21:03 时间
接上一个,REDO报错搞定后OPEN数据库时又报错ORA-00600: internal error code, arguments: [2662]。
原因是_ALLOW_RESETLOGS_CORRUPTION后resetlogs打开数据库,我们可能会因为SCN不一致而遭遇到ORA-00600 2662号错误( current scn 小于undo block scn)。
现象及解决--这个没拍照參考EYGLE的样例吧
Sun Dec 11 18:02:25 2005 Errors in file /opt/oracle/admin/conner/udump/conner_ora_13349.trc: ORA-00600: internal error code, arguments: [2662], [0], [547743994], [0], [898092653], [8388617], [], [] Sun Dec 11 18:02:27 2005參考链接 周亮DBA实战攻略 http://www.eygle.com/archives/2005/12/oracle_diagnostics_howto_deal_2662_error.html此时我们能够通过Oracle的内部事件来调整SCN:
增进SCN有两种经常用法:
1.通过immediate trace name方式(在数据库Open状态下)
alter session set events 'IMMEDIATE trace name ADJUST_SCN level x';
2.通过10015事件(在数据库无法打开,mount状态下)
alter session set events '10015 trace name adjust_scn level x';
注:level 1为增进SCN 10亿 (1 billion) (1024*1024*1024),通常Level 1已经足够。也能够依据实际情况适当调整。
LEVEL的计算规则:
ORA-00600: internal error code, arguments: [2662], [0], [547743994], [0], [898092653], [8388617], [], []ORA-00600: internal error code, arguments: [2662], [a], [b], [c], [d], [e], [], []A CRUUENT SCN WRAP B--CURRENT SCN BASE C--DEPENDENT SCN WRAP D--DEPENDENT SCN BASE E--where present this is the dba where the dependent scn came from.
d< 1024*1024*1024=1073741824 时,须要的LEVEL为:c*4+1d< 1024*1024*1024*2=1073741824*2 时,须要的LEVEL为:c*4+2
还能够通过设置隐含參数_minimum_giga_scn 高速递增CURRENT SCN。2012年1月后的PSU中包括隐含參数_external_scnrejection_threshold_hours,此时隐含參数和10015事件会失效。
相关文章
- vs2017运行时修改代码Changes are not allowed while code is running.
- Visual Studio Code(VS code)你们都在用吗?或许你们需要看一下这篇博文 Asp.Net Core + SignalR 实现实时通信 Net Core 下 Newtonsoft.Json 转换字符串 null 替换成string.Empty
- [tool] Visual Studio Code python配置
- Error: [mobx] Since strict-mode is enabled, changing observed observable values outside actions is not allowed. Please wrap the code in an `action` if this change is intended.
- docker: Error response from daemon: error while creating mount source path mkdir
- SQL state [99999]; error code [17056]; 不支持的字符集 (在类路径中添加 orai18n.jar): ZHS16GBK;
- 【VSCode】代码行数统计/vs code counter
- 【HMS Core】视频编辑服务报错method not allowed 20124、Parameter error. Error: appId is invalid
- mysql错误一例:ERROR 1030 (HY000): Got error 28 from storage engine
- Code First系列之视图,存储过程和异步API
- Error Code: 1044. Access denied for user 'root'@'%' to database
- 深度强化学习 之 运行环境 mujoco 报错 ERROR: GLEW initalization error: Missing GL version
- Spring Boot的exit code
- 【Error】Error running process: CreateProcess failed. Code 2
- ORA-00600: internal error code, arguments: [SKGMFAIL], [2], [4], [4], [1], [], [], [], [], [], [], [
- Qt error ------ 出现Error - RtlWerpReportException failed with status code :-1073741823. Will try to launch the process directly
- 语义化HTML:p、h1-6、q、blockquote、hr、address、code、pre、var、cite、dfn和samp
- 代码编辑器横评:为什么 VS Code 能拔得头筹
- Code Review代码审查的思路
- Error Code: 1414. OUT or INOUT argument 2 for routine company.new_procedure is not a variable or NEW
- Job for iptables.service failed because the control process exit with error code 修复
- How to fix “HTTP Status Code 505 – HTTP Version Not Supported” error?--转
- 89. Gray Code