ORA-65188 on RELOCATE PDB with AVAILABILITY MAX from LOWER version to HIGHER version (文档 ID 2551092.1)

Applies to:

Symptoms

 Recolate pdb with AVAILABILITY MAX from 18.3 to 19c failed with error ORA-65188.

Example:

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> create pluggable database <pdb_name> from <pdb_name>@<dblink> relocate availability max create_file_dest='xxxxx';
create pluggable database <pdb_name> from <pdb_name>@<dblink> relocate availability max create_file_dest='xxxxx'
*
ERROR at line 1::
ORA-65188: CANNOT RELOCATE A PDB OPENED WITH WARNINGS

Changes

Cause

 Recolate pdb with AVAILABILITY MAX from lower version to higher version.

AVAILABILITY MAX means that we don't want customer to get any downtime. Upgrade can be time consuming, and it is a manual action currently.
So AVAILABILITY MAX will still be a downtime for customer application. Hence, we do not allow AVAILABILITY MAX during relocate from lower version to higher version.

Solution

 Recolate pdb from lower version to higher version, without using 'AVAILABILITY MAX'.