[20150601]模拟ora-00600[2608]错误.txt
--前几天在测试使用bbed解决丢失的归档,链接:
http://blog.itpub.net/267265/viewspace-1676438/ [20150529]使用bbed解决丢失的归档.txt
--出现如下错误:
ORA-00600: internal error code, arguments: [2608], [1], [2], [4101877000], [2], [4101877009], [], []
--不过后续的我做的操作在也没有出现这个错误.上午看了刘工的链接:
http://www.askmaclean.com/archives/oracle%E5%86%85%E9%83%A8%E9%94%99%E8%AF%AFora-00600-2608%E4%B8%80%E4%BE%8B.html
--自己重复模拟看看:
该ORA-00600[2608]可能由数据文件头中记录的checkpoint scn过小造成，Oracle会将该checkpoint scn与块中的resetlogs scn以及控制
文件中记录的日志文件的Low scn相比较，若文件头中的checkpoint scn远小于对比值，那么就会出现ORA-00600[2608]内部错误。
下面我们通过修改数据文件头中kcvfhckp结构中记录的checkpoint scn到一个较小值，来模拟出发ORA-00600[2608]内部错误:
1.测试环境:
SYS@test> @ &r/ver1
PORT_STRING VERSION BANNER
------------------------------ -------------- ----------------------------------------------------------------
x86_64/Linux 2.4.xx 10.2.0.4.0 Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
--启动数据库到mount状态.
SYS@test> SELECT file#, CHECKPOINT_CHANGE#, UNRECOVERABLE_CHANGE# ,LAST_CHANGE#, OFFLINE_CHANGE#, ONLINE_CHANGE#,status FROM v$datafile;
FILE# CHECKPOINT_CHANGE# UNRECOVERABLE_CHANGE# LAST_CHANGE# OFFLINE_CHANGE# ONLINE_CHANGE# STATUS
------------ ------------------ --------------------- ------------ --------------- -------------- ----------
1 12691983312 0 12691983312 0 0 SYSTEM
2 12691983312 0 12691983312 0 0 ONLINE
3 12691983312 0 12691983312 0 0 ONLINE
4 12691983312 0 12691983312 0 0 ONLINE
5 12691983312 0 12691983312 0 0 ONLINE
6 12691983312 0 12691983312 12691975496 12691983100 ONLINE
6 rows selected.
SYS@test> SELECT file#, CHECKPOINT_CHANGE#, CREATION_CHANGE# , RESETLOGS_CHANGE#,status, CHECKPOINT_COUNT,fuzzy FROM v$datafile_header;
FILE# CHECKPOINT_CHANGE# CREATION_CHANGE# RESETLOGS_CHANGE# STATUS CHECKPOINT_COUNT FUZ
------------ ------------------ ---------------- ----------------- ---------- ---------------- ---
1 12691983312 5 12691748925 ONLINE 868465271 NO
2 12691983312 600647 12691748925 ONLINE 868465271 NO
3 12691983312 6678 12691748925 ONLINE 868465271 NO
4 12691983312 10685 12691748925 ONLINE 868465274 NO
5 12691983312 625439 12691748925 ONLINE 868465271 NO
6 12691983312 11997383136 12691748925 ONLINE 292 NO
6 rows selected.
SYS@test> @ &r/logfile
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME GROUP# STATUS TYPE MEMBER IS_
------ ------- --------- ----------- ------- --- ---------- ------------- ------------------- ------ ---------- ---------- ----------------------------- ---
1 1 40 52428800 1 YES INACTIVE 12691887202 2015-05-30 04:05:39 1 ONLINE /mnt/ramdisk/test/redo01.log NO
2 1 41 52428800 1 NO CURRENT 12691935321 2015-05-31 10:08:21 2 ONLINE /mnt/ramdisk/test/redo02.log NO
3 1 39 52428800 1 YES INACTIVE 12691855595 2015-05-29 10:32:22 3 ONLINE /mnt/ramdisk/test/redo03.log NO
--当前数据文件6的scn是12691983312.
12691983312-2^33=4102048720
4102048720 = 0xf4804bd0
0xf4700000 = 4100980736
4100980736+2^33=12690915328
修改为 0xf4700000
--RESETLOGS_CHANGE#
12691748925-2^33=4101814333
4101814333 = 0xf47cb83d
----我准备将scn最后4位修改为f4804bd0=>0xf4700000看看(比RESETLOGS_CHANGE#小).(注意我的测试环境wrap=2,要扣除2^32*2)
2.bbed修改:
BBED> set dba 6,1
DBA 0x01800001 (25165825 6,1)
BBED> p kcvfh.kcvfhrls
struct kcvfhrls, 8 bytes @116
ub4 kscnbas @116 0xf47cb83d
ub2 kscnwrp @120 0x0002
--resetlogset scn,与前面的正好对上.
f47cb83d = 4101814333
4101814333+2^33=12691748925
-----
BBED> p kcvfh.kcvfhckp
struct kcvfhckp, 36 bytes @484
struct kcvcpscn, 8 bytes @484
ub4 kscnbas @484 0xf4804bd0
ub2 kscnwrp @488 0x0002
ub4 kcvcptim @492 0x3486c9dc
ub2 kcvcpthr @496 0x0001
union u, 12 bytes @500
struct kcvcprba, 12 bytes @500
ub4 kcrbaseq @500 0x00000029
ub4 kcrbabno @504 0x00012fa6
ub2 kcrbabof @508 0x0010
ub1 kcvcpetb[0] @512 0x02
ub1 kcvcpetb[1] @513 0x00
ub1 kcvcpetb[2] @514 0x00
ub1 kcvcpetb[3] @515 0x00
ub1 kcvcpetb[4] @516 0x00
ub1 kcvcpetb[5] @517 0x00
ub1 kcvcpetb[6] @518 0x00
ub1 kcvcpetb[7] @519 0x00
BBED> p kcvfh.kcvfhckp.kcvcpscn.kscnbas
ub4 kscnbas @484 0xf4804bd0
--要颠倒1下.
BBED> modify /x 0000
...
BBED> p kcvfh.kcvfhckp.kcvcpscn.kscnbas
ub4 kscnbas @484 0xf4800000
BBED> set offset +2
OFFSET 486
BBED> modify /x 70f4
...
BBED> p kcvfh.kcvfhckp.kcvcpscn.kscnbas
ub4 kscnbas @484 0xf4800000
BBED> p kcvfh.kcvfhckp.kcvcpscn.kscnbas
ub4 kscnbas @484 0xf4700000
BBED> sum apply ;
Check value for File 6, Block 1:
current = 0x28e6, required = 0x28e6
3.开始测试:
SYS@test> SELECT file#, CHECKPOINT_CHANGE#, UNRECOVERABLE_CHANGE# ,LAST_CHANGE#, OFFLINE_CHANGE#, ONLINE_CHANGE#,status FROM v$datafile;
FILE# CHECKPOINT_CHANGE# UNRECOVERABLE_CHANGE# LAST_CHANGE# OFFLINE_CHANGE# ONLINE_CHANGE# STATUS
------------ ------------------ --------------------- ------------ --------------- -------------- ----------
1 12691983312 0 12691983312 0 0 SYSTEM
2 12691983312 0 12691983312 0 0 ONLINE
3 12691983312 0 12691983312 0 0 ONLINE
4 12691983312 0 12691983312 0 0 ONLINE
5 12691983312 0 12691983312 0 0 ONLINE
6 12691983312 0 12691983312 12691975496 12691983100 ONLINE
6 rows selected.
SYS@test> SELECT file#, CHECKPOINT_CHANGE#, CREATION_CHANGE# , RESETLOGS_CHANGE#,status, CHECKPOINT_COUNT,fuzzy FROM v$datafile_header;
FILE# CHECKPOINT_CHANGE# CREATION_CHANGE# RESETLOGS_CHANGE# STATUS CHECKPOINT_COUNT FUZ
------------ ------------------ ---------------- ----------------- ---------- ---------------- ---
1 12691983312 5 12691748925 ONLINE 868465271 NO
2 12691983312 600647 12691748925 ONLINE 868465271 NO
3 12691983312 6678 12691748925 ONLINE 868465271 NO
4 12691983312 10685 12691748925 ONLINE 868465274 NO
5 12691983312 625439 12691748925 ONLINE 868465271 NO
6 12690915328 11997383136 12691748925 ONLINE 292 NO
6 rows selected.
SYS@test> alter database open ;
alter database open
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [3619], [1], [0], [], [], [], [], []
SYS@test> select open_mode from v$database ;
OPEN_MODE
----------
MOUNTED
SYS@test> recover datafile 6;
ORA-00283: recovery session canceled due to errors
ORA-00600: internal error code, arguments: [2608], [2], [2], [4100980736], [2], [4102000729], [], []
--第2个参数2,标识log group#(我猜测的)
--第3个参数wrap,第4个参数base scn. 文件头CHECKPOINT_CHANGE#.
--第5个参数wrap,第6个参数base scn. 这个值是log group# =2 ,FIRST_CHANGE#.
2^33+4100980736=12690915328
2^33+4102000729=12691935321
4.还原现场:
BBED> set dba 6,1
DBA 0x01800001 (25165825 6,1)
BBED> p kcvfh.kcvfhckp.kcvcpscn.kscnbas
ub4 kscnbas @484 0xf4700000
BBED> modify /x d04b
..
BBED> set offset +2
OFFSET 486
BBED> modify /x 80f4
BBED> p kcvfh.kcvfhckp.kcvcpscn.kscnbas
ub4 kscnbas @484 0xf4804bd0
BBED> sum apply ;
Check value for File 6, Block 1:
current = 0x254d, required = 0x254d
SYS@test> SELECT file#, CHECKPOINT_CHANGE#, UNRECOVERABLE_CHANGE# ,LAST_CHANGE#, OFFLINE_CHANGE#, ONLINE_CHANGE#,status FROM v$datafile;
FILE# CHECKPOINT_CHANGE# UNRECOVERABLE_CHANGE# LAST_CHANGE# OFFLINE_CHANGE# ONLINE_CHANGE# STATUS
------------ ------------------ --------------------- ------------ --------------- -------------- ----------
1 12691983312 0 12691983312 0 0 SYSTEM
2 12691983312 0 12691983312 0 0 ONLINE
3 12691983312 0 12691983312 0 0 ONLINE
4 12691983312 0 12691983312 0 0 ONLINE
5 12691983312 0 12691983312 0 0 ONLINE
6 12691983312 0 12691983312 12691975496 12691983100 ONLINE
6 rows selected.
SYS@test> SELECT file#, CHECKPOINT_CHANGE#, CREATION_CHANGE# , RESETLOGS_CHANGE#,status, CHECKPOINT_COUNT,fuzzy FROM v$datafile_header;
FILE# CHECKPOINT_CHANGE# CREATION_CHANGE# RESETLOGS_CHANGE# STATUS CHECKPOINT_COUNT FUZ
------------ ------------------ ---------------- ----------------- ---------- ---------------- ---
1 12691983312 5 12691748925 ONLINE 868465271 NO
2 12691983312 600647 12691748925 ONLINE 868465271 NO
3 12691983312 6678 12691748925 ONLINE 868465271 NO
4 12691983312 10685 12691748925 ONLINE 868465274 NO
5 12691983312 625439 12691748925 ONLINE 868465271 NO
6 12691983312 11997383136 12691748925 ONLINE 292 NO
6 rows selected.
SYS@test> shutdown immediate ;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SYS@test> startup mount
ORACLE instance started.
Total System Global Area 473956352 bytes
Fixed Size 2084776 bytes
Variable Size 260046936 bytes
Database Buffers 201326592 bytes
Redo Buffers 10498048 bytes
Database mounted.
SYS@test> alter database open ;
Database altered.
SYS@test> select * from scott.deptx;
DEPTNO DNAME LOC
------------ -------------- -------------
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON
