Storage Management (ASM ACFS DNFS ODM) (MOSC)

MOSC Banner

ASM directory structure for PDB data files

edited May 28, 2015 10:02AM in Storage Management (ASM ACFS DNFS ODM) (MOSC) 2 commentsAnswered

The default ASM directory structure for a 12c pluggable database appears to be: toplevel/name of CDB/GUID of PDB/tblspce.260.874748939, thus:

SQL> select CON_ID,name,GUID from v$pdbs;

    CON_ID NAME GUID

---------- ------------------------------ --------------------------------

         2 PDB$SEED 11A20738A24E4F0DE053198E680A46DB

         3 FORMS 11A21BB0B7BB5767E053198E680AE16E

SQL> select con_id,file_name from cdb_data_files order by con_id;

     CON_ID FILE_NAME

---------- ----------------------------------------------------------------------------------------------------

         1 +DATA_DG/POCDB/DATAFILE/system.319.874748481

         1 +DATA_DG/POCDB/DATAFILE/users.320.874748515

         1 +DATA_DG/POCDB/DATAFILE/undotbs1.322.874748517

         1 +DATA_DG/POCDB/DATAFILE/sysaux.321.874748449

         3 +DATA_DG/POCDB/11A21BB0B7BB5767E053198E680AE16E/DATAFILE/sysaux.260.874748939

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