How to Migrate Non-CDB to CDB – With Downtime

Step 1:Non-CDB Instance
1.1 Open Non-CDB in Read-Only Mode
1.2 execute dbms_pdb.describe and generate the PDB Description XML File
1.3 Shutdown Non-CDB Instance

Step 2: Target CDB
2.1. Check the PDB description compatibiliy
dbms_pdb.check_plug_compatibility
2.2. Confirm if any voilations are there pdb_plug_in_violation view for this PDB
All Voilations should be fixed except execute non-cdb_to_pdb.sql
2.3. Create pluggable database using PDB Description XML File
Options:
COPY – This will copy all the files from source.
NOn-COPY
MOVE
2.4. Execute the non-cdb_to_pdb.sql from rdbms/admin folder
2.5. Confirm the no voilations in pdb_plug_in_violation view for this PDB