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

标题: 在WINDOWS上执行 pdb 活动复制报：RMAN-00600 [5304] [打印本页]

作者: 郑全 时间: 2022-12-25 12:49
标题: 在WINDOWS上执行 pdb 活动复制报：RMAN-00600 [5304]
如果在WINDOWS上通过RMAN 连接到LINUX进行PDB活动复制，后面就会报这个错误：

C:\Users\zq>rman target sys/sztech_4U@192.168.133.120:1521/cdb1 auxiliary sys/sztech_4U@192.168.133.130:1521/cdb2

恢复管理器: Release 19.0.0.0.0 - Production on 星期日 12月 25 12:27:37 2022
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

已连接到目标数据库: CDB1 (DBID=1093694741)
已连接到辅助数据库: CDB2 (DBID=867025235)

RMAN> duplicate pluggable database pdb1 as pdb2 to cdb2 from active database;

从位于 25-12月-22 的 Duplicate PDB 开始
使用目标数据库控制文件替代恢复目录
分配的通道: ORA_AUX_DISK_1
通道 ORA_AUX_DISK_1: SID=398 设备类型=DISK
当前日志已存档
RMAN-05159: 正在将 Online logs 复制到 Oracle Managed File (OMF) 位置
RMAN-05159: 正在将 Datafiles 复制到 Oracle Managed File (OMF) 位置
将数据文件 146 以前的重复文件 /u01/app/oracle/oradata/CDB2/F09FFE3883E934FCE0537885A8C0DA67/datafile/o1_mf_system_jc1g8v8o_.dbf 与 6154073 的检查点 SCN 一起使用
将数据文件 147 以前的重复文件 /u01/app/oracle/oradata/CDB2/F09FFE3883E934FCE0537885A8C0DA67/datafile/o1_mf_sysaux_i01g8v8v_.dbf 与 6154077 的检查点 SCN 一起使用
将数据文件 148 以前的重复文件 /u01/app/oracle/oradata/CDB2/F09FFE3883E934FCE0537885A8C0DA67/datafile/o1_mf_undotbs1_c51g8v96_.dbf 与 6154081 的检查点 SCN 一起使用

内存脚本的内容:
{
set newname for datafile  146 to
"/u01/app/oracle/oradata/CDB2/F09FFE3883E934FCE0537885A8C0DA67/datafile/o1_mf_system_jc1g8v8o_.dbf";
set newname for datafile  147 to
"/u01/app/oracle/oradata/CDB2/F09FFE3883E934FCE0537885A8C0DA67/datafile/o1_mf_sysaux_i01g8v8v_.dbf";
set newname for datafile  148 to
"/u01/app/oracle/oradata/CDB2/F09FFE3883E934FCE0537885A8C0DA67/datafile/o1_mf_undotbs1_c51g8v96_.dbf";
}
正在执行内存脚本

正在执行命令: SET NEWNAME

正在执行命令: SET NEWNAME

正在执行命令: SET NEWNAME
当前日志已存档

内存脚本的内容:
{
set archivelog destination to  '/tmp';
restore clone force from service  '192.168.133.120:1521/cdb1'
         foreign archivelog from scn  6154073;
}
正在执行内存脚本

正在执行命令: SET ARCHIVELOG DESTINATION

从位于 25-12月-22 的 restore 开始
使用通道 ORA_AUX_DISK_1

通道 ORA_AUX_DISK_1: 正在开始将归档日志还原到用户指定的目标
归档日志目标=/tmp
通道 ORA_AUX_DISK_1: 正在使用来自服务 192.168.133.120:1521/cdb1 的网络备份集
通道 ORA_AUX_DISK_1: 正在还原归档日志
归档日志线程 = 1 序列 = 114
通道 ORA_AUX_DISK_1: 还原完成, 用时: 00:00:01
通道 ORA_AUX_DISK_1: 正在开始将归档日志还原到用户指定的目标
归档日志目标=/tmp
通道 ORA_AUX_DISK_1: 正在使用来自服务 192.168.133.120:1521/cdb1 的网络备份集
通道 ORA_AUX_DISK_1: 正在还原归档日志
归档日志线程 = 1 序列 = 115
通道 ORA_AUX_DISK_1: 还原完成, 用时: 00:00:01
通道 ORA_AUX_DISK_1: 正在开始将归档日志还原到用户指定的目标
归档日志目标=/tmp
通道 ORA_AUX_DISK_1: 正在使用来自服务 192.168.133.120:1521/cdb1 的网络备份集
通道 ORA_AUX_DISK_1: 正在还原归档日志
归档日志线程 = 1 序列 = 116
通道 ORA_AUX_DISK_1: 还原完成, 用时: 00:00:01
通道 ORA_AUX_DISK_1: 正在开始将归档日志还原到用户指定的目标
归档日志目标=/tmp
通道 ORA_AUX_DISK_1: 正在使用来自服务 192.168.133.120:1521/cdb1 的网络备份集
通道 ORA_AUX_DISK_1: 正在还原归档日志
归档日志线程 = 1 序列 = 117
通道 ORA_AUX_DISK_1: 还原完成, 用时: 00:00:01
通道 ORA_AUX_DISK_1: 正在开始将归档日志还原到用户指定的目标
归档日志目标=/tmp
通道 ORA_AUX_DISK_1: 正在使用来自服务 192.168.133.120:1521/cdb1 的网络备份集
通道 ORA_AUX_DISK_1: 正在还原归档日志
归档日志线程 = 1 序列 = 118
通道 ORA_AUX_DISK_1: 还原完成, 用时: 00:00:01
通道 ORA_AUX_DISK_1: 正在开始将归档日志还原到用户指定的目标
归档日志目标=/tmp
通道 ORA_AUX_DISK_1: 正在使用来自服务 192.168.133.120:1521/cdb1 的网络备份集
通道 ORA_AUX_DISK_1: 正在还原归档日志
归档日志线程 = 1 序列 = 119
通道 ORA_AUX_DISK_1: 还原完成, 用时: 00:00:01
通道 ORA_AUX_DISK_1: 正在开始将归档日志还原到用户指定的目标
归档日志目标=/tmp
通道 ORA_AUX_DISK_1: 正在使用来自服务 192.168.133.120:1521/cdb1 的网络备份集
通道 ORA_AUX_DISK_1: 正在还原归档日志
归档日志线程 = 1 序列 = 120
通道 ORA_AUX_DISK_1: 还原完成, 用时: 00:00:02
通道 ORA_AUX_DISK_1: 正在开始将归档日志还原到用户指定的目标
归档日志目标=/tmp
通道 ORA_AUX_DISK_1: 正在使用来自服务 192.168.133.120:1521/cdb1 的网络备份集
通道 ORA_AUX_DISK_1: 正在还原归档日志
归档日志线程 = 1 序列 = 121
通道 ORA_AUX_DISK_1: 还原完成, 用时: 00:00:01
在 25-12月-22 完成了 restore
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: 位于 12/25/2022 12:28:06 的 Duplicate PDB 命令失败
RMAN-05501: 终止复制目标数据库
RMAN-00600: internal error, arguments [5304] [/u01/app/oracle/oradata/CDB1/pdb1/temp012022-11-05_17-04-06-925-PM.dbf] [] [] []

RMAN>

如果不在WINDOWS上执行，直接在LINUX执行，就不会报错了：

如下：

[oracle@dbserver dbs]$ rman target sys/sztech_4U@192.168.133.120:1521/cdb1 auxiliary sys/sztech_4U@192.168.133.120:1521/cdb3

Recovery Manager: Release 19.0.0.0.0 - Production on Sun Dec 25 12:37:27 2022
Version 19.16.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

connected to target database: CDB1 (DBID=1093694741)
connected to auxiliary database: CDB3 (DBID=821688448)

RMAN> duplicate pluggable database pdb1 as pdb2 to cdb3 from active database;

Starting Duplicate PDB at 25-DEC-22
using channel ORA_AUX_DISK_1
current log archived
duplicating Online logs to Oracle Managed File (OMF) location
duplicating Datafiles to Oracle Managed File (OMF) location
Using previous duplicated file /home/oracle/CDB3/F09FFE3883E934FCE0537885A8C0DA67/datafile/o1_mf_system_up1g8uc1_.dbf for datafile 146 with checkpoint SCN of 6151331
Using previous duplicated file /home/oracle/CDB3/F09FFE3883E934FCE0537885A8C0DA67/datafile/o1_mf_sysaux_gq1g8uc4_.dbf for datafile 147 with checkpoint SCN of 6151333
Using previous duplicated file /home/oracle/CDB3/F09FFE3883E934FCE0537885A8C0DA67/datafile/o1_mf_undotbs1_7p1g8uc8_.dbf for datafile 148 with checkpoint SCN of 6151336
current log archived

contents of Memory Script:
{
set newname for datafile  146 to
"/home/oracle/CDB3/F09FFE3883E934FCE0537885A8C0DA67/datafile/o1_mf_system_up1g8uc1_.dbf";
set newname for datafile  147 to
"/home/oracle/CDB3/F09FFE3883E934FCE0537885A8C0DA67/datafile/o1_mf_sysaux_gq1g8uc4_.dbf";
set newname for datafile  148 to
"/home/oracle/CDB3/F09FFE3883E934FCE0537885A8C0DA67/datafile/o1_mf_undotbs1_7p1g8uc8_.dbf";
}
executing Memory Script

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

contents of Memory Script:
{
set archivelog destination to  '/home/oracle';
restore clone force from service  '192.168.133.120:1521/cdb1'
         foreign archivelog from scn  6151331;
}
executing Memory Script

executing command: SET ARCHIVELOG DESTINATION

Starting restore at 25-DEC-22
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting archived log restore to user-specified destination
archived log destination=/home/oracle
channel ORA_AUX_DISK_1: using network backup set from service 192.168.133.120:1521/cdb1
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=111
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_1: starting archived log restore to user-specified destination
archived log destination=/home/oracle
channel ORA_AUX_DISK_1: using network backup set from service 192.168.133.120:1521/cdb1
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=112
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_1: starting archived log restore to user-specified destination
archived log destination=/home/oracle
channel ORA_AUX_DISK_1: using network backup set from service 192.168.133.120:1521/cdb1
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=113
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_1: starting archived log restore to user-specified destination
archived log destination=/home/oracle
channel ORA_AUX_DISK_1: using network backup set from service 192.168.133.120:1521/cdb1
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=114
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_1: starting archived log restore to user-specified destination
archived log destination=/home/oracle
channel ORA_AUX_DISK_1: using network backup set from service 192.168.133.120:1521/cdb1
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=115
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_1: starting archived log restore to user-specified destination
archived log destination=/home/oracle
channel ORA_AUX_DISK_1: using network backup set from service 192.168.133.120:1521/cdb1
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=116
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_1: starting archived log restore to user-specified destination
archived log destination=/home/oracle
channel ORA_AUX_DISK_1: using network backup set from service 192.168.133.120:1521/cdb1
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=117
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_1: starting archived log restore to user-specified destination
archived log destination=/home/oracle
channel ORA_AUX_DISK_1: using network backup set from service 192.168.133.120:1521/cdb1
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=118
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_1: starting archived log restore to user-specified destination
archived log destination=/home/oracle
channel ORA_AUX_DISK_1: using network backup set from service 192.168.133.120:1521/cdb1
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=119
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:02
channel ORA_AUX_DISK_1: starting archived log restore to user-specified destination
archived log destination=/home/oracle
channel ORA_AUX_DISK_1: using network backup set from service 192.168.133.120:1521/cdb1
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=120
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_1: starting archived log restore to user-specified destination
archived log destination=/home/oracle
channel ORA_AUX_DISK_1: using network backup set from service 192.168.133.120:1521/cdb1
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=121
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_1: starting archived log restore to user-specified destination
archived log destination=/home/oracle
channel ORA_AUX_DISK_1: using network backup set from service 192.168.133.120:1521/cdb1
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=122
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_1: starting archived log restore to user-specified destination
archived log destination=/home/oracle
channel ORA_AUX_DISK_1: using network backup set from service 192.168.133.120:1521/cdb1
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=123
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_1: starting archived log restore to user-specified destination
archived log destination=/home/oracle
channel ORA_AUX_DISK_1: using network backup set from service 192.168.133.120:1521/cdb1
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=124
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_1: starting archived log restore to user-specified destination
archived log destination=/home/oracle
channel ORA_AUX_DISK_1: using network backup set from service 192.168.133.120:1521/cdb1
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=125
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_1: starting archived log restore to user-specified destination
archived log destination=/home/oracle
channel ORA_AUX_DISK_1: using network backup set from service 192.168.133.120:1521/cdb1
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=126
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_1: starting archived log restore to user-specified destination
archived log destination=/home/oracle
channel ORA_AUX_DISK_1: using network backup set from service 192.168.133.120:1521/cdb1
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=127
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_1: starting archived log restore to user-specified destination
archived log destination=/home/oracle
channel ORA_AUX_DISK_1: using network backup set from service 192.168.133.120:1521/cdb1
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=128
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_1: starting archived log restore to user-specified destination
archived log destination=/home/oracle
channel ORA_AUX_DISK_1: using network backup set from service 192.168.133.120:1521/cdb1
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=129
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_1: starting archived log restore to user-specified destination
archived log destination=/home/oracle
channel ORA_AUX_DISK_1: using network backup set from service 192.168.133.120:1521/cdb1
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=130
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_1: starting archived log restore to user-specified destination
archived log destination=/home/oracle
channel ORA_AUX_DISK_1: using network backup set from service 192.168.133.120:1521/cdb1
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=131
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_1: starting archived log restore to user-specified destination
archived log destination=/home/oracle
channel ORA_AUX_DISK_1: using network backup set from service 192.168.133.120:1521/cdb1
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=132
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:02
channel ORA_AUX_DISK_1: starting archived log restore to user-specified destination
archived log destination=/home/oracle
channel ORA_AUX_DISK_1: using network backup set from service 192.168.133.120:1521/cdb1
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=133
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_1: starting archived log restore to user-specified destination
archived log destination=/home/oracle
channel ORA_AUX_DISK_1: using network backup set from service 192.168.133.120:1521/cdb1
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=134
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
Finished restore at 25-DEC-22

Performing import of metadata...
Finished Duplicate PDB at 25-DEC-22

RMAN>

成功后，验证：已经有PDB2了。
[oracle@dbserver ~]$ export ORACLE_SID=cdb3
[oracle@dbserver ~]$ sqlplus /nolog

SQL*Plus: Release 19.0.0.0.0 - Production on Sun Dec 25 12:37:08 2022
Version 19.16.0.0.0

Copyright (c) 1982, 2022, Oracle.  All rights reserved.

SQL> conn / as sysdba
Connected.
SQL> show pdbs

CON_ID CON_NAME                      OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
      2 PDB$SEED                      READ ONLY  NO
SQL> show pdbs

CON_ID CON_NAME                      OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
      2 PDB$SEED                      READ ONLY  NO
      3 PDB2                         READ WRITE NO
SQL>

作者: 郑全 时间: 2022-12-25 12:50
本帖最后由郑全于 2022-12-25 12:53 编辑

这个就是一个BUG，具体可以参见：Doc ID 32415846.8，正好碰到了。

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