pdb$seed directory structure in ASM (OMF)
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