当前位置：首页 -> 基础 -> 数据库编程

Oracle12cCDB和PDB表空间管理和配置说明(一)

2015-01-22 21:55:34 · 作者: · 浏览: 27
标签: Oracle12cCDB PDB 空间 管理 配置 说明

?

1 管理CDB中的表空间

CDB表空间的管理和non-CDB 表空间的管理一样，CDB 也有一个实例，在安装的时候指定。

?

?

--查看表空间：

SQL> select instance_name fromv$instance;

INSTANCE_NAME

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

Cndba



SQL> col file_name for a50

SQL> selecttablespace_name,file_id,file_name from dba_data_files;



TABLESPACE_NAME FILE_ID FILE_NAME

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

USERS 6 /u01/app/oracle/oradata/cndba/users01.dbf

UNDOTBS1 4/u01/app/oracle/oradata/cndba/undotbs01.dbf

SYSAUX 3/u01/app/oracle/oradata/cndba/sysaux01.dbf

SYSTEM 1 /u01/app/oracle/oradata/cndba/system01.dbf



--切换container：

SQL> set lin 140

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



CON_ID DBID GUID NAME OPEN_MODE

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

2 4088301206 F7C1E3C96BBF0585E0430A01A8C05459 PDB$SEED READ ONLY

3 426143573F7C209EB1DFC0854E0430A01A8C0B787 PDBCNDBA READ WRITE

4 1231796139 F812DE1B6A8F363AE0430A01A8C0C759 PCNDBA2 READ WRITE



SQL> alter session setcontainer=pcndba2;



Session altered.



SQL> selecttablespace_name,file_id,file_name from dba_data_files;



TABLESPACE_NAME FILE_ID FILE_NAME

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

SYSTEM 12/u01/app/oracle/oradata/cndba/pcndba2/system01.dbf

SYSAUX 13/u01/app/oracle/oradata/cndba/pcndba2/sysaux01.dbf

USERS 14/u01/app/oracle/oradata/cndba/pcndba2/pcndba2_users01.dbf





--表空间具体操作示例

SQL> alter session setcontainer=CDB$ROOT;

Session altered.



SQL> show con_name

CON_NAME

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

CDB$ROOT



SQL> CREATE TABLESPACE dave

2 DATAFILE'/u01/app/oracle/oradata/cndba/pcndba2/dave01.dbf' SIZE 1M

3 AUTOEXTEND ON NEXT 1M;

Tablespace created.



SQL> ALTER TABLESPACE dave ADD

2 DATAFILE'/u01/app/oracle/oradata/cndba/pcndba2/dave02.dbf' SIZE 1M

3 AUTOEXTEND ON NEXT 1M;



Tablespace altered.



--查看：

SQL> selecttablespace_name,file_id,file_name from dba_data_files;



TABLESPACE_NAME FILE_ID FILE_NAME

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

SYSTEM 1/u01/app/oracle/oradata/cndba/system01.dbf

SYSAUX 3/u01/app/oracle/oradata/cndba/sysaux01.dbf

UNDOTBS1 4/u01/app/oracle/oradata/cndba/undotbs01.dbf

USERS 6/u01/app/oracle/oradata/cndba/users01.dbf

DAVE 16/u01/app/oracle/oradata/cndba/pcndba2/dave02.dbf

DAVE 15/u01/app/oracle/oradata/cndba/pcndba2/dave01.dbf





--drop 表空间：

SQL> drop tablespace dave includingcontents and datafiles;

Tablespace dropped.



SQL> selecttablespace_name,file_id,file_name from dba_data_files;



TABLESPACE_NAME FILE_ID FILE_NAME

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

SYSTEM 1/u01/app/oracle/oradata/cndba/system01.dbf

SYSAUX 3/u01/app/oracle/oradata/cndba/sysaux01.dbf

UNDOTBS1 4/u01/app/oracle/oradata/cndba/undotbs01.dbf

USERS 6/u01/app/oracle/oradata/cndba/users01.dbf

2 管理PDB的表空间

?

PDB 表空