How to restore logical logs from file ?

hi all, my logical log files are saved to file (each logical log is one file) LTAPEDEV =/tmp/logfile will be removed each time after back up with ontape -a The Problem is that informix crashes when i try to recover them. The 1st one will be read successfully but then informix get offline. this is what my logfile shows after the rootdbs has been restored : -- 15:25:41 Physical Restore of rootdbs Completed. 15:25:41 Checkpoint Completed: duration was 0 seconds. 15:25:41 Checkpoint loguniq 73, logpos 0x18c2b4 15:25:57 Logical Recovery Started. 15:25:57 dynamically allocated new shared memory segment (size 8388608) 15:25:57 Checkpoint Completed: duration was 0 seconds. 15:25:57 Checkpoint loguniq 73, logpos 0x18c2b4 15:25:57 Start Logical Recovery - Start Log 73, End Log ? 15:25:57 Starting Log Position - 73 0x18c2b4 15:25:58 Checkpoint Completed: duration was 0 seconds. 15:25:58 Checkpoint loguniq 73, logpos 0x18d018 15:26:27 Logical Recovery ABORTED. Aborted by client. 15:26:27 Assert Failed: Logical Recovery ABORTED. Dynamic Server 2000 must abort 15:26:27 Informix Dynamic Server 2000 Version 9.20.UC1 15:26:27 Who: Session(12, user@backend, 712, 277371568) Thread(19, ontape, 10858298, 1) File: rslgr.c Line: 1079 15:26:27 stack trace for pid 716 written to /tmp/af.3fba003 15:26:27 See Also: /tmp/af.3fba003, shmem.3fba003.0 15:26:30 rslgr.c, line 1079, thread 19, proc id 716, Logical Recovery ABORTED. Dynamic Server 2000 must abort. 15:26:31 The Master Daemon Died 15:26:31 PANIC: Attempting to bring system down 15:26:31 semctl: errno = 22 15:26:31 semctl: errno = 22 -- thanks for any help Chris

How are you attempting the restore? If via script know that ontape will prompt for the next tape/file each time it finishes a file. All logs need to be restored in a single ontape session so unless you are using a sophisticated expect script to manage the ontape session you will need to run the restore by hand. Art S. Kagel Christoph Schiffer wrote: > > hi all, > > my logical log files are saved to file (each logical log is one file) > LTAPEDEV =/tmp/logfile will be removed each time after back up > with ontape -a > > The Problem is that informix crashes when i try to recover them. The 1st > one will be read successfully > but then informix get offline. > > this is what my logfile shows after the rootdbs has been restored : > > -- > 15:25:41 Physical Restore of rootdbs Completed. > 15:25:41 Checkpoint Completed: duration was 0 seconds. > 15:25:41 Checkpoint loguniq 73, logpos 0x18c2b4 > > 15:25:57 Logical Recovery Started. > 15:25:57 dynamically allocated new shared memory segment (size 8388608) > > 15:25:57 Checkpoint Completed: duration was 0 seconds. > 15:25:57 Checkpoint loguniq 73, logpos 0x18c2b4 > > 15:25:57 Start Logical Recovery - Start Log 73, End Log ? > 15:25:57 Starting Log Position - 73 0x18c2b4 > 15:25:58 Checkpoint Completed: duration was 0 seconds. > 15:25:58 Checkpoint loguniq 73, logpos 0x18d018 > > 15:26:27 Logical Recovery ABORTED. > Aborted by client. > 15:26:27 Assert Failed: Logical Recovery ABORTED. > Dynamic Server 2000 must abort > 15:26:27 Informix Dynamic Server 2000 Version 9.20.UC1 > 15:26:27 Who: Session(12, user@backend, 712, 277371568) > Thread(19, ontape, 10858298, 1) > File: rslgr.c Line: 1079 > 15:26:27 stack trace for pid 716 written to /tmp/af.3fba003 > 15:26:27 See Also: /tmp/af.3fba003, shmem.3fba003.0 > 15:26:30 rslgr.c, line 1079, thread 19, proc id 716, Logical Recovery > ABORTED. > Dynamic Server 2000 must abort. > 15:26:31 The Master Daemon Died > 15:26:31 PANIC: Attempting to bring system down > 15:26:31 semctl: errno = 22 > > 15:26:31 semctl: errno = 22 > --> > thanks for any help > > Chris

"Art S. Kagel" wrote: > > How are you attempting the restore? If via script know that ontape will > prompt for the next tape/file each time it finishes a file. All logs need > to be restored in a single ontape session so unless you are using a > sophisticated expect script to manage the ontape session you will need to > run the restore by hand. > after some testing i found out that my LTAPSIZE, LOGSIZE and LOGFILES where to small or not ok in my onconfig file. After changing that everything works fine. thanks to you Art S. Kagel Chris. > Art S. Kagel > > Christoph Schiffer wrote: > > > > hi all, > > > > my logical log files are saved to file (each logical log is one file) > > LTAPEDEV =/tmp/logfile will be removed each time after back up > > with ontape -a > > > > The Problem is that informix crashes when i try to recover them. The 1st > > one will be read successfully > > but then informix get offline. > > > > this is what my logfile shows after the rootdbs has been restored : > > > > -- > > 15:25:41 Physical Restore of rootdbs Completed. > > 15:25:41 Checkpoint Completed: duration was 0 seconds. > > 15:25:41 Checkpoint loguniq 73, logpos 0x18c2b4 > > > > 15:25:57 Logical Recovery Started. > > 15:25:57 dynamically allocated new shared memory segment (size 8388608) > > > > 15:25:57 Checkpoint Completed: duration was 0 seconds. > > 15:25:57 Checkpoint loguniq 73, logpos 0x18c2b4 > > > > 15:25:57 Start Logical Recovery - Start Log 73, End Log ? > > 15:25:57 Starting Log Position - 73 0x18c2b4 > > 15:25:58 Checkpoint Completed: duration was 0 seconds. > > 15:25:58 Checkpoint loguniq 73, logpos 0x18d018 > > > > 15:26:27 Logical Recovery ABORTED. > > Aborted by client. > > 15:26:27 Assert Failed: Logical Recovery ABORTED. > > Dynamic Server 2000 must abort > > 15:26:27 Informix Dynamic Server 2000 Version 9.20.UC1 > > 15:26:27 Who: Session(12, user@backend, 712, 277371568) > > Thread(19, ontape, 10858298, 1) > > File: rslgr.c Line: 1079 > > 15:26:27 stack trace for pid 716 written to /tmp/af.3fba003 > > 15:26:27 See Also: /tmp/af.3fba003, shmem.3fba003.0 > > 15:26:30 rslgr.c, line 1079, thread 19, proc id 716, Logical Recovery > > ABORTED. > > Dynamic Server 2000 must abort. > > 15:26:31 The Master Daemon Died > > 15:26:31 PANIC: Attempting to bring system down > > 15:26:31 semctl: errno = 22 > > > > 15:26:31 semctl: errno = 22 > > --> > > > thanks for any help > > > > Chris