Running into following error during duplicate target database for standby from active database. I woudl appreciate any help on that..
contents of Memory Script:
{
backup as copy reuse
passwordfile auxiliary format '/oradb/app/oracle/product/19.22.0/db_1/dbs/orapwDBDEV2' ;
restore clone from service 'DBDEV2_serverDBDEV2' spfile to
'/oradb/app/oracle/product/19.22.0/db_1/dbs/spfileDBDEV2.ora';
sql clone "alter system set spfile= ''/oradb/app/oracle/product/19.22.0/db_1/dbs/spfileDBDEV2.ora''";
}
executing Memory Script
Starting backup at 30-JUL-24
released channel: d1
released channel: a1
released channel: d2
released channel: a2
released channel: d3
released channel: a3
released channel: d4
released channel: a4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 07/30/2024 08:00:18
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of backup command on d1 channel at 07/30/2024 08:00:18
ORA-17628: Oracle error 19505 returned by remote Oracle server
ORA-19505: failed to identify file ""
Here are the actual error from Source Database alert.log
Errors in file /orahome/u01/app/oracle/diag/rdbms/DBDEV2_serverDBDEV2/DBDEV2/trace/DBDEV2_ora_11521.trc:
ORA-19505: failed to identify file "/oradb/app/oracle/product/19.22.0/db_1/dbs/orapwDBDEV2"
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 1
--Thanks