Oracle 18c 正式版中对PDB创建快照，结果报错：

[oracle@18c dbs]$ sqlplus / as sysdba

SQL*Plus: Release 18.0.0.0.0 - Production on Sun Aug 26 06:23:25 2018
Version 18.3.0.0.0

Copyright (c) 1982, 2018, Oracle.  All rights reserved.

Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.3.0.0.0
SQL> alter session set container=dave;
Session altered.

SQL> ALTER PLUGGABLE DATABASE SNAPSHOT; 
ALTER PLUGGABLE DATABASE SNAPSHOT
*
ERROR at line 1:
ORA-12754: Feature PDB SNAPSHOT CAROUSEL is disabled due to missing capability .

SQL> !oerr ora 12754
12754, 00000, "Feature %s is disabled due to missing capability %s."
// *Document: NO
// *Cause: This feature requires specific capabilities that were not present
//         in the current database instance.
// *Action: Contact Oracle Support Services to enable this feature.

解决方法：

SQL> alter session set container=cdb$root;
Session altered.

SQL> alter system set "_exadata_feature_on"=true scope=spfile;
System altered.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup 
ORACLE instance started.

Total System Global Area 1191181104 bytes
Fixed Size            8895280 bytes
Variable Size          872415232 bytes
Database Buffers      301989888 bytes
Redo Buffers            7880704 bytes
Database mounted.
Database opened.
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> ALTER PLUGGABLE DATABASE SNAPSHOT cdb_cndba_20180813151200;
Pluggable database altered.

SQL> SET LINESIZE 150
COL CON_NAME FORMAT a10
COL SNAPSHOT_NAME FORMAT a30
COL SNAP_SCN FORMAT 9999999
COL FULL_SNAPSHOT_PATH FORMAT a55
SELECT CON_ID, CON_NAME, SNAPSHOT_NAME,
       SNAPSHOT_SCN AS snap_scn, FULL_SNAPSHOT_PATH
FROM   DBA_PDB_SNAPSHOTS
ORDER BSQL> SQL> SQL> Y SNAP_SCN;
SQL> SQL>   2    3    4  
    CON_ID CON_NAME   SNAPSHOT_NAME             SNAP_SCN FULL_SNAPSHOT_PATH
---------- ---------- ------------------------------ -------- -------------------------------------------------------
     3 DAVE       CDB_CNDBA_20180813151200      1599065 /u01/app/oracle/oradata/CNDBA/dave/snap_2977624433_1599065.pdb

之前磊神在18c 还有没有正式发布的时候，也遇到过类似的问题，这个地方应该是Oracle 一个待修复的bug，下一版可能就正常了。http://www.cndba.cn/dave/article/2968http://www.cndba.cn/dave/article/2968

解决Oracle 18c无法安装实例的方法—ORA-12754
https://www.cndba.cn/Expect-le/article/2858http://www.cndba.cn/dave/article/2968http://www.cndba.cn/dave/article/2968

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