重庆思庄Oracle、Redhat认证学习论坛

 找回密码
 注册

QQ登录

只需一步,快速开始

搜索
查看: 2302|回复: 0
打印 上一主题 下一主题

[安装] Error: ORA-16698: LOG_ARCHIVE_DEST_n parameter set for object to be added

[复制链接]
跳转到指定楼层
楼主
发表于 2022-3-25 17:36:46 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式

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




分享到:  QQ好友和群QQ好友和群 QQ空间QQ空间 腾讯微博腾讯微博 腾讯朋友腾讯朋友
收藏收藏 支持支持 反对反对
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

QQ|手机版|小黑屋|重庆思庄Oracle、Redhat认证学习论坛 ( 渝ICP备12004239号-4 )

GMT+8, 2024-11-1 07:20 , Processed in 0.097367 second(s), 20 queries .

重庆思庄学习中心论坛-重庆思庄科技有限公司论坛

© 2001-2020

快速回复 返回顶部 返回列表