Internal
2012-05-23
ORA-600 2252 错误与SCN的一致性
当数据库系统的时间被调整,回到历史状态时,数据库可能出现ORA-600 2252错误。
这个错误指,数据库的SCN被认为是错误和不合理的,Oracle内部控制每秒产生的SCN数量小于 16K 个,然后以1988年1月1日,0点0分0秒开始,可以计算出一个SCN可能的合理最大值。
如果当前SCN的指标超过了这个合理值,则系统就会出现ORA-600 2252错误。
这类错误的错误号可能类似如下:
这个错误指,数据库的SCN被认为是错误和不合理的,Oracle内部控制每秒产生的SCN数量小于 16K 个,然后以1988年1月1日,0点0分0秒开始,可以计算出一个SCN可能的合理最大值。
如果当前SCN的指标超过了这个合理值,则系统就会出现ORA-600 2252错误。
这类错误的错误号可能类似如下:
Mon May 14 17:55:54 2012如果确实因为调整系统时间导致,则可以将时间调整回正确日期,如果系统SCN真的非法跃迁,则可以等候一定时间,等候SCN合理值可以容纳该跃迁或不一致。
Errors in file /t3/orat3/product/admin/ora1020410/bdump/ora1020410_mmon_25386.trc:
ORA-00600: internal error code, arguments: [2252], [2988], [9], [], [], [], [], []
Mon May 14 17:56:06 2012
Errors in file /t3/orat3/product/admin/ora1020410/bdump/ora1020410_smon_23805.trc:
ORA-00600: internal error code, arguments: [2252], [2988], [13], [], [], [], [], []
Mon May 14 17:56:06 2012
Non-fatal internal error happenned while SMON was doing extent coalescing.
SMON encountered 1 out of maximum 100 non-fatal internal errors.
Mon May 14 17:56:07 2012
Errors in file /t3/orat3/product/admin/ora1020410/bdump/ora1020410_smon_23805.trc:
ORA-00600: internal error code, arguments: [2252], [2988], [13], [], [], [], [], []
Non-fatal internal error happenned while SMON was doing extent coalescing.
SMON encountered 2 out of maximum 100 non-fatal internal errors.
Mon May 14 17:56:09 2012
Errors in file /t3/orat3/product/admin/ora1020410/bdump/ora1020410_smon_23805.trc:
ORA-00600: internal error code, arguments: [2252], [2988], [14], [], [], [], [], []
Non-fatal internal error happenned while SMON was doing extent coalescing.
SMON encountered 3 out of maximum 100 non-fatal internal errors.
Mon May 14 17:56:10 2012
Errors in file /t3/orat3/product/admin/ora1020410/bdump/ora1020410_smon_23805.trc:
ORA-00600: internal error code, arguments: [2252], [2988], [14], [], [], [], [], []
Non-fatal internal error happenned while SMON was doing extent coalescing.
SMON encountered 4 out of maximum 100 non-fatal internal errors.
Mon May 14 17:56:11 2012
Errors in file /t3/orat3/product/admin/ora1020410/bdump/ora1020410_smon_23805.trc:
ORA-00600: internal error code, arguments: [2252], [2988], [15], [], [], [], [], []
Non-fatal internal error happenned while SMON was doing extent coalescing.
SMON encountered 5 out of maximum 100 non-fatal internal errors.
历史上的今天
- 2015-05-23 Oracle RWP性能之旅 PPT教材下载地址
- 2015-05-23 异彩纷呈 - Oracle RWP China 性能之旅中国行
- 2008-05-23 试用并选择 Firefox 3.0 全面取代IE
- 2008-05-23 Oracle 10g 之HIGH Water MARK 数据统计
- 2007-05-23 杭州景美 阿里情深 诺顿害人
- 2006-05-23 请客吃饭 报名征集中...