Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Remote PDB cloning error

AndyPolJan 10 2022 — edited Jan 10 2022

Hi
I spent few hours to try remote cloning pdb without success.
My envieronments are based on Oracle Cloud:
Source DB
Oracle EE 18.13
Target DB
Oracle EE 18.14

My steps:
CREATE PLUGGABLE DATABASE pdb1 FROM pdb1@ORCL.Blabla.blabla.ORACLEVCN.COM
KEYSTORE IDENTIFIED BY secret;

10 min. later:
ORA-65169: error encountered while attempting to copy file +DATA/ORCL_IAD1WR/D10F6DABF0F73320E0532A00000A1CB5/DATAFILE/users.279.1088940385
ORA-17628: Oracle error 19505 returned by remote Oracle server
ORA-19505: failed to identify file ""

*Source db alert log:*
....
Deleted Oracle managed file +RECO/ORCL_IAD1WR/ARCHIVELOG/2021_12_14/thread_1_seq_3038.1299.1091300507
Control autobackup written to DISK device

handle '+RECO/ORCL_IAD1WR/AUTOBACKUP/2022_01_10/s_1093597306.1299.1093597307'

2022-01-10T09:07:52.236892+00:00
Errors in file /u01/app/oracle/diag/rdbms/orcl_iad1wr/orcl/trace/orcl_ora_22245.trc:
ORA-19505: failed to identify file "+DATA/ORCL_DEV/D53783DAEBBFD83EE0536400640A67CC/DATAFILE/erp_index01.291.1093597003223"
ORA-17503: ksfdopn:2 Failed to open file +DATA/ORCL_DEV/D53783DAEBBFD83EE0536400640A67CC/DATAFILE/erp_index01.291.1093597003223
ORA-15173: entry 'ORCL_DEV' does not exist in directory '/'
2022-01-10T09:07:52.244243+00:00
Errors in file /u01/app/oracle/diag/rdbms/orcl_iad1wr/orcl/trace/orcl_ora_22241.trc:
ORA-19505: failed to identify file "+DATA/ORCL_DEV/D53783DAEBBFD83EE0536400640A67CC/DATAFILE/system.293.1093597003223"
ORA-17503: ksfdopn:2 Failed to open file +DATA/ORCL_DEV/D53783DAEBBFD83EE0536400640A67CC/DATAFILE/system.293.1093597003223
ORA-15173: entry 'ORCL_DEV' does not exist in directory '/'
2022-01-10T09:07:52.246138+00:00
Errors in file /u01/app/oracle/diag/rdbms/orcl_iad1wr/orcl/trace/orcl_ora_22239.trc:
ORA-19505: failed to identify file "+DATA/ORCL_DEV/D53783DAEBBFD83EE0536400640A67CC/DATAFILE/erp_blob01.292.1093597003223"
ORA-17503: ksfdopn:2 Failed to open file +DATA/ORCL_DEV/D53783DAEBBFD83EE0536400640A67CC/DATAFILE/erp_blob01.292.1093597003223
ORA-15173: entry 'ORCL_DEV' does not exist in directory '/'
2022-01-10T09:07:52.252357+00:00
Errors in file /u01/app/oracle/diag/rdbms/orcl_iad1wr/orcl/trace/orcl_ora_22243.trc:
ORA-19505: failed to identify file "+DATA/ORCL_DEV/D53783DAEBBFD83EE0536400640A67CC/DATAFILE/users.290.1093597003223"
ORA-17503: ksfdopn:2 Failed to open file +DATA/ORCL_DEV/D53783DAEBBFD83EE0536400640A67CC/DATAFILE/users.290.1093597003223
ORA-15173: entry 'ORCL_DEV' does not exist in directory '/'
2022-01-10T09:07:52.384129+00:00
Errors in file /u01/app/oracle/diag/rdbms/orcl_iad1wr/orcl/trace/orcl_ora_22263.trc:
ORA-19505: failed to identify file "+DATA/ORCL_DEV/D53783DAEBBFD83EE0536400640A67CC/DATAFILE/undotbs1.294.1093597003223"
ORA-17503: ksfdopn:2 Failed to open file +DATA/ORCL_DEV/D53783DAEBBFD83EE0536400640A67CC/DATAFILE/undotbs1.294.1093597003223
ORA-15173: entry 'ORCL_DEV' does not exist in directory '/'
2022-01-10T09:07:52.393834+00:00
Errors in file /u01/app/oracle/diag/rdbms/orcl_iad1wr/orcl/trace/orcl_ora_22267.trc:
ORA-19505: failed to identify file "+DATA/ORCL_DEV/D53783DAEBBFD83EE0536400640A67CC/DATAFILE/erp_data01.296.1093597003223"
ORA-17503: ksfdopn:2 Failed to open file +DATA/ORCL_DEV/D53783DAEBBFD83EE0536400640A67CC/DATAFILE/erp_data01.296.1093597003223
ORA-15173: entry 'ORCL_DEV' does not exist in directory '/'
2022-01-10T09:07:52.400479+00:00
Errors in file /u01/app/oracle/diag/rdbms/orcl_iad1wr/orcl/trace/orcl_ora_22265.trc:
ORA-19505: failed to identify file "+DATA/ORCL_DEV/D53783DAEBBFD83EE0536400640A67CC/DATAFILE/logger.295.1093597003223"
ORA-17503: ksfdopn:2 Failed to open file +DATA/ORCL_DEV/D53783DAEBBFD83EE0536400640A67CC/DATAFILE/logger.295.1093597003223
ORA-15173: entry 'ORCL_DEV' does not exist in directory '/'
2022-01-10T09:07:52.404991+00:00
Errors in file /u01/app/oracle/diag/rdbms/orcl_iad1wr/orcl/trace/orcl_ora_22272.trc:
ORA-19505: failed to identify file "+DATA/ORCL_DEV/D53783DAEBBFD83EE0536400640A67CC/DATAFILE/sysaux.297.1093597003223"
ORA-17503: ksfdopn:2 Failed to open file +DATA/ORCL_DEV/D53783DAEBBFD83EE0536400640A67CC/DATAFILE/sysaux.297.1093597003223
ORA-15173: entry 'ORCL_DEV' does not exist in directory '/'
2022-01-10T09:07:52.486710+00:00
Errors in file /u01/app/oracle/diag/rdbms/orcl_iad1wr/orcl/trace/orcl_ora_22290.trc:
ORA-19505: failed to identify file "+DATA/ORCL_DEV/D53783DAEBBFD83EE0536400640A67CC/DATAFILE/erp_data01.298.1093597003223"
ORA-17503: ksfdopn:2 Failed to open file +DATA/ORCL_DEV/D53783DAEBBFD83EE0536400640A67CC/DATAFILE/erp_data01.298.1093597003223
ORA-15173: entry 'ORCL_DEV' does not exist in directory '/'
2022-01-10T09:07:52.487269+00:00
Errors in file /u01/app/oracle/diag/rdbms/orcl_iad1wr/orcl/trace/orcl_ora_22292.trc:
ORA-19505: failed to identify file "+DATA/ORCL_DEV/D53783DAEBBFD83EE0536400640A67CC/DATAFILE/erp_data01.299.1093597003223"
ORA-17503: ksfdopn:2 Failed to open file +DATA/ORCL_DEV/D53783DAEBBFD83EE0536400640A67CC/DATAFILE/erp_data01.299.1093597003223
ORA-15173: entry 'ORCL_DEV' does not exist in directory '/'

*Target db alert log:*

2022-01-10T13:05:27.990058+00:00
CREATE PLUGGABLE DATABASE pdb1 FROM pdb1 @ORCL.Blabla.blabla.ORACLEVCN.COM KEYSTORE IDENTIFIED BY *
2022-01-10T13:05:28.766995+00:00
Opatch validation is skipped for PDB pdb1 (con_id=5)
2022-01-10T13:16:35.594761+00:00
Failed to rename file +DATA/ORCL_DEV/D53AB99EEC23E0B2E0536400640A9594/DATAFILE/users.345.1093611929.
2022-01-10T13:16:35.597476+00:00
Failed to rename file +DATA/ORCL_DEV/D53AB99EEC23E0B2E0536400640A9594/DATAFILE/erp_index01.346.1093611929.
2022-01-10T13:16:35.599418+00:00
Failed to rename file +DATA/ORCL_DEV/D53AB99EEC23E0B2E0536400640A9594/DATAFILE/erp_blob01.347.1093611929.
2022-01-10T13:16:35.601871+00:00
Failed to rename file +DATA/ORCL_DEV/D53AB99EEC23E0B2E0536400640A9594/DATAFILE/system.348.1093611929.
2022-01-10T13:16:35.738100+00:00
Failed to rename file +DATA/ORCL_DEV/D53AB99EEC23E0B2E0536400640A9594/DATAFILE/undotbs1.349.1093611929.
2022-01-10T13:16:35.747345+00:00
Failed to rename file +DATA/ORCL_DEV/D53AB99EEC23E0B2E0536400640A9594/DATAFILE/logger.350.1093611929.
2022-01-10T13:16:35.750810+00:00
Failed to rename file +DATA/ORCL_DEV/D53AB99EEC23E0B2E0536400640A9594/DATAFILE/erp_data01.351.1093611929.
2022-01-10T13:16:35.765912+00:00
Failed to rename file +DATA/ORCL_DEV/D53AB99EEC23E0B2E0536400640A9594/DATAFILE/sysaux.352.1093611929.
2022-01-10T13:16:35.872518+00:00
Failed to rename file +DATA/ORCL_DEV/D53AB99EEC23E0B2E0536400640A9594/DATAFILE/erp_data01.353.1093611931.
2022-01-10T13:16:35.876312+00:00
Failed to rename file +DATA/ORCL_DEV/D53AB99EEC23E0B2E0536400640A9594/DATAFILE/erp_data01.354.1093611931.
2022-01-10T13:16:36.001268+00:00
**************************************************************
Undo Create of Pluggable Database pdb1 with pdb id - 5.
**************************************************************
ORA-65169 signalled during: CREATE PLUGGABLE DATABASE pdb1 FROM pdb1 @ORCL.Blabla.blabla.ORACLEVCN.COM KEYSTORE IDENTIFIED BY *...
Failed to rename file +DATA/ORCL_DEV/D53AB99EEC23E0B2E0536400640A9594/DATAFILE/users.345.1093611929.

I'm sure I have enough spaces on target and source.

Comments
Post Details
Added on Jan 10 2022
0 comments
676 views