Informix 43258 error onbar logical restore
Amit Patel got errors 43258 and 43168 on onbar -r -l after a physical restore. Art Kagel and David Williams suggested checking whether the logical log was backed up by the storage manager, via the ixbar file. Amit found he had opened a new session without exporting environment variables; rerunning onbar -r -l -n with them completed the restore. Solved.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hello All.
I ran onbar -r -p to restore the database which rab successfully. But after running onbar -r -l (Logical Restore) I got 43258 and 43168 error.
Please let me know how to overcome from this issue and run the restore successfully.
current Informix and OS version:
Online.log
bar_act.log
Kindly suggest.
------------------------------
AMIT PATEL
------------------------------
Amit:
See the message log output (onstat -m) that you posted. Netbackup says that it was not used to back up the logical log that is being requested. Is it possible that ontape was used to backup the logs instead of onbar?
Art
------------------------------
Art S. Kagel, President and Principal Consultant
ASK Database Management Corp.
www.askdbmgt.com
------------------------------
Hello Art,
Thanks for replying. Here we are using onbar only. Only the thing is that we used June 23rd backup to restore the data instead of June 24.
And June 23rd data was also backed up successfully.
Regards
Amit Patel
------------------------------
AMIT PATEL
------------------------------
Hi, Check the ixbar file https://www.ibm.com/docs/en/informix-servers/14.10.0?topic=components-ixbar-file-bar-emergency-boot-file Is there a logical log backup for that logical log in the ixbar file? Use copyid hi and lo to check with the storage manager if that object was backed up and if it is still accessible. Regards, David. ------------------------------ David Williams Senior Database Platform Engineer Flutter London ------------------------------
Hello All,
Apologies
. I made the mistake. I started the restoration and during Logical restore I opened the new session and forgot to export the environment variables.
Later I ran onbar -r -l -n <log number> with exporting env variables and Restoration completed.
Thanks for your responses.
------------------------------
AMIT PATEL
------------------------------