查看是否为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
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
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.
手机扫一扫
移动阅读更方便
你可能感兴趣的文章