Re: RMAN Duplicate with subset of data
Date: Wed, 23 Sep 2015 09:10:47 -0600
Message-ID: <5602C0F7.7090903_at_gmail.com>
The appropriate 'official' tool from Oracle would be the Enterprise Manager Cloud Control 'Data Masking and Subsetting Pack'
There are many variants that you can grow on your own, and indeed the Pack automates Data Pump for the 'In-Export' variant of Subsetting.
/Hans
Disclaimer: The opinions expressed herein are my own, and do not
necessarily reflect the opinions of Oracle Corporation.
On 23/09/2015 8:59 AM, Mandal, Ashoke wrote:
>
> I have 4.5TB database and need to make copy of it to test environment.
> But I don’t need to bring all the data to the duplicated copy. The
> production database has data for last 20 years and I would like
> duplicate with last 5 years data.
>
> Is it possible to duplicate a database with a subset of the production
> data using RMAN duplicate feature?
>
> If not then what are the other options?
>
> Thanks,
>
> Ashoke Mandal
>
> [CONFIDENTIALITY AND PRIVACY NOTICE] - Applied from EOP Information
> transmitted by this email is proprietary to Medtronic and is intended
> for use only by the individual or entity to which it is addressed, and
> may contain information that is private, privileged, confidential or
> exempt from disclosure under applicable law. If you are not the
> intended recipient or it appears that this mail has been forwarded to
> you without proper authority, you are notified that any use or
> dissemination of this information in any manner is strictly
> prohibited. In such cases, please delete this mail from your records.
> To view this notice in other languages you can either select the
> following link or manually copy and paste the link into the address
> bar of a web browser: http://emaildisclaimer.medtronic.com
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Sep 23 2015 - 17:10:47 CEST