查看是否为cdb
SQL> select name,cdb,open_mode,con_id from v$database; NAME CDB OPEN_MODE CON_ID --------------------------- --------- ------------------------------------------------------------ ---------- ORCL12C YES READ WRITE 0
查看当前容器
SQL> show con_name CON_NAME ------------------------------ CDB$ROOT
查看有多少个PDB
SQL> select con_id, dbid, guid, name , open_mode from v$pdbs; CON_ID DBID GUID NAME OPEN_MODE ---------- ---------- ------------------------------------------------ ---------------------------- ------------------------------ 2 4096928455 FF675156E40B2F3DE043B303A8C00283 PDB$SEED READ ONLY 3 2301438674 FF6761430B3E311EE043B303A8C00BA6 PDBORCL READ WRITE
关闭PDB
SQL> alter session set container=PDBORCL; Session altered. SQL> shutdown immediate Pluggable Database closed. SQL> show con_name CON_NAME ------------------------------ PDBORCL SQL> alter session set container=CDB$ROOT; Session altered. SQL> select con_id, dbid, guid, name , open_mode from v$pdbs; CON_ID DBID GUID NAME OPEN_MODE ---------- ---------- ------------------------------------------------ ---------------------------- ------------------------------ 2 4096928455 FF675156E40B2F3DE043B303A8C00283 PDB$SEED READ ONLY 3 2301438674 FF6761430B3E311EE043B303A8C00BA6 PDBORCL MOUNTED
启动PDB
SQL> alter session set container=PDBORCL; Session altered. SQL> STARTUP Pluggable Database opened.
进入PDB做一些日常操作
SQL> select FILE_NAME,TABLESPACE_NAME ,file_id from dba_data_files; FILE_NAME TABLESPACE_NAME FILE_ID ------------------------------------------------------------------------------------ ---------------------------- ---------- /u01/app/oracle/oradata/orcl12c/pdborcl/example01.dbf EXAMPLE 11 /u01/app/oracle/oradata/orcl12c/pdborcl/SAMPLE_SCHEMA_users01.dbf USERS 10 /u01/app/oracle/oradata/orcl12c/pdborcl/sysaux01.dbf SYSAUX 9 /u01/app/oracle/oradata/orcl12c/pdborcl/system01.dbf SYSTEM 8
创建PDB
SQL> CREATE PLUGGABLE DATABASE pdbtest1 ADMIN USER pdbtest1admin IDENTIFIED BY pdbtest1admin 2 STORAGE (MAXSIZE 2G MAX_SHARED_TEMP_SIZE 100M) 3 DEFAULT TABLESPACE test1tb1 4 DATAFILE ‘/u01/app/oracle/oradata/orcl12c/pdbtest1/test1tb101.dbf‘ size 50m autoextend off 5 FILE_NAME_CONVERT =(‘/u01/app/oracle/oradata/orcl12c/pdbseed‘,‘/u01/app/oracle/oradata/orcl12c/pdbtest1‘); Pluggable database created.