oracle 容器

容器

判断是否安装cdb

SQL> select name,cdb from v$database;

NAME		   CDB
------------------ ------
CDB		   YES

CDB应该有2个容器,CDBROOT和PDBSEED

SQL> select con_id,name from v$containers;

CON_ID NAME
------------------------------
	 1 CDB$ROOT
	 2 PDB$SEED

查询每个容器关联的数据文件

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

CON_ID FILE_NAME
--------------------------------------------------------------------------------
	 1 /u01/app/oracle/oradata/CDB/system01.dbf
	 1 /u01/app/oracle/oradata/CDB/users01.dbf
	 1 /u01/app/oracle/oradata/CDB/undotbs01.dbf
   1 /u01/app/oracle/oradata/CDB/sysaux01.dbf

可插拔数据库

查看可插拔数据库的状态

SQL> select pdb_id,pdb_name,status from cdb_pdbs;

    PDB_ID PDB_NAME STATUS
----------
	 3 MYPDB NORMAL
	 2 PDB$SEED NORMAL

查看可插拔数据库是否在运行

SQL> select con_id,name,open_mode from v$pdbs;

    CON_ID NAME OPEN_MODE
----------
	 2 PDB$SEED READ ONLY
	 3 MYPDB READ WRITE