扫一扫
分享文章到微信
扫一扫
关注官方公众号
至顶头条
在解决2662错误之后,经常会出现Ora-00600 4193错误,经常可以在alert文件中看到的错误号类似:
Fri Dec 16 22:37:27 2005
Errors in file /opt/oracle/admin/conner/bdump/conner_smon_22817.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4193], [1171], [1187], [], [], [], [], []
Fri Dec 16 23:28:40 2005
Errors in file /opt/oracle/admin/conner/bdump/conner_smon_22817.trc:
ORA-00600: internal error code, arguments: [4193], [1171], [1187], [], [], [], [], []
4193错误通常是因为恢复时redo与undo不一致所导致。
Oracle的解释如下:
While backing out an undo record (i.e. at the time of rollback) we found a transaction id mis-match indicating either a corruption in the rollback segment or corruption in an object which the rollback segment is trying to apply undo records on.
This would indicate a corrupted rollback segment.
检查具体的Trace文件,可以发现类似如下错误:
*** 2005-12-16 20:54:53.496 |
由于是UNDO存在不一致,可以通过重建UNDO表空间来解决:
SQL> create undo tablespace undotbs2 Tablespace created. SQL> alter system set undo_tablespace=undotbs2 scope=both; System altered. SQL> shutdown immediate; Total System Global Area 114365800 bytes NAME TYPE VALUE SQL> drop tablespace undotbs1 including contents and datafiles; Tablespace dropped. |
至此,Ora-600 4193错误不再出现。
从alert文件中,可以看到自动控制文件备份生效:
Sun Dec 18 22:37:59 2005 |
如果您非常迫切的想了解IT领域最新产品与技术信息,那么订阅至顶网技术邮件将是您的最佳途径之一。
现场直击|2021世界人工智能大会
直击5G创新地带,就在2021MWC上海
5G已至 转型当时——服务提供商如何把握转型的绝佳时机
寻找自己的Flag
华为开发者大会2020(Cloud)- 科技行者