Logical Logging error for 'OLDRSAM:HDELETE' in 'logread'

Hi, I have a problem with fast recovery logical restore. I was running delete sentences, to many, and I aborted program. For this reason, the server changed your mode: online to fast recovery. The problem is: I don`t change to online mode. I study different options and I can't resolve it: 1. I saw message log 2. I saw the temporal files to get the logical log id 3. I couldn't use Onlog utility to view the transaction and repair manually because the server is offline and I couldn't change it. 4. I couldn't use onparams command to delete bad logical log. And now I don't know what can I do, anybody have some suggestions? I attach the temporal file and the last lines message's log: -- Temporal File af.40365f6 13:59:35 log_get: page doesn't match loguniq 7402 or pagenum 488 13:59:35 pg_uniqid = 7420, pg_number = 488 page header 0d0b3000: b1130001 3d21bcb0 00000001 fc0f0000 ....=!.. ........ 0d0b3010: fc1c0000 e8010000 ........ 13:59:35 log_get: cannot read loguniq 7402 logpos 0x1e82d4 13:59:35 logm_read: cannot read loguniq 7402 logpos 0x1e82d4 13:59:35 logerr('logread') 13:59:35 tx 0xeeae728, tx_flags 0x80001 13:59:35 tx_loguniq 0, tx_logpos 0x0 --- Message log file 10:25:05 Logical Log 7403 Complete. 10:25:07 Logical Log 7404 Complete. 10:25:14 Fuzzy Checkpoint Completed: duration was 2 seconds, 402 buffers not flushed. 10:25:14 Checkpoint loguniq 7405, logpos 0x163d94 10:25:16 Logical Log 7405 Complete. 10:25:18 Logical Log 7406 Complete. 10:25:22 Fuzzy Checkpoint Completed: duration was 2 seconds, 536 buffers not flushed. 10:25:22 Checkpoint loguniq 7407, logpos 0x2c39d8 10:25:22 Aborting Long Transaction: tx 0xeeaeab0 username: dba uid: 7 10:25:25 Logical Log 7407 Complete. 10:25:28 Fuzzy Checkpoint Completed: duration was 2 seconds, 659 buffers not flushed. 10:25:28 Checkpoint loguniq 7408, logpos 0x1844f0 10:25:29 Logical Log 7408 Complete. 10:25:32 Logical Log 7409 Complete. 10:25:36 Logical Log 7410 Complete. 10:25:37 Logical Log 7411 Complete. 10:25:39 Fuzzy Checkpoint Completed: duration was 2 seconds, 319 buffers not flushed. 10:25:39 Checkpoint loguniq 7412, logpos 0x24484 10:25:41 Logical Log 7413 Complete. 10:25:48 Logical Log 7414 Complete. 10:25:49 Logical Log 7415 Complete. 10:25:50 Logical Log 7416 Complete. 10:25:55 Logical Log 7418 Complete. 10:25:58 Fuzzy Checkpoint Completed: duration was 3 seconds, 762 buffers not flushed. 10:25:58 Checkpoint loguniq 7419, logpos 0x11f018 10:26:00 Logical Log Files are Full -- Backup is Needed 10:26:00 Logical Log 7419 Complete. 11:33:39 listener-thread: err = -951: oserr = 0: errstr = dba: Incorrect password or user dba is not known on the database server. 11:40:07 Informix Dynamic Server 2000 Started. Tue Oct 21 11:40:13 2003 11:40:13 Booting Language <c> from module <> 11:40:13 Loading Module <CNULL> 11:40:14 Booting Language <builtin> from module <> 11:40:14 Loading Module <BUILTINNULL> 11:40:20 Informix Dynamic Server 2000 Version 9.21.TC5 Software Serial Number AAD#J223696 11:40:26 Informix Dynamic Server 2000 Initialized -- Shared Memory Initialized. 11:40:27 Physical Recovery Started at Page(12:187). 11:40:36 Physical Recovery Complete: 867 Pages Examined 867 Pages Restored. 11:40:37 Logical Recovery Started. 11:40:38 10 recovery worker threads will be started. 11:40:44 Fast Recovery Switching to Log 7408 11:40:50 Fast Recovery Switching to Log 7409 11:40:58 Logical Logging error for 'OLDRSAM:HDELETE' in 'logread' 11:50:54 Informix Dynamic Server 2000 Started. Tue Oct 21 11:51:01 2003 11:51:01 Booting Language <c> from module <> 11:51:02 Loading Module <CNULL> 11:51:02 Booting Language <builtin> from module <> 11:51:03 Loading Module <BUILTINNULL> 11:51:09 Informix Dynamic Server 2000 Version 9.21.TC5 Software Serial Number AAD#J223696 11:51:17 Informix Dynamic Server 2000 Initialized -- Shared Memory Initialized. 11:51:18 Physical Recovery Started at Page(12:187). 11:51:23 Physical Recovery Complete: 867 Pages Examined 867 Pages Restored. 11:51:24 Logical Recovery Started. 11:51:24 10 recovery worker threads will be started. 11:51:30 Fast Recovery Switching to Log 7408 11:51:38 Fast Recovery Switching to Log 7409 11:51:45 Logical Logging error for 'OLDRSAM:HDELETE' in 'logread' 12:06:58 Informix Dynamic Server 2000 Started. Tue Oct 21 12:07:07 2003 12:07:07 Booting Language <c> from module <> 12:07:08 Loading Module <CNULL> 12:07:08 Booting Language <builtin> from module <> 12:07:08 Loading Module <BUILTINNULL> 12:07:13 Informix Dynamic Server 2000 Version 9.21.TC5 Software Serial Number AAD#J223696 12:07:18 Informix Dynamic Server 2000 Initialized -- Shared Memory Initialized. 12:07:20 Physical Recovery Started at Page(12:187). 12:07:23 Physical Recovery Complete: 867 Pages Examined 867 Pages Restored. 12:07:24 Logical Recovery Started. 12:07:24 10 recovery worker threads will be started. 12:07:36 Fast Recovery Switching to Log 7408 12:07:43 Fast Recovery Switching to Log 7409 12:07:55 Logical Logging error for 'OLDRSAM:HDELETE' in 'logread' 12:42:03 Informix Dynamic Server 2000 Started. Tue Oct 21 12:42:09 2003 12:42:09 Booting Language <c> from module <> 12:42:09 Loading Module <CNULL> 12:42:09 Booting Language <builtin> from module <> 12:42:09 Loading Module <BUILTINNULL> 12:42:15 Informix Dynamic Server 2000 Version 9.21.TC5 Software Serial Number AAD#J223696 12:42:17 Informix Dynamic Server 2000 Initialized -- Shared Memory Initialized. 12:42:18 Physical Recovery Started at Page(12:187). 12:42:18 Physical Recovery Complete: 867 Pages Examined 867 Pages Restored. 12:42:18 Logical Recovery Started. 12:42:18 10 recovery worker threads will be started. 12:42:22 Fast Recovery Switching to Log 7408 12:42:28 Fast Recovery Switching to Log 7409 12:42:43 Logical Logging error for 'OLDRSAM:HDELETE' in 'logread' 13:59:17 Informix Dynamic Server 2000 Started. Tue Oct 21 13:59:17 2003 13:59:17 Booting Language <c> from module <> 13:59:17 Loading Module <CNULL> 13:59:17 Booting Language <builtin> from module <> 13:59:17 Loading Module <BUILTINNULL> 13:59:22 Informix Dynamic Server 2000 Version 9.21.TC5 Software Serial Number AAD#J223696 13:59:24 Informix Dynamic Server 2000 Initialized -- Shared Memory Initialized. 13:59:24 Physical Recovery Started at Page(12:187). 13:59:25 Physical Recovery Complete: 867 Pages Examined 867 Pages Restored. 13:59:25 Logical Recovery Started. 13:59:25 10 recovery worker threads will be started. 13:59:27 Fast Recovery Switching to Log 7408 13:59:31 Fast Recovery Switching to Log 7409 13:59:35 Logical Logging error for 'OLDRSAM:HDELETE' in 'logread' Thanks Paola ------------------------------------------------- This mail sent through IMP: http://mail.info.unlp.edu.ar/