如下:修改参数报错,纠结很久
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)
System altered.