【故障描述】

在备份PDB时，使用'CREATE_FILE_DEST'子句创建的可插拔数据库（PDB）将返回ORA-65250错误。

例如，假定使用以下命令创建PDB：

CREATE PLUGGABLE DATABASE SANDATA ADMIN USER sys IDENTIFIED BY <password>  CREATE_FILE_DEST='/u01/app/oracle/oradata/SDDB/SANDATA/';

备份上述命令创建的可插拔数据库失败，并出现以下错误：

starting piece 1 at 20-SEP-2021 11:36:05
RMAN-03009: failure of backup command on BACKUP1 channel at 09/20/2021 12:36:06
ORA-65250: invalid path specified for file - /orabackup/test/test_20-09-2021_1uuc7td5_1_1
continuing other job steps, job failed will not be re-run

RMAN-03009: failure of backup command on BACKUP1 channel at 09/20/2021 12:36:06
ORA-65250: invalid path specified for file - /orabackup/test/test_20-09-2021_1uuc7td5_1_1
RMAN-03009: failure of backup command on BACKUP1 channel at 09/20/2021 12:36:05
ORA-65250: invalid path specified for file - /orabackup/test_20-09-2021_1tuc7td4_1_1

【解决方法】

1.清空 db_create_file_dest 参数

SQL> alter session set container = <CDB NAME>;
SQL> alter system set db_create_file_dest ='' scope=both;
SQL> show parameter db_create_file_dest

2.重新执行RMAN备份

【参考文档】

RMAN Backup of Pluggable Database Returns Error ORA-65250 (Doc ID 2596048.1)

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)