This discussion is archived
7 Replies Latest reply: Dec 31, 2012 2:56 AM by 793965 RSS

RMAN-05520: database name mismatch

vk82 Explorer
Currently Being Moderated
Hi All,

My DB Version :11.2.0
OS :Linux

What i am doing is to try duplicating the database on the same machine using RMAN. But what happens when i am trying to run the below mentione command i am getting below error
RMAN> duplicate target database to test2 from active database nofilenamecheck;

Starting Duplicate Db at 31-DEC-12
using channel ORA_AUX_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 12/31/2012 02:25:32
RMAN-05520: database name mismatch, auxiliary instance has TEST1, command specified TEST2


Can anyone please suggest me why i am facing this problem.


connecting to rman as follows

rman target sys/tiger@test1

RMAN> connecting auxiliary sys/tiger@test2

Connected to auxiliary database: TEST1(not mounted)


my pfile entries for test2(cloned db ) are as follows:

test2.__db_cache_size=658505728
test2.__java_pool_size=4194304
test2.__large_pool_size=4194304
test2.__oracle_base='/home/app/oracle/app/oracle'#ORACLE_BASE set from environment
test2.__pga_aggregate_target=306184192
test2.__sga_target=914358272
test2.__shared_io_pool_size=0
test2.__shared_pool_size=239075328
test2.__streams_pool_size=0
*.audit_file_dest='/home/app/oracle/app/oracle/admin/test2/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/home/app/oracle/app/oracle/oradata/test2/control01.ctl','/home/app/oracle/app/oracle/flash_recovery_area/test2/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='test1'
*.db_recovery_file_dest='/home/app/oracle/app/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=4039114752
*.diagnostic_dest='/home/app/oracle/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=test2XDB)'
*.local_listener='LISTENER_TEST1'
*.open_cursors=300
*.pga_aggregate_target=304087040
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=912261120
*.undo_tablespace='UNDOTBS1'
*.db_file_name_convert='/home/app/oracle/app/oracle/oradata/test1','/home/app/oracle/app/oracle/oradata/test2'
*.log_file_name_convert='/home/app/oracle/app/oracle/oradata/test','/home/app/oracle/app/oracle/oradata/test2'

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points