Forum Stats

  • 3,874,298 Users
  • 2,266,718 Discussions
  • 7,911,809 Comments

Discussions

Multitenant / Data Guard for just on pdb

brian.mcginity
brian.mcginity Member Posts: 140 Bronze Badge
edited Apr 14, 2022 1:23PM in Data Guard

Is it possible to set up Data Guard on a single pluggable db?

==============================================

Data Center 1: EE and Multitenant

PDB1 = production instance

PDB2 = DG for for Data Center 2-PDB1

==============================================

==============================================

Data Center 2: EE and Multitenant

PDB1 = production instance

PDB2 = DG for Data Center 1-PDB1

==============================================

Note that Data Center 1 and Data Center 2 production databases are different and do not share data.


I know Data Guard can operate on the entire Multitenant container. Can it operate on just a single pdb?

Answers

  • brian.mcginity
    brian.mcginity Member Posts: 140 Bronze Badge

    I did some research and I think it is possible. I had a conversation with dbvisit.com and they said their product would be able to set up DG for just a single PDB. So if that's true, it can most likely be done within Oracle's standard toolset.

  • Luís Gustavo Lira
    Luís Gustavo Lira Member Posts: 119 Silver Badge

    Hi,

    you don't inform your database version.

    But, in 12.1.0.2, the CREATE PLUGGABLE DATABASE statement has a new clause, STANDBYS=NONE, that allows for deferral of file instantiation on the standby allowing the physical standby database to continue to protect existing pluggable databases.

    I recommend you check the following notes:

    • Data Guard Impact on Oracle Multitenant Environments (Doc ID 2049127.1)
    • Making Use Deferred PDB Recovery and the STANDBYS=NONE Feature with Oracle Multitenant (Doc ID 1916648.1)
    • Effect of PDB Clone On Data guard Environment (Doc ID 1591518.1)
    • How to change a PDB name in a Standby database (Doc ID 2406370.1)


  • brian.mcginity
    brian.mcginity Member Posts: 140 Bronze Badge