本文共 1647 字，大约阅读时间需要 5 分钟。

今天在测试oracle 18c 通过local pdb 创建pdb但不克隆PDB中的数据的测试的时候报了如下的报错：

SQL>  CREATE PLUGGABLE DATABASE pdb2 FROM pdb1 NO DATA file_name_convert=('/u01/oradata/pdb1','/u02/oradata/pdb2');

 CREATE PLUGGABLE DATABASE pdb2 FROM pdb1 NO DATA file_name_convert=('/u01/oradata/pdb1','/u02/oradata/pdb2') * ERROR at line 1: ORA-65359: unable to create pluggable database with no data

 

下面贴出oracle18c 给出的步骤

下面给出解决办法:

[oracle@oracle18c pdb2]$  oerr ora 6535965359, 00000, "unable to create pluggable database with no data"// *Cause:   An attempt was made to clone a pluggable database that was opened//           in read/write mode.// *Action:  Retry the clone operation after the source pluggable database is//           in read-only mode.//[oracle@oracle18c pdb2]$SQL> alter pluggable database pdb1 close;Pluggable database altered.SQL> show pdbs;    CON_ID CON_NAME			  OPEN MODE  RESTRICTED---------- ------------------------------ ---------- ----------	 2 PDB$SEED			  READ ONLY  NO	 5 PDB1 			  MOUNTEDSQL> alter pluggable database pdb1 open read only;Pluggable database altered.SQL> show pdbs;    CON_ID CON_NAME			  OPEN MODE  RESTRICTED---------- ------------------------------ ---------- ----------	 2 PDB$SEED			  READ ONLY  NO	 5 PDB1 			  READ ONLY  NOSQL> create pluggable database pdb2 from pdb1 no data file_name_convert=('/u01/oradata/pdb1','/u02/oradata/pdb2');Pluggable database created.SQL> show pdbs    CON_ID CON_NAME			  OPEN MODE  RESTRICTED---------- ------------------------------ ---------- ----------	 2 PDB$SEED			  READ ONLY  NO	 3 PDB2 			  MOUNTED	 5 PDB1 			  READ ONLY  NOSQL> alter pluggable database pdb2 open;Pluggable database altered.