Re: 19c Physical Standby

 Mladen
Look like this parameter was introduced in 12.2 itself. What I am trying is to create Standby with only one PDB and it look like this parameter will stop sync for defined PDBs to standby or can help if any new PDB is added to primary without using Standby clause and need not replicated. Not sure if Oracle has anything Duplicate database for standby with pluggable database clause TxSanjay

    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