This content has been marked as final. Show 4 replies
Please post full version number and the actual code you are running ... all of it.
These could be the possibilities of the error RMAN-05520.
1) The db_name parameter could be different from target and auxiliary database init files
2) Using wrong db name in duplicate script
The error is very much clear, as you are duplicating the database ,then the db_name must be same.
RMAN-05520: database name mismatch, auxiliary instance has SID1, command specified SID2
I don't able to understand, are you duplicating the existing database (or) trying to create new database using dbca on the same host ?
I used *bold* dbca to create the new oracle instance SID2*bold* and checked the entried in the lisntner.ora and tnsnames.ora and they seems to be fine. The primary db is in mount mode and the aux database is in nomount mode. I am trying to run this command from the the db session where ORACLE_SID=SID.
Sine the dbca is not at all required. I suggest kindly check the process/steps from oracle recovery manager doc.
- Pavan Kumar N
Thank you all for your help.
I went to a different route and cloned the database using templates created using dbca , i guess it suits my needs because I might need to migrate the database to another machines.