若PDB 的数据文件存储在 18c 、 19c 的非 ASM 存储中，则可以正常使用，但是若 PDB 的数据文件存储在 18c 、 19c 的 ASM 中，则创建快照会报错 ORA-17517 ，目前无解：

SYS@lhr19cdb> alter pluggable database snapshot test_snapshot;

alter pluggable database snapshot test_snapshot

*

ERROR at line 1:

ORA-00604: error occurred at recursive SQL level 1

ORA-65169: error encountered while attempting to copy file +DATA/LHR19CDB/A2ED06838339ABB0E053343BA8C0289C/DATAFILE/undotbs1.270.1037379889

ORA-17517: Database cloning using storage snapshot failed on file 8:+DATA/LHR19CDB/A2ED06838339ABB0E053343BA8C0289C/DATAFILE/undotbs1.270.1037379889

SYS@lhr19cdb> alter system set db_create_file_dest='/u01/app/oracle/oradata/';
System altered.
SYS@lhr19cdb> create pluggable database pdb1 admin user lhr identified by lhr;
Pluggable database created.
SYS@lhr19cdb> show pdbs
    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDBLHR1                        READ WRITE NO
         5 PDB1                           MOUNTED
SYS@lhr19cdb> alter pluggable database pdb1 open;
Pluggable database altered.
SYS@lhr19cdb> aler session set container=pdb1;
SP2-0734: unknown command beginning "aler sessi..." - rest of line ignored.
SYS@lhr19cdb> alter session set container=pdb1;
Session altered.
SYS@lhr19cdb> 
SYS@lhr19cdb> alter pluggable database snapshot test_snapshot;
alter pluggable database snapshot test_snapshot
*
ERROR at line 1:
ORA-12754: Feature PDB SNAPSHOT CAROUSEL is disabled due to missing capability .
SYS@lhr19cdb> 
SYS@lhr19cdb> alter system set "_exadata_feature_on"=true scope=spfile;
alter system set "_exadata_feature_on"=true scope=spfile
*
ERROR at line 1:
ORA-65040: operation not allowed from within a pluggable database
SYS@lhr19cdb> conn / as sysdba
Connected.
SYS@lhr19cdb> 
SYS@lhr19cdb> alter system set "_exadata_feature_on"=true scope=spfile;
System altered.
SYS@lhr19cdb> startup force
ORACLE instance started.
Total System Global Area 1073738488 bytes
Fixed Size                  9143032 bytes
Variable Size             742391808 bytes
Database Buffers          314572800 bytes
Redo Buffers                7630848 bytes
Database mounted.
Database opened.
SYS@lhr19cdb> show pdbs
    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDBLHR1                        READ WRITE NO
         5 PDB1                           MOUNTED
SYS@lhr19cdb> alter pluggable database PDB1 open;
Pluggable database altered.
SYS@lhr19cdb> alter session set container=pdb1;
Session altered.
SYS@lhr19cdb>  alter pluggable database snapshot test_snapshot;
Pluggable database altered.
SYS@lhr19cdb> 
SYS@lhr19cdb> SET LINESIZE 1500 pagesize 1000
SYS@lhr19cdb> COL CON_NAME FORMAT a10
SYS@lhr19cdb> COL SNAPSHOT_NAME FORMAT a30
SYS@lhr19cdb> COL SNAP_SCN FORMAT 9999999
SYS@lhr19cdb> COL FULL_SNAPSHOT_PATH FORMAT a70
SYS@lhr19cdb> COL   SNAP_TIME  format a20
SYS@lhr19cdb> SELECT CON_ID,
  2         CON_NAME,
  3         SNAPSHOT_NAME,
  4         SNAPSHOT_SCN AS snap_scn,
  5         to_char(scn_to_timestamp(a.SNAPSHOT_SCN), 'yyyy-mm-dd hh24:mi:ss')  snap_time,
  6         FULL_SNAPSHOT_PATH
  7    FROM CDB_PDB_SNAPSHOTS A
  8   ORDER BY SNAP_SCN;
    CON_ID CON_NAME   SNAPSHOT_NAME                  SNAP_SCN SNAP_TIME            FULL_SNAPSHOT_PATH
---------- ---------- ------------------------------ -------- -------------------- ----------------------------------------------------------------------
         5 PDB1       TEST_SNAPSHOT                   2926315 2020-05-08 10:39:42  /u01/app/oracle/oradata/snap_2990742954_2926315.pdb
SYS@lhr19cdb> alter session set container=PDBLHR1;
Session altered.
SYS@lhr19cdb>  alter pluggable database snapshot;
 alter pluggable database snapshot
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-65169: error encountered while attempting to copy file +DATA/LHR19CDB/A2ED06838339ABB0E053343BA8C0289C/DATAFILE/undotbs1.270.1037379889
ORA-17517: Database cloning using storage snapshot failed on file 8:+DATA/LHR19CDB/A2ED06838339ABB0E053343BA8C0289C/DATAFILE/undotbs1.270.1037379889

Create PDB From Snapshot Copy Throws ORA-65169/ORA-17525 Errors (Doc ID 2084589.1)

In this Document

APPLIES TO:

Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.

SYMPTOMS

On 12c database, create pdb from snapshot copy throws ora-65169/ora-17525 errors :

CAUSE

1. The storage does not support file snapshots.
2. clonedb was not set . 

SOLUTION

The ORA-17525 error is thrown because the storage does not support file snapshots. Use a compatible storage.

Or)

Set clonedb=TRUE

About Me