Hi,
I am trying to create standby database using RMAN duplicate active. When I execute RMAN script it fails at below error (when RMAN duplicate shutdown and restarts auxiliary instance).
Upon checking RMAN log, during auxiliary restart it is creating new spfile in $ORACLE_HOME/dbs folder of standby database server and this spfile has contents belonging to primary prod.
It looks like its picking up audit dest path from this spfile and hence resulting into below error.
Does any one has idea why it is picking up spfile created from production even though I have used init.ora pfile to start auxiliary in nomount ?
I have also created audit dest folder and setup parameter in init pfile of auxiliary instance but stil doesn't work.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 12/02/2017 12:09:20
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-04014: startup failed: ORA-09925: Unable to create audit trail file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 9925
RMAN-04017: startup error description: ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance