RE: 19c Physical Standby

A sledge hammer approach requires asking yourself the question of whether having two distinct container databases on the complex of machinery in question is reasonable.  

IF so, an approach is to plug all the PDBs you want on dataguard into one container and all the other ones into another container.  

There *may* be some advantage to having this separation between log writers and data produced that need to and do not need to be transmitted securely elsewhere.  

Having more than one container puts you on the slippery slope of increasing total number of processes and need to carve up available system memory that containers were introduced to avoid.  

Depending on the size of the machinery complex and whether having multiple (2 minimum) containers poses a significant configuration and utilization problem for you, this *might* be useful.  

Two is often a special number in things like this, and like the Holy Hand grenade of St. Antioch, 5 is right out!  

Good luck.  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Sanjay Mishra (Redacted sender "smishra_97" for DMARC) Sent: Thursday, February 25, 2021 12:50 AM To: oracle-l_at_freelists.org; Mladen Gogala Subject: Re: 19c Physical Standby  

Thanks Mladen :) Earlier heard the feature but not able to find it. Will use other method to test it  

Thanks again to all  

Sanjay  

On Wednesday, February 24, 2021, 10:58:39 PM EST, Mladen Gogala <gogala.mladen_at_gmail.com> wrote:    

Hi Sanjay,

I've had the same problem as you and I found the solution...sort of. The solution is the parameter ENABLED_PDBS_ON_STANDBY on the primary DB.

https://docs.oracle.com/en/database/oracle/oracle-database/21/refrn/ENABLED_PDBS_ON_STANDBY.html#GUID-A2EC2381-D9C0-4612-87C9-A225C7BCE8C4

It's even described in the Data Guard manual:

https://docs.oracle.com/en/database/oracle/oracle-database/21/sbydb/creating-oracle-data-guard-physical-standby.html#GUID-20D2DEAC-0355-4FBB-ADB8-37BF5F4328E2

Before you get too happy, there is one minor detail: this is a 21c parameter, not available in versions 19c and below. Oracle database 21c is available in the sky. So is Lucy, with diamonds.

Regards.

On 2/24/21 3:21 PM, Sanjay Mishra (Redacted sender smishra_97 for DMARC) wrote:
> Rajeev
>
> In my Case Primary Already has multiple PDB but I need standby for
> only one PDB. This clause will work if I am adding new PDB and don't
> want it to sync with Standby
>
> Tx
> Sanjay

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com

--
http://www.freelists.org/webpage/oracle-l









--
http://www.freelists.org/webpage/oracle-l