Archived discussions are read-only. Learn more about SAP Q&A

ORA-16025: parameter LOG_ARCHIVE_DEST_2 contains repeated or conflicting at

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

Not what you were looking for? View more on this topic or Ask a question