While i was doing active replication from production to test i got the below error in RMAN. RMAN triggered from dev server as usual. When i saw remote server i doubted the prod server then realized i was absolutely wrong. I looked into alert long in prod and everything was clean. I did tnsping and checked listener (lsnrctl status), everything was perfect from production side.
Since we connect DEV as auxiliary instance in RMAN, remote server actually means dev server. So if you ever get this error it should be caused by DEV server.
Read my blog to know how to duplicate database with backup.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 10/11/2017 15:54:56
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of backup command on c3 channel at 10/11/2017 15:54:56
ORA-17628: Oracle error 19505 returned by remote Oracle server
Error from alert log in DEV :
Create Relation IPS_PACKAGE_UNPACK_HISTORY
Completed: alter database mount
Wed Oct 11 15:54:45 2017
Errors in file /d02/DEV/oratest/11204/admin/DEV_******/diag/rdbms/dev/DEV/trace/DEV_ora_8082.trc:
ORA-19505: failed to identify file "/a02/oraclone/DEV/data/undo01.dbf"
ORA-27040: file create error, unable to create file
SVR4 Error: 2: No such file or directory
Additional information: 1
Wed Oct 11 15:54:45 2017
Errors in file /d02/DEV/oratest/11204/admin/DEV_******/diag/rdbms/dev/DEV/trace/DEV_ora_8084.trc:
I can see the instance is mounted without any issue. Even i opened the trace file too and found about the same error as alert.
ORA-19505: failed to identify file "/a02/oraclone/DEV/data/undo01.dbf"
ORA-27040: file create error, unable to create file
SVR4 Error: 2: No such file or directory
Additional information: 1
From the error i decided to check the below,
- Is the dev os user has proper permission?
- Is the directory exist?
- Checked the path for data files and log files.
Finally i found out,
db_file_name_convert='/u01/oracle/PROD/data','/a02/oraclone/DEV/data'
log_file_name_convert='/u01/oracle/PROD/data','/a02/oraclone/DEV/data'
As i checked in the pfile i provided the wrong path for the parameters above. path is actually '/d02/DEV/oratest/data', since i provided the wrong one RMAN was trying to look into the path above and returned into error. Error disappeared after i update right path in pfile.
Its purely processing issue and this post is enough for Larry to promote Oracle 18c self-autonomous database. :)
Happy learning!
Hope DBA never dies!
