I wrote many posts about all new features of Oracle 12c , how multi-tenant architecture works and all.

In this post, we will see how oracle’s internal mechanisms have changed with multi-tenant architecture for its existing technologies.

Let us start with Oracle Xstream :

In Oracle Xtream, capturing changes from the database must always be from the CDB root as we have a single redo log file per CDB. XStream outbound can be configured to capture changes from a PDB or the entire CDB.Applying
changes via Oracle GoldenGate is done per PDB. An XStream Inbound Server is configured to apply changes into a specific PDB and performs all of its work within the context of the PDB.

Data Guard with Multi-Tenant Architecture :

Data Guard will be created for entire CDB. A database role is defined at the CDB level, individual pdb does not contain any database role.

When we perform any switchover or failover activity whole cdb will be affected.

Scheduling Operations in a PDB :

A job defined at PDB level will only run if that specific pdb is in open stage. Jobs created by the user can be imported and exported using data pump utility.

Note: Predefined scheduler objects are not exported. Any changes we have made to the predefined scheduler needs to be applied again after the database has been imported to pdb.

If you want to be updated with all our articles send us an 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


About The Author

Leave a Reply

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