Hi,

sorry, but contacting Tech Support with this problem may
be a limited "solution", because this version of IDS has
long gone out of support. Support may be provided on a
"time & material basis", but usually that is subject to individual
negotiation ...

I would try to first do physical only restore ("ontape -p").

Then try to bring the server to on-line mode.
You may try this by doing "onmode -m", or "onmode -yuk"
followed by "oninit" (i.e. bring down the server and start it again).
The "ontape -l" after "ontape -p" I think is a scenario you already
tried.

If there is an open transaction that needs to be rolled back,
but there are no log records, then the above will most likely
not solve the problem. In that case Tech Support may be able
to cut off that transaction so that it will not be rolled back. Then
you'd have somewhere a logic inconsistency, but
at least you could access most of the data ...

Regards,
Martin
--
Martin Fuerderer
IBM Informix Development Munich, Germany
Information Management

IBM Deutschland GmbH
Chairman of the Supervisory Board: Hans Ulrich Märki
Board of Management: Martin Jetter (Chairman), Rudolf Bauer, Christian
Diedrich, Christoph Grandpierre, Matthias Hartmann, Thomas Fell, Michael
Diemer
Corporate Seat: Stuttgart, Germany; Reg.-Gericht: Amtsgericht Stuttgart,
HRB-Nr.: 14 562 WEEE-Reg.-Nr. DE 99369940

informix-list-bounces@iiug.org wrote on 19.06.2007 08:38:21:
> Contact TS this sounds like a bug. they will probably have to write a
> new checkpoint record.
>
> Superboer.
>
> On 18 jun, 21:36, v...@yandex.ru wrote:
> > I have a surprise problem with restore from 0-archive (IDS 2000
> > Version 9.20.UC2. Sun Solaris 8)
> >
> > The 0-archive is created by "ontape -s -L 0". But I can't perform cold
> > restore from it by "ontape -r"
> > (I do it without logical recovery):
> >
> > # . . .
> > # 22:30:19 Physical Restore of rootdbs, ritblb, basedbs, sbs1,
> > rapdbs, ritdbs Completed.
> > # 22:30:19 Checkpoint Completed: duration was 0 seconds.
> > # 22:30:19 Checkpoint loguniq 27, logpos 0x7ff018
> > #
> > # 22:30:32 Log 27 not found.
> > # 22:30:32 Cannot change to Quiescent Mode.
> > # . . .
> >
> > It looks like the 0-archive does not contain Log File 27 with
> > checkpoint 0x7ff018 - start point
> > for recovery:
> >
> > > % onstat -l
> > > . . .
> > > address number flags uniqid begin size used %used
> > > a499cdc 1 F------ 0 1010a7 2048 0 0.00
> > > a499cf8 2 F------ 0 1018a7 2048 0 0.00
> > > a499d14 3 F------ 0 1020a7 2048 0 0.00
> > > a499d30 4 F------ 0 1028a7 2048 0 0.00
> > > a499d4c 5 F------ 0 1030a7 2048 0 0.00
> > > a499d68 6 F------ 0 1038a7 2048 0 0.00
> > > a499d84 7 F------ 0 1040a7 2048 0 0.00
> > > a499da0 8 F------ 0 1048a7 2048 0 0.00
> > > a499dbc 9 F------ 0 1050a7 2048 0 0.00
> > > a499dd8 10 F------ 0 1058a7 2048 0 0.00
> > > a499df4 11 F------ 0 1060a7 2048 0 0.00
> > > a499e10 12 F------ 0 1068a7 2048 0 0.00
> >
> > If I do it witj logical restory (ontape -l), the result is wrong again
> > (the backup contains log files
> > 27-29):
> >
> > > % ontape -l
> > > Please mount tape 1 on <...> and press Return to continue ...
> > >
> > > Roll forward should start with log number 28
> > >
> > > Logical restore failed - buc_fe.c : Archive API processing failed
> > > at line 920 for msgtype
> > >
> > > Program over.
> >
> > online.log:
> > # 21:59:09 Checkpoint loguniq 27, logpos 0x7ff018
> > #
> > # 21:59:09 Start Logical Recovery - Start Log 28, End Log ?
> > # 21:59:09 Starting Log Position - 27 0x7ff018
> > # 21:59:33 Logical Recovery ABORTED.
> > # Log recovery needs to start with log 28.
> > #
> > # 21:59:33 Assert Failed: Logical Recovery ABORTED.
> > # Dynamic Server 2000 must abort
> > # 21:59:33 Informix Dynamic Server 2000 Version 9.20.UC2
> > # 21:59:33 Who: Session(10, informix@dwarf, 21495, 202381548)
> > # Thread(31, ontape, c0d3cd8, 1)
> > # File: rslgr.c Line: 1079
> > # 21:59:33 stack trace for pid 21446 written to /tmp/af.40792f4
> > # 21:59:33 See Also: /tmp/af.40792f4
> > # 21:59:54 rslgr.c, line 1079, thread 31, proc id 21446,
> > # Logical Recovery ABORTED.
> > # Dynamic Server 2000 must abort.
> > # 21:59:54 The Master Daemon Died
> > # 21:59:54 PANIC: Attempting to bring system down
> > # 21:59:54 semctl: errno = 22
> >
> > --------------------------------------------------------
> >
> > The question: IS ANY WAY TO RESTORE FROM THIS 0-ARCHIVE (wich does
> > not
> > include important log file 27 with starting point for recovery)?
> >
> > ================================================== ============
>
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list