一般来讲我们可以通过转储日志文件头来获得更多的日志文件信息:
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/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/12361284/viewspace-951/