19c 创建PDB快照报错:ORA-65169,ORA-17517

郑全

SQL> alter pluggable database pdb2
  2     snapshot pdb2_first_snap;
alter pluggable database pdb2
*
ERROR at line 1:
ORA-65169: error encountered while attempting to copy file
+DATA/CDB1/D86B683A56D1541CE0537885A8C06795/DATAFILE/undotbs1.277.1097147211
ORA-17517: Database cloning using storage snapshot failed on file
8:+DATA/CDB1/D86B683A56D1541CE0537885A8C06795/DATAFILE/undotbs1.277.1097147211


这个问题，主要是到目前为此，PDB快照不支持ASM，可以使用文件系统。或者设置

alter system set clonedb=true scope=spfile;

郑全

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




In this Document

Symptoms
Cause
Solution
References


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 :


create pluggable database pclone1 from pclone snapshot copy file_name_convert=('/oradata/testclone/datafile/o1_mf_system_c5bocwh0_.dbf','/oradata/testclone2/system01.dbf','/oradata/testclone/datafile/o1_mf_sysaux_c5bocwh3_.dbf','/oradata/testclone2/sysaux01.dbf','/oradata/testclone/datafile/o1_mf_users_c5bocwh5_.dbf','/oradata/testclone2/users01.dbf','/oradata/testclone/datafile/o1_mf_temp_c5bocwh5_.dbf','/oradata/testclone2/temp01.dbf')
*
ERROR at line 1:
ORA-65169: error encountered while attempting to copy file
/oradata/testclone/datafile/o1_mf_syst
em_c5bocwh0_.dbf
ORA-17525: Database clone using storage snapshot not supported on file
/oradata/testclone/datafile/o1_mf_syst
em_c5bocwh0_.dbf




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

SQL> alter system set clonedb=true scope=spfile;

Then restart database