Re: Transitioning live service from 10g to 11g
From: joel garry <joel-garry_at_home.com>
Date: Tue, 1 Mar 2011 09:29:30 -0800 (PST)
Message-ID: <a3e2bdf1-d36a-4e1f-8855-1ee036aa457a_at_d26g2000prn.googlegroups.com>
On Mar 1, 4:14 am, Jeremy <jeremy0..._at_gmail.com> wrote:
> In article <2e2d49d8-e592-469a-96f4-8bc3a44f0272
> _at_r13g2000yqk.googlegroups.com>, Mark.Powe..._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 09:29:30 -0800 (PST)
Message-ID: <a3e2bdf1-d36a-4e1f-8855-1ee036aa457a_at_d26g2000prn.googlegroups.com>
On Mar 1, 4:14 am, Jeremy <jeremy0..._at_gmail.com> wrote:
> In article <2e2d49d8-e592-469a-96f4-8bc3a44f0272
> _at_r13g2000yqk.googlegroups.com>, Mark.Powe..._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.
>
http://download.oracle.com/docs/cd/E11882_01/license.112/e10594/editions.htm#CJACGHEB
jg
-- _at_home.com is bogus. http://www.signonsandiego.com/news/2011/feb/28/qualcomm-names-winner-of-qprize/Received on Tue Mar 01 2011 - 11:29:30 CST