alert log:

Tue Apr 17 10:50:33 2007
LGWR: terminating instance due to error 472
Instance terminated by LGWR, pid = 1652

trace file:

sjprmktdb01 > more mrkt_ora_2140.trc
Dump file c:\oracle\admin\mrkt\udump\mrkt_ora_2140.trc
Tue Apr 17 10:55:07 2007
ORACLE V9.2.0.2.1 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Oracle9i Enterprise Edition Release 9.2.0.2.1 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.2.0 - Production
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Instance name: mrkt

Redo thread mounted by this instance: 1

Oracle process number: 13

Windows thread id: 2140, image: ORACLE.EXE


*** SESSION ID:(10.1) 2007-04-17 10:55:07.000
Thread checkpoint rba:0x08fe84.00000002.0010 scn:0x0001.888018e0
On-disk rba:0x08fe85.0000038f.0000 scn:0x0001.8897717e
Use incremental checkpoint cache-low RBA
Thread 1 recovery from rba:0x08fe84.00004ea8.0000 scn:0x0000.00000000
----- Redo read statistics for thread 1 -----
Read rate (ASYNC): 10864Kb in 0.25s => 40.00 Mb/sec
Longest record: 8Kb, moves: 2/3065 (0%)
Change moves: 0/22 (0%), moved: 0Mb
----------------------------------------------
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 1
Average hash chain = 84/84 = 1.0
Max compares per lookup = 1
Avg compares per lookup = 2719/2865 = 0.9
----------------------------------------------
*** 2007-04-17 10:55:07.000
KCRA: start recovery claims for 84 data blocks
*** 2007-04-17 10:55:07.000
KCRA: buffers claimed = 84/84, eliminated = 0
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 1
Average hash chain = 84/84 = 1.0
Max compares per lookup = 1
Avg compares per lookup = 2198/2803 = 0.8
----------------------------------------------