ORA-65169: error encountered while attempting to copy file ORA-17525: Database clone using storage snapshot not supported on file

Cause:

Creating a snapshot clone fails with the below error.

kIsH@STAX<>create pluggable database PROX2 from PROX1 snapshot copy;
create pluggable database PROX2 from PROX1 snapshot copy
*
ERROR at line 1:
ORA-65169: error encountered while attempting to copy file
/u01/app/oracle/oradata/STAXDB/STAXDB/E9E87BBFFBE82E19E053C738A8C06078/datafile/
o1_mf_undotbs1_kmg6h19y_.dbf
ORA-17525: Database clone using storage snapshot not supported on file
/u01/app/oracle/oradata/STAXDB/STAXDB/E9E87BBFFBE82E19E053C738A8C06078/datafile/
o1_mf_undotbs1_kmg6h19y_.dbf

Alertlog message:

create pluggable database PROX2 from PROX1 snapshot copy
2022-10-20T16:26:02.845479+05:30
PROX1(4): AUDSYS.AUD$UNIFIED (SQL_TEXT) - CLOB populated
2022-10-20T16:26:02.867390+05:30
Errors in file /u01/app/oracle/diag/rdbms/staxdb/staxdb/trace/staxdb_ora_11209.trc:
ORA-17525: Database clone using storage snapshot not supported on file /u01/app/oracle/oradata/STAXDB/STAXDB/E9E87BBFFBE82E19E053C738A8C06078/datafile/o1_mf_undotbs1_kmg6h19y_.dbf
2022-10-20T16:26:02.867543+05:30
Errors in file /u01/app/oracle/diag/rdbms/staxdb/staxdb/trace/staxdb_ora_11209.trc:
ORA-17525: Database clone using storage snapshot not supported on file /u01/app/oracle/oradata/STAXDB/STAXDB/E9E87BBFFBE82E19E053C738A8C06078/datafile/o1_mf_system_kmg6h19o_.dbf
2022-10-20T16:26:02.867642+05:30
Errors in file /u01/app/oracle/diag/rdbms/staxdb/staxdb/trace/staxdb_ora_11209.trc:
ORA-17525: Database clone using storage snapshot not supported on file /u01/app/oracle/oradata/STAXDB/STAXDB/E9E87BBFFBE82E19E053C738A8C06078/datafile/o1_mf_sysaux_kmg6h19x_.dbf

Solution:

Enable the below parameter to support snapshot clone feature

kIsH@STAX<>show parameter clone

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
clonedb                              boolean     FALSE
clonedb_dir                          string

kIsH@STAX<>alter system set clonedb=true;
alter system set clonedb=true
                 *
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified


kIsH@STAX<>alter system set clonedb=true scope=spfile;

System altered.
kIsH@STAX<>alter system set clonedb_dir='/apps01/oradata' scope=spfile;

System altered.

kIsH@STAX<>startup force
ORACLE instance started.

Total System Global Area 1962932432 bytes
Fixed Size                  9136336 bytes
Variable Size            1358954496 bytes
Database Buffers          469762048 bytes
Redo Buffers                7639040 bytes
In-Memory Area            117440512 bytes
Database mounted.
Database opened.

kIsH@STAX<>show parameter clone

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
clonedb                              boolean     TRUE
clonedb_dir                          string

Create the snapshot clone PDB

kIsH@STAX<>create pluggable database PROX2 from PROX1 snapshot copy;

Pluggable database created.

Leave a Reply