https://www.cndba.cn/dave/article/222
https://www.cndba.cn/dave/article/222https://www.cndba.cn/dave/article/222
手工创建PDB 可以从seed PDB创建,也可以从已经存在的PDB进行复制,只需要在复制的时候保证PDB是只读状态即可。
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 DAVE READ WRITE NO
SQL> alter session set container=DAVE;
Session altered.
SQL> select file_name from dba_data_files;
FILE_NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/CNDBA/dave/users01.dbf
/u01/app/oracle/oradata/CNDBA/dave/sysaux01.dbf
/u01/app/oracle/oradata/CNDBA/dave/system01.dbf
SQL>
SQL> !mkdir -p /u01/app/oracle/oradata/CNDBA/ahdba
SQL> alter pluggable database dave close;
Pluggable database altered.
SQL> alter pluggable database dave open read only;
Pluggable database altered.
SQL> CREATE PLUGGABLE DATABASE ahdba FROM dave
FILE_NAME_CONVERT=('/u01/app/oracle/oradata/CNDBA/dave/','/u01/app/oracle/oradata/CNDBA/ahdba/');
Pluggable database created.
SQL> SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 DAVE READ ONLY NO
4 AHDBA MOUNTED
SQL>
SQL> alter pluggable database ahdba open;
Pluggable database altered.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 DAVE READ ONLY NO
4 AHDBA READ WRITE NO
SQL> alter pluggable database dave close;
Pluggable database altered.
SQL> alter pluggable database dave open;
Pluggable database altered.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 DAVE READ WRITE NO
4 AHDBA READ WRITE NO
SQL>
https://www.cndba.cn/dave/article/222
https://www.cndba.cn/dave/article/222
https://www.cndba.cn/dave/article/222
https://www.cndba.cn/dave/article/222https://www.cndba.cn/dave/article/222https://www.cndba.cn/dave/article/222
版权声明:本文为博主原创文章,未经博主允许不得转载。