Oracle12C添加PDB

最新推荐文章于 2023-12-28 10:43:18 发布

挠背小能手

最新推荐文章于 2023-12-28 10:43:18 发布

阅读量417

点赞数

分类专栏： Oracle日常运维文章标签： oracle

本文链接：https://blog.csdn.net/m0_37625564/article/details/115205910

版权

Oracle日常运维专栏收录该内容

129 篇文章 18 订阅

订阅专栏

Oracle 12C，在CDB中添加PDB，方法有很多，12C官方文档提到6种创建PDB的技术，如下：

Create a PDB by using the seed
Create a PDB by cloning an existing PDB or non-CDB
Create a PDB by relocating it to a different CDB
Create a PDB by plugging an unplugged PDB into a CDB
Create a PDB as a proxy PDB
Create s PDB by using a non-CDB

此次客户环境采用第一种，从seed复制。

在这里插入图片描述

查看当前环境有哪些PDB

[oracle@node0 ~]$ 
[oracle@node0 ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Thu Mar 25 12:35:08 2021

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


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options

SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 HIS                         READ WRITE NO
         4 LIS                           READ WRITE NO
         5 EMR                        READ WRITE NO
         7 DOCARE                         READ WRITE NO
...

创建PDB

SQL> create pluggable database EIFDB admin user eifadmin identified by oracle;

Pluggable database created.

SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 HIS                         READ WRITE NO
         4 LIS                           READ WRITE NO
         5 EMR                        READ WRITE NO
         7 DOCARE                         READ WRITE NO
        15 EIFDB                          MOUNTED

打开PDB

SQL> alter pluggable database eifdb open;

Pluggable database altered.

SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 HIS                         READ WRITE NO
         4 LIS                           READ WRITE NO
         5 EMR                        READ WRITE NO
         7 DOCARE                         READ WRITE NO
        15 EIFDB                          READ WRITE NO

查看PDB

SQL> alter session set container=eifdb;

Session altered.

SQL> show  pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
        15 EIFDB                          READ WRITE NO
SQL> select name from v$dbfile;

NAME
--------------------------------------------------------------------------------
/u02/app/oracle/oradata/datcdb/cdb/CDB/BE55F44A695E5782E0531400A8C0B40D/datafile
/o1_mf_system_j5r4srov_.dbf

/u02/app/oracle/oradata/datcdb/cdb/CDB/BE55F44A695E5782E0531400A8C0B40D/datafile
/o1_mf_sysaux_j5r4srp1_.dbf