7 Replies Latest reply: Dec 31, 2012 4:56 AM by 793965 RSS

    RMAN-05520: database name mismatch

    vk82
      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'