1 2 Previous Next 19 Replies Latest reply on Mar 29, 2012 5:27 PM by CKPT

    ORA-16025: parameter LOG_ARCHIVE_DEST_2 contains repeated or conflicting

    914276
      I am doing to create PROD and STANDBY DB in the same host machine and on different Oracle Servers but facing ORA-16025 error when i issue startup nomount at STANDBY DB and can u please check whether the Value given in the Standby_archive_dest parameter is correct or not?

      My Host name is : www.dba.com

      **PROD Pfile**

      # Database name
      db_name=prod
      db_unique_name=prim
      # Location of Archive logs
      log_archive_config='DG_CONFIG=(prim,dr)'
      log_archive_dest_1='LOCATION=/home/oracle/d03/oradata/prod/arch DB_UNIQUE_NAME=prim'
      log_archive_dest_2='service=TO_DR reopen=15 DB_UNIQUE_NAME=dr'
      log_archive_dest_state_1=ENABLE
      log_archive_dest_state_2=ENABLE
      log_archive_format='log_%t_%s_%d_%r.arc'i
      standby_file_management=AUTO
      standby_archive_dest=/home/oracle/d03/oradata/prod/arch
      # Compatibilty of DB
      compatible=11.1.0
      # Global Naming -- enforce that a dblink has same name as the db it connects to
      global_names = TRUE
      # Convert Parameters
      db_file_name_convert='/home/oracle/d03/oradata/prod/','/home/oracle_1/d01/oradata/dr/'
      log_file_name_convert='/home/oracle/d03/oradata/prod/','/home/oracle_1/d01/oradata/dr/'

      Listener

      TO_PROD =
      (DESCRIPTION_LIST =
      (DESCRIPTION =
      (ADDRESS=(PROTOCOL = TCP)(HOST = www.dba.com)(PORT = 1662)(QUEUESIZE = 10))
      )
      )
      SID_LIST_TO_PROD =
      (SID_LIST =
      (SID_DESC =
      (SID_NAME = PROD)
      (ORACLE_HOME = /home/oracle/app/oracle/product/11.1.0)
      )
      )

      tnsnames

      TO_DR =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = www.dba.com)(PORT = 1555))
      (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = PROD)
      )
      )

      **DR pfile**

      # Database name
      db_name=prod
      db_unique_name=dr
      # Location of Archive logs
      log_archive_dest_1='location=/home/oracle_1/d01/oradata/dr/arch DB_UNIQUE_NAME=dr'
      log_archive_dest_2='SERVICE=TO_PRIM repoen=15 DB_UNIQUE_NAME=prim'
      log_archive_dest_state_1=ENABLE
      log_archive_dest_state_2=ENABLE
      standby_archive_dest='/home/oracle_1/d01/oradata/dr/arch'
      log_archive_format='log_%t_%s_%d_%r.arc'
      # Compatibilty of DB
      compatible=11.1.0
      # Global Naming -- enforce that a dblink has same name as the db it connects to
      global_names = TRUE
      # Convert Parameters
      db_file_name_convert='/home/oracle_1/d01/oradata/dr/','/home/oracle/d03/oradata/prod/'
      log_file_name_convert='/home/oracle_1/d01/oradata/dr/','/home/oracle/d03/oradata/prod/'

      Listener

      TO_STANDBY =
      (DESCRIPTION_LIST =
      (DESCRIPTION =
      (ADDRESS=(PROTOCOL = TCP)(HOST = www.dba.com)(PORT = 1555)(QUEUESIZE = 10))
      )
      )
      SID_LIST_TO_STANDBY =
      (SID_LIST =
      (SID_DESC =
      (SID_NAME = PROD)
      (ORACLE_HOME = /home/oracle_1/app/oracle/product/11.1.0)
      )
      )

      tnsnames

      TO_PRIM =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = www.dba.com)(PORT = 1662))
      (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = PROD)
      )
      )
        1 2 Previous Next