ORA-19505: failed to identify file "": RMAN Duplicate
Cause:
Missing directory structure on auxiliary database server
Solution:
Identify all missing directories and create them. All the directory structures for data files on target systems must be available on auxiliary server as well.
On Target
SQL> select name from v$datafile;
data/ORCL1P/dbfile/SYSTEM_01.DBF
data/ORCL1P/dbfile/pdbseed/ORCL1P/SYSTEM_01.DBF
data/ORCL1P/dbfile/SYSAUX_01.DBF
data/ORCL1P/dbfile/pdbseed/ORCL1P/SYSAUX_01.DBF
data/ORCL1P/dbfile/UNDO_01.DBF
data/ORCL1P/dbfile/pdbseed/ORCL1P/UNDO_01.DBF
data/ORCL1P/dbfile/USERS_01.DBF
data/ORCL1P/dbfile/PDB01/ORCL1P/SYSTEM_01.DBF
data/ORCL1P/dbfile/PDB01/ORCL1P/SYSAUX_01.DBF
data/ORCL1P/dbfile/PDB01/ORCL1P/UNDO_01.DBF
..
..
data/ORCL1P/dbfile/pdbseed/ORCL1P/SYSTEM_01.DBF
data/ORCL1P/dbfile/SYSAUX_01.DBF
data/ORCL1P/dbfile/pdbseed/ORCL1P/SYSAUX_01.DBF
data/ORCL1P/dbfile/UNDO_01.DBF
data/ORCL1P/dbfile/pdbseed/ORCL1P/UNDO_01.DBF
data/ORCL1P/dbfile/USERS_01.DBF
data/ORCL1P/dbfile/PDB01/ORCL1P/SYSTEM_01.DBF
data/ORCL1P/dbfile/PDB01/ORCL1P/SYSAUX_01.DBF
data/ORCL1P/dbfile/PDB01/ORCL1P/UNDO_01.DBF
..
..
On Auxiliary
mkdir -p data/ORCL1P/dbfile/
mkdir -p data/ORCL1P/dbfile/pdbseed/ORCL1P/
mkdir -p data/ORCL1P/dbfile/PDB01/ORCL1P/
...
..
mkdir -p data/ORCL1P/dbfile/pdbseed/ORCL1P/
mkdir -p data/ORCL1P/dbfile/PDB01/ORCL1P/
...
..
Starting backup at 07-JUL-20
channel prmy1: starting datafile copy
input datafile file number=00002 name=/data//ORCL1P/dbfile/pdbseed/ORCL1P/SYSTEM_01.DBF
channel prmy2: starting datafile copy
input datafile file number=00004 name=/data//ORCL1P/dbfile/pdbseed/ORCL1P/SYSAUX_01.DBF
ORA-17628: Oracle error 19505 returned by remote Oracle server
ORA-19505: failed to identify file ""
channel prmy2 disabled, job failed on it will be run on another channel
released channel: prmy1
released channel: prmy2
released channel: stby1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 07/07/2020 10:06:34
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
ORA-19505: failed to identify file ""
channel prmy2 disabled, job failed on it will be run on another channel
released channel: prmy1
released channel: prmy2
released channel: stby1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 07/07/2020 10:06:34
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of backup command on prmy2 channel at 07/07/2020 10:06:34
ORA-17628: Oracle error 19505 returned by remote Oracle server
ORA-19505: failed to identify file ""
RMAN-03009: failure of backup command on prmy1 channel at 07/07/2020 10:06:34
ORA-17628: Oracle error 19505 returned by remote Oracle server
ORA-19505: failed to identify file ""
ORA-17628: Oracle error 19505 returned by remote Oracle server
ORA-19505: failed to identify file ""
RMAN-03009: failure of backup command on prmy1 channel at 07/07/2020 10:06:34
ORA-17628: Oracle error 19505 returned by remote Oracle server
ORA-19505: failed to identify file ""
Comments
Post a Comment