重庆思庄Oracle、Redhat认证学习论坛

标题: OCM一个大坑：pdb在CDB之间使用RMAN复制失败 [打印本页]

作者: 郑全 时间: 2024-3-9 02:03
标题: 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)

作者: 郑全 时间: 2024-3-9 02:08
该问题，在19.17以前一直存在，而19cOCM环境 ORACLE 版本为19.3

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)