记一次异常断电导致ora-600、ORA-25153的处理经过

最新推荐文章于 2024-06-24 15:37:24 发布

当代小学生

最新推荐文章于 2024-06-24 15:37:24 发布

阅读量436

点赞数

分类专栏：数据库文章标签： ora600 重建控制文件重建undo 重建临时表空间

本文链接：https://blog.csdn.net/shilukun/article/details/102740964

版权

本文详细记录了一次由于异常断电导致ora-600错误和ORA-25153问题的处理过程，涉及控制文件重建、undo表空间修复及临时表空间重建等关键步骤，最终成功恢复数据库正常运行。

摘要由CSDN通过智能技术生成

朋友突然联系我说，他们项目的数据库宕机起不来了，报错全是600，请我帮他处理下，现在记录处理过程如下：

首先看下报错日志：

alter database mount
ORA-1100 signalled during: alter database mount ...
Fri Oct 25 08:53:37 2019
alter database open
Beginning crash recovery of 1 threads
parallel recovery started with 7 processes
Started redo scan
Completed redo scan
read 258 KB redo, 35 data blocks need recovery
Errors in file c:\app\administrator\diag\rdbms\xdyy\xdyy\trace\xdyy_ora_3068.trc (incident=19794):
ORA-00600: 内部错误代码, 参数: [kcratr_nab_less_than_odr], [1], [4757], [69495], [69667], [], [], [], [], [], [], []
Incident details in: c:\app\administrator\diag\rdbms\xdyy\xdyy\incident\incdir_19794\xdyy_ora_3068_i19794.trc
Aborting crash recovery due to error 600
Errors in file c:\app\administrator\diag\rdbms\xdyy\xdyy\trace\xdyy_ora_3068.trc:
ORA-00600: 内部错误代码, 参数: [kcratr_nab_less_than_odr], [1], [4757], [69495], [69667], [], [], [], [], [], [], []
Errors in file c:\app\administrator\diag\rdbms\xdyy\xdyy\trace\xdyy_ora_3068.trc:
ORA-00600: 内部错误代码, 参数: [kcratr_nab_less_than_odr], [1], [4757], [69495], [69667], [], [], [], [], [], [], []
ORA-600 signalled during: alter database open ...
Fri Oct 25 08:53:39 2019
Trace dumping is performing id=[cdmp_20191025085339]
Fri Oct 25 08:53:40 2019
Sweep [inc][19794]: completed
Sweep [inc2][19794]: completed
Fri Oct 25 08:55:45 2019
alter database mount
ORA-1100 signalled during: alter database mount ...
Fri Oct 25 08:57:02 2019
Shutting down instance (immediate)
Shutting down instance: further logons disabled
Stopping background process MMNL
Stopping background process MMON
License high water mark = 8