Oracle12c日常pdb创建、开关和删除…

1.1  Oracle12c日常pdb创建、开关和删除操作

1.1.1  直接创建pdb数据库

CREATE PLUGGABLE DATABASEtestdb

ADMIN USER testdbdb IDENTIFIEDBY testdb

STORAGE (MAXSIZE 2GMAX_SHARED_TEMP_SIZE 100M)

DEFAULT TABLESPACE testdbdbDATAFILE '/opt/oracle//datafile/testdbdb_001.dbf' SIZE 25MAUTOEXTEND ON;

1.1.2  以现有模板创建pdb数据库，

CREATE PLUGGABLE DATABASEtestdbdb

ADMIN USERtestdbdb  IDENTIFIED BY testdbdbroles=(dba)

file_name_convert=('/inm/data/oracle12c/oradata/testdb/pdbseed','/inm/data/oracle12c/oradata/testdb/testdbdb');

1.1.3  删除pdb数据库

DROP PLUGGABLE DATABASE testdbINCLUDING DATAFILES

1.1.4  打开关闭单个pdb数据库

alter pluggable database testdbopen

alter pluggable database testdbclose immediate;

1.1.5  All Pdb开关操作

开启所有的pdb

alter pluggable database allopen;

 alterpluggable database all close immediate;

1.1.6  切换pdb

切换到pdb1

SYS@cdb >alter session setcontainer=pdb1;

1.1.7  当前pdb状态

show pdbs;

[oracle@inmdb03 expdp]$ sqlplus"/as sysdba"

 

SQL*Plus: Release 12.1.0.2.0Production on Thu May 7 17:55:42 2015

 

Copyright (c) 1982, 2014,Oracle.  All rights reserved.

 

 

Connected to:

Oracle Database 12c EnterpriseEdition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, RealApplication Clusters, Automatic Storage Management,OLAP,

Advanced Analytics and RealApplication Testing options

 

SQL> show pdbs;

 

   CON_IDCON_NAME                      OPEN MODE  RESTRICTED

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

        2PDB$SEED                      READ ONLY  NO

        3testdb                         MOUNTED

        4INMWAP                        MOUNTED

        5testdbTEST                     MOUNTED

        6NMSVIP                        MOUNTED

        7testdbBIZ                      MOUNTED

SQL>