Broker介绍
DG Broker是一个分布式管理框架，可自动且集中创建、维护和监控 DG。
broke作用
DG Broker搭建adg过程展示
[oracle@prodsty admin]$ cat listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = prod)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)
(SID_NAME = prod)
)
)
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.2)(PORT = 1521))
)
Tnsnames.pra
[oracle@prodsty admin]$ cat tnsnames.ora
pri =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = prod)
)
)
sty =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = prod)
)
)[oracle@prodpri dbs]$scp initprod.ora 192.168.**.*:
/u01/oracle/product/db11gr2/dbs
[oracle@prodpri dbs]$scp orapwprod 192.168.**.*:
/u01/oracle/product/db11gr2/dbs并修改db_unique_name，创建相关目录，启动数据库到nomount状态。
SQL> startup nomount。[oracle@prodsty dbs]$rman target sys/"#EDC5rdx"@pri
auxiliary sys/"#EDC5rdx"@sty nocatalog <rman.log
RMAN> duplicate target database for standby from active
database dorecover nofilenamecheck; SQL> alter system set dg_broker_config_file1 =/oradata/prod/dr1.dat;
System altered.
SQL> alter system set dg_broker_config_file2 =/oradata/prod/dr2.dat;
System altered.
SQL> alter system set dg_broker_start=true;
System altered.
SQL> show parameter broker
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
dg_broker_config_file1 string /oradata/prod/dr1.dat
dg_broker_config_file2 string /oradata/prod/dr2.dat
dg_broker_start boolean TRUE[oracle@prod prod]$ dgmgrl /
DGMGRL for Linux: Version 11.2.0.4.0 - 64bit Production
Copyright (c) 2000, 2009, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
Connected.
DGMGRL> create configuration prod as primary database is prod_pri connect identifier is pri;
Configuration "prod" created with primary database "prod_pri"DGMGRL> add database prod_sty as connect identifier is sty maintained as physical;
Database "prod_sty" added
DGMGRL> enable configuration;
Enabled.DGMGRL> show configuration
Configuration - prod
Protection Mode: MaxPerformance
Databases:
prod_pri - Primary database
prod_sty - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESSDGMGRL> edit database prod_pri set property LogXptMode=SYNC;
Property "logxptmode" updated
DGMGRL> edit database prod_sty set property LogXptMode=SYNC;
Property "logxptmode" updated
DGMGRL> edit database prod_pri set property StandbyFileManagement = AUTO;
Property "standbyfilemanagement" updated
DGMGRL> edit database prod_sty set property StandbyFileManagement = AUTO;
Property "standbyfilemanagement" updated
DGMGRL> edit configuration set protection mode as maxavailability;
Succeeded.[oracle@prod ~]$ dgmgrl sys/#EDC5rdx@pri
DGMGRL for Linux: Version 11.2.0.4.0 - 64bit Production
Copyright (c) 2000, 2009, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
Connected.
DGMGRL> switchover to prod_sty
Performing switchover NOW, please wait...
New primary database "prod_sty" is opening...
Operation requires startup of instance "prod" on database "prod_pri"
Starting instance "prod"...
ORACLE instance started.
Database mounted.
Database opened.
Switchover succeeded, new primary is "prod_sty"DGMGRL> show configuration;
Configuration - prod
Protection Mode: MaxAvailability
Databases:
prod_sty - Primary database
prod_pri - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS-----------------------------------------
文章版权归作者所有，未经允许请勿转载,若此文章存在违规行为，您可以联系管理员删除。
转载请注明本文地址：https://www.ucloud.cn/yun/129700.html
19C DG Broker配置和测试 img{ display:block; margin:0 auto !important; width:100%; } body{ width:75%; ...
摘要：问题九库控制文件扩展报错库的扩展报错，用的是裸设备，和还是原来大小，主库的没有报错，并且大小没有变，求解释。专家解答从报错可以看出，控制文件从个块扩展到个块时报错，而裸设备最大只支持个块，无法扩展，可以尝试将参数改小，避免控制文件报错。 链接描述引言 近期我们在DBASK小程序新关联了运维之美、高端存储知识、一森咖记、运维咖啡吧等数据领域的公众号，欢迎大家阅读分享。 问答集萃 接下来，...
摘要：新晋技术专家下面是墨天轮部分新晋的技术专家。大家可以点击往期阅读墨天轮技术专家邀请函了解详情，申请成为我们的技术专家，加入专家团队，与我们一起创建一个开放互助的数据库技术社区。新关联公众号墨天轮是一个开放互助的数据库技术社区。 引言 近期我们在DBASK小程序增加了数据库 MongoDB、Redis、 Elasticsearch、DB2、Weblogic 等新的的专题栏目和一些新的技术...
阅读 1249·2023-01-11 13:20
阅读 1557·2023-01-11 13:20
阅读 1011·2023-01-11 13:20
阅读 1680·2023-01-11 13:20
阅读 3971·2023-01-11 13:20
阅读 2519·2023-01-11 13:20
阅读 1310·2023-01-11 13:20
阅读 3486·2023-01-11 13:20
