My Oracle Support Banner

Creating A Refreshable PDB Clone (Doc ID 2772386.1)

Last updated on FEBRUARY 04, 2022

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Goal

Creating a refreshable PDB clone with intents to use the refreshable PDB as a reporting database. Need to refresh PDB every hour of the day. Setup the PDB to be AUTO refresh every 60 minutes. PDB is OPEN READ ONLY, but is not auto-closing to perform refresh. It seems the PDB has to be in closed state for the refresh to automatically work. Is this correct behavior? If so, then it would seem we have to create a job to close the PDB, refresh, and then OPEN READ ONLY. Can you confirm this behavior?

If the above is true, is there a future enhancement for refreshable PDB where the auto refresh could perform these steps automatically to avoid us having to create a job?
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.