轉儲日誌檔案頭

一般來講我們可以通過轉儲日誌檔案頭來獲得更多的日誌檔案資訊：

SQL> alter session set events 'immediate trace name redohdr level 10';

會話已更改。
 
以下是日誌檔案的內容：

通過蘭色字型我們可以看到更多的資訊內容，比如日誌塊資料的大小(512位元組)，而且通過Next scn: 0xffff.ffffffff 我們還可以看到log file group 1是我們的current日誌檔案組

Dump file d:\oracle\admin\icmnlsdb\udump\mylife_ora_4256.trc
Thu Dec 20 13:48:25 2007
ORACLE V9.2.0.8.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.1 Service Pack 2, CPU type 586
Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
Windows 2000 Version 5.1 Service Pack 2, CPU type 586
Instance name: mylife

Redo thread mounted by this instance: 1

Oracle process number: 10

Windows thread id: 4256, image: ORACLE.EXE

*** 2007-12-20 13:48:25.515
*** SESSION ID:(8.1338) 2007-12-20 13:48:25.500
DUMP OF LOG FILES: 3 logs in database
LOG FILE #1:
  (name #3) D:\ORACLE\ORADATA\ICMNLSDB\REDO01.LOG
 Thread 1 redo log links: forward: 2 backward: 0
 siz: 0x32000 seq: 0x00000011 hws: 0x1 bsz: 512 nab: 0xffffffff flg: 0x8 dup: 1
 Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.003022c6
 Low scn: 0x0000.003022c8 12/18/2007 14:34:04
 Next scn: 0xffff.ffffffff 01/01/1988 00:00:00
 FILE HEADER:
 Software vsn=153092096=0x9200000, Compatibility Vsn=153092096=0x9200000
 Db ID=862305779=0x3365bdf3, Db Name='ICMNLSDB'
 Activation ID=873011973=0x34091b05
 Control Seq=1146=0x47a, File size=204800=0x32000
 File Number=1, Blksiz=512, File Type=2 LOG
 descrip:"Thread 0001, Seq# 0000000017, SCN 0x0000003022c8-0xffffffffffff"
 thread: 1 nab: 0xffffffff seq: 0x00000011 hws: 0x1 eot: 1 dis: 0
 reset logs count: 0x261cb1c6 scn: 0x0000.0023ff8c
 Low scn: 0x0000.003022c8 12/18/2007 14:34:04
 Next scn: 0xffff.ffffffff 01/01/1988 00:00:00
 Enabled scn: 0x0000.0023ff8c 11/23/2007 15:12:06
 Thread closed scn: 0x0000.003022c8 12/18/2007 14:34:04
 Log format vsn: 0x8000000 Disk cksum: 0xd4d5 Calc cksum: 0xd4d5
 Terminal Recovery Stamp scn: 0x0000.00000000 01/01/1988 00:00:00
 Most recent redo scn: 0x0000.00000000
 Largest LWN: 0 blocks
 Miscellaneous flags: 0x0
LOG FILE #2:
  (name #2) D:\ORACLE\ORADATA\ICMNLSDB\REDO02.LOG
 Thread 1 redo log links: forward: 3 backward: 1
 siz: 0x32000 seq: 0x0000000f hws: 0x6 bsz: 512 nab: 0x32ae flg: 0x0 dup: 1
 Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.002ecfaf
 Low scn: 0x0000.002f1f17 12/14/2007 16:38:12
 Next scn: 0x0000.003022c6 12/18/2007 14:34:01
 FILE HEADER:
 Software vsn=153092096=0x9200000, Compatibility Vsn=153092096=0x9200000
 Db ID=862305779=0x3365bdf3, Db Name='ICMNLSDB'
 Activation ID=873011973=0x34091b05
 Control Seq=1144=0x478, File size=204800=0x32000
 File Number=2, Blksiz=512, File Type=2 LOG
 descrip:"Thread 0001, Seq# 0000000015, SCN 0x0000002f1f17-0x0000003022c6"
 thread: 1 nab: 0x32ae seq: 0x0000000f hws: 0x6 eot: 0 dis: 0
 reset logs count: 0x261cb1c6 scn: 0x0000.0023ff8c
 Low scn: 0x0000.002f1f17 12/14/2007 16:38:12
 Next scn: 0x0000.003022c6 12/18/2007 14:34:01
 Enabled scn: 0x0000.0023ff8c 11/23/2007 15:12:06
 Thread closed scn: 0x0000.002f3d07 12/16/2007 14:00:09
 Log format vsn: 0x8000000 Disk cksum: 0xfd5 Calc cksum: 0xfd5
 Terminal Recovery Stamp scn: 0x0000.00000000 01/01/1988 00:00:00
 Most recent redo scn: 0x0000.00000000
 Largest LWN: 0 blocks
 Miscellaneous flags: 0x0
LOG FILE #3:
  (name #1) D:\ORACLE\ORADATA\ICMNLSDB\REDO03.LOG
 Thread 1 redo log links: forward: 0 backward: 2
 siz: 0x32000 seq: 0x00000010 hws: 0x2 bsz: 512 nab: 0x2 flg: 0x0 dup: 1
 Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.002f1f17
 Low scn: 0x0000.003022c6 12/18/2007 14:34:01
 Next scn: 0x0000.003022c8 12/18/2007 14:34:04
 FILE HEADER:
 Software vsn=153092096=0x9200000, Compatibility Vsn=153092096=0x9200000
 Db ID=862305779=0x3365bdf3, Db Name='ICMNLSDB'
 Activation ID=873011973=0x34091b05
 Control Seq=1146=0x47a, File size=204800=0x32000
 File Number=3, Blksiz=512, File Type=2 LOG
 descrip:"Thread 0001, Seq# 0000000016, SCN 0x0000003022c6-0x0000003022c8"
 thread: 1 nab: 0x2 seq: 0x00000010 hws: 0x2 eot: 0 dis: 0
 reset logs count: 0x261cb1c6 scn: 0x0000.0023ff8c
 Low scn: 0x0000.003022c6 12/18/2007 14:34:01
 Next scn: 0x0000.003022c8 12/18/2007 14:34:04
 Enabled scn: 0x0000.0023ff8c 11/23/2007 15:12:06
 Thread closed scn: 0x0000.003022c6 12/18/2007 14:34:01
 Log format vsn: 0x8000000 Disk cksum: 0x9d39 Calc cksum: 0x9d39
 Terminal Recovery Stamp scn: 0x0000.00000000 01/01/1988 00:00:00
 Most recent redo scn: 0x0000.00000000
 Largest LWN: 0 blocks
 Miscellaneous flags: 0x0

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/12361284/viewspace-951/，如需轉載，請註明出處，否則將追究法律責任。