I like the Oracle Multitenant architecture which was introduced in 12.1. But the concept to clone a source database to multiple copies in a small step had one big problem. In Oracle 12.1, to clone a pluggable database the source database had to be in state read-only. In 12.2 is it not longer necessary to set the source pluggable database in state read-only, the source database has not to be modified to create a clone. Oracle calls it in the documentation “Hot Clone”. Link to the official Oracle documentation: https://docs.oracle.com/database/122/ADMIN/creating-and-removing-pdbs-with-sql-plus.htm#ADMIN13584 Here is a clone of the pluggable database PDB1 into PDB2 in the Oracle Database Cloud Service. Verify existing Pluggable Databases and States – PDB1 is in state READ-WRITE SQL>…
Read MoreThursday, April 25, 2024