OCM一个大坑：pdb在CDB之间使用RMAN复制失败

郑全

如果源端有临时文件编号和数据文件编号一样，将导致RMAN在CDB之间复制，失败，报如下错误：

channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:00
channel ORA_AUX_DISK_2: restore complete, elapsed time: 00:00:01
Finished restore at 09-MAR-24
FILE_NAME_CONVERT missing pattern
Oracle error from auxiliary database: ORA-65011: Pluggable database PDBDEV2 does not exist.

Oracle error from auxiliary database: ORA-65000: missing or invalid pluggable database name

Oracle error from auxiliary database: ORA-65000: missing or invalid pluggable database name

Oracle error from auxiliary database: ORA-65000: missing or invalid pluggable database name

Oracle error from auxiliary database: ORA-65000: missing or invalid pluggable database name

Oracle error from auxiliary database: ORA-65000: missing or invalid pluggable database name

Finished Duplicate PDB at 09-MAR-24



经检查，发现源端临时文件号和数据文件号重复了：

SYS@PRODCDB> select t.file#,t.name from v$tempfile t,v$datafile v
  2  where t.file#=v.file# and t.con_id=v.con_id
  3  and v.con_id=3;

     FILE# NAME
---------- ------------------------------
         9 /u01/app/oracle/oradata/PRODCD
           B/PDBPROD1/temp101.dbf


把这个重复编号的临时文件删除，复制就没有问题了。

该问题是一个BUG，具体可以参见官方：

RMAN PDB Duplicate Fails with FILE_NAME_CONVERT missing pattern and ORA-65005 (Doc ID 2860935.1)

郑全

该问题，在19.17以前一直存在，而19cOCM环境 ORACLE 版本为19.3