Re: Informix 7.30 (I know!)
- From: "Keith Simmons" <smiley73@xxxxxxxxxxxxxx>
- Date: Wed, 30 May 2007 09:08:21 +0100
On 30/05/07, John Carlson <jwcarlson1@xxxxxxxxxxxxxxxxx> wrote:
On Tue, 29 May 2007 12:58:48 -0400, "navdeep virk" <nvirk@xxxxxxx>Navdeep
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@xxxxxxxx
http://www.iiug.org/mailman/listinfo/informix-list
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
.
- References:
- Re: Is IBM actually doing something with IDS?
- From: art . kagel
- Informix 7.30 (I know!)
- From: navdeep virk
- Re: Informix 7.30 (I know!)
- From: John Carlson
- Re: Is IBM actually doing something with IDS?
- Prev by Date: Re: Migration advise request SE or IDS Express
- Next by Date: Re: Cache connect to Oracle
- Previous by thread: Re: Informix 7.30 (I know!)
- Next by thread: Re: Is IBM actually doing something with IDS?
- Index(es):
Relevant Pages
|
