为12.1.0.2 DataGuard配置DGMGRL时遇到了ORA-16698错误:
BANNER CON_ID ------------------------------------------------------------------------------------------ ---------- Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production 0 PL/SQL Release 12.1.0.2.0 - Production 0 CORE 12.1.0.2.0 Production 0 TNS for Linux: Version 12.1.0.2.0 - Production 0 NLSRTL Version 12.1.0.2.0 - Production 0 DGMGRL> DGMGRL> [oracle@PD009 ~]$ oerr ora 16698 16698, 0000, "LOG_ARCHIVE_DEST_n parameter set for object to be added" // *Cause: One or more LOG_ARCHIVE_DEST_n initialization parameters that // contain a SERVICE attribute but not the NOREGISTER attribute were // set when attempting to create a configuration or add a standby or // far sync instance to the configuration. askmac.cn // *Action: If creating a configuration, clear all LOG_ARCHIVE_DEST_n // initialization parameters that contain a SERVICE attribute but not // the NOREGISTER attribute. If adding a standby database or far sync // instance, clear the LOG_ARCHIVE_DEST_n initialization parameter // that specifies the database or far sync instance to be added.
这个错误可以通过在Primary 和 Standby上取消log_archive_dest_n参数来解决,实际这一块的参数应当是交给DG broker 来管理了,不再需要人为介入设置。
primary: SQL> alter system reset log_archive_dest_2 scope=spfile sid='*'; System altered. SQL> alter system reset log_archive_dest_1 scope=spfile sid='*'; System altered. SQL> startup force; ORACLE instance started. standby: SQL> alter system reset log_archive_dest_2 scope=spfile sid='*'; System altered. SQL> alter system reset log_archive_dest_1 scope=spfile sid='*'; System altered. 重启primary和standby实例 [oracle@PD009 ~]$ dgmgrl sys/oracle@PDPROD DGMGRL for Linux: Version 12.1.0.2.0 - 64bit Production Copyright (c) 2000, 2013, Oracle. All rights reserved. Welcome to DGMGRL, type "help" for information. Connected as SYSDBA. DGMGRL> create CONFIGURATION PDPROD as primary database is PDPROD CONNECT IDENTIFIER IS PDPROD; Configuration "pdprod" created with primary database "pdprod" add database PDSTBY as CONNECT IDENTIFIER IS PDSTBY MAINTAINED AS PHYSICAL; Database "pdstby" added Connected as SYSDBA. DGMGRL> enable configuration; Enabled. DGMGRL> DGMGRL> show configuration; Configuration - pdprod Protection Mode: MaxPerformance Members: pdprod - Primary database pdstby - Physical standby database Fast-Start Failover: DISABLED Configuration Status: SUCCESS (status updated 5 seconds ago)
log_archive_dest_1参数需要reset吗?好像重启的时候报错说该参数无法被识别