9.oracle的dump理解九 dump REDO文件头

9.oracle的dump理解九 dump REDO文件头

欢迎转载，转载请标明出处：http://blog.csdn.net/notbaron/article/details/51284566

DUMP REDO文件头命令如下：

SQL> oradebug dump redohdr 1

1     等级1的DUMP

内容其实是非常少的，如下：

LOG FILE #1:

 name #3: F:\TOADDBDATAFILE\TOADDB\REDO01.LOG

 Thread 1 redo log links: forward: 2 backward:0

 siz:0x19000 seq: 0x00000019 hws: 0x2 bsz: 512 nab: 0x13ec2 flg: 0x0 dup: 1

 Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.00287f1a

 Low scn: 0x0000.0028bcf6 04/24/2016 22:04:23

 Next scn: 0x0000.002919cb 04/25/2016 06:00:33

LOG FILE #2:

 name #2: F:\TOADDBDATAFILE\TOADDB\REDO02.LOG

 Thread 1 redo log links: forward: 3 backward:1

 siz:0x19000 seq: 0x0000001a hws: 0x1 bsz: 512 nab: 0xffffffff flg: 0x8 dup: 1

 Archive links: fwrd: 0 back: 0 Prev scn:0x0000.0028bcf6

 Lowscn: 0x0000.002919cb 04/25/2016 06:00:33

 Nextscn: 0xffff.ffffffff 01/01/1988 00:00:00

LOG FILE #3:

 name #1: F:\TOADDBDATAFILE\TOADDB\REDO03.LOG

 Thread 1 redo log links: forward: 0 backward:2

 siz:0x19000 seq: 0x00000018 hws: 0x2 bsz: 512 nab: 0x16adf flg: 0x0 dup: 1

 Archive links: fwrd: 0 back: 0 Prev scn:0x0000.00284582

 Lowscn: 0x0000.00287f1a 04/24/2016 16:00:06

 Nextscn: 0x0000.0028bcf6 04/24/2016 22:04:23

共3个REDO 文件，大家好找的内容也就是SCN相关的。

2     等级2的DUMP

增加了文件头兼容性相关内容。

FILE HEADER:

       CompatibilityVsn = 202375680=0xc100200

       DbID=60949636=0x3a20484, Db Name='TOADDB'

       ActivationID=60965508=0x3a24284

       ControlSeq=7064=0x1b98, File size=102400=0x19000

       FileNumber=3, Blksiz=512, File Type=2 LOG

3     等级3的DUMP

增加了更多详细的内容如下：

LOG FILE #1:

 name #3: F:\TOADDBDATAFILE\TOADDB\REDO01.LOG

 Thread 1 redo log links: forward: 2 backward:0

 siz:0x19000 seq: 0x00000019 hws: 0x2 bsz: 512 nab: 0x13ec2 flg: 0x0 dup: 1

 Archive links: fwrd: 0 back: 0 Prev scn:0x0000.00287f1a

 Lowscn: 0x0000.0028bcf6 04/24/2016 22:04:23

 Nextscn: 0x0000.002919cb 04/25/2016 06:00:33

 FILEHEADER:

       CompatibilityVsn = 202375680=0xc100200

       DbID=60949636=0x3a20484, Db Name='TOADDB'

       ActivationID=60965508=0x3a24284

       ControlSeq=7237=0x1c45, File size=102400=0x19000

       FileNumber=1, Blksiz=512, File Type=2 LOG

 Format ID is 18

 redolog key is 5de02dd51cc1d42500dadbde04abdd4d

 redolog key flag is 5

 descrip:"Thread 0001, Seq# 0000000025,SCN 0x00000028bcf6-0x0000002919cb"

 thread: 1 nab: 0x13ec2 seq: 0x00000019 hws: 0x2eot: 0 dis: 0

 reset logs count: 0x36383b08 scn:0x0000.00221544

 Lowscn: 0x0000.0028bcf6 04/24/2016 22:04:23

 Nextscn: 0x0000.002919cb 04/25/2016 06:00:33

 Enabled scn: 0x0000.00221544 04/20/201609:53:12

 Thread closed scn: 0x0000.0028bcf6 04/24/201622:04:23

 Diskcksum: 0xba60 Calc cksum: 0xba60

 Terminal Recovery Stop scn: 0x0000.00000000

 Terminal Recovery Stamp  01/01/1988 00:00:00

 Mostrecent redo scn: 0x0000.00000000

 Largest LWN: 1668 blocks

 Miscellaneous flags: 0x10800000

 Thread internal enable indicator: thr: 0, seq:0 scn: 0x0000.00000000

 Zeroblocks: 8

 Enabled redo threads: 1