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

今天在18c做测试的时候，对PDB创建快照，发生如下的报错信息:

[oracle@oracle18c ~]$ sqlplus / as sysdbaSQL*Plus: Release 18.0.0.0.0 - Production on Fri Sep 28 22:25:22 2018Version 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 - ProductionVersion 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 2018Version 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 - ProductionVersion 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> startupORACLE instance started.Total System Global Area 1191181104 bytesFixed Size		    8895280 bytesVariable Size		  771751936 bytesDatabase Buffers	  402653184 bytesRedo Buffers		    7880704 bytesDatabase mounted.Database opened.SQL> show pdbs;     CON_ID CON_NAME			  OPEN MODE  RESTRICTED---------- ------------------------------ ---------- ----------	 2 PDB$SEED			  READ ONLY  NO	 5 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 150COL CON_NAME FORMAT a10COL SNAPSHOT_NAME FORMAT a30COL SNAP_SCN FORMAT 9999999COL 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

转载地址：http://hchji.baihongyu.com/