Surf through this page to know about features and enhancements that were released on each version from 12cR1. I'll try to cover these features one by one in my future posts.
12.1.0.1 Onwards -
Create and Configure a Container Database (CDB)
Create and Configure a Pluggable Database (PDB)
Migrate a Non-Container Database (CDB) to a Pluggable Database (PDB)
Connect, Manage, Administer Container Databases (CDB) and Pluggable Databases (PDB)
Configure Instance Parameters and Modify Container Databases (CDB) and Pluggable Databases (PDB)
Manage Tablespaces in a Container Database (CDB) and Pluggable Database (PDB)
Manage Users and Privileges For Container Databases (CDB) and Pluggable Databases (PDB)
Backup and Recovery of a Container Database (CDB) and a Pluggable Database (PDB)
Flashback of a Container Database (CDB)
Resource Manager with Container Databases (CDB) and Pluggable Databases (PDB)
RMAN (BACKUP VALIDATE, RESTORE VALIDATE, RECOVERY VALIDATE)
Database Triggers on Pluggable Databases (PDBs)
Transparent Data Encryption (TDE) in Pluggable Databases (PDBs)
PDBs With Different Time Zones to the CDB
Pluggable Database (PDB) Names Modify
Upgrade a PDB using Unplug/Plugin
Recovery Manager (RMAN) Database Duplication Enhancements : Multitenant Considerations
ADO (Automatic Data Optimisation) => based on heat_map=ON/OFF(default) (working at CDB in this version)
Emergency Monitoring (is from OEM Cloud Control) with O/S credentials (check hung analysis)
Real-Time ADDM (regular ADDM is based on AWR Snapshots, real-time ADDM is based on ASH Data (last 10 min))
In-Memory introduced
Data Redaction (security feature, visibility masking) and it is different from Data Masking
Partition Enhancements (merge, split, add multiple, remove multiple, etc.)
12.1.0.2 Onwards -
Clone a Remote PDB or Non-CDB (12.1.0.2)
Metadata Only PDB Clones (12.1.0.2)
PDB Subset Cloning (12.1.0.2)
PDB CONTAINERS Clause (12.1.0.2 and 12.2)
PDB Logging Clause (12.1.0.2)
USER_TABLESPACES Clause (12.1.0.2)
12.2.0.1 Onwards -
Application Containers (12.2)
Controlling PDB Replication in Data Guard Environments : ENABLED_PDBS_ON_STANDBY Parameter (12.2)
Default Tablespace Clause During PDB Creation (12.2)
Flashback Pluggable Database (PDB) (12.2)
Hot Clone a Remote PDB or Non-CDB (12.2)
Local Undo Mode (12.2)
Parallel PDB Creation Clause (12.2)
PDB Archive Files (.pdb = xml file with data files) for Unplug and Plugin (12.2)
PDB Lockdown Profiles (12.2)
PDBs With Different Character Sets to the CDB (12.2)
PDB Refresh (12.2)
Proxy PDB (12.2)
Relocate a PDB (auto drop on source side) (12.2)
Rename Services During PDB Creation (12.2)
Heat Map, Information Lifecycle Management (ILM) and Automatic Data Optimization (ADO)
Table Point in Time Recovery across Platforms
New Tool SQLcl, New Commands and Features for SQL * Plus
18c Onwards -
CDB Fleet Management
Copying a PDB in a Data Guard Environment
DBCA PDB Clone and DBCA CDB Duplicate
Duplicate a Pluggable Database (PDB) to an existing Container Database (CDB)
PDB Lockdown Profile Enhancements
PDB Snapshot Carousel
Refreshable PDB Switchover
Usable Backups of Non-CDBs and Relocated PDBs
Logical Partitioning - Container Maps
Parallel Statement Queuing at the PDB Level
Create a Keystore for each Pluggable Database
PDB Snapshot Carousel
ADDM analysis for PDBs
Schema only accounts
19c Onwards -
DBCA PDB Remote Clone
DBCA PDB Relocate
Upgrading to Oracle Database 19c
Upgrading to Oracle Database 19c (Non-CDB) - Upgrade from 11.2 to 19c, including conversion to PDB.
Workload capture and replay in a PDB
Support for multiple PDB shards in the same CDB
Cloud object store support for Data Pump Import
Database Vault Operations Control for infrastructure database administrators
Thank you for taking a look. I hope this helps.
Regards,
Balaaji Dhananjayan
Comments