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

On Feb 20, 7:52*am, Jeremy <jeremy0... (AT) gmail (DOT) com> wrote:
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/do...r.htm#i1017514

On Feb 20, 7:52*am, Jeremy <jeremy0... (AT) gmail (DOT) com> wrote:
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.

HTH -- Mark D Powell --

In article <2e2d49d8-e592-469a-96f4-8bc3a44f0272
@r13g2000yqk.googlegroups.com>, Mark.Powell2 (AT) hp (DOT) com says...

--
jeremy

On Mar 1, 4:14*am, Jeremy <jeremy0... (AT) gmail (DOT) com> wrote:
http://download.oracle.com/docs/cd/E...s.htm#CJACGHEB

jg
--
@home.com is bogus.
http://www.signonsandiego.com/news/2...ner-of-qprize/

In article <a3e2bdf1-d36a-4e1f-8855-
1ee036aa457a (AT) d26g2000prn (DOT) googlegroups.com>, joel-garry (AT) home (DOT) com says...

--
jeremy
K1200S