Database Administration (MOSC)

MOSC Banner

pdb$seed directory structure in ASM (OMF)

edited Jun 18, 2019 5:05AM in Database Administration (MOSC) 1 commentAnswered

Hi

Oracle 19.3

Oracle Enterprise Linux 7.6

ASM (OMF)

I was just wondering, is there any particular reason why pdb$seed pluggable database tempfile is in different directory structure..?

Also, pdb$seed GUID comes from TEMPFILE directory structure. Why not from DATAFILE structure..?

GUID: 8A08AAA467397105E0531302330A8F53DATAFILE: +DATA/ORCL/86B637B62FE07A65E053F706E80A27CA/DATAFILE/..TEMPFILE: +DATA/ORCL/8A08AAA467397105E0531302330A8F53/TEMPFILE/..

SQL> show pdbs    CON_ID CON_NAME                       OPEN MODE  RESTRICTED---------- ------------------------------ ---------- ----------         2 PDB$SEED                       READ ONLY  NO         4 PDB5                           READ WRITE NOSQL> col pdb_name for a15;select PDB_ID, PDB_NAME, GUID from cdb_pdbs;    PDB_ID PDB_NAME        GUID---------- --------------- --------------------------------         4 PDB5            8A1F4DCA366E1903E0531302330AD132         2 PDB$SEED        8A08AAA467397105E0531302330A8F53SQL> alter session set container=pdb$seed;col file_name for a100;select FILE_NAME, file_id from dba_data_files;FILE_NAME                                                                         FILE_ID------------------------------------------------------------------------------ ----------+DATA/ORCL/86B637B62FE07A65E053F706E80A27CA/DATAFILE/system.270.1009560797              5+DATA/ORCL/86B637B62FE07A65E053F706E80A27CA/DATAFILE/sysaux.271.1009560797              6+DATA/ORCL/86B637B62FE07A65E053F706E80A27CA/DATAFILE/undotbs1.272.1009560797            8             SQL> col name for a90;select FILE#, con_id, name from v$tempfile;     FILE#     CON_ID NAME---------- ---------- -------------------------------------------------------------------------         2          2 +DATA/ORCL/8A08AAA467397105E0531302330A8F53/TEMPFILE/temp.273.1009560817

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center