RE: Restoring a level-1 backup at a later date?
That doesn't sound right...
You should be able to do that with onbar without hacking the ixbar.
Informix wouldn't leave you in the wind like that....
Art?
Martin?
JL?
....
-----Original Message-----
From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]
On Behalf Of Neil Truby
Sent: Thursday, February 03, 2005 5:43 AM
To: informix-list@iiug.org
Subject: Re: Restoring a level-1 backup at a later date?
<malc_p@btinternet.com> wrote in message
news:1107429166.336614.266270@l41g2000cwc.googlegroups.com...
> Not sure we can tell it there's a level-1 to come - that's held in the
> ixbar file isn't it? So the level-0 would just exit to fast recovery
> without asking for a level-1 unless we can hack the ixbar.........
ugh.
ontape! ontape!
============================================================
The information contained in this message may be privileged
and confidential and protected from disclosure. If the reader
of this message is not the intended recipient, or an employee
or agent responsible for delivering this message to the
intended recipient, you are hereby notified that any reproduction,
dissemination or distribution of this communication is strictly
prohibited. If you have received this communication in error,
please notify us immediately by replying to the message and
deleting it from your computer. Thank you. Tellabs
============================================================
sending to informix-list
Sebastian, Norma J. wrote:
> That doesn't sound right...
> You should be able to do that with onbar without hacking the ixbar.
> Informix wouldn't leave you in the wind like that....
>
> Art?
> Martin?
> JL?
> ....
>
>
>
>
> -----Original Message-----
> From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]
> On Behalf Of Neil Truby
> Sent: Thursday, February 03, 2005 5:43 AM
> To: informix-list@iiug.org
> Subject: Re: Restoring a level-1 backup at a later date?
>
> <malc_p@btinternet.com> wrote in message
> news:1107429166.336614.266270@l41g2000cwc.googlegroups.com...
>
>>Not sure we can tell it there's a level-1 to come - that's held in the
>
>
>>ixbar file isn't it? So the level-0 would just exit to fast recovery
>>without asking for a level-1 unless we can hack the ixbar.........
>
> ugh.
>
> ontape! ontape!
> ============================================================
>
You are looking to achieve perpertual roll-forward using onbar :)
This can be done, but it is a "cheat" and one that is not supported ...
no doubt, in that you have to issue an onbar -r -l to a logical log that
is not present yet :D
So ...
onbar -r -p
Physical restore completes (with no logical log salvage which is
important in this scenario)
ixbar has the last logical log entry as, say, 10 ...
onbar -r -l 11
Check in the bar_act.log file and you will see "logical restore
suspended ...
Then when you have log 11 available, and the entry is in the ixbar file,
you can then either continue the perpertual rollforward by issuing
onbar -r -l 12
OR you can complete the logical recovery by issuing
onbar -r -l 11
Still ... don't believe me, believe the pudding (The Big Pudding)