Hi all, I've installed and configurated a Rac 2 nodes database version 19.3. (CDB + 2 PDBS)
After the installation i applied the patches:
- 30869156 for DB
- 30899722 for GRID
Now when I run sqlplus or rman i see:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.7.0.0.0
In my database the compatible after the patches was: 19.0.0.
When i tried to restore a foreign pluggable database with RMAN I've this error:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 07/21/2020 17:20:52
ORA-19870: error while restoring backup piece /mnt/backup/SIMCORP/export.bck
ORA-19690: backup piece release 19.3.0.0.0 incompatible with Oracle release 19.0.0.0.0
or when i tried to clone a pluggable database using a dblink:
CREATE PLUGGABLE DATABASE XXXX FROM XXXX@clone_link ;
I've this error:
ERROR at line 1: ORA-65294: PDB's compatible parameter value (19.7.0.0.0) is higher than CDB's compatible parameter value (19.0.0.0.0).
For this reasons i change in my cdb database the parameter compatible = 19.7.0 and restart the cdb.
both rman and clone pdbs work fine after the change.
Now I run an expdp and I received the error:
Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
ORA-39001: invalid argument value
ORA-39021: Database compatibility version 19.7.0.0.0 is not supported.
How can i run this expdp?
Why did the patches not change my compatible parameter?
My V$version view show:
BANNER: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
BANNER_FULL: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.7.0.0.0
BANNER_LEGACY: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production