本篇内容介绍了“分析SQL中的RAC+DataGuard Broker”的有关知识，在实际案例的操作过程中，不少人都会遇到这样的困境，接下来就让小编带领大家学习一下如何处理这些情况吧！希望大家仔细阅读，能够学有所成！
创新互联建站成都企业网站建设服务，提供做网站、
成都网站建设网站开发,网站定制,建网站,网站搭建,网站设计,
响应式网站设计,网页设计师打造企业风格网站,提供周到的售前咨询和贴心的售后服务。欢迎咨询做网站需要多少钱:028-86922220
前言：
在备库需要清理昨天的环境：
SQL> alter system set log_archive_dest_2='';
System altered.
一、主备库启用Broker特性
主：
SQL> alter system set dg_broker_start=true;
System altered.
备：
SQL> alter system set dg_broker_start=true;
System altered.
SQL> show parameter dg
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
adg_account_info_tracking string LOCAL
adg_redirect_dml boolean FALSE
cell_offloadgroup_name string
dg_broker_config_file1 string /u01/app/oracle/product/19.3.0
/dbhome_1/dbs/dr1woo.dat
dg_broker_config_file2 string /u01/app/oracle/product/19.3.0
/dbhome_1/dbs/dr2woo.dat
dg_broker_start boolean TRUE
inmemory_adg_enabled boolean TRUE /dbhome_1/dbs/dr1woo.datdg_broker_config_file2 string /u01/app/oracle/product/19.3.0 /dbhome_1/dbs/dr2woo.datdg_broker_start boolean TRUEinmemory_adg_enabled boolean TRUE
二、登录Broker命令行DGMGRL
dgmgrl sys/oracle@woo
三、创建Primary库
DGMGRL> CREATE CONFIGURATION dg_config AS PRIMARY DATABASE IS woo CONNECT IDENTIFIER IS woo;
Configuration "dg_config" created with primary database "woo"
三、创建standby备库
DGMGRL> ADD DATABASE woosty AS CONNECT IDENTIFIER IS woosty MAINTAINED AS PHYSICAL;
Database "woosty" added
四、启用配置
DGMGRL> ENABLE CONFIGURATION;
Enabled.
五、查看配置
DGMGRL> show configuration;
Configuration - dg_config
Protection Mode: MaxPerformance
Members:
woo - Primary database
Fast-Start Failover: Disabled
Configuration Status:
SUCCESS (status updated 0 seconds ago)
六、查看主库信息
DGMGRL> SHOW DATABASE woo;
Database - woo
Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
woo1
woo2
Database Status:
SUCCESS
七、查看备库信息
DGMGRL> show configuration;
Configuration - dg_config
Protection Mode: MaxPerformance
Members:
woo - Primary database
woosty - Physical standby database
Fast-Start Failover: Disabled
Configuration Status:
SUCCESS (status updated 45 seconds ago)
八、故障诊断
DGMGRL> show database woo statusreport;
STATUS REPORT
INSTANCE_NAME SEVERITY ERROR_TEXT
DGMGRL> show database woosty statusreport;
STATUS REPORT
INSTANCE_NAME SEVERITY ERROR_TEXT
“分析SQL中的RAC+DataGuard Broker”的内容就介绍到这里了，感谢大家的阅读。如果想了解更多行业相关的知识可以关注创新互联-成都网站建设公司网站，小编将为大家输出更多高质量的实用文章！
分享文章：分析SQL中的RAC+DataGuardBroker-创新互联
网页网址：
http://cdkjz.cn/article/iooji.html
