ORA-16025: parameter LOG_ARCHIVE_DEST_2 contains repeated or conflicting at

[Former Member]

Hi all expert,

i'm trying to config oracle data guard for replication between SOLMAN (as primary system) and SOLMAN2 (as secondary system)

SOLMAN

SID : SOM

DB_UNIQUE_NAME : SOM_PRD

SOLMAN2

SID: SOM

DB_UNIQUE_NAME : SOM_DRC

The step when i configured LOG_ARCHIVE_DEST_2 is working with Query Result "System Altered", but after i restart it to make change parameters effect to oracle instance, there is an error message

ORA-16025: parameter LOG_ARCHIVE_DEST_2 contains repeated or conflicting attributes

below is SOLMAN initSOM.ora file

*._B_TREE_BITMAP_PLANS=FALSE
*._IN_MEMORY_UNDO=FALSE
*._INDEX_JOIN_ENABLED=FALSE
*._OPTIM_PEEK_USER_BINDS=FALSE
*._OPTIMIZER_MJC_ENABLED=FALSE
*._SORT_ELIMINATION_COST_RATIO=10
*._TABLE_LOOKUP_PREFETCH_SIZE=0
*.background_dump_dest='F:\oracle\SOM\saptrace\background'
*.compatible='10.2.0'
*.control_file_record_keep_time=30
*.control_files='C:\oracle\SOM\origlogA\cntrl\cntrlSOM.dbf','C:\oracle\SOM\origlogB\cntrl\cntrlSOM.dbf','F:\oracle\SOM\sapdata1\cntrl\cntrlSOM.dbf'
*.core_dump_dest='F:\oracle\SOM\saptrace\background'
*.db_block_size=8192
*.db_cache_size=160903987
*.db_domain='SOLMAN'
*.db_files=254
*.db_name='SOM'
*.db_unique_name='SOM_PRD'
*.dml_locks=4000
*.event='10191 trace name context forever, level 1'
*.fal_client='SOM_PRD'
*.fal_server='SOM_DRC'
*.FILESYSTEMIO_OPTIONS='setall'
*.job_queue_processes=1
*.log_archive_config='DG_CONFIG=(SOM_PRD,SOM_DRC)'
*.log_archive_dest=''
*.log_archive_dest_1='LOCATION=F:\oracle\SOM\oraarch\SOMarch MANDATORY'
*.log_archive_dest_2='SERVICE=SOM_DRC OPTIONAL LGWR AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)DB_UNIQUE_NAME=SOM_DRC'
*.log_archive_dest_state_1='enable'
*.log_archive_dest_state_2='enable'
*.log_buffer=1048576
*.log_checkpoint_interval=0
*.log_checkpoints_to_alert=true
*.open_cursors=800
*.parallel_execution_message_size=16384
*.pga_aggregate_target=214538649
*.processes=80
*.query_rewrite_enabled='false'
*.recyclebin='off'
*.remote_login_passwordfile='EXCLUSIVE'
*.remote_os_authent=true
*.replication_dependency_tracking=false
*.sessions=96
*.sga_max_size=321807974
*.shared_pool_reserved_size=16090398
*.shared_pool_size=160903987
*.sort_area_retained_size=0
*.sort_area_size=2097152
*.standby_file_management='AUTO'
*.star_transformation_enabled='true'
*.undo_management='AUTO'
*.undo_retention=43200
*.undo_tablespace='PSAPUNDO'
*.user_dump_dest='F:\oracle\SOM\saptrace\usertrace'

i had not configure initialization parameters in standby instance (SOM_DRC)

Somebody Please help me, give me a clue.

Regards,

rio

[Former Member]

Hi Rio,

Set the value for the log_archive_dest_2 parameter, below;

log_archive_dest_2='SERVICE=<service_name> OPTIONAL COMPRESSION=ENABLE REOPEN=<value> MAX_FAILURE=<value> DELAY=<value>'

Remove the parameters, below;

*.log_archive_config='DG_CONFIG=(SOM_PRD,SOM_DRC)'

*.log_archive_dest=''

Best regards,

Orkun Gedik