1

We are currently planning to upgrade our databases from 11g to 12c. But I have some confusions regarding 12c. Here are my questions.

  1. Can standby database of a non-container database be pluggable or vice versa?

  2. Suppose there are 2 CDBs on 2 different server. And one has 3 primary PDBs, the other has 3 standby PDBs of the primary with dataguard configuration. If the switchover executed on one primary, will it execute switchover on other 2 PDBs?

1

Can standby database of a non-container database be pluggable or vice versa?

In order to plugin a non-CDB standby database into a CDB, the non-CDB standby database needs to be of version 12c as well. So existing non-CDB databases will need to be upgraded to 12c before they can be part of a 12c CDB.

Suppose there are 2 CDBs on 2 different server. And one has 3 primary PDBs, the other has 3 standby PDBs of the primary with dataguard configuration. If the switchover executed on one primary, will it execute switchover on other 2 PDBs?

The dataguard switchover or failover operations are all performed at the CDB level. When the Data Guard is configured with the CDB database, all PDBs are also replicated to the target. Same way when a failover or switchover operation is performed all the PDBs also change role along with the CDB container.

As migration is a serious task I would recommend to take look at Oracle Support Knowledge based documents.(MOS account required)
Step by Step Examples of Migrating non-CDBs and PDBs Using ASM for File Storage (Doc ID 1576755.1)

5
  • One more thing, suppose I have 2 non-CDB primary databases on 2 servers, can their standby PDB databases exist in same CDB?
    – babuuz
    Mar 17 '16 at 1:25
  • please answer question above @JSapkota
    – babuuz
    Mar 21 '16 at 15:17
  • @babuuz: Sorry for the late reply. But I didn't understand what you are asking here. non-CDB primary with standby PDBs. We need CDB to plug PDBs.
    – atokpas
    Mar 21 '16 at 15:21
  • Sorry for confusion. I want 2 non CDB primary databases on 2 different servers and their standbys are as PDBs on same CDB on 3rd server. Is it possible?
    – babuuz
    Mar 21 '16 at 15:24
  • @babuuz:Are you talking about creating CDB standby(with pdbs) for non-CDB primary database? If so that may not be possible AFAIK.
    – atokpas
    Mar 21 '16 at 15:35

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.