1 Reply Latest reply: Oct 7, 2011 7:18 AM by Orkun Gedik RSS

ORA-16025: parameter LOG_ARCHIVE_DEST_2 contains repeated or conflicting at

rio firmansyah
Currently Being Moderated

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

Actions