环境:oracle 19c 19.15 +linux 7.9
源端为:单机19.15 cdb,目标端rac 19.15 cdb
把单机下面的一个pdb使用下面的语句在线 复制 到 远程rac,
duplicate pluggable database pdb1 to cdb3 from active database ;
可以成功,但在OPEN这个PDB1时,报警文件中,总有提示
WARNING: Pluggable Database HEAMONITOR with pdb id - 3 is
altered with errors or warnings. Please look into
PDB_PLUG_IN_VIOLATIONS view for more details.
sql>select time,cause,message,status ,action from PDB_PLUG_IN_VIOLATIONS where con_id=3 order by 1
TIME CAUSE MESSAGE STATUS ACTION
--------------------------------------- ----------------- -------------------------------------------------- --------- ------------------------------
24-OCT-22 09.31.51.619406 PM OPTION Database option RAC mismatch: PDB installed version NULL. CDB installed version 19.0.0.0.0. PENDING Fix the database option in the PDB or the CDB
sql>select comp_name,version,status from dba_registry;
COMP_NAME VERSION STATUS
---------------------------------------- ------------------------------ ----------------------
...
Oracle Real Application Clusters 19.0.0.0.0 OPTION OFF
...
看到 Doc ID 2415014.1 ,是RAC 到NON-RAC,可以
SQL> exec dbms_registry.OPTION_OFF('RAC');
但我这里是 non-rac 到rac,
那执行
SQL> exec dbms_registry.OPTION_ON('RAC');
结果报错。没有这个OPTION_ON的过程。
最后,解决办法为:
在PDB中,执行下面语句,解决,再去启动PDB,不再报警,组件也变成valid:
@?/rdbms/admin/catclust.sql
...
Oracle Real Application Clusters 19.0.0.0.0 VALID
|