克隆过程遇到问题1:compatible不一致
ORA-65294: PDB’s compatible parameter value (12.2.0.1.0) is higher than CDB’s
compatible parameter value (12.2.0.0.0).
解决办法:
目标端将CDB的compatible进行设置,例如:
alter system set compatible=‘12.2.0.1.0’ scope=spfile;
克隆pdb遇到问题2:权限不足,DBA也不行
ERROR at line 1:
ORA-17628: Oracle error 1031 returned by remote Oracle server
ORA-01031: insufficient privileges
解决办法:
给dba权限也不够,需要额外的权限;grant create pdb to xxx;
克隆pdb遇到问题3:ORA-00600: internal error code
ERROR at line 1:
ORA-17627: ORA-01041: internal error. hostdef extension doesn’t exist
ORA-17627: ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [17114], [0x7FD1B8C6AF20], [], [],
[], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [17112], [0x7FD1B8C6AF20], [], [],
[], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [17147], [0x7FD1B8C6AF20], [], [],
[], [], [], [], [], [], [], []
Process ID:
Session ID: 2070 Serial number: 45834
解决办法:
在sqlnet.ora里增加
DISABLE_OOB = ON
克隆pdb遇到问题4:归档备备份走了
ORA-65345: cannot refresh pluggable database
ORA-65345: cannot refresh pluggable database Cause: The foreign archive log required for refreshing the pluggable database was not found.
Action: Re-create the refresh pluggable database and ensure that archive logging is enabled for the source multitenant container database (CDB).
这个是归档被备份走了,把归档还原一下就ok了.
克隆pdb遇到问题5:克隆后无法打开pdb,或者pdb处于受限模式
查询PDB_PLUG_IN_VIOLATIONS试图,看看具体有什么问题,根据错误信息处理,一般情况是由于克隆到新位置后,数据字典版本不一致导致,datapatch一下即可。
./OPatch/datapatch -verbose -pdb SHENJIDB
克隆pdb遇到问题6:failed to identify file
ERROR at line 1:
ORA-65169: error encountered while attempting to copy file
+DATA/NXRS3DB/74B18075EF4D2650E0537BCCEC0AD681/DATAFILE/users.312.985596303
ORA-17628: Oracle error 19505 returned by remote Oracle server
ORA-19505: failed to identify file “”
解决办法:
一般是源端与目标端数据文件位置变化导致的,这种情况下一般源端手动创建数据库文件,目标端无法自动创建,需要用create_file_dest来指定新库路径:create pluggable xxx create_file_dest=’+DATA’
这个一直没有测试成功,不知道网络上是否有大佬实验过吗?