RMAN-05520: Database Name Mismatch (Auxiliary Has PROD, Command Specified CLONE)

Error

When running RMAN DUPLICATE, you get this error:


RMAN-05520: database name mismatch, auxiliary instance has PROD, 
command specified CLONE

RMAN started duplication.
During the process, it mounted the auxiliary database with the wrong name (PROD — from the target).
Duplication failed partway, so the auxiliary still thinks it is the source DB.

Shutdown the auxiliary database immediately:
```
sqlplus / as sysdba
shutdown abort;
```
Start the auxiliary database in NOMOUNT with the correct PFILE:
```
startup nomount pfile='/path/to/initCLONE.ora';
```

Re-run the RMAN duplicate command:


duplicate target database to CLONE from active database nofilenamecheck;

Make sure the DB_NAME in the auxiliary PFILE matches what you mention in the DUPLICATE TO command.
If duplication fails after mounting, always shutdown and restart the auxiliary in NOMOUNT before retrying.

Please do like and subscribe to my youtube channel: https://www.youtube.com/@foalabs If you like this post please follow,share and comment