ITPub博客

首页 > 数据库 > Oracle > Redo log header 研究

Redo log header 研究

原创 Oracle 作者:desert_xu 时间:2015-09-12 17:34:02 0 删除 编辑
            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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2013-10-23

  • 博文量
    79
  • 访问量
    242284