我们在进行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
|