12c PDB文件名中有GUID

12c PDB文件名中有GUID

+DATADG/SCMB/69A58713CAC2024AE053630D2C79F6C9/DATAFILE/system.427.976378719
+DATADG/SCMB/69A58713CAC2024AE053630D2C79F6C9/DATAFILE/sysaux.426.976378719
+DATADG/SCMB/DATAFILE/users.382.976378549
+DATADG/SCMB/69A58713CAC2024AE053630D2C79F6C9/DATAFILE/undotbs1.429.976378719
+DATADG/SCMB/DATAFILE/undotbs2.390.976378549
+DATADG/SCMB/69A5ED1A3F260110E053630D2C79B14A/DATAFILE/system.380.976378663  --
+DATADG/SCMB/69A5ED1A3F260110E053630D2C79B14A/DATAFILE/sysaux.381.976378663
+DATADG/SCMB/69A5ED1A3F260110E053630D2C79B14A/DATAFILE/undotbs1.379.976378665
+DATADG/SCMB/69A5ED1A3F260110E053630D2C79B14A/DATAFILE/undo_2.444.976378665
+DATADG/SCMB/69A5ED1A3F260110E053630D2C79B14A/DATAFILE/users.424.976378665 
SQL> select PDB_ID,PDB_NAME,CON_UID,GUID from dba_pdbs
    PDB_ID PDB_NAME                CON_UID GUID
---------- -------------------- ---------- --------------------------------
         3 SPCMB                1074306366 69A5ED1A3F260110E053630D2C79B14A    --create service
         2 PDB$SEED              943292160 69A58713CAC2024AE053630D2C79F6C9
SQL> 
SQL> col INSTANCE_NAME for a30
SQL> /
 
    CON_ID CON_NAME             INSTANCE_NAME                     CON_UID GUID                             STATE          RES
---------- -------------------- ------------------------------ ---------- -------------------------------- -------------- ---
         3 SPCMB                scmb1                          1074306366 69A5ED1A3F260110E053630D2C79B14A OPEN           NO
         3 SPCMB                scmb2                          1074306366 69A5ED1A3F260110E053630D2C79B14A OPEN           NO
         3 SPCMB                scmbdg1                        1074306366 69A5ED1A3F260110E053630D2C79B14A OPEN           NO
         3 SPCMB                scmbdg2                        1074306366 69A5ED1A3F260110E053630D2C79B14A OPEN           NO
SQL> l 
  1* select * from dba_pdb_saved_states
SQL>

ASM官网上有介绍
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/ostmg/asm-files-directories-templates.html#GUID-21305D87-1D0C-442C-97AE-DE8ACA979F91
Fully Qualified File Name Form

You can use a fully qualified form for referencing existing Oracle ASM files in Oracle ASM operations,
except for disk group creation. This form is the Oracle ASM file name that Oracle ASM automatically generates when an Oracle ASM file is created.
A fully qualified file name has the following form in a non-multitenant environment:
+diskgroup/dbname/filetype/filetypetag.file.incarnation
 
With multitenant databases, a fully qualified file name has the following form:
+diskgroup/cdb/pdb_guid/filetype/filetypetag.file.incarnation
 
The fields of the fully qualified file name are:
•+diskgroup is the disk group name preceded by a plus sign.
You can think of the plus sign (+) as the root directory of the Oracle ASM file system, similar to the slash (/) on UNIX or Linux computers.
•dbname is the DB_UNIQUE_NAME of the database to which the file belongs.
•filetype is the Oracle file type and can be one of the file types shown in Table 5-3.
•filetypetag is type-specific information about the file and can be one of the tags shown in Table 5-3.
•file.incarnation is the file/incarnation pair, used to ensure uniqueness.
•cdb is the name of the CDB
•pdb_guid is the PDB GUID value.
This entry was posted in 学习. Bookmark the permalink.