Shulou(Shulou.com)05/31 Report--

This article introduces the knowledge of "analyzing RAC+DataGuard Broker in SQL". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

Foreword:

Before preparing the library, you need to clean up yesterday's environment:

SQL > alter system set log_archive_dest_2='';System altered. First, the main and standby libraries enable the Broker feature.

Lord:

SQL > alter system set dg_broker_start=true;System altered.

Standby:

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 II. Log in to the Broker command line DGMGRL

Dgmgrl sys/oracle@woo III. Create a Primary library

DGMGRL > CREATE CONFIGURATION dg_config AS PRIMARY DATABASE IS woo CONNECT IDENTIFIER IS woo;Configuration "dg_config" created with primary database "woo" 3. Create a standby repository

DGMGRL > ADD DATABASE woosty AS CONNECT IDENTIFIER IS woosty MAINTAINED AS PHYSICAL;Database "woosty" added IV. Enable configuration

DGMGRL > ENABLE CONFIGURATION;Enabled. 5. Check the configuration DGMGRL > show configuration;Configuration-dg_config Protection Mode: MaxPerformance Members: woo-Primary databaseFast-Start Failover: DisabledConfiguration Status:SUCCESS (status updated 0 seconds ago) 6. View the information of the main library

DGMGRL > SHOW DATABASE woo;Database-woo Role: PRIMARY Intended State: TRANSPORT-ON Instance (s): woo1 woo2Database Status: success 7. View repository information

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) VIII. Fault diagnosis

That's all for DGMGRL > show database woo statusreport;STATUS REPORT INSTANCE_NAME SEVERITY ERROR_TEXTDGMGRL > show database woosty statusreport;STATUS REPORT INSTANCE_NAME SEVERITY ERROR_TEXT "analyzing RAC+DataGuard Broker in SQL". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.