Re: Informix 7.30 (I know!)
On Tue, 29 May 2007 12:58:48 -0400, "navdeep virk" <nvirk@msn.com> wrote: >We have a need to migrate the database from a running Production server on >to a Pre Production machine which will eventually replace the Production >Machine. This is a Transaction Processing system so we want the migration to >happen without any downtime. > >We plan to take level "0" back from the Old box , restore to the new box and >then apply the delta using scripts( Unload /load) to bring the data in sync. > >Is there a way by which after we have taken a level "0" backup , we can then >take another backup of whatever changed after level "0" and apply that to >database using some informix utility.I am not sure if a Level "1" will do >the job as while the Level "1" is being restored we will have a down time. > >NSV > Ew . . . ancient! Anyway, as far as I know, the only way a level 1 can be applied is if there was a level 0 immediately preceeding. We moved Informix to new hardware last year and used HDR to handle the data migration. Wasn't "no downtime", but the total downtime was very minimal . . . . Not sure if you could do that with 7.30, though. JWC
On 30/05/07, John Carlson <jwcarlson1@yahoo.com.invalid> wrote: > On Tue, 29 May 2007 12:58:48 -0400, "navdeep virk" <nvirk@msn.com> > wrote: > > >We have a need to migrate the database from a running Production server on > >to a Pre Production machine which will eventually replace the Production > >Machine. This is a Transaction Processing system so we want the migration to > >happen without any downtime. > > > >We plan to take level "0" back from the Old box , restore to the new box and > >then apply the delta using scripts( Unload /load) to bring the data in sync. > > > >Is there a way by which after we have taken a level "0" backup , we can then > >take another backup of whatever changed after level "0" and apply that to > >database using some informix utility.I am not sure if a Level "1" will do > >the job as while the Level "1" is being restored we will have a down time. > > > >NSV > > > > Ew . . . ancient! > > Anyway, as far as I know, the only way a level 1 can be applied is if > there was a level 0 immediately preceeding. > > We moved Informix to new hardware last year and used HDR to handle the > data migration. Wasn't "no downtime", but the total downtime was very > minimal . . . . > > Not sure if you could do that with 7.30, though. > > JWC > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > Navdeep How are you preserving your logical logs? The simplest way is to restore your level 0 archive followed by rolling forward the logs to bring you up to the current point in time. Of course you need to have the same version of IDS (7.30) running on similar hardware and O/S. You can then run through an upgrade path to (I think) 7.31 then 10.0. This may not give you the most efficient final database afetr all the structure changes. Can you get no downtime at all (not even 22:00 on Saturday night for 8 hours !!). An unload to text files followed by reload to a new instance (IDS 10 ?) would be by far the best way forward. How large is your database? Keith