ORA-65169 , ORA-17628 and ORA-19505 during hot PDB clone over db link
Create pluggable database command over db link for hot cloning was failing with below errors on Oracle 12.2.0.1. ORA-65169 , ORA-17628 and ORA-19505. Source and Destination both were using ASM disk groups and the destination disk group had enough space available. On the source PDB some of the datafiles were using OMF while others were using aliases to OMF file names similar to below example, FILE_NAME_CONVERT and CREATE_FILE_DEST FILE_NAME_CONVERT does not help a lot in this scenario as OMF is involved. The easiest work around in this situation is to use CREATE_FILE_DEST instead. CREATE PLUGGABLE DATABASE PRMINTGR FROM PRODPRM@clone_link create_file_dest='+PRIM_CON_DG/'; CREATE_FILE_DEST moves all files to new disk group for target the PDB.