[20170512]ora-00600[2662]错误3.txt

[20170512]ora-00600[2662]错误3.txt

--//前一阵子的测试:链接http://blog.itpub.net/267265/viewspace-2137424/
--//本想测试修改一些重要的信息块,结果提升了scn的结果,但是如果异常关闭,就没有这样的结果.

--//前几看http://www.itpub.net/thread-2087326-1-1.html
--//很奇怪看到的scn号减少的,理论讲出现这个错误,如果不断重启scn号每次加1,差距不大可以追上.
ORA-00600: 内部错误代码, 参数: [2662], [0], [20556827], [0], [20564324], [12583040], [], [], [], [], [], []
ORA-00600: 内部错误代码, 参数: [2662], [0], [20556826], [0], [20564324], [12583040], [], [], [], [], [], []
ORA-01092: ORACLE 实例终止。强制断开连接
ORA-00600: 内部错误代码, 参数: [2662], [0], [20556824], [0], [20564324], [12583040], [], [], [], [], [], []

--//但是看到是减少的,很奇怪.我自己模拟这样的情况,是否最后可以正常启动.
--//再次说明,绝不要在生产系统做这样的测试!!

1.环境:
SCOTT@book> @ &r/ver1
PORT_STRING                    VERSION        BANNER
------------------------------ -------------- --------------------------------------------------------------------------------
x86_64/Linux 2.4.xx            11.2.0.4.0     Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

--//另外说明一下在system文件块头中保存一个bootstrap$的段头地址。
BBED> p kcvfh.kcvfhrdb
ub4 kcvfhrdb                                @96       0x00400208

> @ &r/dfb16 0x00400208

    RFILE#     BLOCK# TEXT
---------- ---------- ------------------------------------------------------------
         1        520 alter system dump datafile 1 block 520 ;

--//oracle 通过system文件头读取kcvfhrdb，定位sys.bootstrap$信息，加载数据字典。
--//修改这个块dba=1,521块的scn大于块头,看看启动会发生什么?

2.通过bbed观察记录dba=1,521块的scn。
--//正常关闭数据库.

p dba 1,521 kcbh.bas_kcbh
p dba 1,521 ktbbh.ktbbhitl[0].ktbitbas
p dba 1,521 ktbbh.ktbbhcsc.kscnbas

BBED> p dba 1,521 kcbh.bas_kcbh
ub4 bas_kcbh                                @8        0x000001d7

BBED> p dba 1,521 ktbbh.ktbbhitl[0].ktbitbas
ub4 ktbitbas                                @64       0x000001d7

BBED> p dba 1,521 ktbbh.ktbbhcsc.kscnbas
ub4 kscnbas                                 @28       0x00000173

SYS@book> SELECT file#, CHECKPOINT_CHANGE#, CHECKPOINT_TIME,CREATION_CHANGE#  , RESETLOGS_CHANGE#,status, CHECKPOINT_COUNT,fuzzy,name,tablespace_name  FROM v$datafile_header;
FILE# CHECKPOINT_CHANGE# CHECKPOINT_TIME     CREATION_CHANGE# RESETLOGS_CHANGE# STATUS  CHECKPOINT_COUNT FUZ NAME                                               TABLESPACE_NAME
----- ------------------ ------------------- ---------------- ----------------- ------- ---------------- --- -------------------------------------------------- ------------------------------
    1        13276968090 2017-05-12 10:25:45                7            925702 ONLINE               870 NO  /mnt/ramdisk/book/system01.dbf                     SYSTEM
    2        13276968090 2017-05-12 10:25:45             1834            925702 ONLINE               859 NO  /mnt/ramdisk/book/sysaux01.dbf                     SYSAUX
    3        13276968090 2017-05-12 10:25:45           923328            925702 ONLINE               780 NO  /mnt/ramdisk/book/undotbs01.dbf                    UNDOTBS1
    4        13276968090 2017-05-12 10:25:45            16143            925702 ONLINE               865 NO  /mnt/ramdisk/book/users01.dbf                      USERS
    5        13276968090 2017-05-12 10:25:45           952916            925702 ONLINE               776 NO  /mnt/ramdisk/book/example01.dbf                    EXAMPLE
    6        13276968090 2017-05-12 10:25:45      13276257767            925702 ONLINE               247 NO  /mnt/ramdisk/book/tea01.dbf                        TEA
6 rows selected.

--//假设现在要修改块scn=13276968100.比文件头大10.

select 13276968100,trunc(13276968100/power(2,32)) scn_wrap,mod(13276968100,power(2,32))  scn_base from dual
13276968100     SCN_WRAP     SCN_BASE SCN_WRAP16 SCN_BASE16
------------ ------------ ------------ ---------- ----------
13276968100            3    392066212          3   175e74a4

--//执行如下：(注测试库的scn wrap=3 ,也要修改)
assign  dba 1,521 kcbh.bas_kcbh=392066212
assign  dba 1,521 kcbh.wrp_kcbh=3

--//注意tailchk也要跟着修改，因为这部分包括{(bas_kcbh(低2字节))+(type_kcbh)+(seq_kcbh)}

BBED> p dba 1,521 tailchk
ub4 tailchk                                 @8188     0x01d70601

BBED> assign dba 1,521 tailchk=0x074a40601
ub4 tailchk                                 @8188     0x74a40601

--//补充说明一下，使用assign命令修改tailchk,如果第1个大于0x8,不能这样修改。例子：
BBED> assign dba 1,521 tailchk=0x8c000601
BBED-00207: invalid offset specifier (8c000601)

--//要执行如下，注意cpu类型，大小头问题。
BBED> modify /x 0x008c 8190
File: /mnt/ramdisk/book/system01.dbf (1)
Block: 521                      Offsets: 8190 to 8191                             Dba:0x00400209
--------------------------------------------------------------------------------------------------
008c

<64 bytes per line>

BBED> p dba 1,521 tailchk
ub4 tailchk                                 @8188     0x8c000601
---//

BBED> sum apply dba 1,521
Check value for File 1, Block 521:
current = 0x45a7, required = 0x45a7

BBED> verify dba 1,521
DBVERIFY - Verification starting
FILE = /mnt/ramdisk/book/system01.dbf
BLOCK = 521

--OK.现在dba=1,521 scn =13276968100 .

3.测试：
SYS@book> alter database open ;
alter database open
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00704: bootstrap process failure
ORA-00600: internal error code, arguments: [2662], [3], [392066208], [3], [392066212], [4194825], [], [], [], [], [], []
Process ID: 9198
Session ID: 232 Serial number: 3

--//重新启动数据库到mount:
SYS@book> SELECT file#, CHECKPOINT_CHANGE#, CHECKPOINT_TIME,CREATION_CHANGE#  , RESETLOGS_CHANGE#,status, CHECKPOINT_COUNT,fuzzy,name,tablespace_name  FROM v$datafile_header where file#=1;
FILE# CHECKPOINT_CHANGE# CHECKPOINT_TIME     CREATION_CHANGE# RESETLOGS_CHANGE# STATUS  CHECKPOINT_COUNT FUZ NAME                                               TABLESPACE_NAME
----- ------------------ ------------------- ---------------- ----------------- ------- ---------------- --- -------------------------------------------------- ------------------------------
    1        13276968094 2017-05-12 10:32:15                7            925702 ONLINE               871 YES /mnt/ramdisk/book/system01.dbf                     SYSTEM

--//对比前面的scn 从13276968090 => 13276968094,增加4.

SYS@book> alter database open ;
Database altered.

--//这次open就正常了,没有报错..

SYS@book> select power(2,32)*3+392066208 from dual ;
POWER(2,32)*3+392066208
-----------------------
            13276968096

SYS@book> @ &r/dfb10 4194825
      RFILE#       BLOCK#
------------ ------------
           1          521

TEXT
----------------------------------------
alter system dump datafile 1 block 521 ;

--//也再次说明差距不大,重启几次就可以避开这个错误.再次想起以前的一次测试http://blog.itpub.net/267265/viewspace-2137424/.
--//那次我修改dba 1,225 就是undo$ 的数据块。结果提升了这个数据库的scn号.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/267265/viewspace-2138954/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/267265/viewspace-2138954/