本文主要是介绍ORA-12754: Feature PDB SNAPSHOT CAROUSEL is disabled due to missing capability，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！
今天在18c做测试的时候，对PDB创建快照，发生如下的报错信息:
[oracle@oracle18c ~]$ sqlplus / as sysdbaSQL*Plus: Release 18.0.0.0.0 - Production on Fri Sep 28 22:25:22 2018
Version 18.3.0.0.0Copyright (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.0SQL> alter pluggable database pdb1 snapshot pdb1_test1;
alter pluggable database pdb1 snapshot pdb1_test1
*
ERROR at line 1:
ORA-12754: Feature PDB SNAPSHOT CAROUSEL is disabled due to missing capability
.解决办法：
[oracle@oracle18c ~]$ sqlplus / as sysdbaSQL*Plus: Release 18.0.0.0.0 - Production on Fri Sep 28 22:34:08 2018
Version 18.3.0.0.0Copyright (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.0SQL> 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 771751936 bytes
Database Buffers 402653184 bytes
Redo Buffers 7880704 bytes
Database mounted.
Database opened.
SQL> show pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------2 PDB$SEED READ ONLY NO5 PDB1 MOUNTEDSQL> alter pluggable database pdb1 open;Pluggable database altered.SQL> alter session set container=pdb1;Session altered.SQL> alter pluggable database pdb1 snapshot pdb1_test1;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 a55SQL> SQL> SQL> SQL> SQL> select con_id, con_name, snapshot_name,snapshot_scn as snap_scn, full_snapshot_path from dba_pdb_snapshots order by snap_scn;CON_ID CON_NAME SNAPSHOT_NAME SNAP_SCN FULL_SNAPSHOT_PATH
---------- ---------- ------------------------------ -------- -------------------------------------------------------5 PDB1 PDB1_TEST1 1711651 /u01/oradata/pdb1/snap_70485319_1711651.pdb
这篇关于ORA-12754: Feature PDB SNAPSHOT CAROUSEL is disabled due to missing capability的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！
