My Oracle Support Banner

Datafile on Standby Database is created under incorrect directory (Doc ID 2346623.1)

Last updated on MARCH 10, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

This problem may happen on CDB (Container Database) with Data Guard + OMF (Oracle Managed Files).
When new PDB is created on Primary Database, new PDB is also created on Standby Database.

If datafiles are located under ASM, file path is specified by naming method of OMF.
File path defined by OMF contains GUID as follows.
So all datafiles of specific PDB should be located under same file path which has GUID.

* Expected File Path

SQL> select con_id, file#, name from v$datafile where con_id = (select pdb_id from cdb_pdbs where pdb_name='PDB1') order by 1,2;

CON_ID FILE# NAME
---------- ---------- --------------------------------------------------------------------------------
5 152 +<PATH>/DATAFILE/<FILE_NAME>
5 153 +<PATH>/DATAFILE/<FILE_NAME>
5 154 +<PATH>/DATAFILE/<FILE-NAME> 
5 155 +<PATH>/DATAFILE/<FILE_NAME>
5 156 +<PATH>/DATAFILE/<FILE_NAME>

But on Standby Database, some data files are located under different file path as follows.
At this case, tablespace PDB1TBS(file#160) and TESTBS(file#161) are created under wrong file path.

* Unexpected File Path

SQL> select con_id, file#, name from v$datafile where con_id = (select pdb_id from cdb_pdbs where pdb_name='PDB1') order by 1,2;

CON_ID FILE# NAME
---------- ---------- --------------------------------------------------------------------------------
6 157 +<PATH>/DATAFILE/<FILE_NAME>
6 158 +<PATH>/DATAFILE/<FILE_NAME>
6 159 +<PATH>/DATAFILE/<FILE_NAME>
6 160 +<PATH>/DATAFILE/<FILE_NAME>
6 161 +<PATH>/DATAFILE/<FILE_NAME>


And at above case, "show pdbs" command does not show existing PDB name on Standby Database.
But cdb_pdbs view show all existing PDB on Standby Database.

Changes

This problem may happen  on CDB (Container Database) with Data Guard + OMF.

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.