RE: Duplicating a PDB to an existing CDB at a point in time in the recent past

From: Scott Canaan <srcdco@xxxxxxx>
To: "steve.wales@xxxxxxxxxxxxx" <steve.wales@xxxxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
Date: Mon, 1 Jun 2020 18:11:25 +0000

Check out this page for examples of PITR of a single pdb:

https://oracle-base.com/articles/12c/multitenant-rman-backup-recovery-cdb-and-pdb-12cr1#pdb-pitr-recovery

Scott Canaan '88
Sr Database Administrator
Information & Technology Services
Finance & Administration
Rochester Institute of Technology
o: (585) 475-7886 | f: (585) 475-7520
srcdco@xxxxxxx<mailto:srcdco@xxxxxxx> | c: (585) 339-8659

CONFIDENTIALITY NOTE: The information transmitted, including attachments, is
intended only for the person(s) or entity to which it is addressed and may
contain confidential and/or privileged material. Any review, retransmission,
dissemination or other use of, or taking of any action in reliance upon this
information by persons or entities other than the intended recipient is
prohibited. If you received this in error, please contact the sender and
destroy any copies of this information.

From: oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> On Behalf
Of Steve Wales (AddOns)
Sent: Monday, June 1, 2020 1:58 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Duplicating a PDB to an existing CDB at a point in time in the recent
past

Let's say I have a CDB with 3 PDB's.
Something happens yesterday, a bug, an erroneous update, whatever and I need to
restore just ONE of my PDB's to yesterday at noon to test or dev for
troubleshooting.

I am not sure how I restore just the ONE PDB to yesterday at 11:59 so I can see
the data as it existed at that time.

I am aware of several different means of transferring data from Prod to Test
but none of them go back 24 hours (that I'm aware of).

1) Export Prod / Import to Test (good for current data, not for yesterday)
2) Duplicate the PDB over a database link (this is current data, not yesterday)
3) Restore the whole CDB to another database, unplug the PDB you want, plug it
into test (this blows my mind, that means I need to provision double the disk
space just for this process).

So, short of doubling disk allocation to the server to perform #3, is there any
other way to duplicate a PDB from Prod to test to a point in time in the past.

I have been reading all I can find in the Documentation and notes at Oracle
Support but I'm not finding any ideas here with a clear example.

I have raised an SR with Support, but the engineer I'm working with isn't
giving me a lot of information and what I am getting back are short one
sentence answers.

I have seen some pages on assorted sites like:

https://oracle-base.com/articles/12c/recovery-manager-rman-database-duplication-enhancements-12cr1
https://oracle-base.com/articles/18c/multitenant-duplicate-a-pdb-to-an-existing-cdb-18c

Oracle Documentation on this is here:
https://docs.oracle.com/en/database/oracle/oracle-database/18/bradv/rman-duplicating-databases.html#GUID-23205E75-CFA8-4BCE-AC50-3D39DF040512

Maybe I'm misunderstanding what "FROM ACTIVE DATABASE" is meaning here. Can
you combine UNTIL TIME or UNTIL SCN with FROM ACTIVE DATABASE to make it go
read the RMAN catalog info from Prod and do the appropriate things to the new
PDB in test ?

My ability to play with this is a little limited. The database I'm copying is
600 or 700 GB so anything I try isn't exactly a quick test.

Would appreciate insights from anyone running in this kind of configuration,
the whole PDB thing is relatively new to me, we're just starting to look at
converting from a non-CDB architecture into the multi-tenant world.

If it makes any difference, this is hosted in Oracle Cloud (but I don't have
access to the cloud console).

Thanks
Steve

Disclaimer

The information contained in this communication from the sender is
confidential. It is intended solely for use by the recipient and others
authorized to receive it. If you are not the recipient, you are hereby notified
that any disclosure, copying, distribution or taking action in relation of the
contents of this information is strictly prohibited and may be unlawful.

This email has been scanned for viruses and malware, and may have been
automatically archived.

Follow-Ups:
- Re: (EXT) RE: Duplicating a PDB to an existing CDB at a point in time in the recent past
  - From: Steve Wales (AddOns)

References:
- Duplicating a PDB to an existing CDB at a point in time in the recent past
  - From: Steve Wales (AddOns)

RE: Duplicating a PDB to an existing CDB at a point in time in the recent past

Other related posts: