重做日志文件跟踪日志分析

重做日志文件对Oracle系统来说,是至关重要的,Oracle对重做日志文件的所有变化都有日志文件记录.

日志存放路径:

D:/oracle/admin/ora92/bdump

以上路径与Oracle的安装有关.

在以上路径中,所有的 .trc 文件都用来记录重做日志文件的每一次变更:

下面以实例分析:

Dump file d:/oracle/admin/ora92/bdump/ora92_arc2_2076.trc
Fri Nov 17 00:03:00 2006
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 1, CPU type 586
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Windows 2000 Version 5.2 Service Pack 1, CPU type 586
Instance name: ora92

Redo thread mounted by this instance: 1

Oracle process number: 12

Windows thread id: 2076, image: ORACLE.EXE

*** SESSION ID:(11.1) 2006-11-17 00:03:00.000
- Created archivelog as 'D:/ORACLE/ORA92/RDBMS/ARC00001.001'

 

刚开始的部分说明文件存放的路径和创建的时间:

Dump file d:/oracle/admin/ora92/bdump/ora92_arc2_2076.trc
Fri Nov 17 00:03:00 2006

再下面是关于Oracle和操作系统的信息:

ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 1, CPU type 586
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Windows 2000 Version 5.2 Service Pack 1, CPU type 586

当前Oracle的实例名:

Instance name: ora92

进程信息:

Redo thread mounted by this instance: 1

Oracle process number: 12

Windows thread id: 2076, image: ORACLE.EXE

最下面是关于重做日志事件的记录,主要有事件发生的时间和事件信息:

*** SESSION ID:(11.1) 2006-11-17 00:03:00.000
- Created archivelog as 'D:/ORACLE/ORA92/RDBMS/ARC00001.001'

这个记录说明: Oralce新建了一个归档文件ARC00001.001,存放在 D:/ORACLE/ORA92/RDBMS/目录下.

这只是一个正常的归档记录,再看下面:

Dump file d:/oracle/admin/ora92/bdump/ora92_lgwr_3148.trc
Thu Nov 16 11:33:58 2006
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 1, CPU type 586
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Windows 2000 Version 5.2 Service Pack 1, CPU type 586
Instance name: ora92

Redo thread mounted by this instance: 1

Oracle process number: 4

Windows thread id: 3148, image: ORACLE.EXE

*** SESSION ID:(3.1) 2006-11-16 11:33:58.000
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: 'D:/ORACLE/ORADATA/ORA92/REDO03.LOG'
ORA-27041: unable to open file
OSD-04002: 无法打开文件
O/S-Error: (OS 2) 系统找不到指定的文件。
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: 'D:/ORACLE/ORADATA/ORA92/REDO03.LOG'
ORA-27041: unable to open file
OSD-04002: 无法打开文件
O/S-Error: (OS 2) 系统找不到指定的文件。

在这个日志中,记录了一个发生的错误. 不能打开日志组3.

 

Dump file d:/oracle/admin/ora92/bdump/ora92_lgwr_3920.trc
Wed Nov 15 00:41:43 2006
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 1, CPU type 586
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Windows 2000 Version 5.2 Service Pack 1, CPU type 586
Instance name: ora92

Redo thread mounted by this instance: 1

Oracle process number: 4

Windows thread id: 3920, image: ORACLE.EXE

*** SESSION ID:(3.1) 2006-11-15 00:41:43.000
Archiving is disabled

这个说明了自动归档被禁止了.

从上面可以看出来,只要是和日志有关的事件,都会被记录下来,如果有关重做日志出错了,可以从这些记录中查看原因.