分析SQL中的RAC+DataGuardBroker
本篇内容介绍了“分析SQL中的RAC+DataGuard Broker”的有关知识,在实际案例的操作过程中,不少人都会遇到这样的困境,接下来就让小编带领大家学习一下如何处理这些情况吧!希望大家仔细阅读,能够学有所成!
10年积累的成都网站设计、成都网站制作、外贸网站建设经验,可以快速应对客户对网站的新想法和需求。提供各种问题对应的解决方案。让选择我们的客户得到更好、更有力的网络服务。我虽然不认识你,你也不认识我。但先网站设计后付款的网站建设流程,更有宣化免费网站建设让你可以放心的选择与我们合作。
前言:
在备库需要清理昨天的环境:
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://pwwzsj.com/article/gccgde.html