Redo log header 研究

            Redo log  结构如下：
       

block0 操作系统文件头
    

点击(此处)折叠或打开

1. dd if=redo01.log bs=512 count=1 |od -X
   1+0 records in
   1+0 records out
   512 bytes (512 B) copied, 0.00175973 s, 291 kB/s
   0000000 00002200 ffc00000 00000000 00000000
   0000020 0000c867 00000200 00019000 7a7b7c7d
   0000040 000081a0 00000000 00000000 00000000
   0000060 00000000 00000000 00000000 00000000
2. dd block 1 redo header
3. -bash-4.1$ dd if=redo01.log skip=1 bs=512 count=1 |od -X    ==>字节序已经反转过来了
   1+0 records in
   1+0 records out
   512 bytes (512 B) copied, 0.000347541 s, 1.5 MB/s
   0000000 00002201 00000001 0000009d f8268000   => seq\ disksum zero blocks
   0000020 00000000 0b200400 0f4382b8 444f5250   =>Compatibility Vsn、 dbid\db_name PROD
   0000040 00000000 00003d44 00019000 00000200   =>Control Seq\blocks\block_size
   0000060 00020001 10bd1e2f 00000000 00000000   =>log_format,FILE_NUMBER,Activation ID
   0000100 00000000 00000000 00000000 00000000
   0000120 00000000 00000000 00000000 65726854    descip
   0000140 30206461 2c313030 71655320 30302023
   0000160 30303030 37353130 4353202c 7830204e
   0000200 30303030 39633030 34623864 3078302d
   0000220 30303030 36616330 00616531 00006d65  => nab
   0000240 33cb6ac8 0081cdf7 00000000 00000004  => reset logs count,scn
   0000260 00000001 00c9d8b4 00000000 350eb0e2  => low scn
   0000300 00ca61ea 00000000 350fa3d3 02080000  => next scn
   0000320 0081cdf7 00000000 33cb6ac8 00ca61e8  => enable scn ,thread close scn
   0000340 00000000 350f07bf 00000000 00800000
   0000360 00000000 00000000 00000000 00000002
   0000400 00000000 00000000 00000000 00000000
   0000420 00000000 00000000 00000000 007a5b94
   0000440 00000000 33ae8481 00000000 00000000
   0000460 00000000 00000000 00000000 00000000
   0000700 820de317 c9752ead 6447e99b 586fe9ba
   0000720 b3adcfa5 a7aa95e3 21134335 1f91e372
   0000740 00000005 00000000 00000000 00000000
   0000760 00000000 00000000 00000000 00000000
   0001000
   
   

                                                                                                

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

转载于:http://blog.itpub.net/21980353/viewspace-1798080/