崩溃恢复的起点和终点(三)
union ktbbhsid, 4 bytes @24
struct ktbbhcsc, 8 bytes @28
sb2 ktbbhict @36
ub1 ktbbhflg @38
ub1 ktbbhfsl @39
ub4 ktbbhfnx @40
struct ktbbhitl[2], 48 bytes @44
struct kdbh, 14 bytes @100
ub1 kdbhflag @100
sb1 kdbhntab @101
sb2 kdbhnrow @102
sb2 kdbhfrre @104
sb2 kdbhfsbo @106
sb2 kdbhfseo @108
sb2 kdbhavsp @110
sb2 kdbhtosp @112
struct kdbt[1], 4 bytes @114
sb2 kdbtoffs @114
sb2 kdbtnrow @116
sb2 kdbr[28] @118
ub1 freespace[7846] @174
ub1 rowdata[168] @8020
ub4 tailchk @8188
BBED> p kdbhnrow
sb2 kdbhnrow @102 28--28行数据
BBED>
BBED>
BBED> p *kdbr[28]
BBED-00401: file not found; arguments: [28] --下标以0开始
BBED> p *kdbr[27] --下标27为最后一条数据
rowdata[0]
----------
ub1 rowdata[0] @8020 0x2c
BBED>
BBED>
BBED> x /rnccntnnn
rowdata[0] @8020
----------
flag@8020: 0x2c (KDRHFL, KDRHFF, KDRHFH)
lock@8021: 0x02
cols@8022: 1
col 0[2] @8023: 28 --第28条数据为28
SESSION C：
SESSION C>startup mount
ORACLE 例程已经启动。
Total System Global Area 334036992 bytes
Fixed Size 2228144 bytes
Variable Size 201326672 bytes
Database Buffers 125829120 bytes
Redo Buffers 4653056 bytes
数据库装载完毕。
SESSION A：
SESSION A> select group# from v$log where status='CURRENT';
GROUP#
----------
1
SESSION A>select member from v$logfile where group#=1;
MEMBER
------------------------------
/u01/app/oracle/oradata/myorcl/redo01.log
SESSION A>alter session set events 'immediate trace name controlf level 3';
会话已更改。
SESSION A>
SESSION A>alter system dump logfile '/u01/app/oracle/oradata/myorcl/redo01.log';
系统已更改。
SESSION A>oradebug tracefile_name
/u01/app/oracle/diag/rdbms/myorcl/myorcl/trace/myorcl_ora_6375.trc
***************************************************************************
CHECKPOINT PROGRESS RECORDS
***************************************************************************
(size = 8180, compat size = 8180, section max = 11, section in-use = 0,
last-recid= 0, old-recno = 0, last-recno = 0)
(extent = 1, blkno = 2, numrecs = 11)
THREAD #1 - status:0x2 flags:0x0 dirty:5
low cache rba:(0x25.42.0) on disk rba:(0x25.48.0)
on disk scn: 0x0000.00199bec 04/26/2013 14:19:09
resetlogs scn: 0x0000.00106ee4 04/10/2013 14:52:35
heartbeat: 813797392 mount id: 234341189
THREAD #2 - status:0x0 flags:0x0 dirty:0
low cache rba:(0x0.0.0) on disk rba:(0x0.0.0)
刚才数据文件中的Thread Checkpoint RBA是00000025.00000042.047e0010
控制文件中的low cache rba为0x25.42.0
显然是数据文件中的Thread Checkpoint RBA大