Re: Ontape: problem with restore from 0-archive - Log File not found
A user with a corrupt/unrestorable level-0 ontape archive (made by IDS 9.20.UC2 on SunOS 5.7) tried to extract data table-by-table using the newer archecker from IDS 10.00.FC3 on SunOS 5.9, but archecker failed immediately with "Failed tape page check / Failed tape header/sanity check". One reply suggested the 32-bit (UC) vs 64-bit (FC) mismatch was to blame; Art Kagel suggested restoring an earlier level-0 and rolling logical logs forward (not possible here, as the bad archive was the only data source) and noted page header formats changed in 9.40, while believing archecker was backward compatible. No resolution is recorded; the thread ends asking an IBM developer to comment.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
>======================================================
> One possibility, get and install the IDS10 demo version from IIUG.
> It contains the latest archecker version which can
> extract data from any archive (IB that it ignores the versioning on
> the tapes) and can use SQL to insert the data it finds
> into tables in an existing DB. If that works for you you can extract
> the data, table by table, from the tape and restore to
> an empty database.
>=======================================================
Archecker can not read our archive tape (we try phys restore for
single
table: "archecker -tv ...").
It writes to log just after opening tape file:
. . .
ERROR: Failed tape page check.
ERROR: Failed tape header/sanity check.
. . .
Archive tape is created with "ontape -s -L 0" (IDS 9.20.UC2, SunOS
5.7).
We try to read archive with archecker on IDS 10.00.FC3, SunOS 5.9.
Can I read ontape files from IDS 9.20.UC2 on IDS 10.00.FC3?
On 03/07/07, vkubr@yandex.ru <vkubr@yandex.ru> wrote:
> >======================================================
> > One possibility, get and install the IDS10 demo version from IIUG.
> > It contains the latest archecker version which can
> > extract data from any archive (IB that it ignores the versioning on
> > the tapes) and can use SQL to insert the data it finds
> > into tables in an existing DB. If that works for you you can extract
> > the data, table by table, from the tape and restore to
> > an empty database.
> >=======================================================
>
> Archecker can not read our archive tape (we try phys restore for
> single
> table: "archecker -tv ...").
> It writes to log just after opening tape file:
> . . .
> ERROR: Failed tape page check.
> ERROR: Failed tape header/sanity check.
> . . .
>
> Archive tape is created with "ontape -s -L 0" (IDS 9.20.UC2, SunOS
> 5.7).
>
> We try to read archive with archecker on IDS 10.00.FC3, SunOS 5.9.
>
> Can I read ontape files from IDS 9.20.UC2 on IDS 10.00.FC3?
>
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
>
You are trying to read a tape produced by a 32 bit application (UC)
running on a 32 bit O/S into a 64 bit app (FC) running on a 64bit OS.
You may have a problemette or two !!
Keith
>================================================== > You are trying to read a tape produced by a 32 bit application (UC) > running on a 32 bit O/S into a 64 bit app (FC) running on a 64bit OS. > You may have a problemette or two !! >===================================== Is this the main cause? Now we try archecker-restore on remote host (64-bit SunOS 5.9) We plan to upgrade our host from IDS.9.20 to IDS.10.00 and from SunOS 5.7 to SunOS 5.8 (because IDS10 does not work on 5.7). And we want to check does such restore work at all.
On Jul 3, 10:32 am, v...@yandex.ru wrote: > >================================================== > > You are trying to read a tape produced by a 32 bit application (UC) > > running on a 32 bit O/S into a 64 bit app (FC) running on a 64bit OS. > > You may have a problemette or two !! > >===================================== > > Is this the main cause? > Now we try archecker-restore on remote host (64-bit SunOS 5.9) > > We plan to upgrade our host from IDS.9.20 to IDS.10.00 and from > SunOS 5.7 to SunOS 5.8 (because IDS10 does not work on 5.7). And > we want to check does such restore work at all. Hmm, do you HAPPEN to have the PREVIOUS level 0 archive tape(s)? If so you can restore that one and roll forward all of the logical logs to the present. Slow but it should work. Art S. Kagel
On Jul 3, 11:19 pm, "Art S. Kagel" <art.ka...@gmail.com> wrote: > On Jul 3, 10:32 am, v...@yandex.ru wrote: > > > >================================================== > > > You are trying to read a tape produced by a 32 bit application (UC) > > > running on a 32 bit O/S into a 64 bit app (FC) running on a 64bit OS. > > > You may have a problemette or two !! > > >===================================== > > > Is this the main cause? > > Now we try archecker-restore on remote host (64-bit SunOS 5.9) > > > We plan to upgrade our host from IDS.9.20 to IDS.10.00 and from > > SunOS 5.7 to SunOS 5.8 (because IDS10 does not work on 5.7). And > > we want to check does such restore work at all. > > Hmm, do you HAPPEN to have the PREVIOUS level 0 archive tape(s)? > > If so you can restore that one and roll forward all of the logical > logs to the present. Slow but it should work. > > Art S. Kagel >=============================================== It is clear. We know about varios possible ways... But in this case the 'defective' 0-archive is the only source of data we try to restore. -- - - Do any compatability problems with tape files exist in 9.20 and 10.00 versions? Vadim Kubrak
On Jul 3, 4:45 pm, v...@yandex.ru wrote: > On Jul 3, 11:19 pm, "Art S. Kagel" <art.ka...@gmail.com> wrote: > > > > > On Jul 3, 10:32 am, v...@yandex.ru wrote: > > > > >================================================== > > > > You are trying to read a tape produced by a 32 bit application (UC) > > > > running on a 32 bit O/S into a 64 bit app (FC) running on a 64bit OS. > > > > You may have a problemette or two !! > > > >===================================== > > > > Is this the main cause? > > > Now we try archecker-restore on remote host (64-bit SunOS 5.9) > > > > We plan to upgrade our host from IDS.9.20 to IDS.10.00 and from > > > SunOS 5.7 to SunOS 5.8 (because IDS10 does not work on 5.7). And > > > we want to check does such restore work at all. > > > Hmm, do you HAPPEN to have the PREVIOUS level 0 archive tape(s)? > > > If so you can restore that one and roll forward all of the logical > > logs to the present. Slow but it should work. > > > Art S. Kagel > >=============================================== > > It is clear. We know about varios possible ways... > But in this case the 'defective' 0-archive is the only source of > data > we try to restore. > -- - - > Do any compatability problems with tape files exist in 9.20 and > 10.00 versions? > > Vadim Kubrak There may have been changes. Certainly the page header format changed in 9.40 to support large chunks. I always thought that archecker was backward compatible. Is John Miller online? John can you help these folk? Art S. Kagel