转储日志文件实验

来源：互联网发布：主机是数据终端设备编辑：程序博客网时间：2024/04/28 06:03

今天实验的内容是对online redo log进行转储，并分析其中内容

--创建测试表

SQL> conn zlm/zlm

Connected.

SQL> create table t1(name varchar2(10));

Table created.

--插入数据

SQL> insert into t1 values('abc');

1 row created.

SQL> commit;

Commit complete.

SQL> select group#,sequence#,status,first_change# from v$log;

GROUP# SEQUENCE# STATUS FIRST_CHANGE#

---------- ---------- ---------------- -------------

1 1 INACTIVE 1723867

2 2 CURRENT 1743875

3 0 UNUSED 0

SQL> select * from v$logfile;

GROUP# STATUS TYPE MEMBER IS_

---------- ------- ------- --------------------------------------------- ---

3 ONLINE /u01/app/oracle/oradata/zlm11g/redo03.log NO

2 ONLINE /u01/app/oracle/oradata/zlm11g/redo02.log NO

1 ONLINE /u01/app/oracle/oradata/zlm11g/redo01.log NO

--切换日志

SQL> alter system switch logfile;

System altered.

--更新t1表

SQL> update t1 set name='def';

1 row updated.

SQL> commit;

Commit complete.

SQL> select group#,sequence#,status,first_change# from v$log;

GROUP# SEQUENCE# STATUS FIRST_CHANGE#

---------- ---------- ---------------- -------------

1 1 INACTIVE 1723867

2 2 ACTIVE 1743875

3 3 CURRENT 1746970

--切换日志

SQL> alter system switch logfile;

System altered.

SQL> select group#,sequence#,status,first_change# from v$log;

GROUP# SEQUENCE# STATUS FIRST_CHANGE#

---------- ---------- ---------------- -------------

1 4 CURRENT 1746997

2 2 ACTIVE 1743875

3 3 ACTIVE 1746970

切换2次日志以后，当前日志组变为1，之前update操作的内容，记录在之前的那组online redo日志文件中，即序列3对应的第3组日志文件

--转储日志文件

SQL> alter system dump logfile '/u01/app/oracle/oradata/zlm11g/redo03.log';

System altered.

--通过脚本捕获trace文件

SQL> SELECT d.VALUE || '/' || LOWER(RTRIM(i.INSTANCE, CHR(0))) || '_ora_' ||

2 p.spid || '.trc' trace_file_name

3 FROM (SELECT p.spid

4 FROM v$mystat m, v$session s, v$process p

5 WHERE m.statistic# = 1

6 AND s.SID = m.SID

7 AND p.addr = s.paddr) p,

8 (SELECT t.INSTANCE

9 FROM v$thread t, v$parameter v

10 WHERE v.NAME = 'thread'

11 AND (v.VALUE = 0 OR t.thread# = TO_NUMBER(v.VALUE))) i,

12 (SELECT VALUE FROM v$parameter WHERE NAME = 'user_dump_dest') d;

TRACE_FILE_NAME

----------------------------------------------------------------------------------------------------------------------------------

/u01/app/oracle/diag/rdbms/zlm11g/zlm11g/trace/zlm11g_ora_6138.trc

SQL>

由于还要使用这个会话做一些演示，为了方便查看，再另外开一个session，查看捕获到的trace文件

[oracle@zlm2 ~]$ cat /u01/app/oracle/diag/rdbms/zlm11g/zlm11g/trace/zlm11g_ora_6138.trc

--环境部分

Trace file /u01/app/oracle/diag/rdbms/zlm11g/zlm11g/trace/zlm11g_ora_6138.trc

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1

System name: Linux

Node name: zlm2

Release: 2.6.32-200.13.1.el5uek

Version: #1 SMP Wed Jul 27 21:02:33 EDT 2011

Machine: x86_64

Instance name: zlm11g

Redo thread mounted by this instance: 1

Oracle process number: 19

Unix process pid: 6138, image: oracle@zlm2 (TNS V1-V3)

以上内容包括ORACLE_HOME环境变量，主机名，系统版本号，架构，实例名等

进程号pid6138，在OS上通过ps -ef可以获取：

[oracle@zlm2 ~]$ ps aux|grep ora|grep LOCAL=YES|grep -v grep

oracle 6138 0.2 3.9 1083252 81672 ? Ss 00:05 0:03 oraclezlm11g (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

*** 2015-01-01 00:10:55.201

*** SESSION ID:(38.13) 2015-01-01 00:10:55.201

*** CLIENT ID:() 2015-01-01 00:10:55.201

*** SERVICE NAME:(SYS$USERS) 2015-01-01 00:10:55.201

*** MODULE NAME:(SQL*Plus) 2015-01-01 00:10:55.201

*** ACTION NAME:() 2015-01-01 00:10:55.201

以上信息包括转储操作时间，操作模块，操作会话等，SESSION ID对应sid和serial#可以通过以下SQL语句查询获得：

SQL> select sid from v$mystat where rownum<2;

SID

----------

SQL> select sid,serial# from v$session where sid=38;

SID SERIAL#

---------- ----------

38 13

--文件头部分

Initial buffer sizes: read 1024K, overflow 832K, change 805K

Log read is SYNCHRONOUS though disk_asynch_io is enabled! --尽管磁盘异步io是enabled，但是日志读取仍然是同步的

DUMP OF REDO FROM FILE '/u01/app/oracle/oradata/zlm11g/redo03.log'

Opcodes *.*

RBAs: 0x000000.00000000.0000 thru 0xffffffff.ffffffff.ffff

SCNs: scn: 0x0000.00000000 thru scn: 0xffff.ffffffff

Times: creation thru eternity

FILE HEADER:

Compatibility Vsn = 186646528=0xb200000

Db ID=536742738=0x1ffe0b52, Db Name='ZLM11G'

Activation ID=583916685=0x22cddc8d

Control Seq=4798=0x12be, File size=102400=0x19000

File Number=3, Blksiz=512, File Type=2 LOG

descrip:"Thread 0001, Seq# 0000000003, SCN 0x0000001aa81a-0x0000001aa835"

thread: 1 nab: 0xc seq: 0x00000003 hws: 0x2 eot: 0 dis: 0

resetlogs count: 0x33b98e2f scn: 0x0000.001a4ddb (1723867)

prev resetlogs count: 0x30f58973 scn: 0x0000.0014248f (1320079)

Low scn: 0x0000.001aa81a (1746970) 01/01/2015 00:07:31

Next scn: 0x0000.001aa835 (1746997) 01/01/2015 00:08:09

Enabled scn: 0x0000.001a4ddb (1723867) 12/31/2014 23:09:35

Thread closed scn: 0x0000.001aa81a (1746970) 01/01/2015 00:07:31

Disk cksum: 0xa903 Calc cksum: 0xa903

Terminal recovery stop scn: 0x0000.00000000

Terminal recovery 01/01/1988 00:00:00

Most recent redo scn: 0x0000.00000000

Largest LWN: 3 blocks

End-of-redo stream : No

Unprotected mode

Miscellaneous flags: 0x800000

Thread internal enable indicator: thr: 0, seq: 0 scn: 0x0000.00000000

Zero blocks: 8

Format ID is 2

redo log key is 219262ef1796229e573c92311e442b2

redo log key flag is 5

Enabled redo threads: 1

dbid和db_name也可以通过查询以下视图获得：

SQL> select dbid,name from v$database;

DBID NAME

---------- ---------

536742738 ZLM11G

File Number=3, Blksiz=512, File Type=2 LOG

表示文件号为3，块大小为512(OS最小的块)，文件类型是日志文件

descrip:"Thread 0001, Seq# 0000000003, SCN 0x0000001aa81a-0x0000001aa835"

thread: 1 nab: 0xc seq: 0x00000003 hws: 0x2 eot: 0 dis: 0

表示日志序列3，SCN 0x0000001aa81a-0x0000001aa835"是16进制SCN号，是一个范围，从Low scn到Next scn

Low scn和Next scn对应的值和v$log中的first_change#对应：

SQL> select group#,sequence#,status,first_change# from v$log;

GROUP# SEQUENCE# STATUS FIRST_CHANGE#

---------- ---------- ---------------- -------------

1 4 CURRENT 1746997

2 2 ACTIVE 1743875

3 3 ACTIVE 1746970

如果dump的是current日志，那么Next scn的值为无穷大

--重做记录部分

REDO RECORD - Thread:1 RBA: 0x000003.00000002.0010 LEN: 0x0140 VLD: 0x05

SCN: 0x0000.001aa81a SUBSCN: 1 01/01/2015 00:07:31

(LWN RBA: 0x000003.00000002.0010 LEN: 0003 NST: 0001 SCN: 0x0000.001aa81a)

CHANGE #1 TYP:0 CLS:27 AFN:3 DBA:0x00c000d0 OBJ:4294967295 SCN:0x0000.001aa7c3 SEQ:1 OP:5.2 ENC:0 RBL:0

ktudh redo: slt: 0x000b sqn: 0x000004a6 flg: 0x0411 siz: 80 fbi: 0

uba: 0x00c05282.010b.1b pxid: 0x0000.000.00000000

CHANGE #2 TYP:0 CLS:28 AFN:3 DBA:0x00c05282 OBJ:4294967295 SCN:0x0000.001aa7c2 SEQ:1 OP:5.1 ENC:0 RBL:0

ktudb redo: siz: 80 spc: 3210 flg: 0x0010 seq: 0x010b rec: 0x1b

xid: 0x0006.00b.000004a6

ktubl redo: slt: 11 rci: 0 opc: 5.7 [objn: 0 objd: 0 tsn: 0]

Undo type: Regular undo Begin trans Last buffer split: No

Temp Object: No

Tablespace Undo: No

0x00000000 prev ctl uba: 0x00c05282.010b.1a

prev ctl max cmt scn: 0x0000.001aa100 prev tx cmt scn: 0x0000.001aa114

txn start scn: 0xffff.ffffffff logon user: 100 prev brb: 12604033 prev bcl: 0 BuExt idx: 0 flg2: 0

CHANGE #3 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:5.20 ENC:0

session number = 38

serial number = 13

transaction name =

Recursive transaction

LSBY preserve

version 186647296

audit sessionid 810234

Client Id =

Thread:1 RBA: 0x000003.00000002.0010 LEN: 0x0140 VLD: 0x05

SCN: 0x0000.001aa81a SUBSCN: 1 01/01/2015 00:07:31

Thread:1 线程号，单实例都为1

RBA: 0x000003.00000002.0010 每个Redo记录有一个地址（RBA）。日志序号+块头+块字节号（偏移量）日志序号为0x13=3，第2块，偏移为16

LEN: 0x0140 记录长度（ bytes）

SCN: 0x0000.001aa81a 系统改变号，对应为1746970（十进制）

01/01/2015 00:07:31 改变的日期和时间

AFN:3 DBA:0x00c000d0 OBJ:4294967295 SCN:0x0000.001aa7c3

AFN:3 表示3号数据文件，可以通过以下视图得到确认，是undo表空间的文件：

SQL> col file_name for a50

SQL> select file_name,file_id from dba_data_files;

FILE_NAME FILE_ID

-------------------------------------------------- ----------

/u01/app/oracle/oradata/zlm11g/users01.dbf 4

/u01/app/oracle/oradata/zlm11g/undotbs01.dbf 3

/u01/app/oracle/oradata/zlm11g/sysaux01.dbf 2

/u01/app/oracle/oradata/zlm11g/system01.dbf 1

/u01/app/oracle/oradata/zlm11g/example01.dbf 5

/u01/app/oracle/oradata/zlm11g/zlm01.dbf 6

DBA:0x00c000d0 表示Data Block Address，即数据块号，以下匿名块可以获得：

SQL> set serveroutput on

SQL> DECLARE

2 l_dba NUMBER := TO_NUMBER ('c000d0','XXXXXXXX');

3 l_file NUMBER := DBMS_UTILITY.DATA_BLOCK_ADDRESS_FILE (l_dba);

4 l_block NUMBER := DBMS_UTILITY.DATA_BLOCK_ADDRESS_BLOCK (l_dba);

5 BEGIN

6 DBMS_OUTPUT.PUT_LINE ('File : '||l_file);

7 DBMS_OUTPUT.PUT_LINE ('Block : '||l_block);

8 END;

9 /

File : 3

Block : 208

PL/SQL procedure successfully completed.

OBJ:4294967295 表示对象号，但这里表示地却有些问题，db_id不可能有那么大的编号

SQL> select count(*) from dba_objects;

COUNT(*)

----------

75386

SQL> select max(to_number(object_id)) from dba_objects;

MAX(TO_NUMBER(OBJECT_ID))

-------------------------

77887

这样来说，OBJ的值最大也就为77887，不应该变成40多W

数据块的scn存在于数据块头中，可以执行如下查询：

SQL> select name,dbms_rowid.rowid_block_number(rowid) blocks,ora_rowscn from t1;

NAME BLOCKS ORA_ROWSCN

---------- ---------- ----------

def 151 1746979

这里ora_rowscn是一个伪列

SCN:0x0000.001aa7c3

SQL> select to_number('1aa7c3','xxxxxxxx') from dual;

TO_NUMBER('1AA7C3','XXXXXXXX')

------------------------------

1746883

uba: 0x00c05282.010b.1b、xid: 0x0006.00b.000004a6 是和事务相关的信息：

SQL> select

2 to_number(substr(xid,3,4),'xxxxxxxxxxxx') xidusn,

3 to_number(substr(xid,8,3),'xxxxxxxxxxxx') xidslot,

4 to_number(substr(xid,12,8),'xxxxxxxxxxxx') xidsqn

5 from (

6 select '0x0006.00b.000004a6' xid from dual);

XIDUSN XIDSLOT XIDSQN

---------- ---------- ----------

6 11 1190

SQL> select

2 dbms_utility.data_block_address_file(to_number(substr(uba,3,8),'xxxxxxxxxxxx')) as undo_file#,

dbms_utility.data_block_address_block(to_number(substr(uba,3,8),'xxxxxxxxxxxx')) as undo_block ,

4 to_number(substr(uba,12,4),'xxxxxxxxxxxx') undo_sequence ,

5 to_number(substr(uba,17,2),'xxxxxxxxxxxx') undo_record

6 from

7 (select '0x00c05282.010b.1b' uba from dual);

UNDO_FILE# UNDO_BLOCK UNDO_SEQUENCE UNDO_RECORD

---------- ---------- ------------- -----------

3 21122 267 27

REDO RECORD - Thread:1 RBA: 0x000003.00000002.0150 LEN: 0x01c8 VLD: 0x01

SCN: 0x0000.001aa81a SUBSCN: 1 01/01/2015 00:07:31

CHANGE #1 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:11.17 ENC:0

REDO RECORD - Thread:1 RBA: 0x000003.00000003.0128 LEN: 0x01f4 VLD: 0x01

SCN: 0x0000.001aa81a SUBSCN: 1 01/01/2015 00:07:31

CHANGE #1 TYP:0 CLS:27 AFN:3 DBA:0x00c000d0 OBJ:4294967295 SCN:0x0000.001aa81a SEQ:1 OP:5.2 ENC:0 RBL:0

ktudh redo: slt: 0x000b sqn: 0x00000000 flg: 0x0002 siz: 108 fbi: 0

uba: 0x00c05282.010b.1c pxid: 0x0000.000.00000000

CHANGE #2 TYP:0 CLS:28 AFN:3 DBA:0x00c05282 OBJ:4294967295 SCN:0x0000.001aa81a SEQ:1 OP:5.1 ENC:0 RBL:0

ktudb redo: siz: 108 spc: 3128 flg: 0x0022 seq: 0x010b rec: 0x1c

xid: 0x0006.00b.000004a6

ktubu redo: slt: 11 rci: 0 opc: 11.1 objn: 384 objd: 75342 tsn: 0

Undo type: Regular undo Undo type: Last buffer split: No

Tablespace Undo: No

0x00000000

KDO undo record:

KTB Redo

op: 0x04 ver: 0x01

compat bit: 4 (post-11) padding: 1

op: L itl: xid: 0x0004.00f.0000034b uba: 0x00c053dd.010a.1e

flg: C--- lkc: 0 scn: 0x0000.001a4e9d

KDO Op code: DRP row dependencies Disabled

xtype: XA flags: 0x00000000 bdba: 0x00400905 hdba: 0x00400900

itli: 2 ispac: 0 maxfr: 4863

tabn: 0 slot: 54(0x36)

CHANGE #3 TYP:2 CLS:1 AFN:1 DBA:0x00400905 OBJ:75342 SCN:0x0000.001aa798 SEQ:1 OP:11.2 ENC:0 RBL:0

KTB Redo

op: 0x01 ver: 0x01

compat bit: 4 (post-11) padding: 1

op: F xid: 0x0006.00b.000004a6 uba: 0x00c05282.010b.1c

KDO Op code: IRP row dependencies Disabled

xtype: XA flags: 0x00000000 bdba: 0x00400905 hdba: 0x00400900

itli: 2 ispac: 0 maxfr: 4863

tabn: 0 slot: 54(0x36) size/delt: 95

fb: --H-FL-- lb: 0x2 cc: 39

null:

01234567890123456789012345678901234567890123456789012345678901234567890123456789

---N-----NNNNNNNNNNNNNNN-NNN-N-NN--NNN-

col 0: [ 4] c3 52 03 23

col 1: [ 2] c1 03

col 2: [ 2] c1 19

col 3: *NULL*

col 4: [ 3] 5a 4c 4d

col 5: [ 4] 7a 6c 6d 32

col 6: [ 5] 70 74 73 2f 31

col 7: [ 2] c1 32

col 8: [ 1] 80

col 9: *NULL*

col 10: *NULL*

col 11: *NULL*

col 12: *NULL*

col 13: *NULL*

col 14: *NULL*

col 15: *NULL*

col 16: *NULL*

col 17: *NULL*

col 18: *NULL*

col 19: *NULL*

col 20: *NULL*

col 21: *NULL*

col 22: *NULL*

col 23: *NULL*

col 24: [ 6] 6f 72 61 63 6c 65

col 25: *NULL*

col 26: *NULL*

col 27: *NULL*

col 28: [ 2] c1 04

col 29: *NULL*

col 30: [11] 78 72 0c 1f 11 08 20 16 e1 f8 a0

col 31: *NULL*

col 32: *NULL*

col 33: [ 1] 80

col 34: [ 4] 36 31 33 38

col 35: *NULL*

col 36: *NULL*

col 37: *NULL*

col 38: [ 6] c5 06 25 4b 1c 27

OP表示操作代码，一般REDO的为11.2，5.2表示修改回滚数据块头

REDO RECORD - Thread:1 RBA: 0x000003.00000004.012c LEN: 0x00a4 VLD: 0x01

SCN: 0x0000.001aa81b SUBSCN: 1 01/01/2015 00:07:31

CHANGE #1 TYP:0 CLS:27 AFN:3 DBA:0x00c000d0 OBJ:4294967295 SCN:0x0000.001aa81a SEQ:2 OP:5.4 ENC:0 RBL:0

ktucm redo: slt: 0x000b sqn: 0x000004a6 srt: 0 sta: 9 flg: 0x2 ktucf redo: uba: 0x00c05282.010b.1c ext: 4 spc: 3018 fbi: 0

CHANGE #2 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:24.4 ENC:0

REDO RECORD - Thread:1 RBA: 0x000003.00000005.0010 LEN: 0x0218 VLD: 0x05

SCN: 0x0000.001aa81f SUBSCN: 1 01/01/2015 00:07:41

(LWN RBA: 0x000003.00000005.0010 LEN: 0002 NST: 0001 SCN: 0x0000.001aa81e)

CHANGE #1 TYP:0 CLS:25 AFN:3 DBA:0x00c000c0 OBJ:4294967295 SCN:0x0000.001aa7cf SEQ:1 OP:5.2 ENC:0 RBL:0

ktudh redo: slt: 0x0014 sqn: 0x000003f0 flg: 0x0012 siz: 160 fbi: 0

uba: 0x00c00720.019c.2e pxid: 0x0000.000.00000000

CHANGE #2 TYP:0 CLS:26 AFN:3 DBA:0x00c00720 OBJ:4294967295 SCN:0x0000.001aa7ce SEQ:1 OP:5.1 ENC:0 RBL:0

ktudb redo: siz: 160 spc: 2380 flg: 0x0012 seq: 0x019c rec: 0x2e

xid: 0x0005.014.000003f0

ktubl redo: slt: 20 rci: 0 opc: 11.1 [objn: 77887 objd: 77887 tsn: 9]

Undo type: Regular undo Begin trans Last buffer split: No

Temp Object: No

Tablespace Undo: No

0x00000000 prev ctl uba: 0x00c00720.019c.02

prev ctl max cmt scn: 0x0000.001aa106 prev tx cmt scn: 0x0000.001aa11a

txn start scn: 0xffff.ffffffff logon user: 100 prev brb: 12584734 prev bcl: 0 BuExt idx: 0 flg2: 0

KDO undo record:

KTB Redo

op: 0x03 ver: 0x01

compat bit: 4 (post-11) padding: 1

op: Z

KDO Op code: URP row dependencies Disabled

xtype: XA flags: 0x00000000 bdba: 0x01800097 hdba: 0x01800083

itli: 2 ispac: 0 maxfr: 4858

tabn: 0 slot: 0(0x0) flag: 0x2c lock: 0 ckix: 0

ncol: 1 nnew: 1 size: 0

col 0: [ 3] 61 62 63

CHANGE #3 TYP:2 CLS:1 AFN:6 DBA:0x01800097 OBJ:77887 SCN:0x0000.001aa804 SEQ:1 OP:11.5 ENC:0 RBL:0

KTB Redo

op: 0x11 ver: 0x01

compat bit: 4 (post-11) padding: 1

op: F xid: 0x0005.014.000003f0 uba: 0x00c00720.019c.2e

Block cleanout record, scn: 0x0000.001aa81f ver: 0x01 opt: 0x02, entries follow...

itli: 1 flg: 2 scn: 0x0000.001aa804

KDO Op code: URP row dependencies Disabled

xtype: XA flags: 0x00000000 bdba: 0x01800097 hdba: 0x01800083

itli: 2 ispac: 0 maxfr: 4858

tabn: 0 slot: 0(0x0) flag: 0x2c lock: 2 ckix: 0

ncol: 1 nnew: 1 size: 0

col 0: [ 3] 64 65 66

CHANGE #4 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:5.20 ENC:0

session number = 38

serial number = 13

transaction name =

version 186647296

audit sessionid 810234

Client Id =

REDO RECORD - Thread:1 RBA: 0x000003.00000007.0010 LEN: 0x00d0 VLD: 0x05

SCN: 0x0000.001aa823 SUBSCN: 1 01/01/2015 00:07:48

(LWN RBA: 0x000003.00000007.0010 LEN: 0001 NST: 0001 SCN: 0x0000.001aa822)

CHANGE #1 TYP:0 CLS:25 AFN:3 DBA:0x00c000c0 OBJ:4294967295 SCN:0x0000.001aa81f SEQ:1 OP:5.4 ENC:0 RBL:0

ktucm redo: slt: 0x0014 sqn: 0x000003f0 srt: 0 sta: 9 flg: 0x2 ktucf redo: uba: 0x00c00720.019c.2e ext: 3 spc: 2218 fbi: 0

CHANGE #2 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:24.4 ENC:0

REDO RECORD - Thread:1 RBA: 0x000003.00000008.0010 LEN: 0x0084 VLD: 0x05

SCN: 0x0000.001aa825 SUBSCN: 1 01/01/2015 00:07:49

(LWN RBA: 0x000003.00000008.0010 LEN: 0001 NST: 0001 SCN: 0x0000.001aa824)

CHANGE #1 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:24.4 ENC:0

REDO RECORD - Thread:1 RBA: 0x000003.00000009.0010 LEN: 0x0240 VLD: 0x05

SCN: 0x0000.001aa82a SUBSCN: 1 01/01/2015 00:07:49

(LWN RBA: 0x000003.00000009.0010 LEN: 0003 NST: 0001 SCN: 0x0000.001aa827)

CHANGE #1 TYP:0 CLS:29 AFN:3 DBA:0x00c000e0 OBJ:4294967295 SCN:0x0000.001aa7d4 SEQ:1 OP:5.2 ENC:0 RBL:0

ktudh redo: slt: 0x000e sqn: 0x00000335 flg: 0x0412 siz: 192 fbi: 0

uba: 0x00c05303.011f.19 pxid: 0x0000.000.00000000

CHANGE #2 TYP:0 CLS:30 AFN:3 DBA:0x00c05303 OBJ:4294967295 SCN:0x0000.001aa7d3 SEQ:1 OP:5.1 ENC:0 RBL:0

ktudb redo: siz: 192 spc: 3830 flg: 0x0012 seq: 0x011f rec: 0x19

xid: 0x0007.00e.00000335

ktubl redo: slt: 14 rci: 0 opc: 11.1 [objn: 6581 objd: 6581 tsn: 1]

Undo type: Regular undo Begin trans Last buffer split: No

Temp Object: No

Tablespace Undo: No

0x00000000 prev ctl uba: 0x00c05303.011f.18

prev ctl max cmt scn: 0x0000.001aa102 prev tx cmt scn: 0x0000.001aa116

txn start scn: 0xffff.ffffffff logon user: 0 prev brb: 12604162 prev bcl: 0 BuExt idx: 0 flg2: 0

KDO undo record:

KTB Redo

op: 0x04 ver: 0x01

compat bit: 4 (post-11) padding: 1

op: L itl: xid: 0x0003.015.000003eb uba: 0x00c009ab.011a.13

flg: C--- lkc: 0 scn: 0x0000.001a4ade

KDO Op code: URP row dependencies Disabled

xtype: XA flags: 0x00000000 bdba: 0x008018d7 hdba: 0x008018d2

itli: 1 ispac: 0 maxfr: 4858

tabn: 0 slot: 0(0x0) flag: 0x2c lock: 0 ckix: 0

ncol: 7 nnew: 2 size: 0

col 3: [ 6] c5 0f 15 04 59 1b

col 4: [ 2] c1 14

CHANGE #3 TYP:2 CLS:1 AFN:2 DBA:0x008018d7 OBJ:6581 SCN:0x0000.001a9d24 SEQ:1 OP:11.5 ENC:0 RBL:0

KTB Redo

op: 0x11 ver: 0x01

compat bit: 4 (post-11) padding: 1

op: F xid: 0x0007.00e.00000335 uba: 0x00c05303.011f.19

Block cleanout record, scn: 0x0000.001aa82a ver: 0x01 opt: 0x02, entries follow...

itli: 2 flg: 2 scn: 0x0000.001a9d24

KDO Op code: URP row dependencies Disabled

xtype: XA flags: 0x00000000 bdba: 0x008018d7 hdba: 0x008018d2

itli: 1 ispac: 0 maxfr: 4858

tabn: 0 slot: 0(0x0) flag: 0x2c lock: 1 ckix: 0

ncol: 7 nnew: 2 size: 0

col 3: [ 6] c5 0f 15 05 15 45

col 4: [ 2] c1 15

CHANGE #4 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:5.20 ENC:0

session number = 15

serial number = 1

transaction name =

Recursive transaction

version 186647296

audit sessionid 0

Client Id =

REDO RECORD - Thread:1 RBA: 0x000003.0000000a.0060 LEN: 0x012c VLD: 0x01

SCN: 0x0000.001aa82a SUBSCN: 1 01/01/2015 00:07:49

CHANGE #1 TYP:0 CLS:30 AFN:3 DBA:0x00c05303 OBJ:4294967295 SCN:0x0000.001aa82a SEQ:1 OP:5.1 ENC:0 RBL:0

ktudb redo: siz: 132 spc: 3636 flg: 0x0022 seq: 0x011f rec: 0x1a

xid: 0x0007.00e.00000335

ktubu redo: slt: 14 rci: 25 opc: 11.1 objn: 6583 objd: 6583 tsn: 1

Undo type: Regular undo Undo type: Last buffer split: No

Tablespace Undo: No

0x00000000

KDO undo record:

KTB Redo

op: 0x04 ver: 0x01

compat bit: 4 (post-11) padding: 1

op: L itl: xid: 0x0003.015.000003eb uba: 0x00c009ab.011a.14

flg: C--- lkc: 0 scn: 0x0000.001a4ade

KDO Op code: URP row dependencies Disabled

xtype: XA flags: 0x00000000 bdba: 0x008018e7 hdba: 0x008018e2

itli: 2 ispac: 0 maxfr: 4858

tabn: 0 slot: 4(0x4) flag: 0x2c lock: 0 ckix: 0

ncol: 3 nnew: 1 size: -1

col 2: [ 1] 80

CHANGE #2 TYP:2 CLS:1 AFN:2 DBA:0x008018e7 OBJ:6583 SCN:0x0000.001a9d24 SEQ:1 OP:11.5 ENC:0 RBL:0

KTB Redo

op: 0x01 ver: 0x01

compat bit: 4 (post-11) padding: 1

op: F xid: 0x0007.00e.00000335 uba: 0x00c05303.011f.1a

KDO Op code: URP row dependencies Disabled

xtype: XA flags: 0x00000000 bdba: 0x008018e7 hdba: 0x008018e2

itli: 2 ispac: 0 maxfr: 4858

tabn: 0 slot: 4(0x4) flag: 0x2c lock: 2 ckix: 0

ncol: 3 nnew: 1 size: 1

col 2: [ 2] c1 02

REDO RECORD - Thread:1 RBA: 0x000003.0000000a.018c LEN: 0x00a4 VLD: 0x01

SCN: 0x0000.001aa82b SUBSCN: 1 01/01/2015 00:07:49

CHANGE #1 TYP:0 CLS:29 AFN:3 DBA:0x00c000e0 OBJ:4294967295 SCN:0x0000.001aa82a SEQ:1 OP:5.4 ENC:0 RBL:0

ktucm redo: slt: 0x000e sqn: 0x00000335 srt: 0 sta: 9 flg: 0x2 ktucf redo: uba: 0x00c05303.011f.1a ext: 3 spc: 3502 fbi: 0

CHANGE #2 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:24.4 ENC:0

END OF REDO DUMP

----- Redo read statistics for thread 1 -----

Read rate (SYNC): 5Kb in 0.01s => 0.49 Mb/sec

Total redo bytes: 5Kb Longest record: 0Kb, moves: 0/10 moved: 0Mb (0%)

Longest LWN: 1Kb, reads: 5

Last redo scn: 0x0000.001aa82b (1746987)

Change vector header moves = 2/24 (8%)

----------------------------------------------

[oracle@zlm2 ~]$

后面部分内容分析略，基本与之前的大同小异

0 0