ORACLE 中查看CDB、PDB数据文件

Step1: 切换到相应的PDB下，执行以下命令：

SQL> alter session set container=PDB1;
Session altered.
SQL>

Step2 :执行命令来查看：

SQL> select FILE_NAME,FILE_ID,TABLESPACE_NAME from dba_data_files;
FILE_NAME FILE_ID TABLESPACE_NAME
-------------------------------------------------- ---------- ------------------------------
/u02/oradata/CDB1/pdb1/system01.dbf 9 SYSTEM
/u02/oradata/CDB1/pdb1/sysaux01.dbf 10 SYSAUX
/u02/oradata/CDB1/pdb1/undotbs01.dbf 11 UNDOTBS1
/u02/oradata/CDB1/pdb1/users01.dbf 12 USERS
SQL>

注意： 对于容器id(con_id)可以通过v$pdbs视图或show pdbs命令进行查看。

SQL>
SQL> show parameter db_create_file_dest
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_create_file_dest string /u02/oradata
SQL> 

• CDB root

SQL>
SQL> show con_name;
CON_NAME
------------------------------
CDB$ROOT
SQL> select file_name from dba_data_files;
FILE_NAME
--------------------------------------------------
/u02/oradata/CDB1/system01.dbf
/u02/oradata/CDB1/sysaux01.dbf
/u02/oradata/CDB1/undotbs01.dbf
/u02/oradata/CDB1/users01.dbf
SQL> 

• PDB

SQL>
SQL> alter session set container=PDB1;
Session altered.
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
3 PDB1 READ WRITE NO
SQL> show con_name;
CON_NAME
------------------------------
PDB1
SQL> select file_name from dba_data_files;
FILE_NAME
--------------------------------------------------
/u02/oradata/CDB1/pdb1/system01.dbf
/u02/oradata/CDB1/pdb1/sysaux01.dbf
/u02/oradata/CDB1/pdb1/undotbs01.dbf
/u02/oradata/CDB1/pdb1/users01.dbf
SQL>