Applying logical logs after level 0 restored
A user restored a level 0 archive on Informix 7.13 (HP-UX) but didn't apply the logical logs during the restore, and asked how to apply them afterwards -- also hoping to use daily log backups to keep a development box in sync with production. The answer: once the restore finishes and the server is online, logs can't be applied; the only option is to redo the restore and include the logs when prompted. Standalone/continuous log restore (warm standby style) wasn't available until IDS 11.10, so upgrading was recommended; one poster described achieving it on older versions only via complex custom scripts that keep the server permanently in restore mode (and thus unusable).
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi Everyone, I just restored the complete level 0 backup of informix 7.13 on hp-ux 10.01 in our development environment. At the end of restore, I didn't forget apply logical logs to the database. can anyone advise me to apply the logical logs on the database that I restored? Please help. Best Regards Deepak
On 6 May 2010 13:13, DEEPAK JOSHI <djoshih@hotmail.com> wrote: > Hi Everyone, > > I just restored the complete level 0 backup of informix 7.13 on hp-ux 10.01 in > our development environment. At the end of restore, I didn't forget apply > logical logs to the database. > > can anyone advise me to apply the logical logs on the database that I > restored? > > Please help. > > Best Regards > Deepak > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > Once the restore has ended and the database is online it is not possible to apply any logs. Your only choice is to start the restore again and do not forget the logs this time !!!
Your post is confused. If you did NOT apply the logical logs at the time of
the restore, then under IDS 7.13 your only recourse is to perform the
restore again remembering to restore the logical logs when ontape or onbar
asks for them. You cannot restore logical logs independent of an archive
restore prior to IDS 11.10 IB.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
IIUG Board of Directors (art@iiug.org)
See you at the 2010 IIUG Informix Conference
April 25-28, 2010
Overland Park (Kansas City), KS
www.iiug.org/conf
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference. Neither do those opinions reflect those of other individuals
affiliated with any entity with which I am affiliated nor those of the
entities themselves.
On Thu, May 6, 2010 at 8:13 AM, DEEPAK JOSHI <djoshih@hotmail.com> wrote:
> Hi Everyone,
>
> I just restored the complete level 0 backup of informix 7.13 on hp-ux 10.01
> in
> our development environment. At the end of restore, I didn't forget apply
> logical logs to the database.
>
> can anyone advise me to apply the logical logs on the database that I
> restored?
>
> Please help.
>
> Best Regards
> Deepak
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001636e0a6e961a4330485eca15f
Thx Keith,
I had a question.
I restored development box from production level 0 backup on 05/01/2010.
We want a synchronization of our production environment to a development? Is
there any way that we can do this in version 7.13?
We thought to apply logical logs to development box everyday for
synchronization because we are taking logical logs backup everyday in our
production environment using
ontape -c.
Can't we apply these logical logs to a development environment for
synchronization?
Can't we apply logical logs separately without level 0 restore? Is this the
limitation of version 7.13 we are using here?
Please advise.
Thx,
In IDS 11.10 and later versions you can create a warm backup server by
restoring the server using an archive from the primary then start a
continuous logical log restore and restore each logical log file or set of
logical log files brought over from the primary as they complete and are
archived (works best with ontape -a from a cron or from the ALARMPROGRAM to
backup each log as it completes). There is a facility to stop the restore
and restart it later, but only if the engine is kept in recovery mode. Once
the engine is online it is assumed to no longer be compatible with the
logical logs you would restore.
At any rate, in way back in IDS 7.13 in 1995 this feature was not even a
gleam in its father's eye.
I know you've been told this before, and I know there are reasons why you
are still on 7.13, but, all that aside, you REALLY need to upgrade to a
current release. Say... 11.50xC6W3 or later.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
IIUG Board of Directors (art@iiug.org)
See you at the 2010 IIUG Informix Conference
April 25-28, 2010
Overland Park (Kansas City), KS
www.iiug.org/conf
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference. Neither do those opinions reflect those of other individuals
affiliated with any entity with which I am affiliated nor those of the
entities themselves.
On Thu, May 6, 2010 at 9:16 AM, DEEPAK JOSHI <djoshih@hotmail.com> wrote:
> Thx Keith,
>
> I had a question.
>
> I restored development box from production level 0 backup on 05/01/2010.
>
> We want a synchronization of our production environment to a development?
> Is
> there any way that we can do this in version 7.13?
>
> We thought to apply logical logs to development box everyday for
> synchronization because we are taking logical logs backup everyday in our
> production environment using
> ontape -c.>
> Can't we apply these logical logs to a development environment for
> synchronization?
>
> Can't we apply logical logs separately without level 0 restore? Is this the
> limitation of version 7.13 we are using here?
>
> Please advise.
>
> Thx,
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001636e909e6c9f98b0485ecde04
the other posters are correct, you can't do it. perhaps you could, if you come up with a complex series of home-grown scripts to hold the development server in continous logical log restore. we did this at one of my previous jobs. we modified the alarmprogram to backup only after 5 logs were full, then we bundled the logs, zipped them up, ftp'd them to another site where an expect script was constantly running, watching for files to show up... then they showed up, the expect script fed the logs to the constantly running/waiting informix restore. it was complex but it worked. of course this means the development server would not be accessible at all since it is in constant restore. probably easier to upgrade to a supported version that has this type of feature built in as others have indicated.