做dataguard犯了一个低级错误修改参数报错ORA-16187: LOG_ARCHIVE_CONFIG contains duplicate, conflicting or invalid att

来源：互联网发布：python jsonrpc 编辑：程序博客网时间：2024/04/28 23:54

如下：修改参数报错，纠结很久

SYS@orcl>alter system set log_archive_config='DG_CONFIG=DG_CONFIG=(orcl,orcldg,orcldgl)' scope=both;

alter system set log_archive_config='DG_CONFIG=DG_CONFIG=(orcl,orcldg,orcldgl)' scope=both
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-16187: LOG_ARCHIVE_CONFIG contains duplicate, conflicting or invalid attributes

SYS@orcl>alter system set log_archive_config='DG_CONFIG=DG_CONFIG=(orcl,orcldg)' scope=both;
alter system set log_archive_config='DG_CONFIG=DG_CONFIG=(orcl,orcldg)' scope=both
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-16187: LOG_ARCHIVE_CONFIG contains duplicate, conflicting or invalid attributes
---上网查了一下没有相关的资料，纠结了有10分钟

最后发现“（）”问题，不复制，首先修改参数语句就可以了

SYS@orcl>show parameter log_archive_config

NAME TYPE VALUE
------------------------------------ --------------------------------- ------------------------------

log_archive_config string DG_CONFIG=(orcl,orcldg)

SYS@orcl> ALTER SYSTEM SET log_archive_config='DG_CONFIG=(orcl,orcldg,orcldg2)';

System altered.

0 0