Re: Database migration options

From: Chris Taylor <christopherdtaylor1994_at_gmail.com>
Date: Wed, 21 Mar 2018 21:00:12 -0500
Message-ID: <CAP79kiTwsQ6qVMr8fookM2jUOni7fv_Sm3wENAaVMYY8ar-dTg_at_mail.gmail.com>



Datapump can subset data - you provide a query to DataPump to pull out the data you want to export and import into the new database.

You could at least do a POC (Proof of Concept) of datapump to see how what that can get you . You can use parallel on the datapump to speed things up a lot.

You could combine Datapump subsetting and GoldenGate I think - subset your data and use Golden Gate to sync up the SCNs (CSNs in GoldenGate) to keep the new data up to date if I'm not terribly mistaken.

Chris

On Wed, Mar 21, 2018 at 7:50 PM, Chen Zhou <oracle.unknowns_at_gmail.com> wrote:

> Hi,
> Our company needs to migrate some databases to new servers.
> However we don't want to migrate the whole databases, which have years of
> old data. Rather, we want to select some newer data from some tables and
> only carry these over to the new databases.
> Export and import will take too long due to the large sizes of our
> databases.
> Physical Standby won't work. Is logical standby an option here?
> I am also considering using GoldenGate.
> Are there other options?
> Thank you,
> Chen
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 22 2018 - 03:00:12 CET

Original text of this message