RMAN-03002 RMAN-05520

Starting Duplicate Db at 07-JUL-15
released channel: c1
released channel: c2
released channel: ch1
released channel: ch2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 07/07/2015 06:34:15
RMAN-05520: database name mismatch, auxiliary instance has PROD, command specified TEST

Recovery Manager complete.


Here the issue is with db_name in target server, db_name set as PROD and instance started as TEST and duplicating target database to TEST. So we are duplicating to TEST but db_name set to PROD in parameter file.

i have changed the db_name parameter in parameter file to TEST and duplicate complted successfully.

Steps:

1) Check DB started with pfile or spfile

2) if it is with spfile, Take the backup of spfile and create pfile from spfile

3) shutdown the database and change directory to $ORACLE_HOME/dbs

4) open the init parameter file and change db_name parameter to TEST from PROD

5) Start the database with pfile

6) create the spfile from pfile

7) start the instance in nomount state and run the duplicate script.