ORA-17517 CREATING PLUGGABLE DATABASE FROM SNAPSHOT COPY ON SAME MOUNT (Doc ID 1948990.1)

Last updated on OCTOBER 31, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 and later
Information in this document applies to any platform.

Symptoms

Creating a SNAPSHOT COPY of an existing PDB on same volume failing with error :

create pluggable database SNAP_PDB_1 from SNAP_PDB snapshot copy
FILE_NAME_CONVERT=('/mycdb/first/SNAP_PDB/','/mycdb/first/SNAP_PDB_1/');

create pluggable database SNAP_PDB_1 from SNAP_PDB snapshot copy
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level
ORA-17517: Database cloning using storage snapshot failed on file :

Here in this case /mycdb/first/ is coming from same zfs storage volume

Database alert log:
----------------------
Mon Sep 15 01:00:10 2014
Errors in file
/tpravi/log/Clog/diag/rdbms/mycdb/mycdb/trace/mycdb_ora_22969.trc:
ORA-17517: Database cloning using storage snapshot failed on file 1:/mycdb/first/SNAP_PDB/SNAP_PDB_users01.dbf
ORA-604 signalled during: create pluggable database SNAP_PDB_1 from SNAP_PDB snapshot copy
FILE_NAME_CONVERT=('/mycdb/first/SNAP_PDB/','/mycdb/first/SNAP_PDB_1/')...
Mon Sep 15 01:04:18 2014
Incremental checkpoint up to RBA [0x11.174b1.0], current log tail at RBA
[0x11.2c421.0]
Mon Sep 15 02:00:00 2014

mycdb_ora_22969.trc
---------------------
*** 2014-09-15 01:00:10.651
Storage clones not supported on /mycdb/first/SNAP_PDB/system01.dbf
storage_type=0
ORA-17517: Database cloning using storage snapshot failed on file
1:/mycdb/first/SNAP_PDB/system01.dbf

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms