Re: Transitioning live service from 10g to 11g
From: Jeremy <jeremy0505_at_gmail.com>
Date: Tue, 1 Mar 2011 12:14:59 -0000
Message-ID: <MPG.27d6f3a0a24a1bc19898b5_at_News.Individual.NET>
In article <2e2d49d8-e592-469a-96f4-8bc3a44f0272 _at_r13g2000yqk.googlegroups.com>, Mark.Powell2_at_hp.com says...
>
> On Feb 20, 7:52 am, Jeremy <jeremy0..._at_gmail.com> wrote:
> > Hi
> >
> > Just wanted to know if this was (coneceptually) feasible and supported
> > to get from 10gR2 to 11gR2:
> >
> > - build new 11g database
> > - export from 10g and do some sort of checkpoint
> > - import into 11g
> > - apply redo logs from the 10g database from the "checkpoint" time to
> > the 11g database whilst continuing to test the 11g environment before
> > turning off the 10g database.
> >
> > Can something like this be achieved?
> What about creating a new 11gR2 database. Set up replication for all
> tables so that you copy all the tables from the existing database to
> the new one and apply all updates via logging (either via replication
> or manual triggers).
>
> Once you have everything copied and have verified the updates are
> working you can shutdown the existing database then point the
> applications to the new one.
>
Is this available with Standard Edition? It is a nice idea.
Date: Tue, 1 Mar 2011 12:14:59 -0000
Message-ID: <MPG.27d6f3a0a24a1bc19898b5_at_News.Individual.NET>
In article <2e2d49d8-e592-469a-96f4-8bc3a44f0272 _at_r13g2000yqk.googlegroups.com>, Mark.Powell2_at_hp.com says...
>
> On Feb 20, 7:52 am, Jeremy <jeremy0..._at_gmail.com> wrote:
> > Hi
> >
> > Just wanted to know if this was (coneceptually) feasible and supported
> > to get from 10gR2 to 11gR2:
> >
> > - build new 11g database
> > - export from 10g and do some sort of checkpoint
> > - import into 11g
> > - apply redo logs from the 10g database from the "checkpoint" time to
> > the 11g database whilst continuing to test the 11g environment before
> > turning off the 10g database.
> >
> > Can something like this be achieved?
> What about creating a new 11gR2 database. Set up replication for all
> tables so that you copy all the tables from the existing database to
> the new one and apply all updates via logging (either via replication
> or manual triggers).
>
> Once you have everything copied and have verified the updates are
> working you can shutdown the existing database then point the
> applications to the new one.
>
Is this available with Standard Edition? It is a nice idea.
-- jeremyReceived on Tue Mar 01 2011 - 06:14:59 CST