19c 探索高可用系列(二) - 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 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
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/20674423/viewspace-2681873/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
