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

前言：


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

SQL>altersystemsetlog_archive_dest_2='';Systemaltered.一、主备库启用Broker特性

主：

SQL>altersystemsetdg_broker_start=true;Systemaltered.

备：

SQL>altersystemsetdg_broker_start=true;Systemaltered.SQL>showparameterdgNAMETYPEVALUE-----------------------------------------------------------------------------adg_account_info_trackingstringLOCALadg_redirect_dmlbooleanFALSEcell_offloadgroup_namestringdg_broker_config_file1string/u01/app/oracle/product/19.3.0/dbhome_1/dbs/dr1woo.datdg_broker_config_file2string/u01/app/oracle/product/19.3.0/dbhome_1/dbs/dr2woo.datdg_broker_startbooleanTRUEinmemory_adg_enabledbooleanTRUE/dbhome_1/dbs/dr1woo.datdg_broker_config_file2string/u01/app/oracle/product/19.3.0/dbhome_1/dbs/dr2woo.datdg_broker_startbooleanTRUEinmemory_adg_enabledbooleanTRUE二、登录Broker命令行DGMGRL

dgmgrlsys/oracle@woo三、创建Primary库

DGMGRL>CREATECONFIGURATIONdg_configASPRIMARYDATABASEISwooCONNECTIDENTIFIERISwoo;Configuration"dg_config"createdwithprimarydatabase"woo"三、创建standby备库

DGMGRL>ADDDATABASEwoostyASCONNECTIDENTIFIERISwoostyMAINTAINEDASPHYSICAL;Database"woosty"added四、启用配置

DGMGRL>ENABLECONFIGURATION;Enabled.五、查看配置

DGMGRL>showconfiguration;Configuration-dg_configProtectionMode:MaxPerformanceMembers:woo-PrimarydatabaseFast-StartFailover:DisabledConfigurationStatus:SUCCESS(statusupdated0secondsago)六、查看主库信息

DGMGRL>SHOWDATABASEwoo;Database-wooRole:PRIMARYIntendedState:TRANSPORT-ONInstance(s):woo1woo2DatabaseStatus:SUCCESS七、查看备库信息

DGMGRL>showconfiguration;Configuration-dg_configProtectionMode:MaxPerformanceMembers:woo-Primarydatabasewoosty-PhysicalstandbydatabaseFast-StartFailover:DisabledConfigurationStatus:SUCCESS(statusupdated45secondsago)八、故障诊断

DGMGRL>showdatabasewoostatusreport;STATUSREPORTINSTANCE_NAMESEVERITYERROR_TEXTDGMGRL>showdatabasewoostystatusreport;STATUSREPORTINSTANCE_NAMESEVERITYERROR_TEXT

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