如果源端有临时文件编号和数据文件编号一样,将导致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)
|