Re: Transitioning live service from 10g to 11g
From: onedbguru <onedbguru_at_yahoo.com>
Date: Mon, 21 Feb 2011 05:57:48 -0800 (PST)
Message-ID: <34118db8-b719-43ef-899c-b6a2c80c9210_at_l14g2000pre.googlegroups.com>
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?
>
> --
> jeremy
Date: Mon, 21 Feb 2011 05:57:48 -0800 (PST)
Message-ID: <34118db8-b719-43ef-899c-b6a2c80c9210_at_l14g2000pre.googlegroups.com>
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?
>
> --
> jeremy
You cannot apply redo logs from the 10g db to the "new" 11g database. Be aware that there were some problems just "upgrading" a 10g db to 11gR2 - but, I believe that was fixed if you go directly to 11.2.0.2. The problem is that it would take many hrs to convert a tiny 100G database. You will need to test using 11.2.0.2 to see if this is still true.
What you "might" be able to do is use LOGMINER and apply any of those
changes - look at
http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10825/logminer.htm#i1017514
Received on Mon Feb 21 2011 - 07:57:48 CST