Re: DB Merge Ideas?

From: amihay gonen <agonenil_at_gmail.com>
Date: Thu, 18 Dec 2014 08:46:36 +0200
Message-ID: <CAKb+SBVJynBjQWGiT=Wfq+rm7mGh8=if1r952-+opnzsQD2WbA_at_mail.gmail.com>

Use pdb
On 18 Dec 2014 01:51, "Michael Cunningham" <napacunningham_at_gmail.com> wrote:

> Hello list,
>
> We have 16 similar instances that we want to merge into a single
> instance. I'm looking for input on the best method. Below is all I could
> think of to help.
>
> Oracle 12.1.0.1 on Linux
> All instances exist on the same server.
> ASM is being used. Currently one diskgroup for all instances.
> No tables have the same name.
> The tablespaces that matter do not have the same name between databases
> (one db is TBS0, another is TBS1, and so on).
> Each is around 500GB (5.5TB total).
> We do not have golden gate license.
>
> Any thoughts?
>
> I'm thinking of transportable tablespaces, but I'm looking for other
> input. I need to minimize downtime.
>
>
> --
> Michael Cunningham
>

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

Received on Thu Dec 18 2014 - 07:46:36 CET