Select of Encrypted Tablespace in Standby Fails with ORA-28304
(Doc ID 2632789.1)
Last updated on JULY 06, 2021
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 and later
Oracle Database Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
For the purposes of this document, the following fictitious environment is used as an example to describe the procedure:
Pluggable Database Names: SOURCE_PDB, TEST_PDB,
Tablespace Name: TEST_TBS
Table Name: TEST_TABLE
Directory Name: /u02/app/oracle/oradata/ORCL/ and all subdirectories
A PDB containing encrypted tablespaces can be successfully cloned and opened at the primary and active dataguard standby site without any errors.
However, a select of a table in the encrypted tablespaces will fail with ORA-28304 at Standby site. Oracle RAC(Real Application Clusters) and Automatic Storage Management (ASM) can be excluded from a condition to see this symptom.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document