快捷搜索:

SCN不一致将会导致ORA-00600 2662错误

首先,在正常启动数据库后,大年夜家可以从alert文件中发明ora-00600 2662号差错。

Sun Dec 11 18:02:25 2005Errors in file /opt/oracle/admin/conner/udump/conner_ora_13349.trc:ORA-00600: internal error code, arguments: [2662], [0], [547743994], [0], [898092653], [8388617], [], []Sun Dec 11 18:02:27 2005Errors in file /opt/oracle/admin/conner/udump/conner_ora_13349.trc:ORA-00600: internal error code, arguments: [2662], [0], [547743994], [0], [898092653], [8388617], [], []Sun Dec 11 18:02:27 2005Error 600 happened during db open, shutting down databaseUSER: terminating instance due to error 600

(可以经由过程Oracle的内部变糊弄调剂SCN)

增进SCN的常用措施:

1.经由过程immediate trace name要领(在数据库Open状态下)

alter session set events ’IMMEDIATE trace name ADJUST_SCN level x’;

2.经由过程10015事故(在数据库无法打开,mount状态下)

alter session set events ’10015 trace name adjust_scn level x’;

注释:level 1为增进SCN 10亿 (1 billion) (1024*1024*1024),一样平常环境下Level 1已经够用。大年夜家也可以根据实际环境适当调剂。

在此示例中因为数据库无法打开,只能应用两种措施。

[oracle@jumper dbs]$ sqlplus "/ as sysdba"SQL*Plus: Release 9.2.0.4.0 - Production on Sun Dec 11 18:26:18 2005Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.Connected to an idle instance.SQL> startup mount pfile=initconner.oraORACLE instance started.Total System Global Area 97588504 bytesFixed Size 451864 bytesVariable Size 33554432 bytesDatabase Buffers 62914560 bytesRedo Buffers 667648 bytesDatabase mounted.SQL> alter session set events ’10015 trace name adjust_scn level 10’;Session altered.SQL> alter database open;Database altered.

大年夜家必要留意,因为示例中应用了10015事故,使得SCN增进了10 billion,稍后可以继承来验证。

[oracle@jumper dbs]$ sqlplus "/ as sysdba"SQL*Plus: Release 9.2.0.4.0 - Production on Sun Dec 11 18:26:18 2005Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.Connected to an idle instance.SQL> startup mount pfile=initconner.oraORACLE instance started.Total System Global Area 97588504 bytesFixed Size 451864 bytesVariable Size 33554432 bytesDatabase Buffers 62914560 bytesRedo Buffers 667648 bytesDatabase mounted.SQL> alter session set events ’10015 trace name adjust_scn level 10’;Session altered.SQL> alter database open;Database altered.

此时,数据库可以打开,从alert文件中大年夜家可以发明下面的提示:

Sun Dec 11 18:27:04 2005SMON: enabling cache recoverySun Dec 11 18:27:05 2005Debugging event used to advance scn to 10737418240

SCN被增进了10 billion,即 10 * (1024*1024*1024) = 10737418240,恰恰这天志里记录的数量。

大年夜家可以从数据库内部看一下反省点的增进环境:

SQL> select open_mode from v$database;OPEN_MODE----------READ WRITESQL> select file#,CHECKPOINT_CHANGE# from v$datafile; FILE# CHECKPOINT_CHANGE#---------- ------------------ 1 547783998 2 547783998 3 547783998SQL> shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down.SQL> startupORACLE instance started.Total System Global Area 97588504 bytesFixed Size 451864 bytesVariable Size 33554432 bytesDatabase Buffers 62914560 bytesRedo Buffers 667648 bytesDatabase mounted.Database opened.SQL> select file#,CHECKPOINT_CHANGE# from v$datafile; FILE# CHECKPOINT_CHANGE#---------- ------------------ 1 1.0737E+10 2 1.0737E+10 3 1.0737E+10SQL> col CHECKPOINT_CHANGE# for 99999999999999999SQL> select file#,CHECKPOINT_CHANGE# from v$datafile; FILE# CHECKPOINT_CHANGE#---------- ------------------ 1 10737418447 2 10737418447 3 10737418447

至此,大年夜家可以发明CHECKPOINT_CHANGE#着末被增进了10 Billion。

您可能还会对下面的文章感兴趣: