Re: 19c database duplication

From: Ghassan Salem <salem.ghassan_at_gmail.com>
Date: Tue, 3 Mar 2020 21:15:16 +0100
Message-ID: <CALEzEShh-rgmr+KZzF9Ge0TNKEPLRNC=qcYGYsQv5ufjftfFQA_at_mail.gmail.com>



You can either clone from the active database (very much similar to rman's duplicate from active, but way easier), or restore from a backup, see here <https://docs.oracle.com/en/database/oracle/oracle-database/20/bradv/rman-duplicating-databases.html#GUID-9E630E2C-3D1B-4594-B738-4B5B43E50C58>

On Tue, Mar 3, 2020 at 8:27 PM Jeffrey Beckstrom <jbeckstrom_at_gcrta.org> wrote:

> But isn't that reading the datafile's directly? What if we do not want to
> use the current database but rather a prior backup?
> >>> Ghassan Salem <salem.ghassan_at_gmail.com> 3/3/20 2:23 PM >>>
> You just clone the pdb, via create pluggable database xyz from
> pdb1_at_sourcedb. It will copy db files and then 'recover' them by itself.
>
> Regards
>
> On Tue, Mar 3, 2020, 19:36 Jeffrey Beckstrom <jbeckstrom_at_gcrta.org> wrote:
>
>> If I have:
>> source CDBS
>> PDB1
>> PDB2
>> PDB3
>>
>> Target CDBT
>> PDB4
>> PDB5
>>
>> If I want to clone PDB1 from CDBS to CDBT, it is my understanding that I
>> need to use active duplication so that I do not lose PDB4 and PDB5. Is that
>> correct? Also, active duplication only reads the source database's
>> datafiles not the backupsets, is that correct as well.
>>
>> Jeffrey Beckstrom
>> Lead Database Administrator
>> Information Technology Department
>> Greater Cleveland Regional Transit Authority
>> 1240 W. 6th Street
>> Cleveland, Ohio 44113
>>
>>
>
> ------------------------------
> This email has been scanned for spam and viruses. Click here
> <https://attseg.cloud-protect.net/index01.php?mod_id=11&mod_option=logitem&mail_id=1583263433-BRrVmkHmojhn&r_address=jbeckstrom%40gcrta.org&report=1>
> to report this email as spam.
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Mar 03 2020 - 21:15:16 CET

Original text of this message