0 积分	1 好友	8 主题

发消息

[Exadata硬件] redo中到底记录了什么，如何重演对数据库的操作？

1^#

发表于 2013-9-20 11:37:35 | 查看: 3222| 回复: 6

请问一下各位大神：

redo日志在记录数据库改动时，是怎么记录的？

1）delete操作

redo记录的时候是只记录一些能够重演操作的关键信息吗？（比如说被删除的数据块号，行号等）？？？
会不会记录操作的完整sql代码？？？如果记录了sql代码，那么用该日志恢复的时候是重新跑这个代码吗？？？

2）alter tablespace users add datafie '/oradata/users02.dbf' size 100m;

像此类改变数据库结构的操作oracle的redo日志会怎么记录呢？？？
会记录完整的sql代码吗？？？如果记录了完整的sql代码？？

分享0

收藏0 回复只看该作者道具举报

Maclean Liu(刘相兵

2^#

发表于 2013-9-20 19:36:47

alter tablespace users add datafie '/oradata/users02.dbf' size 100m;

==> 包括controlfile的transaction 和对一些字典基表的修改，这些都记录在redo logfile里。

回复只看该作者道具举报

Maclean Liu(刘相兵

3^#

发表于 2013-9-20 19:52:26

SQL> alter system switch logfile;

系统已更改。

SQL> set linesize 200 pagesize 2000 ;
SQL> select * from v$log;

GROUP# THREAD#  SEQUENCE#    BYTES  BLOCKSIZE MEMBERS ARCHIV STATUS                      FIRST_CHANGE# FIRST_TIME    NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- ------ -------------------------------- ------------- -------------- ------------ -------
      1       1       109 52428800       512       1 YES INACTIVE                         6271132 18-9月 -13    6276638 19-9月 -13
      2       1       110 52428800       512       1 YES ACTIVE                            6276638 19-9月 -13    6280024 20-9月 -13
      3       1       108 52428800       512       1 YES INACTIVE                         6269766 18-9月 -13    6271132 18-9月 -13
      10       1       111 1073741824       512       2 NO    CURRENT                         6280024 20-9月 -13 2.8147E+14
      99       1       107  536870912       512       2 YES INACTIVE                         6226385 16-9月 -13    6269766 18-9月 -13

SQL> alter tablespace users add datafile size 10M;

表空间已更改。

SQL> select * from v$logfile where group#=10;

GROUP# STATUS       TYPE
---------- -------------- --------------
MEMBER
-------------------------------------------------------------------

IS_REC    CON_ID
------ ----------
      10             ONLINE
C:\APP\XIANGBLI\ORADATA\MACLEAN\ONLINELOG\O1_MF_10_90K7WWXJ_.LOG
NO             0

SQL> alter system dump logfile 'C:\APP\XIANGBLI\ORADATA\MACLEAN\ONLINELOG\O1_MF_10_90K7WWXJ_.LOG';

系统已更改。

SQL> oradebug setmypid
已处理的语句
SQL> oradebug tracefile_name
C:\APP\XIANGBLI\diag\rdbms\maclean\maclean\trace\maclean_ora_5536.trc

REDO RECORD - Thread:1 RBA: 0x00006f.0000000b.0010 LEN: 0x01c4 VLD: 0x05 CON_UID: 0
SCN: 0x0000.005fd36c SUBSCN:  1 09/20/2013 19:37:57
(LWN RBA: 0x00006f.0000000b.0010 LEN: 0002 NST: 0001 SCN: 0x0000.005fd36a)
CHANGE #1 CON_ID:0 TYP:0 CLS:36 AFN:5 DBA:0x0140038e OBJ:4294967295 SCN:0x0000.005fd369 SEQ:3 OP:5.1 ENC:0 RBL:0
ktudb redo: siz: 160 spc: 6530 flg: 0x0022 seq: 0x02da rec: 0x0f
         xid:  0x000a.010.00000dac
ktubu redo: slt: 16 rci: 14 opc: 11.1 objn: 17 objd: 17 tsn: 0
Undo type:  Regular undo    Undo type:  Last buffer split:  No
Tablespace Undo:  No
         0x00000000
KDO undo record:
KTB Redo
op: 0x02  ver: 0x01
compat bit: 4 (post-11) padding: 0
op: C  uba: 0x0140038e.02da.0c
KDO Op code: URP row dependencies Disabled
  xtype: XA flags: 0x00000000  bdba: 0x004000e9  hdba: 0x004000e8
itli: 1  ispac: 0  maxfr: 4863
tabn: 0 slot: 12(0xc) flag: 0x2c lock: 1 ckix: 0
ncol: 11 nnew: 9 size: 2
col  1: [ 2]  c1 03
col  2: [ 1]  80
col  3: [ 2]  c1 05
col  4: [ 2]  c1 0e
col  5: [ 1]  80
col  6: [ 1]  80
col  7: [ 4]  c3 07 38 24
col  8: [ 6]  c5 2b 5f 61 49 60
col 10: [ 5]  c4 37 35 3c 37
CHANGE #2 CON_ID:0 TYP:0 CLS:1 AFN:1 DBA:0x004000e9 OBJ:17 SCN:0x0000.005fd369 SEQ:1 OP:11.5 ENC:0 RBL:0
KTB Redo
op: 0x02  ver: 0x01
compat bit: 4 (post-11) padding: 0
op: C  uba: 0x0140038e.02da.0f
KDO Op code: URP row dependencies Disabled
  xtype: XA flags: 0x00000000  bdba: 0x004000e9  hdba: 0x004000e8
itli: 1  ispac: 0  maxfr: 4863
tabn: 0 slot: 12(0xc) flag: 0x2c lock: 1 ckix: 0
ncol: 11 nnew: 9 size: -2
col  1: [ 2]  c1 03
col  2: [ 3]  c2 0d 51
col  3: [ 2]  c1 05
col  4: [ 2]  c1 0e
col  5: [ 1]  80
col  6: [ 1]  80
col  7: [ 1]  80
col  8: [ 5]  c4 07 1d 01 2c
col 10: [ 5]  c4 37 35 3c 37

OBJ:17

SQL> select name from sys.obj$ where obj#=17;

NAME
--------------------------------------------------

FILE$

回复只看该作者道具举报

Maclean Liu(刘相兵

4^#

发表于 2013-9-20 19:53:07

more redo dump

控制文件事务  加入数据文件

REDO RECORD - Thread:1 RBA: 0x00006f.0000000b.01d4 LEN: 0x0204 VLD: 0x01 CON_UID: 0
SCN: 0x0000.005fd36d SUBSCN:  1 09/20/2013 19:37:57
CHANGE #1 CON_ID:0 TYP:0 CLS:35 AFN:5 DBA:0x01400110 OBJ:4294967295 SCN:0x0000.005fd369 SEQ:1 OP:5.4 ENC:0 RBL:0
ktucm redo: slt: 0x0010 sqn: 0x00000dac srt: 0 sta: 9 flg: 0x2 ktucf redo: uba: 0x0140038e.02da.0f ext: 2 spc: 6368 fbi: 0
CHANGE #2 MEDIA RECOVERY MARKER CON_ID:0 SCN:0x0000.00000000 SEQ:0 OP:17.30 ENC:0
Add datafiles to tablespace #4
file #13  relative file #13. 'C:\APP\XIANGBLI\ORADATA\MACLEAN\DATAFILE\O1_MF_USERS_93RDWOBL_.DBF'
flags(reuse): 0x0
Checkpointed at scn:  0x0000.005fd36b 09/20/2013 19:37:57
thread:1 rba:(0x6f.b.10)
enabled  threads:  01000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000
CHANGE #3 MEDIA RECOVERY MARKER CON_ID:0 SCN:0x0000.00000000 SEQ:0 OP:17.28 ENC:0
STANDBY METADATA CACHE INVALIDATION
KQR INFO:
[90d92d5a, 6, 0]
KGL INFO:

回复只看该作者道具举报

Maclean Liu(刘相兵

5^#

发表于 2013-9-20 19:54:30

more redo dump

REDO RECORD - Thread:1 RBA: 0x00006f.0000000d.0010 LEN: 0x008c VLD: 0x05 CON_UID: 0
SCN: 0x0000.005fd36e SUBSCN:  1 09/20/2013 19:37:57
(LWN RBA: 0x00006f.0000000d.0010 LEN: 0026 NST: 0001 SCN: 0x0000.005fd36e)
CHANGE #1 CON_ID:0 TYP:1 CLS:12 AFN:13 DBA:0x03400003 OBJ:4294967295 SCN:0x0000.005fd36d SEQ:1 OP:22.4 ENC:0 RBL:0
ktfbbfo - File BitMap Block Format:
BitMap Control:
RelFno: 13, BeginBlock: 128, Flag: 0, First: 0, Free: 63488

REDO RECORD - Thread:1 RBA: 0x00006f.0000000d.009c LEN: 0x0060 VLD: 0x01 CON_UID: 0
SCN: 0x0000.005fd36e SUBSCN:  1 09/20/2013 19:37:57
CHANGE #1 CON_ID:0 TYP:1 CLS:12 AFN:13 DBA:0x03400004 OBJ:4294967295 SCN:0x0000.005fd36d SEQ:1 OP:22.4 ENC:0 RBL:0
ktfbbfo - File BitMap Block Format:
BitMap Control:
RelFno: 13, BeginBlock: 508032, Flag: 0, First: 0, Free: 63488

REDO RECORD - Thread:1 RBA: 0x00006f.0000000d.00fc LEN: 0x0060 VLD: 0x01 CON_UID: 0
SCN: 0x0000.005fd36e SUBSCN:  1 09/20/2013 19:37:57
CHANGE #1 CON_ID:0 TYP:1 CLS:12 AFN:13 DBA:0x03400005 OBJ:4294967295 SCN:0x0000.005fd36d SEQ:1 OP:22.4 ENC:0 RBL:0
ktfbbfo - File BitMap Block Format:
BitMap Control:
RelFno: 13, BeginBlock: 1015936, Flag: 0, First: 0, Free: 63488

==>开始格式化File BitMap

回复只看该作者道具举报

Maclean Liu(刘相兵

6^#

发表于 2013-9-20 20:03:41

更新file header 文件头:

REDO RECORD - Thread:1 RBA: 0x00006f.00000026.0010 LEN: 0x0074 VLD: 0x01 CON_UID: 0
SCN: 0x0000.005fd36e SUBSCN:  1 09/20/2013 19:37:57
CHANGE #1 CON_ID:0 TYP:1 CLS:13 AFN:13 DBA:0x03400002 OBJ:4294967295 SCN:0x0000.005fd36e SEQ:1 OP:22.1 ENC:0 RBL:0
ktfbhfo - File Space Header Format:
Header Control:
RelFno: 13, Unit: 8, Size: 1280, Flag: 1
AutoExtend: NO, Increment: 0, MaxSize: 0
Initial Area: 126, Tail: 1279, First: 0, Free: 144
Deallocation scn: 0.0

REDO RECORD - Thread:1 RBA: 0x00006f.00000026.0084 LEN: 0x004c VLD: 0x01 CON_UID: 0
SCN: 0x0000.005fd36f SUBSCN:  1 09/20/2013 19:37:57
CHANGE #1 MEDIA RECOVERY MARKER CON_ID:0 SCN:0x0000.00000000 SEQ:0 OP:17.32 ENC:0
Redo of datafile header update for - file:13 old space header rdba:  0x00000000new space header rdba:  0x03400002

REDO RECORD - Thread:1 RBA: 0x00006f.00000027.0010 LEN: 0x0110 VLD: 0x05 CON_UID: 0
SCN: 0x0000.005fd370 SUBSCN:  1 09/20/2013 19:37:57
(LWN RBA: 0x00006f.00000027.0010 LEN: 0002 NST: 0001 SCN: 0x0000.005fd370)
CHANGE #1 CON_ID:0 TYP:0 CLS:25 AFN:5 DBA:0x014000c0 OBJ:4294967295 SCN:0x0000.005fd368 SEQ:1 OP:5.2 ENC:0 RBL:0
ktudh redo: slt: 0x0011 sqn: 0x00000f15 flg: 0x0011 siz: 80 fbi: 0
         uba: 0x0140018f.038d.1a pxid:  0x0000.000.00000000
CHANGE #2 CON_ID:0 TYP:0 CLS:26 AFN:5 DBA:0x0140018f OBJ:4294967295 SCN:0x0000.005fd367 SEQ:2 OP:5.1 ENC:0 RBL:0
ktudb redo: siz: 80 spc: 5256 flg: 0x0010 seq: 0x038d rec: 0x1a
         xid:  0x0005.011.00000f15
ktubl redo: slt: 17 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: 0x0140018f.038d.18
prev ctl max cmt scn:  0x0000.005fd06d  prev tx cmt scn:  0x0000.005fd06e
txn start scn:  0xffff.ffffffff  logon user: 0  prev brb: 20971910  prev bcl: 0 BuExt idx: 0 flg2: 0

REDO RECORD - Thread:1 RBA: 0x00006f.00000027.0120 LEN: 0x01d0 VLD: 0x01 CON_UID: 0
SCN: 0x0000.005fd371 SUBSCN:  1 09/20/2013 19:37:57
CHANGE #1 MEDIA RECOVERY MARKER CON_ID:0 SCN:0x0000.00000000 SEQ:0 OP:24.1 ENC:0

REDO RECORD - Thread:1 RBA: 0x00006f.00000029.0010 LEN: 0x0094 VLD: 0x05 CON_UID: 0
SCN: 0x0000.005fd374 SUBSCN:  1 09/20/2013 19:37:57
(LWN RBA: 0x00006f.00000029.0010 LEN: 0001 NST: 0001 SCN: 0x0000.005fd373)
CHANGE #1 CON_ID:0 TYP:0 CLS:25 AFN:5 DBA:0x014000c0 OBJ:4294967295 SCN:0x0000.005fd370 SEQ:1 OP:5.4 ENC:0 RBL:0
ktucm redo: slt: 0x0011 sqn: 0x00000f15 srt: 0 sta: 9 flg: 0x2 ktucf redo: uba: 0x0140018f.038d.1a ext: 2 spc: 5174 fbi: 0

REDO RECORD - Thread:1 RBA: 0x00006f.0000002a.0010 LEN: 0x0078 VLD: 0x06 CON_UID: 0
SCN: 0x0000.005fd37f SUBSCN:  1 09/20/2013 19:38:31
(LWN RBA: 0x00006f.0000002a.0010 LEN: 0006 NST: 0001 SCN: 0x0000.005fd37f)
CHANGE #1 MEDIA RECOVERY MARKER CON_ID:0 SCN:0x0000.00000000 SEQ:0 OP:23.1 ENC:0
Block Written - afn: 1 rdba: 0x004000e9 BFT:(1024,4194537) non-BFT:(1,233)
               scn: 0x0000.005fd36d seq: 0x01 flg:0x06

REDO RECORD - Thread:1 RBA: 0x00006f.0000002a.0088 LEN: 0x005c VLD: 0x02 CON_UID: 0
SCN: 0x0000.005fd37f SUBSCN:  1 09/20/2013 19:38:31
CHANGE #1 MEDIA RECOVERY MARKER CON_ID:0 SCN:0x0000.00000000 SEQ:0 OP:23.1 ENC:0
Block Written - afn: 1 rdba: 0x00400191 BFT:(1024,4194705) non-BFT:(1,401)
               scn: 0x0000.005fd36d seq: 0x01 flg:0x06
Block Written - afn: 1 rdba: 0x00400189 BFT:(1024,4194697) non-BFT:(1,393)
               scn: 0x0000.005fd368 seq: 0x01 flg:0x06

REDO RECORD - Thread:1 RBA: 0x00006f.0000002a.00e4 LEN: 0x004c VLD: 0x02 CON_UID: 0
SCN: 0x0000.005fd37f SUBSCN:  1 09/20/2013 19:38:31
CHANGE #1 MEDIA RECOVERY MARKER CON_ID:0 SCN:0x0000.00000000 SEQ:0 OP:23.1 ENC:0
Block Written - afn: 5 rdba: 0x014000c0 BFT:(1024,20971712) non-BFT:(5,192)
               scn: 0x0000.005fd374 seq: 0x01 flg:0x04

REDO RECORD - Thread:1 RBA: 0x00006f.0000002a.0130 LEN: 0x004c VLD: 0x02 CON_UID: 0
SCN: 0x0000.005fd37f SUBSCN:  1 09/20/2013 19:38:31
CHANGE #1 MEDIA RECOVERY MARKER CON_ID:0 SCN:0x0000.00000000 SEQ:0 OP:23.1 ENC:0
Block Written - afn: 5 rdba: 0x01400110 BFT:(1024,20971792) non-BFT:(5,272)
               scn: 0x0000.005fd36d seq: 0x01 flg:0x04

REDO RECORD - Thread:1 RBA: 0x00006f.0000002a.017c LEN: 0x004c VLD: 0x02 CON_UID: 0
SCN: 0x0000.005fd37f SUBSCN:  1 09/20/2013 19:38:31
CHANGE #1 MEDIA RECOVERY MARKER CON_ID:0 SCN:0x0000.00000000 SEQ:0 OP:23.1 ENC:0
Block Written - afn: 5 rdba: 0x0140018f BFT:(1024,20971919) non-BFT:(5,399)
               scn: 0x0000.005fd370 seq: 0x01 flg:0x04

REDO RECORD - Thread:1 RBA: 0x00006f.0000002a.01c8 LEN: 0x004c VLD: 0x02 CON_UID: 0
SCN: 0x0000.005fd37f SUBSCN:  1 09/20/2013 19:38:31
CHANGE #1 MEDIA RECOVERY MARKER CON_ID:0 SCN:0x0000.00000000 SEQ:0 OP:23.1 ENC:0
Block Written - afn: 5 rdba: 0x0140038e BFT:(1024,20972430) non-BFT:(5,910)
               scn: 0x0000.005fd36c seq: 0x01 flg:0x04

REDO RECORD - Thread:1 RBA: 0x00006f.0000002b.0024 LEN: 0x081c VLD: 0x02 CON_UID: 0
SCN: 0x0000.005fd37f SUBSCN:  1 09/20/2013 19:38:31
CHANGE #1 MEDIA RECOVERY MARKER CON_ID:0 SCN:0x0000.00000000 SEQ:0 OP:23.1 ENC:0
Block Written - afn: 13 rdba: 0x03400002 BFT:(1024,54525954) non-BFT:(13,2)
               scn: 0x0000.005fd36e seq: 0x02 flg:0x04
Block Written - afn: 13 rdba: 0x03400003 BFT:(1024,54525955) non-BFT:(13,3)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400004 BFT:(1024,54525956) non-BFT:(13,4)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400005 BFT:(1024,54525957) non-BFT:(13,5)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400006 BFT:(1024,54525958) non-BFT:(13,6)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400007 BFT:(1024,54525959) non-BFT:(13,7)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400008 BFT:(1024,54525960) non-BFT:(13,8)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400009 BFT:(1024,54525961) non-BFT:(13,9)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x0340000a BFT:(1024,54525962) non-BFT:(13,10)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x0340000b BFT:(1024,54525963) non-BFT:(13,11)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x0340000c BFT:(1024,54525964) non-BFT:(13,12)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x0340000d BFT:(1024,54525965) non-BFT:(13,13)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x0340000e BFT:(1024,54525966) non-BFT:(13,14)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x0340000f BFT:(1024,54525967) non-BFT:(13,15)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400010 BFT:(1024,54525968) non-BFT:(13,16)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400011 BFT:(1024,54525969) non-BFT:(13,17)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x0340007f BFT:(1024,54526079) non-BFT:(13,127)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x0340007e BFT:(1024,54526078) non-BFT:(13,126)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x0340007d BFT:(1024,54526077) non-BFT:(13,125)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x0340007c BFT:(1024,54526076) non-BFT:(13,124)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x0340007b BFT:(1024,54526075) non-BFT:(13,123)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x0340007a BFT:(1024,54526074) non-BFT:(13,122)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400079 BFT:(1024,54526073) non-BFT:(13,121)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400078 BFT:(1024,54526072) non-BFT:(13,120)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400077 BFT:(1024,54526071) non-BFT:(13,119)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400076 BFT:(1024,54526070) non-BFT:(13,118)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400075 BFT:(1024,54526069) non-BFT:(13,117)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400074 BFT:(1024,54526068) non-BFT:(13,116)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400073 BFT:(1024,54526067) non-BFT:(13,115)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400072 BFT:(1024,54526066) non-BFT:(13,114)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400071 BFT:(1024,54526065) non-BFT:(13,113)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400070 BFT:(1024,54526064) non-BFT:(13,112)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x0340006f BFT:(1024,54526063) non-BFT:(13,111)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x0340006e BFT:(1024,54526062) non-BFT:(13,110)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x0340006d BFT:(1024,54526061) non-BFT:(13,109)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x0340006c BFT:(1024,54526060) non-BFT:(13,108)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x0340006b BFT:(1024,54526059) non-BFT:(13,107)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x0340006a BFT:(1024,54526058) non-BFT:(13,106)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400069 BFT:(1024,54526057) non-BFT:(13,105)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400068 BFT:(1024,54526056) non-BFT:(13,104)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400067 BFT:(1024,54526055) non-BFT:(13,103)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400066 BFT:(1024,54526054) non-BFT:(13,102)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400065 BFT:(1024,54526053) non-BFT:(13,101)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400064 BFT:(1024,54526052) non-BFT:(13,100)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400063 BFT:(1024,54526051) non-BFT:(13,99)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400062 BFT:(1024,54526050) non-BFT:(13,98)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400061 BFT:(1024,54526049) non-BFT:(13,97)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400060 BFT:(1024,54526048) non-BFT:(13,96)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x0340005f BFT:(1024,54526047) non-BFT:(13,95)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x0340005e BFT:(1024,54526046) non-BFT:(13,94)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x0340005d BFT:(1024,54526045) non-BFT:(13,93)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x0340005c BFT:(1024,54526044) non-BFT:(13,92)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x0340005b BFT:(1024,54526043) non-BFT:(13,91)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x0340005a BFT:(1024,54526042) non-BFT:(13,90)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400059 BFT:(1024,54526041) non-BFT:(13,89)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400058 BFT:(1024,54526040) non-BFT:(13,88)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400057 BFT:(1024,54526039) non-BFT:(13,87)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400056 BFT:(1024,54526038) non-BFT:(13,86)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400055 BFT:(1024,54526037) non-BFT:(13,85)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400054 BFT:(1024,54526036) non-BFT:(13,84)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400053 BFT:(1024,54526035) non-BFT:(13,83)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400052 BFT:(1024,54526034) non-BFT:(13,82)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400051 BFT:(1024,54526033) non-BFT:(13,81)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400050 BFT:(1024,54526032) non-BFT:(13,80)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x0340004f BFT:(1024,54526031) non-BFT:(13,79)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x0340004e BFT:(1024,54526030) non-BFT:(13,78)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x0340004d BFT:(1024,54526029) non-BFT:(13,77)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x0340004c BFT:(1024,54526028) non-BFT:(13,76)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x0340004b BFT:(1024,54526027) non-BFT:(13,75)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x0340004a BFT:(1024,54526026) non-BFT:(13,74)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400049 BFT:(1024,54526025) non-BFT:(13,73)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400048 BFT:(1024,54526024) non-BFT:(13,72)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400047 BFT:(1024,54526023) non-BFT:(13,71)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400046 BFT:(1024,54526022) non-BFT:(13,70)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400045 BFT:(1024,54526021) non-BFT:(13,69)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400044 BFT:(1024,54526020) non-BFT:(13,68)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400043 BFT:(1024,54526019) non-BFT:(13,67)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400042 BFT:(1024,54526018) non-BFT:(13,66)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400041 BFT:(1024,54526017) non-BFT:(13,65)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400040 BFT:(1024,54526016) non-BFT:(13,64)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x0340003f BFT:(1024,54526015) non-BFT:(13,63)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x0340003e BFT:(1024,54526014) non-BFT:(13,62)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x0340003d BFT:(1024,54526013) non-BFT:(13,61)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x0340003c BFT:(1024,54526012) non-BFT:(13,60)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x0340003b BFT:(1024,54526011) non-BFT:(13,59)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x0340003a BFT:(1024,54526010) non-BFT:(13,58)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400039 BFT:(1024,54526009) non-BFT:(13,57)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400038 BFT:(1024,54526008) non-BFT:(13,56)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400037 BFT:(1024,54526007) non-BFT:(13,55)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400036 BFT:(1024,54526006) non-BFT:(13,54)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400035 BFT:(1024,54526005) non-BFT:(13,53)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400034 BFT:(1024,54526004) non-BFT:(13,52)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400033 BFT:(1024,54526003) non-BFT:(13,51)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400032 BFT:(1024,54526002) non-BFT:(13,50)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400031 BFT:(1024,54526001) non-BFT:(13,49)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400030 BFT:(1024,54526000) non-BFT:(13,48)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x0340002f BFT:(1024,54525999) non-BFT:(13,47)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x0340002e BFT:(1024,54525998) non-BFT:(13,46)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x0340002d BFT:(1024,54525997) non-BFT:(13,45)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x0340002c BFT:(1024,54525996) non-BFT:(13,44)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x0340002b BFT:(1024,54525995) non-BFT:(13,43)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x0340002a BFT:(1024,54525994) non-BFT:(13,42)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400029 BFT:(1024,54525993) non-BFT:(13,41)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400028 BFT:(1024,54525992) non-BFT:(13,40)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400027 BFT:(1024,54525991) non-BFT:(13,39)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400026 BFT:(1024,54525990) non-BFT:(13,38)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400025 BFT:(1024,54525989) non-BFT:(13,37)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400024 BFT:(1024,54525988) non-BFT:(13,36)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400023 BFT:(1024,54525987) non-BFT:(13,35)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400022 BFT:(1024,54525986) non-BFT:(13,34)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400021 BFT:(1024,54525985) non-BFT:(13,33)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400020 BFT:(1024,54525984) non-BFT:(13,32)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x0340001f BFT:(1024,54525983) non-BFT:(13,31)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x0340001e BFT:(1024,54525982) non-BFT:(13,30)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x0340001d BFT:(1024,54525981) non-BFT:(13,29)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x0340001c BFT:(1024,54525980) non-BFT:(13,28)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x0340001b BFT:(1024,54525979) non-BFT:(13,27)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x0340001a BFT:(1024,54525978) non-BFT:(13,26)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400019 BFT:(1024,54525977) non-BFT:(13,25)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400018 BFT:(1024,54525976) non-BFT:(13,24)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400017 BFT:(1024,54525975) non-BFT:(13,23)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400016 BFT:(1024,54525974) non-BFT:(13,22)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400012 BFT:(1024,54525970) non-BFT:(13,18)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400013 BFT:(1024,54525971) non-BFT:(13,19)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400014 BFT:(1024,54525972) non-BFT:(13,20)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04
Block Written - afn: 13 rdba: 0x03400015 BFT:(1024,54525973) non-BFT:(13,21)
               scn: 0x0000.005fd36e seq: 0x01 flg:0x04

REDO RECORD - Thread:1 RBA: 0x00006f.00000030.0010 LEN: 0x023c VLD: 0x05 CON_UID: 0
SCN: 0x0000.005fd381 SUBSCN:  1 09/20/2013 19:38:31
(LWN RBA: 0x00006f.00000030.0010 LEN: 0002 NST: 0001 SCN: 0x0000.005fd380)
CHANGE #1 CON_ID:0 TYP:0 CLS:33 AFN:5 DBA:0x01400100 OBJ:4294967295 SCN:0x0000.005fd2eb SEQ:1 OP:5.2 ENC:0 RBL:0
ktudh redo: slt: 0x0013 sqn: 0x00000fd2 flg: 0x0412 siz: 196 fbi: 0
         uba: 0x01402181.0319.03 pxid:  0x0000.000.00000000
CHANGE #2 CON_ID:0 TYP:0 CLS:34 AFN:5 DBA:0x01402181 OBJ:4294967295 SCN:0x0000.005fd2e9 SEQ:3 OP:5.1 ENC:0 RBL:0
ktudb redo: siz: 196 spc: 7950 flg: 0x0012 seq: 0x0319 rec: 0x03
         xid:  0x0009.013.00000fd2
ktubl redo: slt: 19 rci: 0 opc: 11.1 [objn: 1387 objd: 1387 tsn: 0]
Undo type:  Regular undo       Begin trans Last buffer split:  No
Temp Object:  No
Tablespace Undo:  No
         0x00000000  prev ctl uba: 0x0140010d.0318.03
prev ctl max cmt scn:  0x0000.005fcdc7  prev tx cmt scn:  0x0000.005fcdde
txn start scn:  0xffff.ffffffff  logon user: 0  prev brb: 20971779  prev bcl: 0 BuExt idx: 0 flg2: 0
KDO undo record:
KTB Redo
op: 0x04  ver: 0x01
compat bit: 4 (post-11) padding: 0
op: L  itl: xid:  0x0003.01b.00000f66 uba: 0x0140155f.02eb.06
                  flg: C--- lkc:  0    scn: 0x0000.005fd132
Array Update of 1 rows:
tabn: 0 slot: 0(0x0) flag: 0x2c lock: 0 ckix: 36
ncol: 4 nnew: 3 size: 0
KDO Op code:  21 row dependencies Disabled
  xtype: XAxtype KDO_KDOM2 flags: 0x00000080  bdba: 0x004023d1  hdba: 0x004023d0
itli: 2  ispac: 0  maxfr: 4863
vect = 2
col  1: [ 5]  c4 07 1c 62 17
col  2: [ 5]  c4 07 1c 62 17
col  3: [ 2]  c1 02
CHANGE #3 CON_ID:0 TYP:2 CLS:1 AFN:1 DBA:0x004023d1 OBJ:1387 SCN:0x0000.005fd22c SEQ:1 OP:11.19 ENC:0 RBL:0
KTB Redo
op: 0x11  ver: 0x01
compat bit: 4 (post-11) padding: 0
op: F  xid:  0x0009.013.00000fd2 uba: 0x01402181.0319.03
Block cleanout record, scn:  0x0000.005fd381 ver: 0x01 opt: 0x02, entries follow...
  itli: 1  flg: (opt=2 whr=1)  scn: 0x0000.005fd22c
Array Update of 1 rows:
tabn: 0 slot: 0(0x0) flag: 0x2c lock: 2 ckix: 36
ncol: 4 nnew: 3 size: 0
KDO Op code:  21 row dependencies Disabled
  xtype: XAxtype KDO_KDOM2 flags: 0x00000080  bdba: 0x004023d1  hdba: 0x004023d0
itli: 2  ispac: 0  maxfr: 4863
vect = 2
col  1: [ 5]  c4 07 1d 01 41
col  2: [ 5]  c4 07 1d 01 41
col  3: [ 2]  c1 02

REDO RECORD - Thread:1 RBA: 0x00006f.00000031.005c LEN: 0x0068 VLD: 0x01 CON_UID: 0
SCN: 0x0000.005fd382 SUBSCN:  1 09/20/2013 19:38:31
CHANGE #1 CON_ID:0 TYP:0 CLS:33 AFN:5 DBA:0x01400100 OBJ:4294967295 SCN:0x0000.005fd381 SEQ:1 OP:5.4 ENC:0 RBL:0
ktucm redo: slt: 0x0013 sqn: 0x00000fd2 srt: 0 sta: 9 flg: 0x2 ktucf redo: uba: 0x01402181.0319.03 ext: 2 spc: 7752 fbi: 0
END OF REDO DUMP
==== Redo read statistics for thread 1 ====
Total physical reads (from disk and memory): 1023Kb
-- Redo read_disk statistics --
Read rate (ASYNC): 24Kb in 0.50s => 0.05 Mb/sec
Total redo bytes: 1023Kb Longest record: 2Kb, moves: 0/165 moved: 0Mb (0%)
Longest LWN: 13Kb, reads: 10
Last redo scn: 0x0000.005fd382 (6280066)
Change vector header moves = 2/178 (1%)

回复只看该作者道具举报

Maclean Liu(刘相兵

7^#

发表于 2013-9-20 20:06:17

ktfbhfo - File Space Header Format ==> ktfbhfo - KTFB Header FOrmat formats space file header

回复只看该作者道具举报

返回列表

		自动登录	找回密码
密码			注册