Re: Transitioning live service from 10g to 11g

From: Jeremy <jeremy0505_at_gmail.com>
Date: Tue, 1 Mar 2011 21:28:27 -0000
Message-ID: <MPG.27d7755945606ae99898b7_at_News.Individual.NET>



In article <a3e2bdf1-d36a-4e1f-8855-
1ee036aa457a_at_d26g2000prn.googlegroups.com>, joel-garry_at_home.com says...
>
> 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
>

"Basic replication" - looks good.
-- 
jeremy
K1200S
Received on Tue Mar 01 2011 - 15:28:27 CST

Original text of this message