A lead CDB is the central location for monitoring and managing the CDBs in the fleet. A CDB fleet provides the database infrastructure for scalability and centralized management of many CDBs.

Designate one CDB in the fleet to be the lead CDB by setting its LEAD_CDB database property to TRUE. The other CDBs in the fleet point to the lead CDB by setting the LEAD_CDB_URI database property. After you configure the CDB fleet, PDB information from the various CDBs is synchronized with the lead CDB. All PDBs in the CDBs are now “visible” in the lead CDB, enabling you to access the PDBs in the fleet as a single, logical CDB from the lead CDB.

The following figure shows a CDB fleet consisting of CDB1, CDB2, and CDB3. The lead CDB is CDB1. CDB2_hrpdb, which resides in CDB2, is visible in CDB1. CDB3_hrpdb, which resides in CDB3, is also visible in CDB1.


Image Source

In this example, we are using 2 CDBs


Setting the Lead CDB in a CDB Fleet

Login to CDB18C and make it as LEAD CDB.

Let’s Check the count of PDBs in CDB18C till now.

Now login to another CDB i.e NEWCDB and create a database link and also set the LEAD_CDB_URI.

Let’s Check again the PDBs in CDB18C now.

As we PDB18CFLEET from NEWCDB container is visible in LEAD CDB i.e CDB18C.

Stay tuned for more articles on Oracle 18c 

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel: https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.