flashback使用(3)

Repeat 500 times

7FF7F727C9D0 00000000 00000000 012C0000 04C10202 [..........,.....]

7FF7F727C9E0 78787803 0202012C 610104C1 0202012C [.xxx,......a,...]

7FF7F727C9F0 610103C1 0202012C 610102C1 23690601 [...a,......a..i#]

Block header dump: 0x01002647

Object id on Block? Y

seg/obj: 0x14214 csc: 0x00.af2351 itc: 2 flg: E typ: 1 - DATA

brn: 0 bdba: 0x1002640 ver: 0x01 opc: 0

inc: 0 exflg: 0

Itl Xid Uba Flag Lck Scn/Fsc

0x01 0x0006.014.00002301 0x00c004fc.07fb.28 --U- 3 fsc 0x0000.00af2369

0x02 0x0000.000.00000000 0x00000000.0000.00 ---- 0 fsc 0x0000.00000000

bdba: 0x01002647

data_block_dump,data header at 0x7ff7f727aa64

===============

tsiz: 0x1f98

hsiz: 0x18

pbl: 0x7ff7f727aa64

76543210

flag=--------

ntab=1

nrow=3

frre=-1

fsbo=0x18

fseo=0x1f76

avsp=0x1f64

tosp=0x1f64

0xe:pti[0] nrow=3 offs=0

0x12:pri[0] offs=0x1f90

0x14:pri[1] offs=0x1f88

0x16:pri[2] offs=0x1f76

block_row_dump:

tab 0, row 0, @0x1f90

tl: 8 fb: --H-FL-- lb: 0x1 cc: 2

col 0: [ 2] c1 02

col 1: [ 1] 61

tab 0, row 1, @0x1f88

tl: 8 fb: --H-FL-- lb: 0x1 cc: 2

col 0: [ 2] c1 03

col 1: [ 1] 61

tab 0, row 2, @0x1f76

tl: 10 fb: --H-FL-- lb: 0x1 cc: 2

col 0: [ 2] c1 04

col 1: [ 3] 78 78 78

end_of_block_dump

End dump data blocks tsn: 4 file#: 4 minblk 9799 maxblk 9799

select to_number('00af2369','xxxxxxxxxxx') from dual;

TO_NUMBER('00AF2369','XXXXXXXXXXX')

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

11477865

Dump出来的scn和查询表的ora_rowscn是一样。

alter system dump datafile 4 block 9831;

Start dump data blocks tsn: 4 file#:4 minblk 9831 maxblk 9831

Block dump from cache:

Dump of buffer cache at level 4 for tsn=4, rdba=16787047

BH (0x763da4e8) file#: 4 rdba: 0x01002667 (4/9831) class: 1 ba: 0x76040000

set: 6 pool 3 bsz: 8192 bsi: 0 sflg: 2 pwc: 474,28

dbwrid: 0 obj: 82456 objn: 82456 tsn: 4 afn: 4 hint: f

hash: [0x76fef5a8,0x90a62270] lru: [0x763da700,0x763da4a0]

ckptq: [NULL] fileq: [NULL] objq: [0x76fef998,0x8df6aa78]

st: XCURRENT md: NULL tch: 4

flags: block_written_once redo_since_read

LRBA: [0x0.0.0] LSCN: [0x0.0] HSCN: [0xffff.ffffffff] HSUB: [1]

cr pin refcnt: 0 sh pin refcnt: 0

BH (0x76fef4f8) file#: 4 rdba: 0x01002667 (4/9831) class: 1 ba: 0x76e76000

set: 6 pool 3 bsz: 8192 bsi: 0 sflg: 2 pwc: 474,28

dbwrid: 0 obj: 82456 objn: 82456 tsn: 4 afn: 4 hint: f

hash: [0x76fef808,0x763da598] lru: [0x90b1f818,0x763de4c0]

lru-flags: moved_to_tail

ckptq: [NULL] fileq: [NULL] objq: [NULL]

st: CR md: NULL tch: 2

cr: [scn: 0x0.af2d1d],[xid: 0x0.0.0],[uba: 0x0.0.0],[cls: 0x0.af2d1d],[sfl: 0x0],[lc:

0x0.af257f]

flags: block_written_once redo_since_read

cr pin refcnt: 0 sh pin refcnt: 0

BH (0x76fef758) file#: 4 rdba: 0x01002667 (4/9831) class: 1 ba: 0x76e7a000

set: 6 pool 3 bsz: 8192 bsi: 0 sflg: 2 pwc: 474,28

dbwrid: 0 obj: 82456 objn: 82456 tsn: 4 afn: 4 hint: f

hash: [0x78bf3f48,0x76fef5a8] lru: [0x77feff60,0x76ff08e0]

lru-flags: moved_to_tail

ckptq: [NULL] fileq: [NULL] objq: [NULL]

st: CR md: NULL tch: 2

cr: [scn: 0x0.af257c],[xid: 0x0.0.0],[uba: 0x0.0.0],[cls: 0x0.af257c],[sfl: 0x0],[lc:

0x0.af2558]

flags: redo_since_read

cr pin refcnt: 0 sh pin refcnt: 0

Block dump from disk:

buffer tsn: 4 rdba: 0x01002667 (4/9831)

scn: 0x0000.00af2d1f seq: 0x01 flg: 0x06 tail: 0x2d1f0601

frmt: 0x02 chkval: 0xa39f type: 0x06=trans data

Hex dump of block: st=0, typ_found=1

Dump of memory from 0x00007F63E42BEA00 to 0x00007F63E42C0A00

7F63E42BEA00 0000A206 01002667 00AF2D1F 06010000 [....g&...-......]

7F63E42BEA10 0000A39F 00000001 00014218 00AF257D [.........B..}%..]

7F63E42BEA20 00000000 00320002 01002660 00120004 [......2.`&......]

7F63E42BEA30 00001964 00C0046A 00300A9B 00002001 [d...j.....0.. ..]

7F63E42BEA40 00AF2D1F 000C0002 000022F7 00C00391 [.-......."......]

7F63E42BEA50 00040AEA 00002001 00AF257F 00000000 [..... ...%......]

7F63E42BEA60 00000000 00030120 0018FFFF 1F501F4D [.... .......M.P.]

7F63E42BEA70 00001F50 1F8A0003 1F5E1F4D 00000000 [P.......M.^.....]

7F63E42BEA80 00000000 00000000 00000000 00000000 [................]

Repeat 498 times

7F63E42C09B0 02012C00 25580000 C10200AF 79790403 [.,....X%......yy]

7F63E42C09C0 022C7979 58000002 0200AF25 780304C1 [yy,....X%......x]

7F63E42C09D0 002C7878 58000002 0200AF25 610104C1 [xx,....X%......a]

7F63E42C09E0 0002002C AF255800 03C10200 002C6101 [,....X%......a,.]

7F63E42C09F0 58000002 0200AF25 610102C1 2D1F0601 [...X%......a...-]

Block header dump: 0x01002667

Object id on Block? Y

seg/obj: 0x14218 csc: 0x00.af257d itc: 2 flg: E typ: 1 - DATA

brn: 0 bdba: 0x1002660 ver: 0x01 opc: 0

inc: 0 exflg: 0

Itl Xid Uba Flag Lck Scn/Fsc

0x01 0x0004.012.00001964 0x00c0046a.0a9b.30 --U- 1 fsc 0x0000.00af2d1f

0x02 0x0002.00c.000022f7 0x00c00391.0aea.04 --U- 1 fsc 0x0000.00af257f

bdba: 0x01002667

data_block_dump,data header at 0x7f63e42bea64

===============

tsiz: 0x1f98

hsiz: 0x18

pbl: 0x7f63e42bea64

76543210

flag=--R-----

ntab=1

nrow=3

frre=-1

fsbo=0x18

fseo=0x1f4d

avsp=0x1f50

tosp=0x1f50

0xe:pti[0] nrow=3 offs=0

0x12:pri[0] offs=0x1f8a

0x14:pri[1] offs=0x1f4d

0x16:pri[2] offs=0x1f5e

block_row_dump:

tab 0, row 0, @0x1f8a

tl: 14 fb: --H-FL-- lb: 0x0 cc: 2

dscn 0x0000.00af2558

col 0: [ 2] c1 02

col 1: [ 1] 61

tab 0, row 1, @0x1f4d

tl: 17 fb: --H-FL-- lb: 0x1 cc: 2

dscn 0x0000.00af2558

col 0: [ 2] c1 03

col 1: [ 4] 79 79 79 79

tab 0, row 2, @0x1f5e

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/24237320/viewspace-1058537/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24237320/viewspace-1058537/