- 最后登录
- 2023-8-16
- 在线时间
- 1686 小时
- 威望
- 2135
- 金钱
- 50532
- 注册时间
- 2011-10-12
- 阅读权限
- 200
- 帖子
- 5207
- 精华
- 39
- 积分
- 2135
- UID
- 2
|
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%) |
|