暂无图片
分享
秋语落
2020-03-15
12C中PDB克隆或者Relocate(单实例至RAC)问题

存在Oracle19c Rac数据库,共享存储使用ASM,以及Oracle19c单实例,数据文件为文件系统,在Rac环境通过PDB克隆或者Relocate单实例数据库时总是报错,无论指定CREATE_FILE_DEST、FILE_NAME_CONVERT 、PATH_PREFIX 、DB_CREATE_FILE_DEST 、PDB_FILE_NAME_CONVERT都无法实现将单实例的PDB克隆或者Relocate到Rac集群环境,但是若是两个都是单实例(存储都是文件系统)时正常,是在12c中不支持单实例至Rac此功能吗。

Rac发出Relocate命令
SQL> CREATE PLUGGABLE DATABASE cwsavpd FROM sapdb@DBLINK_CDB_ORCL RELOCATE PATH_PREFIX = ‘+DATA01’;
CREATE PLUGGABLE DATABASE cwsavpd FROM sapdb@DBLINK_CDB_ORCL RELOCATE PATH_PREFIX = ‘+DATA01’
*
ERROR at line 1:
ORA-65169: error encountered while attempting to copy file
/u01/oracle/oradata/SOAWARE/users01.dbf
ORA-17628: Oracle error 19505 returned by remote Oracle server
ORA-19505: failed to identify file “”

Rac对应的alter日志
ORA-65169 signalled during: CREATE PLUGGABLE DATABASE cwsavpd FROM sapdb@DBLINK_CDB_ORCL RELOCATE PATH_PREFIX = ‘+DATA01’…

单实例对应的alter日志
2020-03-16T05:34:26.219095+08:00
SAPDB(4): AUDSYS.AUD$UNIFIED (SQL_TEXT) - CLOB populated
2020-03-16T05:34:30.303579+08:00
WARNING: Clusterware not configured
2020-03-16T05:34:30.304551+08:00
Errors in file /u01/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_40843.trc:
ORA-19505: failed to identify file “+DATA01/CWDB/A0E300B76FF9164EE055020C2926E7AB/DATAFILE/users.302.1035149761”
ORA-17503: ksfdopn:2 Failed to open file +DATA01/CWDB/A0E300B76FF9164EE055020C2926E7AB/DATAFILE/users.302.1035149761
ORA-15001: diskgroup “DATA01” does not exist or is not mounted
ORA-15374: invalid cluster configuration

收藏
分享
1条回答
默认
最新
秋语落
问题已关闭: 问题已经得到解决
暂无图片 评论
暂无图片 有用 1
打赏 0
叙利亚悍匪
2022-08-23
怎么解决的?可以发一下你的解决方案嘛?
回答交流
Markdown


请输入正文
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏