Re: Populate new 12c database

It can be done with RMAN, do an initial incremental level 0, restore it on your destination, then instead of opening the database take daily incrementals from your source db and apply it to your destination. When you are ready, open your new database resetlogs upgrade, and run catupgrde.sql to complete the upgrade. Obviously you would need to rehearse it a few times, but its a fairly straightforward process.

On Tue, Feb 7, 2017 at 1:01 PM, Rich J <rjoralist3_at_society.servebeer.com> wrote:

> On 2017/02/07 10:32, Michael Calisi wrote:
>
> The database I am currently running is on 11.2.0.4.0. We went and build a
> new 12c database on a different node.
>
> I am now looking to populate my new 12c database with my 11 database data.
> What's the best method with limited downtime? I was thinking of using
> RMAN but not sure that's possible. We are not looking to do a traditional
> exp/imp pump it will take to long and the database is over 5TB.
>
>
>
> One way is to get a term license (e.g. 1-year, instead of perpetual) of
> Goldengate. The only downtime that may be required is the switch over to
> the new DB, IIRC.
>
> Oracle has free 1-day hands-on workshops to show you how to upgrade,
> coming to a town (hopefully) near you:
>
> https://blogs.oracle.com/UPGRADE/entry/upgrade_workshops_early_2017_in
>
> HTH! GL!
> Rich
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

--
http://www.freelists.org/webpage/oracle-l