ORA-12754: Feature PDB SNAPSHOT CAROUSEL is disabled due to missing capability

小鱼儿 2022-05-10 12:00 115阅读 0赞

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

[oracle@oracle18c ~]$ sqlplus / as sysdba
    
    SQL*Plus: Release 18.0.0.0.0 - Production on Fri Sep 28 22:25:22 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 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 sysdba
    
    SQL*Plus: Release 18.0.0.0.0 - Production on Fri Sep 28 22:34:08 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=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  NO
    	 5 PDB1 			  MOUNTED
    
    
    SQL> 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