RE: Deferred level 1 restore? [4152]
Unless you are on our system. My system is so busy, that the level 1's
don't finish. Even my level 0's have to run after hours (at night),
for them to finish within 24 hrs.
-----Original Message-----
From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]
On Behalf Of ART KAGEL, BLOOMBERG/ 731 LEXIN
Sent: 03 February 2005 03:31 PM
To: informix-list@iiug.org
Subject: RE: Deferred level 1 restore? [4152]
Yes you can do that. You can even do better than 3 hours downtime. If
you take
the level 1 live, without kicking the users, and restore it, then you
can kick
the users just long enough to apply the logical log file backups taken
after the
level 1 and put the users back on the new system. The logical log
restore of 3
hours' work should run well under an hour, especially if the logical
log copy
period is during a relatively low activity time!
Art S. Kagel
----- Original Message -----
From: Diane Lavoie <diane.lavoie@domtar.com>
At: 2/ 3 8:09
> Hi,
> We are also in the process of moving to new hardware. We are using the
HDR
> to do so.
> 1 - onbar Level-0 backup on primary
> 2 - onbar Level-0 restore on secondary
> 3 - activate HDR, the primary will send the logs to the secondary and
both
> db will be synchronized. We are doing this one week a head of the cut
over.
> 4 - at the time of the cut over, switch log on the primary and stop
the db.
> 5 - change the mode on the secondary to online. Interruption: few
minutes.
>
> We did the same when changing the SAN to HDS. It is fast, save, easy.
>
> Diane.
>
> -----Original Message-----
> From: Malcolm Per.... [mailto:malc_p@btinternet.com]
> Sent: Thursday, February 03, 2005 5:21 AM
> To: ids@iiug.org
> Subject: Deferred level 1 restore? [4147]
>
> Here's a good one.
> (IDS9.30, HP-UX 11i)
> We're moving to a different facility and new hardware (same basic
machine &
> OS) at the end of the month and in order to minimise the time taken to
> transfer our 180Gb instance and allow the users unfettered access up
to the
> very last minute (god we're so good to them) we'd like to do the
following
> using OnBar:
> 1) Run a level-0 backup on the Thursday night from the old production
server
> (currently this takes about 7 hours).
> 2) Restore this to the new server at the new facility (L0 restore time
at
> present is about 12 hours end-to-end).
> 3) Leave the new server in limbo while the users have continued access
to
> the old box.
> 4) Friday night kick the users and then take a level-1 of the old
production
> box - we've tested this and it takes about 2.5 hours.
> 5) Take this level 1 and restore it to the new box (which should take
about
> 3 hours) and let the users onto the new box. Thus the users should
lose only
> 3 hours instead of 12.
>
> Can we do this? From the OnBar guide it looks like we can't but our
scenario
> isn't covered.
> Sorry, we haven't had time to do a test run so we're after list wisdom
> (anyone called Obnoxio please pipe
> down!)
>
> Malc
> (Copying to cdi)
sending to informix-list
sending to informix-list