- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 73 Insurance
- 537.3K On-Premises Infrastructure
- 138.6K Analytics Software
- 38.6K Application Development Software
- 6K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.2K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
PDB Cloning w/OMF in RAC
Using Oracle 188.8.131.52.0. Have 1 SOURCE pdb (PDB1) and attempting to clone to a 2nd pdb (PDB2) within the same cdb (CDB1) using OMF files that are managed by ASM. I created PDB1 some time ago from a NCDB using datafiles that I copied over (using ASMCMD commands) from a remote host. No issue there.
I then successfully clone PDB1 to PDB2 via "create pluggable database PDB2 from PDB1 CREATE_FILE_DEST='+DATA' ;
I DO see the new directory with the GUID +DATA/CDB1/6CCEBF3072B43SEC4E05397447B8636DD/DATAFILE
Again, no problem.
I would like the next set of pdb (PDB3) datafiles I create to go under +DATA/PDB3 - like it it for PDB1 (under +DATA/PDB1). I am sure this is a mix up in my understanding of OMF here, but here is my question:
Why can't I issue "create pluggable database PDB3 from PDB1 CREATE_FILE_DEST='+DATA/PDB3? It gives me the error ""ORA-65165 : missing or invalid patch for file creation". Am I getting this because I am trying to override the underlying fact of OMF here? I get this same error regardless of whether I first explicitly create the PDB3 subdirectory under "+DATA".
Thank you all.