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