2 Replies Latest reply: Jan 28, 2013 7:33 AM by Sunny kichloo RSS

    Active duplication with different DB name

    007
      Hi,

      I am trying to duplicate a Primary database in another server with different db name. On firing the duplicate target database for standby from active database nofilenamecheck i face ORA-01103: database name 'ORADB' in control file is not '11GDB' error. i even tried some other duplication commands by surfing in internet but nothing worked.

      Primary DB

      db name : ORADB

      OS : OracleLinux 5

      version : 11.2.0.1.0

      Standby DB

      db name : 11GDB

      OS : OracleLinux 5

      version : 11.2.0.1.0

      Both the db is running in ASM with different diskgroup name. The below shown in the content of the Standby database pfile.

      11GDB.__db_cache_size=314572800
      11GDB.__java_pool_size=4194304
      11GDB.__large_pool_size=4194304
      11GDB.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
      11GDB.__pga_aggregate_target=318767104
      11GDB.__sga_target=478150656
      11GDB.__shared_io_pool_size=0
      11GDB.__shared_pool_size=146800640
      11GDB.__streams_pool_size=0
      *.audit_file_dest='/u01/app/oracle/admin/11GDB/adump'
      *.audit_trail='db'
      *.compatible='11.2.0.0.0'
      *.control_files='+STDBY/11gdb/controlfile/current.260.788911153'
      *.db_block_size=8192
      *.db_create_file_dest='+STDBY'
      *.db_domain=''
      *.db_file_name_convert='+DATA','+STDBY'
      *.db_name='11GDB'
      *.db_unique_name='11GDB'
      *.diagnostic_dest='/u01/app/oracle'
      *.dispatchers='(PROTOCOL=TCP) (SERVICE=11GDBXDB)'
      *.FAL_CLIENT='11GDB'
      *.FAL_SERVER='ORADB'
      *.log_archive_config='dg_config=(ORADB,11GDB)'
      *.log_archive_dest_1='LOCATION=+STDBY valid_for=(all_logfiles,all_roles) db_unique_name=11GDB'
      *.log_archive_dest_2='service=ORADB LGWR async valid_for=(online_logfiles,primary_role) db_unique_name=ORADB'
      *.log_archive_dest_STATE_1='ENABLE'
      *.log_archive_dest_state_2='ENABLE'
      *.log_file_name_convert='+DATA','+STDBY'
      *.memory_target=796917760
      *.open_cursors=300
      *.processes=150
      *.remote_login_passwordfile='EXCLUSIVE'
      *.standby_file_management='AUTO'
      *.undo_tablespace='UNDOTBS1'

      Plz anyone tell me where it goes wrong.

      Regards,
      007
        • 1. Re: Active duplication with different DB name
          Sunny kichloo
          From the error mentioned the SID of primary is ORADB

          Whereas in the pfile displayed by you it has name

          *.db_name='11GDB'

          db_unique_name can be different but db_name should be same.

          Please do the changes and proceed and Share the output.
          • 2. Re: Active duplication with different DB name
            CKPT
            I am trying to duplicate a Primary database in another server with different db name. On firing the duplicate target database for standby from active database nofilenamecheck i face ORA-01103: database name 'ORADB' in control file is not '11GDB' error. i even tried some other duplication commands by surfing in internet but nothing worked.
            When you duplicate from primary to standby. Ensure the DB_NAME same on both primary and standby and of course you can have different DB_UNIQUE_NAME in both primary and standby databases.