Oracle Multitenant: From OMF-PDB to Non-OMF-PDB
Personally, I prefer running Oracle Container Databases with Oracle Managed Files (OMF), because OMF simplify the handling of the filenames, especially when cloning pluggable databases. But if you are running a “mixed environment” with some databases using OMF and others not, it may occur that you have to plugin an “OMF-PDB” as a “Non-OMF-PDB”. Let’s…
Refreshable PDBs and the Archivelog Deletion Policy
Refreshable PDBs are a cool thing within the Oracle Multitenant Architecture. You can create a copy of your large production database once and later you can „refresh“ it by applying the transactions (redologs) from the source database. But keep in mind that your archivelog deletion policy may kick in and can destroy your refresh mechanism.
ORA-65028 when plugging in a PDB from a PDB archive into a RAC database
I’m currently testing all the different PDB features like local and remote cloning or plugging in a PDB on a 19.6 Container-Database in a Maximum Availability Architecture (MAA), i.e. a setup with RAC, ASM and DataGuard in place. Everything went fine, except for the attempt to plugin a PDB from a PDB archive, which always…