标题: 19c 创建PDB快照报错:ORA-65169,ORA-17517 [打印本页] 作者: 郑全 时间: 2022-2-20 12:12 标题: 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;
作者: 郑全 时间: 2022-2-20 12:13
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.