1 问题现象

在19c 环境中，通过快照创建PDB，报如下错误：http://www.cndba.cn/dave/article/4717

SQL> CREATE PLUGGABLE DATABASE huaining FROM ustc USING SNAPSHOT USTC_SNAP0914;
CREATE PLUGGABLE DATABASE huaining FROM ustc USING SNAPSHOT USTC_SNAP0914
                                                                        *
ERROR at line 1:
ORA-65016: FILE_NAME_CONVERT must be specified

2 解决方法

SQL> !oerr ora 65016
65016, 00000, "FILE_NAME_CONVERT must be specified"
// *Cause:  Data files, and possibly other files, needed to be copied as a
//          part of creating a pluggable database.  However, Oracle Managed
//          Files (OMF) was not enabled, PDB_FILE_NAME_CONVERT was not defined,
//          and there was a failure to specify the FILE_NAME_CONVERT clause.
// *Action: Enable OMF or define PDB_FILE_NAME_CONVERT system parameter before
//          issuing CREATE PLUGGABLE DATABASE statement, or specify
//          FILE_NAME_CONVERT clause as a part of the statement.
//

从错误提示看，有两种方法解决这个问题：http://www.cndba.cn/dave/article/4717http://www.cndba.cn/dave/article/4717

• 1.启用OMF
• 2.添加FILE_NAME_CONVERT 选项。

但实际是第二种方法并不可行，会报如下错误：

SQL> CREATE PLUGGABLE DATABASE huaining FROM ustc USING SNAPSHOT ustc_snap0914  FILE_NAME_CONVERT = ( 'huaining', 'ustc' );
CREATE PLUGGABLE DATABASE huaining FROM ustc USING SNAPSHOT ustc_snap0914  FILE_NAME_CONVERT = ( 'huaining', 'ustc' )
*
ERROR at line 1:
ORA-65365: unable to create pluggable database


SQL> !oerr ora 65365
65365, 00000, "unable to create pluggable database"
// *Cause:  An attempt was made to create a pluggable database (PDB) using a
//          snapshot when Oracle Managed Files (OMF) was not enabled or if the
//          CREATE_FILE_DEST clause was not specified.
// *Action: Enable OMF or specify CREATE_FILE_DEST clause and retry creating
//          the pluggable database.
//

SQL>

根据错误提示的分析，可以看出来，对于从快照创建PDB，只有一种方法，就是启用OMF。 http://www.cndba.cn/dave/article/4717http://www.cndba.cn/dave/article/4717

[dave@www.cndba.cn ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Tue Sep 14 22:06:50 2021
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> show parameter db_create_file_dest

NAME                                 TYPE
------------------------------------ ---------------------------------
VALUE
------------------------------
db_create_file_dest                  string

SQL> alter system set db_create_file_dest='/u01/app/oracle/oradata';

System altered.

设置成功之后，成功创建，但是目录使用的GUID：http://www.cndba.cn/dave/article/4717http://www.cndba.cn/dave/article/4717

SQL> CREATE PLUGGABLE DATABASE huaining FROM ustc USING SNAPSHOT USTC_SNAP0914;

Pluggable database created.

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 ORCLPDB                        MOUNTED
         4 DAVE                           MOUNTED
         5 USTC2                          MOUNTED
         6 USTC                           READ WRITE NO
         7 USTC3                          MOUNTED
         8 HUAINING                       MOUNTED
         9 HEFEI                          MOUNTED
SQL> alter pluggable database huaining open;

Pluggable database altered.

SQL> alter session set container=huaining;

Session altered.

SQL> select file_name from dba_data_files;

FILE_NAME
---------------------------------------------------------------------------------------------
/u01/app/oracle/oradata/ORCL/CBF5BD4A5E88EB2AE053056FA8C067C9/datafile/o1_mf_system_jn1c51r2_.dbf
/u01/app/oracle/oradata/ORCL/CBF5BD4A5E88EB2AE053056FA8C067C9/datafile/o1_mf_sysaux_jn1c51r7_.dbf
/u01/app/oracle/oradata/ORCL/CBF5BD4A5E88EB2AE053056FA8C067C9/datafile/o1_mf_undotbs1_jn1c51r8_.dbf
/u01/app/oracle/oradata/ORCL/CBF5BD4A5E88EB2AE053056FA8C067C9/datafile/o1_mf_dave_jn1c51r8_.dbf

SQL>

版权声明：本文为博主原创文章，未经博主允许不得转载。