Re: rman duplicate error
Posted by ErmanArslansOracleBlog on Aug 14, 2020; 9:53am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/rman-duplicate-error-tp8638p8640.html
That note says - >
Question: Do you have an "init<primary_sid>.ora" in the $ORACLE_HOME/dbs directory at the target/source database host?
Answer : Yes, there is a PFILE init<primary_sid>.ora there.
So in your case, do you have an init<SID>.ora in your source instance or not?
What is initdware11.ora there?
Note says -> Remove the pfile from the Target Database $ORACLE_HOME/dbs if the database is started using the SPFILE.
Then execute the duplicate database again.
That "target" means RMAN Target, which means source.
Also it checks the auxilariy spfile by this name -> /u01/app/ora12c/product/12.1.0/dbhome_1/dbs/spfiledware11.ora.
So it checks 11.ora not 1.ora..
Your TNS connection should be RAC-RMAN Duplicate aware as well.
Please review this one -> STEP BY STEP RMAN DUPLICATE Database From RAC ASM To RAC ASM (Doc ID 1913937.1)