RE: RMAN Duplicate with subset of data

it is not mandatory to specify SYS, SYSAUX and UNDO tablespaces. I usually do duplicate only with one user tablespace specified and other tablespaces are restored automatically. Moreover rman performs tablespace dependency check. If check failed then RMAN-05548: The set of duplicated tablespaces is not self-contained error occurred.

Marian

From: Gary Gruber <GGruber_at_rpmdirectllc.com> To: "ashoke.k.mandal_at_medtronic.com" <ashoke.k.mandal_at_medtronic.com>, "bednar_at_nbs.sk" <bednar_at_nbs.sk>, "oracle-l_at_freelists.org" <oracle-l_at_freelists.org>,
Date: 23. 09. 2015 20:45
Subject: RE: RMAN Duplicate with subset of data

Ashoke,  

You may alternatively specify only the tablespaces you wish to duplicate. However, you must be careful to include several required tablespaces:  

·        Undo tablespace
·        System default tablespace
·        Any tablespaces containing segments owned by sys, system, other 
Oracle internal schemas
·        Any tablespaces containing materialized views
 

You’ll also have to be careful to recover tablespaces that have interdependencies just as you would for a transportable tablespace export.  

duplicate target database to AUX01

    tablespace ADMIN_DATA

,SYSAUX
,SYSTEM
,SYS_AUDITING
,UNDO_TS_2
,USERDATA_1

               ,…and so on      

Gary Gruber
RPM Direct
www.rpmdirectllc.com  

This email including, without limitation, the attachments, if any, accompanying this email, may contain information which is confidential or privileged and exempt from disclosure under applicable law. The information is for the use of the intended recipient. If you are not the intended recipient, be aware that any disclosure, copying, distribution, review or use of the contents of this email, and/or its attachments, is without authorization and is prohibited. If you have received this email in error, please notify us by reply email immediately and destroy all copies of this email and its attachments.    

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mandal, Ashoke
Sent: Wednesday, September 23, 2015 11:42 AM To: bednar_at_nbs.sk; oracle-l_at_freelists.org Subject: RE: RMAN Duplicate with subset of data  

Hi Marian,  

My database tables are partioned by month but I have too many tablespaces to specify in the skip list. Is there any limit on skipped tablespaces count as I have 360-400 tablespaces to skip. DUPLICATE TARGET DATABASE TO dupdb SKIP TABLESPACE <tablespace1>, <tablespace2> ….;  

Thanks,
Ashoke  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Marian Bednar
Sent: Wednesday, September 23, 2015 10:21 AM To: oracle-l_at_freelists.org
Subject: Re: RMAN Duplicate with subset of data  

With duplicate is it possible only when old data are in different tablespaces.
Then duplicate command you can use with tablespace parameter.

Regards,
Marian

From:        "Mandal, Ashoke" <ashoke.k.mandal_at_medtronic.com> 
To:        oracle-l <oracle-l_at_freelists.org>, 
Date:        23. 09. 2015 17:00 
Subject:        RMAN Duplicate with subset of data 
Sent by:        oracle-l-bounce_at_freelists.org 

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-l