PDB$SEED Datafiles Not Appear In CDB_DATA_FILES (Doc ID 1940806.1)

Last updated on DECEMBER 06, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Goal

PDB$SEED datafiles not appear in CDB_DATA_FILES regardless of status of PDB$SEED
SQL> select cdb from v$database;

CDB
---
YES

SQL> show con_name

CON_NAME
------------------------------
CDB$ROOT
SQL> select name from v$datafile;


NAME
--------------------------------------------------------------------------------
+DATA/UHKPLGC1/system01.dbf
+DATA/UHKPLGC1/PDB$SEED/DATAFILE/system01.dbf
+DATA/UHKPLGC1/sysaux01.dbf
+DATA/UHKPLGC1/undotbs01.dbf
+DATA/UHKPLGC1/PDB$SEED/DATAFILE/sysaux01.dbf
+DATA/UHKPLGC1/users01.dbf
+DATA/UHKPLGC1/undotbs02.dbf
+DATA/UHKPLGC1/PDB1/DATAFILE/system.dbf
+DATA/UHKPLGC1/PDB1/DATAFILE/sysaux.dbf
+DATA/UHKPLGC1/PDB1/DATAFILE/dbai_data01.01.dbf

10 rows selected.

SQL> SQL> select file_name from cdb_data_files;


FILE_NAME
--------------------------------------------------------------------------------
+DATA/UHKPLGC1/system01.dbf
+DATA/UHKPLGC1/sysaux01.dbf
+DATA/UHKPLGC1/undotbs01.dbf
+DATA/UHKPLGC1/users01.dbf
+DATA/UHKPLGC1/undotbs02.dbf
+DATA/UHKPLGC1/PDB1/DATAFILE/system.dbf
+DATA/UHKPLGC1/PDB1/DATAFILE/sysaux.dbf
+DATA/UHKPLGC1/PDB1/DATAFILE/dbai_data01.01.dbf

8 rows selected.   <<<<----------- No information about the SEED datafiles.

SQL> SQL> select con_id,name,open_mode from v$pdbs order by 1;


 CON_ID NAME                           OPEN_MODE
---------- ------------------------------ ----------
      2 PDB$SEED                       READ ONLY
      3 PDB1                           READ WRITE

 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms