ORA-65359: unable to create pluggable database with no data

￡神魔★判官ぃ 2022-05-12 02:24 135阅读 0赞

今天在测试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

![70][]

下面贴出oracle18c 给出的步骤

![70 1][]

下面给出解决办法:

[oracle@oracle18c pdb2]$  oerr ora 65359
    65359, 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 			  MOUNTED
    SQL> 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  NO
    SQL> 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  NO
    SQL> alter pluggable database pdb2 open;
    
    Pluggable database altered.

[70]: /images/20220512/4380f76ba6054ac7ba27505f59cd71c5.png
[70 1]: /images/20220512/9232444c39894905837972491fd02722.png