Database & Infrastructure
Wednesday, 13. October 2021., 09:30
Starting with 12c Release 1, Oracle introduced a completely new architecture concept for its database - the Container Database. With this new architecture, new challenges came up but with the same breath a wide branch of new opportunities. © The presentation will address the capabilities to create fast and easy new (test) databases or clones for a running production database. Five different ways will be discussed. - Using Local and Remote Cloning - Using an Unplugged PDB (predefined master) - Using Refreshable PDBs as a master for new (test) databases - Using Data Guard for a limited number of PDBs and its Snapshot Standby capabilities - Snapshot Carousel Another point of the agenda is the usage of the Snapshot features of ACFS and Direct NFS to speed up the creation process. © At the end of the presentation, a comparison of the advantages and disadvantages of each technique will be presented.