This discussion is archived
1 2 Previous Next 19 Replies Latest reply: Mar 29, 2012 10:27 AM by CKPT RSS

ORA-16025: parameter LOG_ARCHIVE_DEST_2 contains repeated or conflicting

914276 Newbie
Currently Being Moderated
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

Legend

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