这篇文章主要介绍了Oracle创建新undo表空间实践(包含段检查),非常不错,具有一定的参考借鉴价值,需要的朋友可以参考下

在处理一则ORA-600 [4194]案例时,参考MOS文档:Step by step to resolve ORA-600 4194 4193 4197 on database crash (文档 ID 1428786.1)

1.对于ORA 600[4194]的解释

2.创建新undo表空间实践(包含段检查)

1.对于ORA 600[4194]的解释:

The following error is occurring in the alert.log right before the database crashes.
ORA-00600: internal error code, arguments: [4194], [#], [#], [], [], [], [], []
This error indicates that a mismatch has been detected between redo records and rollback (undo) records.
ARGUMENTS:
Arg [a] - Maximum Undo record number in Undo block
Arg [b] - Undo record number from Redo block
Since we are adding a new undo record to our undo block, we would expect that the new record number is equal to the maximum record number in the undo block plus one. Before Oracle can add a new undo record to the undo block it validates that this is correct. If this validation fails, then an ORA-600 [4194] will be triggered.

可以看到,此错误是因为redo和undo的记录不匹配。常见于异常断电等

2.创建新undo表空间实践(包含段检查)

Best practice to create a new undo tablespace.
his method includes segment check.
 Create pfile from spfile to edit
SQL> Create pfile='/tmp/initsid.ora' from spfile;
 Shutdown the instance
 set the following parameters in the pfile /tmp/initsid.ora
 undo_management = manual
 event = '10513 trace name context forever, level 2'
 SQL>>startup restrict pfile='/tmp/initsid.ora'
 SQL>select tablespace_name, status, segment_name from dba_rollback_segs where status != 'OFFLINE';
This is critical - we are looking for all undo segments to be offline - System will always be online.
If any are 'PARTLY AVAILABLE' or 'NEEDS RECOVERY' - Please open an issue with Oracle Support or update the current SR. There are many options from this moment and Oracle Support Analyst can offer different solutions for the bad undo segments.
If all offline then continue to the next step
 Create new undo tablespace - example
SQL>create undo tablespace <new undo tablespace> datafile <datafile> size 2000M;
 Drop old undo tablespace
SQL>drop tablespace <old undo tablespace> including contents and datafiles;
 SQL>shutdown immediate;
SQL>startup nomount; --> Using your Original spfile
. Modify the spfile with the new undo tablespace name
SQL> Alter system set undo_tablespace = '<new tablespace created in step 6>' scope=spfile;
. SQL>shutdown immediate;
. SQL>startup; --> Using spfile

总结

以上所述是小编给大家介绍的Oracle创建新undo表空间实践(包含段检查),希望对大家有所帮助,如果大家有任何疑问请给我留言,小编会及时回复大家的。在此也非常感谢大家对爱安网网站的支持!
如果你觉得本文对你有帮助,欢迎转载,烦请注明出处,谢谢!

最新资讯
蔚来汽车:首任ES6/ES8车主可享受终生免费换电服务

蔚来汽车:首任ES6/ES8

满足条件的蔚来车主,自驾前往任意营运中的换电站,均可享
超50万行代码 腾讯重磅发布全栈机器学习平台Angel 3.0

超50万行代码 腾讯重

一个全栈的机器学习平台,近日悄悄上线了。8月22日,腾讯
首届清华智班30人名单公布:专为AI培养 状元金牌云集

首届清华智班30人名单

今年5月,清华宣布成立”人工智能学堂班“,与姚班地位平
索尼和迪士尼“分手”了 但“蜘蛛侠宇宙”才刚开启

索尼和迪士尼“分手”

索尼、漫威和迪士尼的三方博弈尘埃落定,漫威将不再参与
"窃听风云""通天大盗" 黑客视角了解网络安全风险

"窃听风云""通天大

据统计,目前全国各预警平台平均每天产生的信息网络诈骗
黑洞也是由分子组成的?

黑洞也是由分子组成的

作为宇宙中最神秘的天体,黑洞一般被认为是一种扭曲的时
最新文章
Oracle备库宕机启动的完美解决方案

Oracle备库宕机启动的

这篇文章主要给大家介绍了关于Oracle备库宕机启动的完
Oracle的四道经典面试题分享

Oracle的四道经典面试

这篇文章主要给大家介绍了关于Oracle的四道经典面试题
oracle中利用关键字rownum查询前20名员工信息及rownum用法

oracle中利用关键字ro

这篇文章主要介绍了oracle中利用关键字rownum查询前20
Oracle截取JSON字符串内容的方法

Oracle截取JSON字符串

这篇文章主要介绍了Oracle截取JSON字符串内容 ,本文通
Oracle如何查看impdp正在执行的内容

Oracle如何查看impdp

这篇文章主要给大家介绍了关于Oracle如何查看impdp正
Linux虚拟机下安装Oracle 11G教程图文解说

Linux虚拟机下安装Ora

这篇文章主要介绍了Linux虚拟机下安装Oracle 11G教程