1. Home
  2. Knowledge Base
  3. Multitenancy
  4. Oracle 18c New Feature Pluggable Database Switchover

Oracle 18c New Feature Pluggable Database Switchover

In earlier releases prior to Oracle 18c, while we could enable Data Guard for a Multitenant Container/Pluggable database environment, we were restricted when it came to performing a Switchover or Failover – it had to be performed at the Container Database (CDB) level.

This meant that a database role reversal would affect each and every PDB hosted by the CDB undergoing a Data Guard Switchover or Failover.

In Oracle 12c  Release 2, a new feature called refreshable clone PDB was introduced. A refreshable  clone PDB is a read-only clone that can periodically synchronize itself with its source PDB.

This synchronization could be configured to happen manually or automatically based on a predefined interval for the refresh.

In Oracle 18c a new feature has been added using  the refreshable clone mechanism which enables us to now perform a switchover at the individual PDB level. So we are enabling high availability at the PDB level within the CDB.

We can now issue a command in Oracle 18c like this:

SQL> alter pluggable database orclpdb1
refresh mode manual
from orclpdb1@cdb2_link

After the switchover completes, the original source PDB becomes the refreshable clone PDB (which can only be opened in READ ONLY mode), while the original refreshable clone PDB is now open in read/write mode functioning as a source PDB.

How to perform a Switchover for a Pluggable Database (Members Only)

Updated on June 2, 2021

Was this article helpful?

Related Articles

Leave a Comment