Forum Stats

  • 3,814,871 Users
  • 2,258,922 Discussions
  • 7,892,882 Comments

Discussions

Open a PDB in a Standby Database

Alan Somoza
Alan Somoza Member Posts: 9 Red Ribbon
edited Sep 7, 2020 3:29AM in Data Guard

Hi,

I've been wondering if a weird configuration is posible or not, because I've been asked to implement this case and we are discussing if dataguard mutienant is what we need or not.

Let's see:

SERVER 1 (Primary)

CDB

PDB1

PDB2 - not replicated

SERVER 2 (Standby)

CDB

PDB1

PDB3 - not replicated

As far as I know, the configuration is correct. The question is, as is not replicated, and Server 2 CDB is able to be open... Is possible to open PDB3?

I mean, the objective would be to have a replicated PDB1 on dataguard, meanwhile we have 2 additional PDBs up and open, all within the same system. Of course, in my example PDB2 can be opened, but I can't find a way to open PDB3 in read-write.

Is this even possible?

Thanks in advance,

Tagged:

Answers

  • arvindkumar-Oracle
    arvindkumar-Oracle Member Posts: 6 Employee
    edited Sep 7, 2020 3:29AM

    This configuration is not possible if you are referring to physical standby

    This may be possible if you are planning to have a logical standby. But again if you have PDB2 on your primary open, then the replication would fail as PDB2 is missing on the logical standby.

    Hope this helps.