DELETEs causing dumping of current redo log

From: Bruce Pullen <bruce_pullen_at_hotmail.com>
Date: 11 Feb 2005 01:46:12 -0800
Message-ID: <9de33a7d.0502110146.521f590f@posting.google.com>

ORACLE V9.2.0.1.0 on Windows 2000 Server.

A specific DELETE is generating the following error (not as a result of redo logs filling up or waiting on changes to be writtent to disk as far as I can tell) - Can anyone please assist? Each time, the DELETE seems to be failing at the same block number too:

• 2005-02-11 09:23:39.000 *** SESSION ID:(29.40651) 2005-02-11 09:23:39.000 Dumping current redo log in thread 1

DUMP OF REDO FROM FILE '\\ASTERIX\LOGS\ORACLE\TITAN\LOGTITAN3.ORA'  Opcodes *.*

 DBA's: (file # 10, block # 24906) thru (file # 10, block # 24906)
 RBA's: 0x000000.00000000.0000 thru 0xffffffff.ffffffff.ffff
 SCN's scn: 0x0000.00000000 thru scn: 0xffff.ffffffff

 Times: creation thru eternity
 FILE HEADER:
        Software vsn=153092096=0x9200000, Compatibility Vsn=153092096=0x9200000

	Db ID=4227385019=0xfbf8c6bb, Db Name='TITAN'
	Activation ID=4227375803=0xfbf8a2bb
	Control Seq=71494=0x11746, File size=409600=0x64000
	File Number=3, Blksiz=512, File Type=2 LOG

 descrip:"Thread 0001, Seq# 0000003409, SCN 0x00000b9c77dc-0xffffffffffff"
 thread: 1 nab: 0xffffffff seq: 0x00000d51 hws: 0x1 eot: 1 dis: 0  reset logs count: 0x1ce237bb scn: 0x0000.00000001  Low scn: 0x0000.0b9c77dc 02/11/2005 08:19:11  Next scn: 0xffff.ffffffff 01/01/1988 00:00:00  Enabled scn: 0x0000.00000001 01/29/2003 15:50:27  Thread closed scn: 0x0000.0b9c77dc 02/11/2005 08:19:11  Log format vsn: 0x8000000 Disk cksum: 0x1a5f Calc cksum: 0x1a5f  Terminal Recovery Stamp scn: 0x0000.00000000 01/01/1988 00:00:00  Most recent redo scn: 0x0000.00000000
 Largest LWN: 0 blocks
 End-of-redo stream : No
Unprotected mode
 Miscellaneous flags: 0x0 Received on Fri Feb 11 2005 - 03:46:12 CST