When startup nomount on stadby database,getting ORA-16187: LOG_ARCHIVE_CONFIG contains duplicate, conflicting or invalid attributes (Doc ID 2070109.1)

Last updated on OCTOBER 23, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 to 12.1.0.2 [Release 12.1]
Linux x86-64

Symptoms

The database environment is single used ASM on 12.1.0.2.

Primary database created and completely configured .

And then to "startup nomount" the standby database in the begging of standby database creation, the following error occured.

[oracle@adg12102ls dbs]$ sqlplus / as sysdba                             

SQL*Plus: Release 12.1.0.2.0 Production on Sat Oct 24 10:09:07 2015

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORA-16187: LOG_ARCHIVE_CONFIG contains duplicate, conflicting or invalid attributes

 

Changes

 [oracle@adg12102ls dbs]$ cat initadg12102ls.ora
adg12102ls.__data_transfer_cache_size=0
adg12102ls.__db_cache_size=1275068416
adg12102ls.__java_pool_size=16777216
adg12102ls.__large_pool_size=33554432
adg12102ls.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
adg12102ls.__pga_aggregate_target=603979776
adg12102ls.__sga_target=1811939328
adg12102ls.__shared_io_pool_size=83886080
adg12102ls.__shared_pool_size=385875968
adg12102ls.__streams_pool_size=0
*.archive_lag_target=0
*.audit_file_dest='/u01/app/oracle/admin/adg12102p/adump'
*.audit_trail='db'
*.compatible='12.1.0.2.0'
*.control_files='+DATA/ADG12102P/CONTROLFILE/current.261.893507273','+FRA/ADG12102P/CONTROLFILE/current.256.893507273'
*.db_block_size=8192
*.db_create_file_dest='+DATA'
*.db_domain=''
*.db_name='adg12102'
*.db_recovery_file_dest='+FRA'
*.db_recovery_file_dest_size=4560m
#*.db_unique_name='adg12102ls'
*.dg_broker_start=TRUE
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=adg12102lsXDB)'
*.enable_pluggable_database=true
*.fal_client='adg12102ls'
*.fal_server='adg12102ls'
*.open_cursors=300
*.log_archive_config='dg_config=(adg12102ls,adg12102p)';              <<<<<<<<<<<< here, I add this for future creation.
adg12102ls.log_archive_format='arch_%r_%t_%s.arc'
*.log_archive_max_processes=4
*.log_archive_min_succeed_dest=1
adg12102ls.log_archive_trace=0
*.pga_aggregate_target=571m
*.processes=300
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=1713m
*.standby_file_management='AUTO'
*.undo_tablespace='UNDOTBS1'

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms