oracle 12c 配置,Oracle 12c 配置DGMGRL

于 2021-04-09 09:28:18 发布
阅读量264 收藏
点赞数
文章标签： oracle 12c 配置

DGMGRL

The Data Guard command-line interface (DGMGRL) enables you to manage a Data Guard broker configuration and its various members directly from the command line, or from batch programs or scripts. You can use the Data Guard command-line interface as an alternative to Oracle Enterprise Manager Cloud Control (Cloud Control) for managing a Data Guard configuration.

1)修改dg_broker 为true

查看已经是true 如果不是的话 执行下面语句

alter system set dg_broker_start=true;

SQL> show parameter dg_broker_start

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

dg_broker_start boolean TRUE

--主库查看

SQL> show parameter dg

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

cell_offloadgroup_name string

dg_broker_config_file1 string /u01/app/oracle/product/12.2.0

/db_1/dbs/dr1pdbcndba_p.dat

dg_broker_config_file2 string /u01/app/oracle/product/12.2.0

/db_1/dbs/dr2pdbcndba_p.dat

dg_broker_start boolean TRUE

inmemory_adg_enabled boolean TRUE

2)dgmgrl 连接到主库

[oracle@www.cndba.cn ~]$ dgmgrl sys/oracle@cndba

DGMGRL for Linux: Release 12.2.0.1.0 - Production on Wed Aug 16 10:59:16 2017

Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.

Welcome to DGMGRL, type "help" for information.

Connected to "pdbcndba_p"

Connected as SYSDBA.

3)在 主库创建配置

DGMGRL> create configuration 'dg_cndba' as primary database is 'pdbcndba_p' connect identifier is 'PDBCNDBA_P';

Configuration "dg_cndba" created with primary database "pdbcndba_p"

create configuration '配置名称自定义' as primary database is 'db_unique_name' connect identifier is 'tnsname.ora里连接主库';

--查看配置信息

DGMGRL> SHOW CONFIGURATION

Configuration - dg_cndba

Protection Mode: MaxPerformance

Members:

pdbcndba_p - Primary database

Fast-Start Failover: DISABLED

Configuration Status:

DISABLED

4)添加备库到配置信息：

DGMGRL> add database 'pdbcndba_s' as connect identifier is 'PDBCNDBA_S' maintained as physical;

Error: ORA-16698: member has a LOG_ARCHIVE_DEST_n parameter with SERVICE attribute set

Failed.

[oracle@www.cndba.cn trace]$ oerr ora 16698

16698, 00000, "member has a LOG_ARCHIVE_DEST_n parameter with SERVICE attribute set"

// *Cause: One or more LOG_ARCHIVE_DEST_n initialization parameters that

// contain a SERVICE attribute for another member in the

// configuration were set on the new member when attempting to add a

// standby database or far sync instance to the configuration.

// *Action: Clear all LOG_ARCHIVE_DEST_n initialization parameters that

// contain a SERVICE attribute for another member in the configuration

// on the new member to be added.

这个错误可以通过在Primary 和 Standby上取消log_archive_dest_n参数来解决，实际这一块的参数应当是交给DG broker 来管理了，不再需要人为介入设置。

--主备库执行以下语句，重置参数log_archive_dest_2

SQL> alter system set log_archive_dest_2='' scope=both;

System altered.

DGMGRL> add database 'pdbcndba_s' as connect identifier is 'PDBCNDBA_S' maintained as physical;

Database "pdbcndba_s" added

add database 'db_unique_name' as connect identifier is 'tnsname.ora连接备库' maintained as physical;

--查看配置信息：

DGMGRL> show configuration

Configuration - dg_cndba

Protection Mode: MaxPerformance

Members:

pdbcndba_p - Primary database

pdbcndba_s - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:

DISABLED

DGMGRL>

DGMGRL> enable configuration;

Enabled.

DGMGRL> DGMGRL>

DGMGRL> show configuration

Configuration - dg_cndba

Protection Mode: MaxPerformance

Members:

pdbcndba_p - Primary database

pdbcndba_s - Physical standby database

Error: ORA-16664: unable to receive the result from a member

Fast-Start Failover: DISABLED

Configuration Status:

ERROR (status updated 14 seconds ago)

DGMGRL> enable database pdbcndba_s

Enabled.

DGMGRL> show configuration

Configuration - dg_cndba

Protection Mode: MaxPerformance

Members:

pdbcndba_p - Primary database

pdbcndba_s - Physical standby database

Warning: ORA-16792: configurable property value is inconsistent with member setting

Fast-Start Failover: DISABLED

Configuration Status:

WARNING (status updated 8 seconds ago)

DGMGRL> show database pdbcndba_s statusreport;

STATUS REPORT

INSTANCE_NAME SEVERITY ERROR_TEXT

cndba WARNING ORA-16714: the value of property ArchiveLagTarget is inconsistent with the member setting

cndba WARNING ORA-16714: the value of property LogArchiveMaxProcesses is inconsistent with the member setting

cndba WARNING ORA-16714: the value of property LogArchiveMinSucceedDest is inconsistent with the member setting

cndba WARNING ORA-16714: the value of property DataGuardSyncLatency is inconsistent with the member setting

cndba WARNING ORA-16714: the value of property LogArchiveTrace is inconsistent with the member setting

cndba WARNING ORA-16675: database instance restart required for property value modification to take effect

cndba WARNING ORA-16714: the value of property LogArchiveFormat is inconsistent with the member setting

备库状态报告6个属性值与数据库设置不一致，重新设置

DGMGRL> edit database pdbcndba_s set property LogArchiveFormat='%t_%s_%r.dbf';

Warning: ORA-16675: database instance restart required for property value modification to take effect

Property "logarchiveformat" updated

DGMGRL> edit database pdbcndba_s set property ArchiveLagTarget=0;

Property "archivelagtarget" updated

DGMGRL> edit database pdbcndba_s set property LogArchiveMaxProcesses=1;

Property "logarchivemaxprocesses" updated

DGMGRL> edit database pdbcndba_s set property LogArchiveMinSucceedDest=1;

Property "logarchiveminsucceeddest" updated

DGMGRL> edit database pdbcndba_s set property DataGuardSyncLatency=0;

Property "dataguardsynclatency" updated

DGMGRL> edit database pdbcndba_s set property LogArchiveTrace=0;

Property "logarchivetrace" updated

DGMGRL> show database pdbcndba_s statusreport;

STATUS REPORT

INSTANCE_NAME SEVERITY ERROR_TEXT

DGMGRL> show configuration

Configuration - dg_cndba

Protection Mode: MaxPerformance

Members:

pdbcndba_p - Primary database

pdbcndba_s - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:

SUCCESS (status updated 49 seconds ago)

https://www.cndba.cn/leo1990/article/2121

https://www.cndba.cn/leo1990/article/2121

https://www.cndba.cn/leo1990/article/2121

https://www.cndba.cn/leo1990/article/2121

https://www.cndba.cn/leo1990/article/2121

https://www.cndba.cn/leo1990/article/2121

https://www.cndba.cn/leo1990/article/2121

https://www.cndba.cn/leo1990/article/2121

https://www.cndba.cn/leo1990/article/2121

https://www.cndba.cn/leo1990/article/2121

版权声明：本文为博主原创文章，未经博主允许不得转载。

Kevin Hwang
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
[DGMGRL]Dgmgrl管理Dataguard(1)
不忘初心、方得始终
01-15 6818
Dgmgrl表示Data Guard Manager Command Line Interface，用来管理维护Dataguard，而且该命令系统自带不需要额外安装，命令简单易上手，容易学习，比sqlplus用来更加简单一些. 一、初步认识Dgmgrl [oracle@primary ~]$ dgmgrl DGMGRL for Linux: Version 11.2.0.4.0 - 64
Oracle 12c 配置DGMGRL
leo__1990的博客
05-13 1031
DGMGRL The Data Guard command-line interface (DGMGRL) enables you to manage a Data Guard broker configuration and its various members directly from the command line, or from batch programs or scripts...
Oracle 19c dgmgrl 配置
rgb_rgb的博客
10-18 814
DGMGRL> show database verbose tcyang_stb Database - tcyang_stb Role: PRIMARY Intended State: TRANSPORT-ON Instance(s): tcyang Properties: DGConnectIdentifier ...
oracle 19c使用dgmgrl来执行switchover和failover切换
coco3600的博客
08-16 370
oracle 19c使用dgmgrl来执行switchover和failover切换 [oracle@raclhr-18c-n1~]$dgmgrlsys/lhr@lhr19cdg DGMGRLfo...
Oracle 12c dgmgrl 关闭、启动dataguard的顺序
zjw922的专栏
10-15 573
使用dg broker管理的dataguard环境，启动时还是先启动备库、再启动主库。详细操作如下： GMGRL> connect sys/oracle@orcl Connected as SYSDBA. DGMGRL> startup ORACLE instance started. Database mounted. Database opened. DGMGRL> con...
Oracle12c 实战ASM(12.1) 安装配置
最新发布
03-05
Oracle 12c ASM（12.1）安装配置 Oracle 12c ASM（12.1）是 Oracle 公司推出的自动存储管理（Automatic Storage Management）系统，用于管理数据库存储资源。以下是 Oracle 12c ASM（12.1）安装配置的详细过程。 ...
window oracle12c补丁Opatch
07-31
window oracle12c补丁Opatchwindow oracle12c补丁Opatchwindow oracle12c补丁Opatchwindow oracle12c补丁Opatchwindow oracle12c补丁Opatchwindow oracle12c补丁Opatchwindow oracle12c补丁Opatchwindow oracle12c...
Oracle 12c RAC+DG安装配置
08-09
以上是Oracle 12c RAC+DG在Vmware 15 + CentOS 7.6环境下的安装配置过程，涉及了硬件规划、操作系统安装、共享磁盘设置、环境配置以及Data Guard的建立。这个过程复杂且要求细致，需要对Oracle数据库有深入理解。在...
ORACLE 12C RAC 主库配置单实例ADG
02-08
ORACLE 12C RAC 主库配置单实例 ADG Oracle 12C RAC 主库配置单实例 ADG 是一种高可用性和灾难恢复解决方案，旨在提供高可用性和数据保护。下面将详细介绍 ORACLE 12C RAC 主库配置单实例 ADG 的知识点。 一、...
Linux oracle12C安装包下载
12-23
Linux下windows64位 oracle12C安装包 winx64_12102_database_1of2.zip winx64_12102_database_2of2.zip
Oracle监听器中的XDB、_XPT、_DGMGRL 、_DGB、PLSExtProc服务_ITPUB博客.mhtml
08-19
Oracle监听器中的XDB、_XPT、_DGMGRL 、_DGB、PLSExtProc服务_ITPUB博客.mhtml
oracle 12C DG 搭建
09-30
oracle 12C DG 搭建方案以及实施，有不足，请指正，谢谢
ORACLE 11G RAC 和DG原理和安装配置
05-06
ORACLE 11G 高可用性集群RAC和容灾DG的原理和实施安装配置，希望对大家有帮助！
drc oracle,oracle 11g dataguard之dgmgrl
weixin_36481965的博客
04-06 798
１　启用dgmgrl相关参数：dg_broker_startdg_broker_config_file1配置：alter system set dg_broker_start=true scope=both;此时数据库会增加dmon进程[oracle@12crac2 ~]$ ps -ef|grep -i _dmon|grep -v greporacle 2699 1 0 06:...
Oracle 12c 新特性 --- Oracle Data Guard Broker DGMGRL接口 支持块比较
leo__1990的博客
05-10 242
概念 The new database comparison tool, introduced in this release, is also supported by Oracle Data Guard broker. The PL/SQL package that compares blocks across primary and standby databases can also ...
Oracle 12c 新特性 --- Oracle Data Guard Broker 支持执行DGMGRL命令脚本
leo__1990的博客
05-13 328
概念 This feature enables command scripts to be executed through the Oracle Data Guard broker DGMGRL command-line interface; much like in SQL*Plus. DGMGRL commands, SQL commands using the broker SQL c...
oracle 查看dg 配置,oracle官方dg举例初始化参数配置
weixin_35972313的博客
04-08 481
#Primary Role Initialization ParametersDB_NAME=chicagoDB_UNIQUE_NAME=chicagoLOG_ARCHIVE_CONFIG='DG_CONFIG=(chicago,boston)'CONTROL_FILES='/arch1/chicago/control1.ctl', '/arch2/chicago/control2.ctl'LOG...
12C DG DGMGRL必须要记住的几个小命令
weixin_34082695的博客
11-14 308
[root@roidb01 ~]# su - oracle Last login: Thu Nov 23 20:32:31 CST 2017 on pts/1 <roidb01:orcl:/home/oracle>$dgmgrl / DGMGRL for Linux: Version 12.1.0.2.0 - 64bit Productio...
Error: ORA-16698: LOG_ARCHIVE_DEST_n parameter set for object to be added
kiwi的专栏
11-05 1956
我们在进行12c broker配置的时候遇到这样的错误 Error: ORA-16698: LOG_ARCHIVE_DEST_n parameter set for object to be added 这个错误可以通过在Primary 和 Standby上取消log_archive_dest_n参数来解决，实际这一块的参数应当是交给DG broker 来管理了，不再需要人为介入设置。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值