Bug 30419450 - ORA-65250 reports when taking backup of PDB (cerated with 'create_file_dest' clause) to destination other than location "db_create_file_dest" (Doc ID 30419450.8)

Bug 30419450  ORA-65250 reports when taking backup of PDB (cerated with 'create_file_dest' clause) to destination other than location "db_create_file_dest"

Affects:

Product (Component)	Oracle Server (Rdbms)
Range of versions believed to be affected	Versions BELOW 20.1
Versions confirmed as being affected	19.10.0 19.9.0 19.8.0 19.7.0 19.6.0 19.3.0 18.13.0 18.11.0 18.10.0 18.9.0 18.8.0 18.7.0 18.6.0 18.5.0 18.4.0
Platforms affected	Generic (all / most platforms affected)

Fixed:

The fix for 30419450 is first included in

(None Specified)

Interim patches may be available for earlier versions - click here to check.

Description

REDISCOVERY INFORMATION:
  If a PDB is created with the "create_file_dest" clause, then RMAN that is connected to the root cannot take a backup of that PDB to any
  arbitrary location. That is, a command such as 'backup database format ...' will break when that PDB's datafiles are attempted to be backed up.
 
       I.e,  If backup location is other than value of parameter "db_create_file_dest" then we see error "ORA-65250".
 
Workaround
  Turn off the parameter "db_create_file_dest" of the offending PDB 
           
               SQL> alter session set container = <CDB NAME>;
               SQL> alter system set db_create_file_dest ='' scope=both;
               SQL> show parameter db_create_file_dest
 

References

Bug:30419450 (This link will only work for PUBLISHED bugs)
Note:245840.1 Information on the sections in this article