RMAN Duplicate with subset of data

  • From: "Mandal, Ashoke" <ashoke.k.mandal@xxxxxxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 23 Sep 2015 14:59:31 +0000

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

Other related posts: