I've a problem with an Informix 7.5 on Aix 4.3.3, I've re-initialized the
system with an oninit -ivy and only after I've discovered that no one have
made backups... Now, I'm thinking to recover the state using an old backup
(no data, only dbs definitions) but I've no logs archived.
I'm trying to recover only the rootdbs thru the ontape utility, but it
leaves the db in recovery state, on the manual it's written that it will
remain in that state until a logical restore (I've no logical logs
backup...).

Please help me, what I can do to bring it on line?


P.S: Meanwhile, the db is now in quiescent mode, but only a dbspace seems
available an the onstat -d reports only 53 pages used...

I really need help!




"I told you to make weapons, Taim. Show me just how deadly they are.
Disperse the Shaido. Break them." - Rand Al'Thor, Car'a'carn, The Dragon
Reborn.

On Tue, 07 Oct 2003 06:17:38 -0400, Laverio wrote:

Laverio:

If you have a C compiler you can use my dbsup and chunkup utilities to mark the
dbspaces and chunks to online status. HOWEVER, there is no such version as 7.5
and you must know your proper version to successfully run the dbsup utility.
Since you did not post a real address, email me for a copy.

Run either utility without args to see Usage. The last argument is 1 for the
first copy of the main chunk or dbspace page, 2 for the second copy (you have to
do both), 3 for the first copy of the mirror chunk page if any and 4 for the
second copy of the mirror chunk page (there are no mirror dbspace pages). If
the chunk or dbspace table is longer than a single page the header output by
dbsup and/or chunkup will tell you the offset to use to update the next page in
the chain, if that offset is zero then either there are no more pages or the
offset is the next sequential number (know that after the primary page the next
offset is usually 14 or something similar).

The [-5|-6|-7|-73|-92] option to dbsup specifies the IDS version as the format
for the dbspace table has changed from version to version. Use -7 for all 7.xx
releases prior to 7.30, use -73 for all 7.3x releases and for 9.xx releases
prior to 9.20. These utilities have not been updated for 9.4 and so should not
be used.

Each run creates a binary copy of the modified page which you can restore using
dd if needed. Of course you should take a safety archive using ontape or onbar
in general before using an invasive utility like these, and you are on your own
if it does not work. On the other hand you are out of business now, so...

Art S. Kagel

> I've a problem with an Informix 7.5 on Aix 4.3.3, I've re-initialized the
> system with an oninit -ivy and only after I've discovered that no one have
> made backups... Now, I'm thinking to recover the state using an old backup (no
> data, only dbs definitions) but I've no logs archived. I'm trying to recover
> only the rootdbs thru the ontape utility, but it leaves the db in recovery
> state, on the manual it's written that it will remain in that state until a
> logical restore (I've no logical logs backup...).
>
> Please help me, what I can do to bring it on line?
>
>
> P.S: Meanwhile, the db is now in quiescent mode, but only a dbspace seems
> available an the onstat -d reports only 53 pages used...
>
> I really need help!
>
>
>
>
> "I told you to make weapons, Taim. Show me just how deadly they are. Disperse
> the Shaido. Break them." - Rand Al'Thor, Car'a'carn, The Dragon Reborn.