ORA-16025: parameter LOG_ARCHIVE_DEST contains repeated or conflicting attributes


alter system set log_archive_dest_2='service="(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db5.anar.az)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=db1.anar.az)(SERVER=DEDICATED)))"','LGWR ASYNC NOAFFIRM delay=0 optional compression=disable max_failure=0 max_connections=1 reopen=300 db_unique_name="db1" net_timeout=15, valid_for=(all_logfiles,primary_role)' scope=both;

ERROR at line 1:

ORA-02097: parameter cannot be modified because specified value is invalid

ORA-16025: parameter LOG_ARCHIVE_DEST_2 contains repeated or conflicting attributes

Solution:

Remove “net_timeout”

alter system set log_archive_dest_2='service="(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db5.anar.az)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=db1.anar.az)(SERVER=DEDICATED)))"','LGWR ASYNC NOAFFIRM delay=0 optional compression=disable max_failure=0 max_connections=1 reopen=300 db_unique_name="db1", valid_for=(all_logfiles,primary_role)' scope=both;

System altered.

References:

Oracle. (2008). Data Guard Concepts and Administration. Retrieved 04 07, 2014, from http://docs.oracle.com/cd/B19306_01/server.102/b14239/log_transport.htm#i1265762

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: