Pluggable Database (PDB) の作成方法をおさらいです。
全体イメージは下記の通り、どちらも 19c の環境です。
①PDB$SEED からの作成
PDB$SEED から PIYODB1 を作成します。
現在のコンテナが CDB$ROOT であることを確認して作成します。
SQL> sho user
USER is "SYS"
SQL>
SQL> sho con_name
CON_NAME
------------------------------
CDB$ROOT ★
SQL>
SQL> sho pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 ORCLPDB1 READ WRITE NO
SQL>
SQL> !ls -la /opt/oracle/oradata/ORCLCDB/
total 2444092
drwxr-x--- 4 oracle oinstall 4096 Jul 15 15:06 .
drwxr-x--- 3 oracle oinstall 4096 Jul 15 13:43 ..
-rw-r----- 1 oracle oinstall 18726912 Jul 15 15:07 control01.ctl
-rw-r----- 1 oracle oinstall 18726912 Jul 15 15:07 control02.ctl
drwxr-x--- 2 oracle oinstall 4096 Jul 15 14:01 ORCLPDB1
drwxr-x--- 2 oracle oinstall 4096 Jul 15 13:50 pdbseed
-rw-r----- 1 oracle oinstall 209715712 Jul 15 15:06 redo01.log
-rw-r----- 1 oracle oinstall 209715712 Jul 15 14:01 redo02.log
-rw-r----- 1 oracle oinstall 209715712 Jul 15 15:00 redo03.log
-rw-r----- 1 oracle oinstall 534781952 Jul 15 15:06 sysaux01.dbf
-rw-r----- 1 oracle oinstall 933240832 Jul 15 15:06 system01.dbf
-rw-r----- 1 oracle oinstall 33562624 Jul 15 13:53 temp01.dbf
-rw-r----- 1 oracle oinstall 361766912 Jul 15 15:06 undotbs01.dbf
-rw-r----- 1 oracle oinstall 5251072 Jul 15 15:06 users01.dbf
SQL>
SQL> create pluggable database piyodb1
2 admin user piyo identified by password
3 file_name_convert=('/opt/oracle/oradata/ORCLCDB/pdbseed/','/opt/oracle/oradata/ORCLCDB/PIYODB1/');
Pluggable database created.
SQL>
SQL> sho pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 ORCLPDB1 READ WRITE NO
5 PIYODB1 MOUNTED ★
SQL>
SQL> !ls -la /opt/oracle/oradata/ORCLCDB/
total 2444096
drwxr-x--- 5 oracle oinstall 4096 Jul 15 15:08 .
drwxr-x--- 3 oracle oinstall 4096 Jul 15 13:43 ..
-rw-r----- 1 oracle oinstall 18726912 Jul 15 15:08 control01.ctl
-rw-r----- 1 oracle oinstall 18726912 Jul 15 15:08 control02.ctl
drwxr-x--- 2 oracle oinstall 4096 Jul 15 14:01 ORCLPDB1
drwxr-x--- 2 oracle oinstall 4096 Jul 15 13:50 pdbseed
drwxr-x--- 2 oracle oinstall 4096 Jul 15 15:08 PIYODB1 ★
-rw-r----- 1 oracle oinstall 209715712 Jul 15 15:08 redo01.log
-rw-r----- 1 oracle oinstall 209715712 Jul 15 14:01 redo02.log
-rw-r----- 1 oracle oinstall 209715712 Jul 15 15:00 redo03.log
-rw-r----- 1 oracle oinstall 534781952 Jul 15 15:06 sysaux01.dbf
-rw-r----- 1 oracle oinstall 933240832 Jul 15 15:08 system01.dbf
-rw-r----- 1 oracle oinstall 33562624 Jul 15 13:53 temp01.dbf
-rw-r----- 1 oracle oinstall 361766912 Jul 15 15:06 undotbs01.dbf
-rw-r----- 1 oracle oinstall 5251072 Jul 15 15:06 users01.dbf
SQL>
SQL> !ls -la /opt/oracle/oradata/ORCLCDB/PIYODB1/
total 716896
drwxr-x--- 2 oracle oinstall 4096 Jul 15 15:08 .
drwxr-x--- 5 oracle oinstall 4096 Jul 15 15:08 ..
-rw-r----- 1 oracle oinstall 346038272 Jul 15 15:08 sysaux01.dbf
-rw-r----- 1 oracle oinstall 283123712 Jul 15 15:08 system01.dbf
-rw-r----- 1 oracle oinstall 37756928 Jul 15 15:08 temp012025-07-15_13-50-16-340-PM.dbf
-rw-r----- 1 oracle oinstall 104865792 Jul 15 15:08 undotbs01.dbf
SQL>
作成直後は MOUNTED の状態なのでそのままでは接続できません。(ORA-01109)
OPEN に変更して接続します。
SQL> conn piyo/password@//localhost:1521/piyodb1
ERROR:
ORA-01109: database not open ★
Warning: You are no longer connected to ORACLE.
SQL>
SQL> conn / as sysdba
Connected.
SQL>
SQL> alter pluggable database piyodb1 open;
Pluggable database altered. ★
SQL>
SQL> conn piyo/password@//localhost:1521/piyodb1
Connected.
SQL>
SQL> sho user
USER is "PIYO"
SQL>
SQL> sho con_name
CON_NAME
------------------------------
PIYODB1 ★
SQL>
②ローカルPDBのクローニング
①で作成した PIYODB1 を用いて、同一CDB内に PIYODB2 を作成します。
PIYODB1 に適当なテーブルを作成してデータをインサートします。(テスト用)
SQL> conn system/password@//localhost:1521/piyodb1
Connected.
SQL>
SQL> grant dba to piyo;
Grant succeeded.
SQL>
SQL> conn piyo/password@//localhost:1521/piyodb1
Connected.
SQL>
SQL> create table test_tab(sample_time timestamp);
Table created.
SQL>
SQL> insert into test_tab(select sysdate from dual);
1 row created.
SQL>
SQL> commit;
Commit complete.
SQL>
SQL> select * from test_tab;
SAMPLE_TIME
-----------------------------
15-JUL-25 03.17.37.000000 PM ★
SQL>
クローン元の PDB が READ WRITE の状態でもクローン可能です (ホットクローン)
SQL> conn / as sysdba
Connected.
SQL>
SQL> sho user
USER is "SYS"
SQL>
SQL> sho con_name
CON_NAME
------------------------------
CDB$ROOT
SQL>
SQL> sho pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 ORCLPDB1 READ WRITE NO
5 PIYODB1 READ WRITE NO ★
SQL>
SQL> create pluggable database piyodb2 from piyodb1
2 file_name_convert=('/opt/oracle/oradata/ORCLCDB/PIYODB1/','/opt/oracle/oradata/ORCLCDB/PIYODB2/');
Pluggable database created.
SQL>
SQL> sho pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 ORCLPDB1 READ WRITE NO
4 PIYODB2 MOUNTED ★
5 PIYODB1 READ WRITE NO ★
SQL>
SQL> !ls -la /opt/oracle/oradata/ORCLCDB/
total 2444100
drwxr-x--- 6 oracle oinstall 4096 Jul 15 15:20 .
drwxr-x--- 3 oracle oinstall 4096 Jul 15 13:43 ..
-rw-r----- 1 oracle oinstall 18726912 Jul 15 15:20 control01.ctl
-rw-r----- 1 oracle oinstall 18726912 Jul 15 15:20 control02.ctl
drwxr-x--- 2 oracle oinstall 4096 Jul 15 14:01 ORCLPDB1
drwxr-x--- 2 oracle oinstall 4096 Jul 15 13:50 pdbseed
drwxr-x--- 2 oracle oinstall 4096 Jul 15 15:08 PIYODB1
drwxr-x--- 2 oracle oinstall 4096 Jul 15 15:20 PIYODB2 ★
-rw-r----- 1 oracle oinstall 209715712 Jul 15 15:20 redo01.log
-rw-r----- 1 oracle oinstall 209715712 Jul 15 14:01 redo02.log
-rw-r----- 1 oracle oinstall 209715712 Jul 15 15:00 redo03.log
-rw-r----- 1 oracle oinstall 534781952 Jul 15 15:17 sysaux01.dbf
-rw-r----- 1 oracle oinstall 933240832 Jul 15 15:20 system01.dbf
-rw-r----- 1 oracle oinstall 33562624 Jul 15 13:53 temp01.dbf
-rw-r----- 1 oracle oinstall 361766912 Jul 15 15:20 undotbs01.dbf
-rw-r----- 1 oracle oinstall 5251072 Jul 15 15:06 users01.dbf
SQL> !ls -la /opt/oracle/oradata/ORCLCDB/PIYODB2/
total 716896
drwxr-x--- 2 oracle oinstall 4096 Jul 15 15:20 .
drwxr-x--- 6 oracle oinstall 4096 Jul 15 15:20 ..
-rw-r----- 1 oracle oinstall 346038272 Jul 15 15:20 sysaux01.dbf
-rw-r----- 1 oracle oinstall 283123712 Jul 15 15:20 system01.dbf
-rw-r----- 1 oracle oinstall 37756928 Jul 15 15:20 temp012025-07-15_13-50-16-340-PM.dbf
-rw-r----- 1 oracle oinstall 104865792 Jul 15 15:20 undotbs01.dbf
SQL>
SQL> alter pluggable database piyodb2 open;
Pluggable database altered.
SQL>
SQL> conn piyo/password@//localhost:1521/piyodb2
Connected.
SQL>
SQL> select * from test_tab;
SAMPLE_TIME
------------------------------
15-JUL-25 03.17.37.000000 PM ★
SQL>
③リモートPDBのクローニング
①で作成した PIYODB1 を用いて、別CDBに PIYODB3 を作成します。
DBLINK を利用してクローニングするため、ソースPDB に DBLINK用のユーザを作成して権限付与します。
SQL> !hostname
4b8169d2a748
SQL>
SQL> sho user
USER is "SYSTEM"
SQL>
SQL> sho con_name
CON_NAME
------------------------------
PIYODB1
SQL>
SQL> create user remote_piyo identified by password;
User created. ★
SQL>
SQL> grant create session,
2 create pluggable database to remote_piyo;
Grant succeeded. ★
SQL>
SQL>
ターゲットの tnsnames.ora に、ソースPDB の情報を記載します。
(Source_PDB が今回追加した部分)
[oracle@6b5b6d585205 ~]$ cat /opt/oracle/product/19c/dbhome_1/network/admin/
tnsnames.ora
# tnsnames.ora Network Configuration File: /opt/oracle/product/19c/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
ORCLCDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 6b5b6d585205)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORCLCDB)
)
)
LISTENER_ORCLCDB =
(ADDRESS = (PROTOCOL = TCP)(HOST = 6b5b6d585205)(PORT = 1521))
Source_PDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 4b8169d2a748)(PORT = 1521)) ★
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = piyodb1)
)
)
[oracle@6b5b6d585205 ~]$
ターゲットの CDB$ROOT に DBLINK を作成し、ソースPDB をクローニングします。
SQL> !hostname
6b5b6d585205
SQL>
SQL> sho user
USER is "SYS"
SQL>
SQL> sho con_name
CON_NAME
------------------------------
CDB$ROOT
SQL>
SQL> create database link Source_PDB
2 connect to remote_piyo identified by password
3 using 'Source_PDB';
Database link created. ★
SQL>
SQL> sho pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 ORCLPDB1 READ WRITE NO
SQL>
SQL> create pluggable database piyodb3 from piyodb1@Source_PDB
2 file_name_convert=('/opt/oracle/oradata/ORCLCDB/PIYODB1/','/opt/oracle/oradata/ORCLCDB/PIYODB3/');
Pluggable database created.
SQL>
SQL> sho pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 ORCLPDB1 READ WRITE NO
4 PIYODB3 MOUNTED ★
SQL>
SQL> alter pluggable database piyodb3 open;
Pluggable database altered.
SQL>
SQL> conn piyo/password@//localhost:1521/piyodb3
Connected.
SQL>
SQL> select * from test_tab;
SAMPLE_TIME
-----------------------------
15-JUL-25 03.17.37.000000 PM ★
SQL>
④⑤Unplug & Plug
PIYODB1, 2 を Unplugし、別の環境に PIYODB4, 5 として Plugします。
Unplug する時は .xml か .pdb を選択可能で、今回は PIYODB1 を .xml で、PIYODB2 を .pdb で Unplug してみます。
SQL> !hostname
4b8169d2a748
SQL>
SQL> sho user
USER is "SYS"
SQL>
SQL> sho con_name
CON_NAME
------------------------------
CDB$ROOT
SQL>
SQL> sho pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 ORCLPDB1 READ WRITE NO
4 PIYODB2 READ WRITE NO
5 PIYODB1 READ WRITE NO
SQL>
SQL> alter pluggable database piyodb1 close;
Pluggable database altered.
SQL>
SQL> alter pluggable database piyodb2 close;
Pluggable database altered.
SQL>
SQL> sho pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 ORCLPDB1 READ WRITE NO
4 PIYODB2 MOUNTED ★
5 PIYODB1 MOUNTED ★
SQL>
SQL> alter pluggable database piyodb1
2 unplug into '/media/test-crepdb/piyodb1.xml';
Pluggable database altered.
SQL>
SQL> alter pluggable database piyodb2
2 unplug into '/media/test-crepdb/piyodb2.pdb';
Pluggable database altered.
SQL>
SQL> sho pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 ORCLPDB1 READ WRITE NO
4 PIYODB2 MOUNTED ★
5 PIYODB1 MOUNTED ★
SQL>
SQL> !ls -la /media/test-crepdb/
total 106248
drwxrwxrwx 1 root root 4096 Jul 15 16:50 .
drwxrwxrwx 1 root root 4096 Jul 15 16:44 ..
-rw-r--r-- 1 oracle oinstall 6725 Jul 15 16:50 piyodb1.xml ★
-rw-r--r-- 1 oracle oinstall 108787851 Jul 15 16:51 piyodb2.pdb ★
SQL>
SQL>
SQL>
SQL> alter pluggable database piyodb1 open;
alter pluggable database piyodb1 open
*
ERROR at line 1:
ORA-65086: cannot open/close the pluggable database
SQL>
.xml を覗いてみると、PIYODB1 のメタデータが記述されていることがわかります。
なお、.pdb は .xml と データファイル (.dbf) が実態です。
<?xml version="1.0" encoding="UTF-8"?>
<PDB>
<xmlversion>1</xmlversion>
<pdbname>PIYODB1</pdbname>
<cid>5</cid>
<byteorder>1</byteorder>
<vsn>318767104</vsn>
<vsns>
<vsnnum>19.0.0.0.0</vsnnum>
<cdbcompt>19.0.0.0.0</cdbcompt>
<pdbcompt>19.0.0.0.0</pdbcompt>
<vsnlibnum>0.0.0.0.24</vsnlibnum>
<vsnsql>24</vsnsql>
<vsnbsv>8.0.0.0.0</vsnbsv>
</vsns>
<dbid>1962165419</dbid>
<ncdb2pdb>0</ncdb2pdb>
<cdbid>2977600542</cdbid>
<guid>39F2905178C71B89E063020011ACF74B</guid>
<uscnbas>2159557</uscnbas>
<uscnwrp>0</uscnwrp>
<undoscn>280</undoscn>
<rdba>4194824</rdba>
<tablespace>
<name>SYSTEM</name>
<type>0</type>
<tsn>0</tsn>
<status>1</status>
<issft>0</issft>
<isnft>0</isnft>
<encts>0</encts>
<flags>0</flags>
<bmunitsize>8</bmunitsize>
<file>
<path>/opt/oracle/oradata/ORCLCDB/PIYODB1/system01.dbf</path>
<afn>16</afn>
<rfn>1</rfn>
<createscnbas>2147617</createscnbas>
<createscnwrp>0</createscnwrp>
<status>1</status>
<fileblocks>34560</fileblocks>
<blocksize>8192</blocksize>
<vsn>318767104</vsn>
<fdbid>1962165419</fdbid>
<fcpsb>2159548</fcpsb>
<fcpsw>0</fcpsw>
<frlsb>1920977</frlsb>
<frlsw>0</frlsw>
<frlt>1206539169</frlt>
<autoext>1</autoext>
<maxsize>4194302</maxsize>
<incsize>1280</incsize>
<plugscn>0</plugscn>
<plugafn>0</plugafn>
<plugdbid>0</plugdbid>
</file>
</tablespace>
<tablespace>
<name>SYSAUX</name>
<type>0</type>
<tsn>1</tsn>
<status>1</status>
<issft>0</issft>
<isnft>0</isnft>
<encts>0</encts>
<flags>0</flags>
<bmunitsize>8</bmunitsize>
<file>
<path>/opt/oracle/oradata/ORCLCDB/PIYODB1/sysaux01.dbf</path>
<afn>17</afn>
<rfn>4</rfn>
<createscnbas>2147621</createscnbas>
<createscnwrp>0</createscnwrp>
<status>1</status>
<fileblocks>42240</fileblocks>
<blocksize>8192</blocksize>
<vsn>318767104</vsn>
<fdbid>1962165419</fdbid>
<fcpsb>2159548</fcpsb>
<fcpsw>0</fcpsw>
<frlsb>1920977</frlsb>
<frlsw>0</frlsw>
<frlt>1206539169</frlt>
<autoext>1</autoext>
<maxsize>4194302</maxsize>
<incsize>1280</incsize>
<plugscn>0</plugscn>
<plugafn>0</plugafn>
<plugdbid>0</plugdbid>
</file>
</tablespace>
<tablespace>
<name>UNDOTBS1</name>
<type>2</type>
<tsn>2</tsn>
<status>1</status>
<issft>0</issft>
<isnft>0</isnft>
<encts>0</encts>
<flags>0</flags>
<bmunitsize>8</bmunitsize>
<file>
<path>/opt/oracle/oradata/ORCLCDB/PIYODB1/undotbs01.dbf</path>
<afn>18</afn>
<rfn>9</rfn>
<createscnbas>2147624</createscnbas>
<createscnwrp>0</createscnwrp>
<status>1</status>
<fileblocks>12800</fileblocks>
<blocksize>8192</blocksize>
<vsn>318767104</vsn>
<fdbid>1962165419</fdbid>
<fcpsb>2159548</fcpsb>
<fcpsw>0</fcpsw>
<frlsb>1920977</frlsb>
<frlsw>0</frlsw>
<frlt>1206539169</frlt>
<autoext>1</autoext>
<maxsize>4194302</maxsize>
<incsize>640</incsize>
<plugscn>0</plugscn>
<plugafn>0</plugafn>
<plugdbid>0</plugdbid>
</file>
</tablespace>
<tablespace>
<name>TEMP</name>
<type>1</type>
<tsn>3</tsn>
<status>1</status>
<issft>0</issft>
<isnft>0</isnft>
<encts>0</encts>
<flags>0</flags>
<bmunitsize>128</bmunitsize>
<file>
<path>/opt/oracle/oradata/ORCLCDB/PIYODB1/temp012025-07-15_13-50-16-340-PM.dbf</path>
<afn>5</afn>
<rfn>1</rfn>
<createscnbas>2147618</createscnbas>
<createscnwrp>0</createscnwrp>
<status>1</status>
<fileblocks>4608</fileblocks>
<blocksize>8192</blocksize>
<vsn>318767104</vsn>
<autoext>1</autoext>
<maxsize>4194302</maxsize>
<incsize>80</incsize>
<plugscn>0</plugscn>
<plugafn>0</plugafn>
<plugdbid>0</plugdbid>
</file>
</tablespace>
<recover>0</recover>
<optional>
<ncdb2pdb>0</ncdb2pdb>
<csid>873</csid>
<ncsid>2000</ncsid>
<options>
<option>APS=19.0.0.0.0</option>
<option>CATALOG=19.0.0.0.0</option>
<option>CATJAVA=19.0.0.0.0</option>
<option>CATPROC=19.0.0.0.0</option>
<option>CONTEXT=19.0.0.0.0</option>
<option>DV=19.0.0.0.0</option>
<option>JAVAVM=19.0.0.0.0</option>
<option>OLS=19.0.0.0.0</option>
<option>ORDIM=19.0.0.0.0</option>
<option>OWM=19.0.0.0.0</option>
<option>SDO=19.0.0.0.0</option>
<option>XDB=19.0.0.0.0</option>
<option>XML=19.0.0.0.0</option>
<option>XOQ=19.0.0.0.0</option>
</options>
<olsoid>0</olsoid>
<dv>0</dv>
<APEX>NULL</APEX>
<parameters>
<parameter>processes=960</parameter>
<parameter>nls_language='AMERICAN'</parameter>
<parameter>nls_territory='AMERICA'</parameter>
<parameter>db_block_size=8192</parameter>
<parameter>compatible='19.0.0'</parameter>
<parameter>open_cursors=300</parameter>
<parameter>pga_aggregate_target=799014912</parameter>
<parameter>enable_pluggable_database=TRUE</parameter>
</parameters>
<sqlpatches>
<sqlpatch>19.3.0.0.0 Release_Update 1904101227 (RU): APPLY SUCCESS</sqlpatch>
</sqlpatches>
<tzvers>
<tzver>primary version:32</tzver>
<tzver>secondary version:0</tzver>
</tzvers>
<walletkey>0</walletkey>
<services/>
<opatches>
<opatch>29517242</opatch>
</opatches>
<hasclob>1</hasclob>
<awr>
<loadprofile>CPU used by this session=9.882216</loadprofile>
<loadprofile>DB time=20.332337</loadprofile>
<loadprofile>db block changes=905.894031</loadprofile>
<loadprofile>execute count=467.520818</loadprofile>
<loadprofile>logons cumulative=1.132885</loadprofile>
<loadprofile>parse count (hard)=29.289725</loadprofile>
<loadprofile>parse count (total)=294.408229</loadprofile>
<loadprofile>physical reads=87.122674</loadprofile>
<loadprofile>physical writes=10.619452</loadprofile>
<loadprofile>redo size=170661.391206</loadprofile>
<loadprofile>session logical reads=2853.481290</loadprofile>
<loadprofile>user calls=22.060911</loadprofile>
<loadprofile>user commits=2.675951</loadprofile>
<loadprofile>user logons cumulative=0.002259</loadprofile>
<loadprofile>user rollbacks=0.033576</loadprofile>
</awr>
<hardvsnchk>0</hardvsnchk>
<localundo>1</localundo>
<apps/>
<dbedition>8</dbedition>
<dvopsctl>2</dvopsctl>
<clnupsrcpal>1</clnupsrcpal>
</optional>
</PDB>
PIYODB1 を PIYODB4 として Plug します。
PIYODB1 のデータファイルを用意して、usingで .xml を指定して Plug します。
[oracle@6b5b6d585205 ~]$ mkdir /opt/oracle/oradata/ORCLCDB/PIYODB1
[oracle@6b5b6d585205 ~]$ mv /media/test-crepdb/*dbf /opt/oracle/oradata/ORCLCDB/PIYODB1
[oracle@6b5b6d585205 ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Tue Jul 15 17:46:54 2025
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL>
SQL> sho user
USER is "SYS"
SQL>
SQL> sho con_name
CON_NAME
------------------------------
CDB$ROOT
SQL>
SQL> sho pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 ORCLPDB1 READ WRITE NO
4 PIYODB3 READ WRITE NO
SQL>
SQL> create pluggable database piyodb4
2 using '/media/test-crepdb/piyodb1.xml'
3 file_name_convert=('/opt/oracle/oradata/ORCLCDB/PIYODB1/', '/opt/oracle/oradata/ORCLCDB/PIYODB4/');
Pluggable database created.
SQL>
SQL> sho pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 ORCLPDB1 READ WRITE NO
4 PIYODB3 READ WRITE NO
5 PIYODB4 MOUNTED ★
SQL>
SQL> alter pluggable database piyodb4 open;
Pluggable database altered.
SQL>
SQL> conn piyo/password@//localhost:1521/piyodb4
Connected.
SQL>
SQL> select * from test_tab;
SAMPLE_TIME
------------------------------
15-JUL-25 03.17.37.000000 PM
SQL>
SQL>
PIYODB2 を PIYODB5 として Plug します。
PIYODB2 はデータファイルを用意する必要はありません。(.pdb に含まれているため)
.xml の時と同様、usingで .pdb を指定して Plug します。
SQL> sho user
USER is "SYS"
SQL>
SQL> sho con_name
CON_NAME
------------------------------
CDB$ROOT
SQL>
SQL> sho pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 ORCLPDB1 READ WRITE NO
4 PIYODB3 READ WRITE NO
5 PIYODB4 READ WRITE NO
SQL>
SQL> create pluggable database piyodb5
2 using '/media/test-crepdb/piyodb2.pdb'
3 file_name_convert=('/media/test-crepdb/', '/opt/oracle/oradata/ORCLCDB/PIYODB5/');
Pluggable database created.
SQL>
SQL>
SQL> sho pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 ORCLPDB1 READ WRITE NO
4 PIYODB3 READ WRITE NO
5 PIYODB4 READ WRITE NO
6 PIYODB5 MOUNTED ★
SQL>
SQL> alter pluggable database piyodb5 open;
Pluggable database altered.
SQL>
SQL> conn piyo/password@//localhost:1521/piyodb5
Connected.
SQL>
SQL> select * from test_tab;
SAMPLE_TIME
------------------------------
15-JUL-25 03.17.37.000000 PM
SQL>