• 企业400电话
  • 微网小程序
  • AI电话机器人
  • 电商代运营
  • 全 部 栏 目

    企业400电话 网络优化推广 AI电话机器人 呼叫中心 网站建设 商标✡知产 微网小程序 电商运营 彩铃•短信 增值拓展业务
    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表空间最佳实践(包含段检查),希望对大家有所帮助,如果大家有任何疑问请给我留言,小编会及时回复大家的。在此也非常感谢大家对脚本之家网站的支持!
    如果你觉得本文对你有帮助,欢迎转载,烦请注明出处,谢谢!

    您可能感兴趣的文章:
    • Oracle 区块链表创建过程详解
    • Oracle多表查询中间表的创建实例教程
    • Oracle数据库scott用户创建view视图权限的操作方法
    • Navicat Premium中Oracle创建主键自增的方法
    • Navicat for oracle创建数据库的方法
    • Oracle数据库创建存储过程的示例详解
    • 通过PLSQL Developer创建Database link,DBMS_Job,Procedure,实现Oracle跨库传输数据的方法(推荐)
    • oracle创建dblink方法示例
    • Oracle 给rac创建单实例dg并做主从切换功能
    • Oracle创建设置查询权限用户的方法
    • 使用sqlplus命令行工具为oracle创建用户和表空间
    • Oracle创建只读账号的详细步骤
    上一篇:Linux虚拟机下安装Oracle 11G教程图文解说
    下一篇:Oracle备库宕机启动的完美解决方案
  • 相关文章
  • 

    © 2016-2020 巨人网络通讯 版权所有

    《增值电信业务经营许可证》 苏ICP备15040257号-8

    Oracle创建新undo表空间最佳实践(包含段检查) Oracle,创,建新,undo,表,空间,