Error: ORA-16698: LOG_ARCHIVE_DEST_n parameter set for object to be added

郑全

我们在进行12c broker配置的时候遇到这样的错误

DGMGRL> add database 'dgdb' as connect identifier is dgdb;
Error: ORA-16698: member has a LOG_ARCHIVE_DEST_n parameter with SERVICE attribute set



Error: ORA-16698: LOG_ARCHIVE_DEST_n parameter set for object to be added
这个错误可以通过在Primary 和 Standby上取消log_archive_dest_n参数来解决，实际这一块的参数应当是交给DG broker 来管理了，不再需要人为介入设置。


SQL> alter system reset log_archive_dest_1;

System altered.

SQL> alter system reset log_archive_dest_2;

System altered.



重启主备库

再去进行

DGMGRL> add database 'dgdb' as connect identifier is dgdb
> ;
Database "dgdb" added


DGMGRL> ENABLE CONFIGURATION
Enabled.


DGMGRL> SHOW CONFIGURATION

Configuration - dgtest

  Protection Mode: MaxPerformance
  Members:
  auxdb - Primary database
    dgdb  - Physical standby database

Fast-Start Failover:  Disabled

Configuration Status:
SUCCESS   (status updated 37 seconds ago)

DGMGRL>



同时，可以看到日志中，有以下记录：

2022-03-25T17:29:45.931059+08:00
ALTER SYSTEM SET log_archive_dest='' SCOPE=BOTH;
2022-03-25T17:29:45.952788+08:00
ALTER SYSTEM SET log_archive_duplex_dest='' SCOPE=BOTH;
2022-03-25T17:29:45.960490+08:00
RSM0 (PID:13293): Using STANDBY_ARCHIVE_DEST parameter default value as /u01/app/oracle/product/19.14.0/db_1/dbs/arch [krsd.c:18221]
2022-03-25T17:29:45.967221+08:00
ALTER SYSTEM SET log_archive_dest_1='LOCATION=/u01/app/oracle/product/19.14.0/db_1/dbs/arch MANDATORY','valid_for=(ALL_LOGFILES,ALL_ROLES)' SCOPE=BOTH;
2022-03-25T17:29:45.971382+08:00
ALTER SYSTEM SET log_archive_dest_state_1='ENABLE' SCOPE=BOTH;
RSM0 (PID:13293): Using STANDBY_ARCHIVE_DEST parameter default value as /u01/app/oracle/product/19.14.0/db_1/dbs/arch [krsd.c:18221]
2022-03-25T17:29:46.049214+08:00
ALTER SYSTEM SET log_archive_dest_2='service="dgdb"','ASYNC NOAFFIRM delay=0 optional compression=disable max_failure=0 reopen=300 db_unique_name="dgdb" net_timeout=30','valid_for=(online_logfile,all_roles)' SCOPE=BOTH;
2022-03-25T17:29:46.074074+08:00
ALTER SYSTEM SET log_archive_dest_state_2='ENABLE' SCOPE=BOTH;
2022-03-25T17:29:46.128609+08:00
ALTER SYSTEM SET fal_server='' SCOPE=BOTH;
2022-03-25T17:29:48.249651+08:00
Thread 1 advanced to log sequence 23 (LGWR switch),  current SCN: 2521602
  Current log# 2 seq# 23 mem# 0: /u01/app/oracle/oradata/AUXDB/redo02.log
2022-03-25T17:29:48.398426+08:00
ARC3 (PID:12687): Archived Log entry 19 added for T-1.S-22 ID 0x391dfcdb LAD:1