分析SQL中的RAC+DataGuard Broker

本篇内容介绍了"分析SQL中的RAC+DataGuard Broker"的有关知识，在实际案例的操作过程中，不少人都会遇到这样的困境，接下来就让小编带领大家学习一下如何处理这些情况吧！希望大家仔细阅读，能够学有所成！

前言：

在备库需要清理昨天的环境：

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 dgNAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------adg_account_info_tracking            string      LOCALadg_redirect_dml                     boolean     FALSEcell_offloadgroup_name               stringdg_broker_config_file1               string      /u01/app/oracle/product/19.3.0                                                 /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                                               /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 databaseFast-Start Failover:  DisabledConfiguration Status:SUCCESS   (status updated 0 seconds ago)

六、查看主库信息

DGMGRL> SHOW DATABASE woo;Database - woo  Role:               PRIMARY  Intended State:     TRANSPORT-ON  Instance(s):    woo1    woo2Database Status:SUCCESS

七、查看备库信息

DGMGRL>  show configuration;Configuration - dg_config  Protection Mode: MaxPerformance  Members:  woo    - Primary database    woosty - Physical standby databaseFast-Start Failover:  DisabledConfiguration Status:SUCCESS   (status updated 45 seconds ago)

八、故障诊断

DGMGRL> show database woo statusreport;STATUS REPORT       INSTANCE_NAME   SEVERITY ERROR_TEXTDGMGRL> show database woosty statusreport;STATUS REPORT       INSTANCE_NAME   SEVERITY ERROR_TEXT

"分析SQL中的RAC+DataGuard Broker"的内容就介绍到这里了，感谢大家的阅读。如果想了解更多行业相关的知识可以关注网站，小编将为大家输出更多高质量的实用文章！