PDB$SEED Datafiles Not Appear In CDB_DATA_FILES
(Doc ID 1940806.1)
Last updated on JUNE 11, 2024
Applies to:
Oracle Database Exadata Express Cloud Service - Version N/A and laterGen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A 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/DB_NAME1/system01.dbf
+DATA/DB_NAME1/PDB$SEED/DATAFILE/system01.dbf
+DATA/DB_NAME1/sysaux01.dbf
+DATA/DB_NAME1/undotbs01.dbf
+DATA/DB_NAME1/PDB$SEED/DATAFILE/sysaux01.dbf
+DATA/DB_NAME1/users01.dbf
+DATA/DB_NAME1/undotbs02.dbf
+DATA/DB_NAME1/PDB1/DATAFILE/system.dbf
+DATA/DB_NAME1/PDB1/DATAFILE/sysaux.dbf
+DATA/DB_NAME1/PDB1/DATAFILE/dbai_data01.01.dbf
10 rows selected.
SQL> SQL> select file_name from cdb_data_files;
FILE_NAME
--------------------------------------------------------------------------------
+DATA/DB_NAME1/system01.dbf
+DATA/DB_NAME1/sysaux01.dbf
+DATA/DB_NAME1/undotbs01.dbf
+DATA/DB_NAME1/users01.dbf
+DATA/DB_NAME1/undotbs02.dbf
+DATA/DB_NAME1/PDB1/DATAFILE/system.dbf
+DATA/DB_NAME1/PDB1/DATAFILE/sysaux.dbf
+DATA/DB_NAME1/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
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
| Goal |
| Solution |
| References |