为12.1 DataGuard配置DGMGRL遇到ORA-16698

为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)

 

Comments

  1. oracle.zsx says

    log_archive_dest_1参数需要reset吗?好像重启的时候报错说该参数无法被识别

Comment

*

沪ICP备14014813号-2

沪公网安备 31010802001379号