这篇文章主要介绍了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表空间实践(包含段检查),希望对大家有所帮助,如果大家有任何疑问请给我留言,小编会及时回复大家的。在此也非常感谢大家对爱安网网站的支持!
如果你觉得本文对你有帮助,欢迎转载,烦请注明出处,谢谢!

最新资讯
微软CEO:科技公司要像保护人权一样保护数据隐私

微软CEO:科技公司要像

1月23日,据国外媒体报道,微软CEO萨蒂亚·纳德拉在达沃斯
今天,北京快手科技向武汉市捐赠1亿元人民币

今天,北京快手科技向武

23日,武汉市新冠肺炎防控指挥部收到北京快手科技有限公
国铁集团:24日0时起 铁路免收退票费扩至全国

国铁集团:24日0时起 铁

为全力做好新型肺炎疫情防控工作,中国国家铁路集团有限
暴风集团:存在无法在法定期内披露2019年度报告风险

暴风集团:存在无法在

暴风集团发布公告称,截至目前,公司尚未聘请首席财务官和
拼多多通过收购获支付牌照? 回应:不予置评

拼多多通过收购获支付

针对网传“拼多多正式收购付费通获得支付牌照”一事,拼
中兴通讯:本次非公开发行股票将于2020年2月3日上市

中兴通讯:本次非公开

中兴通讯发布公告称,本次非公开发行股票将于2020年2月3
最新文章
oracle实现动态查询前一天早八点到当天早八点的数据功能示例

oracle实现动态查询前

这篇文章主要介绍了oracle实现动态查询前一天早八点到
简单实例解释Oracle分页查询

简单实例解释Oracle分

这篇文章主要给大家介绍了关于Oracle分页查询的相关资
win10系统安装oracle11g时遇到INS-13001环境不满足最低要求解决办法

win10系统安装oracle1

这篇文章主要介绍了win10系统安装oracle11g时遇到INS-
PLSQL配置远程Oracle数据库连接的示例代码

PLSQL配置远程Oracle

这篇文章主要介绍了PLSQL配置远程Oracle数据库连接的
windows本地安装配置oracle客户端完整流程(图文版)

windows本地安装配置o

这篇文章主要介绍了windows本地安装配置oracle客户端
PLSQL Developer连接Oracle11g 64位数据库配置详解(图文)

PLSQL Developer连接O

这篇文章主要介绍了PLSQL Developer连接Oracle11g 64