Oracle12cCDB&PDB基本维护
1.查看数据库是否为多租户数据库（CDB）
SQL> SELECT CDB FROM V$DATABASE;
成都创新互联专注于成都网站制作、网站设计、网页设计、网站制作、网站开发。公司秉持“客户至上,用心服务”的宗旨,从客户的利益和观点出发,让客户在网络营销中找到自己的驻足之地。尊重和关怀每一位客户，用严谨的态度对待客户，用专业的服务创造价值，成为客户值得信赖的朋友，为客户解除后顾之忧。
CDB
YES
2.查看当前容器名字
以下命令只能在12c客户端输入
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED 2 PDB$SEED READ ONLY NO
3 ORCLPDB READ WRITE NOSQL> show con_name
CON_NAME
CDB$ROOT
或
select sys_context('userenv', 'con_name') "Container DB" from dual;
3.pdb管理
3.1直接创建pdb数据库
SQL> CREATE PLUGGABLE DATABASE testdb
2 ADMIN USER testdbdb IDENTIFIED BY testdb
3 STORAGE (MAXSIZE 2G MAX_SHARED_TEMP_SIZE 100M)
4 DEFAULT TABLESPACE testdbdb DATAFILE 'C:\app\Administrator\virtual\oradata\orcl\testdbdb_001.dbf' SIZE 25M AUTOEXTEND ON;
DEFAULT TABLESPACE testdbdb DATAFILE 'C:\app\Administrator\virtual\oradata\orcl\testdbdb_001.dbf' SIZE 25M AUTOEXTEND ON
*
第 4 行出现错误:
ORA-65016: 必须指定 FILE_NAME_CONVERT
SQL> set line 1000
SQL> show parameter db_create_file_dest
NAME TYPE VALUE
db_create_file_dest string
SQL> alter system set db_create_file_dest='C:\app\Administrator\virtual\oradata';
系统已更改。
SQL> show parameter db_create_file_dest
NAME TYPE VALUE
db_create_file_dest string C:\app\Administrator\virtual\o
radata
切换到root容器创建
SQL> alter session set container=cdb$root;
会话已更改。
SQL> show con_name
CON_NAME
------------------------------ CDB$ROOT
SQL> CREATE PLUGGABLE DATABASE pdb2 ADMIN USER pdb2 IDENTIFIED BY pdb2
2 STORAGE (MAXSIZE 2G MAX_SHARED_TEMP_SIZE 100M)
3 DEFAULT TABLESPACE pdb2
4 DATAFILE 'C:\app\Administrator\virtual\oradata\orcl\pdb2\pdb201.dbf' SIZE 250M
5 AUTOEXTEND ON 6 PATH_PREFIX = 'C:\app\Administrator\virtual\oradata\orcl\pdb2'
7 FILE_NAME_CONVERT = ('C:\app\Administrator\virtual\oradata\orcl\DATAFILE\O1_MF_S
8 YSTEMB9GXSYNO.DBF', 'C:\app\Administrator\virtual\oradata\orcl\pdb2\system01.dbf'
9 ,'C:\app\Administrator\virtual\oradata\orcl\DATAFILE\O1_MF_SYSAUXB9GXSYLX.DBF'
10 ,'C:\app\Administrator\virtual\oradata\orcl\pdb2\sysaux01.dbf'
11 ,'C:\app\Administrator\virtual\oradata\orcl\DATAFILE\PDBSEED_TEMP012017-12-13_15
12 -02-15-PM.dbf','C:\app\Administrator\virtual\oradata\orcl\pdb2\temp01.dbf');
CREATE PLUGGABLE DATABASE pdb2 ADMIN USER pdb2 IDENTIFIED BY pdb2
*
第 1 行出现错误:
ORA-65005: 文件缺少文件名模式或其文件名模式无效 - C:\APP\ADMINISTRATOR\VIRTUAL\ORADATA\ORCL\PDBSEED\SYSTEM01.DBF
SQL> set line 200
SQL> col file_name for a80
SQL> select con_id,file_name from cdb_data_files order by 1;
CON_ID FILE_NAME 1 C:\APP\ADMINISTRATOR\VIRTUAL\ORADATA\ORCL\SYSTEM01.DBF
1 C:\APP\ADMINISTRATOR\VIRTUAL\ORADATA\ORCL\USERS01.DBF
1 C:\APP\ADMINISTRATOR\VIRTUAL\ORADATA\ORCL\UNDOTBS01.DBF
1 C:\APP\ADMINISTRATOR\VIRTUAL\ORADATA\ORCL\SYSAUX01.DBF
3 C:\APP\ADMINISTRATOR\VIRTUAL\ORADATA\ORCL\ORCLPDB\UNDOTBS01.DBF
3 C:\APP\ADMINISTRATOR\VIRTUAL\ORADATA\ORCL\ORCLPDB\USERS01.DBF
3 C:\APP\ADMINISTRATOR\VIRTUAL\ORADATA\ORCL\ORCLPDB\SYSTEM01.DBF
3 C:\APP\ADMINISTRATOR\VIRTUAL\ORADATA\ORCL\ORCLPDB\SYSAUX01.DBF 已选择 8 行。
SQL>create pluggable database pdb2 admin user pdb2 identified by oracle file_name_convert=('C:\app\Administrator\virtual\oradata\orcl\pdbseed','C:\app\Administrator\virtual\oradata\orcl\pdb2');
SQL> alter pluggable database pdb2 open read write;
SQL> create TABLESPACE pdb2
2 DATAFILE 'C:\app\Administrator\virtual\oradata\orcl\pdb2\pdb201.dbf' SIZE 250M
3 AUTOEXTEND ON
4 ;
表空间已创建。
SQL> alter user pdb2 DEFAULT TABLESPACE pdb2;
用户已更改。
SQL> select con_id,file_name from cdb_data_files order by 1;
CON_ID FILE_NAME 4 C:\APP\ADMINISTRATOR\VIRTUAL\ORADATA\ORCL\PDB2\SYSTEM01.DBF
4 C:\APP\ADMINISTRATOR\VIRTUAL\ORADATA\ORCL\PDB2\SYSAUX01.DBF
4 C:\APP\ADMINISTRATOR\VIRTUAL\ORADATA\ORCL\PDB2\UNDOTBS01.DBF
4 C:\APP\ADMINISTRATOR\VIRTUAL\ORADATA\ORCL\PDB2\PDB201.DBF
SQL> DROP PLUGGABLE DATABASE pdb2 INCLUDING DATAFILES;DROP PLUGGABLE DATABASE pdb2 INCLUDING DATAFILES *
第 1 行出现错误:
ORA-65025: 未在所有实例上关闭可插入数据库 PDB2。
SQL> alter pluggable database pdb2 close 2 ;
插接式数据库已变更。
SQL> DROP PLUGGABLE DATABASE pdb2 INCLUDING DATAFILES;
插接式数据库已删除。
CREATE PLUGGABLE DATABASE pdb2 ADMIN USER pdb2 IDENTIFIED BY pdb2
STORAGE (MAXSIZE 2G MAX_SHARED_TEMP_SIZE 100M)
PATH_PREFIX = 'C:\app\Administrator\virtual\oradata\orcl\pdb2'
FILE_NAME_CONVERT = ('C:\app\Administrator\virtual\oradata\orcl\pdbseed\system01.dbf'
, 'C:\app\Administrator\virtual\oradata\orcl\pdb2\system01.dbf'
,'C:\app\Administrator\virtual\oradata\orcl\pdbseed\sysaux01.dbf'
,'C:\app\Administrator\virtual\oradata\orcl\pdb2\sysaux01.dbf'
,'C:\app\Administrator\virtual\oradata\orcl\pdbseed\TEMP012017-12-12_14-30-01-009-PM.dbf'
,'C:\app\Administrator\virtual\oradata\orcl\pdb2\temp01.dbf',
'C:\app\Administrator\virtual\oradata\orcl\pdbseed\UNDOTBS01.DBF'
,'C:\app\Administrator\virtual\oradata\orcl\pdb2\UNDOTBS01.DBF')；
SQL> alter pluggable database pdb2 open read write;
插接式数据库已变更。
SQL> alter session set container=pdb2;
会话已更改。
SQL> create TABLESPACE pdb2 DATAFILE 'C:\app\Administrator\virtual\oradata\orcl\pdb2\pdb201.dbf' SIZE 250M AUTOEXTEND ON;
表空间已创建。
SQL> alter user pdb2 DEFAULT TABLESPACE pdb2;
用户已更改。
SQL> set line 1000
SQL> col file_name format A100
SQL> select con_id,file_name from cdb_data_files order by 1;
CON_ID FILE_NAME 4 C:\APP\ADMINISTRATOR\VIRTUAL\ORADATA\ORCL\PDB2\SYSTEM01.DBF
4 C:\APP\ADMINISTRATOR\VIRTUAL\ORADATA\ORCL\PDB2\SYSAUX01.DBF
4 C:\APP\ADMINISTRATOR\VIRTUAL\ORADATA\ORCL\PDB2\UNDOTBS01.DBF
4 C:\APP\ADMINISTRATOR\VIRTUAL\ORADATA\ORCL\PDB2\PDB201.DBF3.2 unplug
SQL> alter pluggable database pdb2 unplug into 'c:\pdb2.xml'; alter pluggable database pdb2 unplug into 'c:\pdb2.xml'
*
第 1 行出现错误:
ORA-65025: 未在所有实例上关闭可插入数据库 PDB2。
SQL> alter pluggable database pdb2 close;
插接式数据库已变更。
SQL> alter pluggable database pdb2 unplug into 'C:\app\Administrator\virtual\oradata\pdb2.xml';
插接式数据库已变更。
unplug后pdb只能mount不能open
SQL> alter pluggable database pdb2 open read only;
alter pluggable database pdb2 open read only
*
第 1 行出现错误:
ORA-65086: 无法打开/关闭可插入数据库
SQL> drop pluggable database pdb2;
插接式数据库已删除。
SQL> create pluggable database pdb2 using 'C:\app\Administrator\virtual\oradata\pdb2.xml' nocopy;
插接式数据库已创建。
静默建pdb和cdb
dbca -silent -createDatabase -templateName C:\app\Administrator\virtual\product\12.2.0\dbhome_2\assistants\dbca\templates\General_Purpose.dbc -gdbname newtest -sid newtest -characterSet UTF8 -createAsContainerDatabase true -sysPassword zncg3008_ZNCG -systemPassword zncg3008ZNCG
分享标题：Oracle12cCDB&PDB基本维护
文章URL：https://www.cdcxhl.com/article28/ipsecp.html
成都网站建设公司_创新互联，为您提供软件开发、云服务器、网站导航、全网营销推广、域名注册、微信公众号
声明：本网站发布的内容（图片、视频和文字）以用户投稿、用户转载内容为主，如果涉及侵权请尽快告知，我们将会在第一时间删除。文章观点不代表本网站立场，如需处理请联系客服。电话：028-86922220；邮箱：631063699@qq.com。内容未经允许不得转载，或转载时需注明来源： 创新互联
- 企业建站之前应该怎样准备资料（干货） 2020-11-14
- 企业建站怎么利用视频元素 2016-10-24
- 随州网站建设公司-随州企业建站网络安全的重要性 2021-09-25
- 企业建站过程中利于网络营销的特征 2022-06-04
- 企业建站为什么要做网站优化? 2023-01-19
- 广州网站制作公司分享企业建站之前应该思考的问题 2014-12-30
- 企业建站需要注意哪些细节 2017-12-20
- 到底企业建站采用动态网页好还是静态网页好 2021-11-07
- 成都网站建设公司解答企业建站常常咨询的问题 2014-11-13
- 企业建站为什么在Mysql中不能使用“UFT8” 2023-01-07
- 创新互联高端网站建设公司给企业建站常用的三个步骤 2022-02-17
- 重庆企业建站当心网站模板行业中的陷阱 2015-07-05