Re: Transitioning live service from 10g to 11g

From: onedbguru <>
Date: Mon, 21 Feb 2011 05:57:48 -0800 (PST)
Message-ID: <>

On Feb 20, 7:52 am, Jeremy <> 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 The problem is that it would take many hrs to convert a tiny 100G database. You will need to test using 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 Received on Mon Feb 21 2011 - 07:57:48 CST

Original text of this message