{"id":3839,"date":"2025-06-09T11:47:00","date_gmt":"2025-06-09T11:47:00","guid":{"rendered":"https:\/\/w3buddy.com\/?post_type=cposts&#038;p=3839"},"modified":"2025-06-09T11:47:01","modified_gmt":"2025-06-09T11:47:01","slug":"oracle-data-guard-broker-dgmgrl-commands","status":"publish","type":"cposts","link":"https:\/\/w3buddy.com\/blog\/notes\/oracle-dba-d2d-tasks\/oracle-data-guard-broker-dgmgrl-commands\/","title":{"rendered":"Oracle Data Guard Broker (DGMGRL) Commands"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><strong>Key DGMGRL commands to configure, manage, validate, troubleshoot, and switch over Oracle Data Guard environments.<\/strong><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Broker Setup (DB Level)<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>-- Set Broker config file locations\nALTER SYSTEM SET dg_broker_config_file1 = '\/path\/to\/standby1.dat' SCOPE=BOTH SID='*';\nALTER SYSTEM SET dg_broker_config_file2 = '\/path\/to\/standby2.dat' SCOPE=BOTH SID='*';\n\n-- For ASM setups (RAC)\nALTER SYSTEM SET dg_broker_config_file1 = '+DATA\/broker\/standby1.dat' SCOPE=BOTH SID='*';\nALTER SYSTEM SET dg_broker_config_file2 = '+DATA\/broker\/standby2.dat' SCOPE=BOTH SID='*';\n\n-- Start the Broker\nALTER SYSTEM SET dg_broker_start = TRUE SCOPE=BOTH SID='*';<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Create &amp; Enable Configuration<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>$ dgmgrl                              -- Launch DGMGRL\nDGMGRL> CONNECT sys\/password;        -- Connect to Broker\n\n-- Create primary configuration\nDGMGRL> CREATE CONFIGURATION 'DG_CONFIG' AS PRIMARY DATABASE IS 'PRIMARY_DB' CONNECT IDENTIFIER IS PRIMARY_DB;\n\n-- Add standby\nDGMGRL> ADD DATABASE 'STANDBY_DB' AS CONNECT IDENTIFIER IS STANDBY_DB MAINTAINED AS PHYSICAL;\n\n-- Enable\nDGMGRL> ENABLE CONFIGURATION;<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">View Configuration &amp; Status<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>SHOW CONFIGURATION;                     -- Summary view  \nSHOW CONFIGURATION VERBOSE;            -- Detailed view  \nSHOW DATABASE 'PRIMARY_DB';            -- DB info  \nSHOW DATABASE 'STANDBY_DB';            -- Standby info  \nSHOW DATABASE VERBOSE 'PRIMARY_DB';    -- Detailed primary info  \n\n-- Status reports &amp; inconsistencies\nSHOW DATABASE PRIMARY_DB STATUSREPORT;\nSHOW DATABASE PRIMARY_DB InconsistentProperties;\nSHOW DATABASE STANDBY_DB InconsistentProperties;\nSHOW DATABASE PRIMARY_DB InconsistentLogXptProps;\nSHOW DATABASE STANDBY_DB InconsistentLogXptProps;<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Log &amp; Queue Checks<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>SHOW DATABASE PRIMARY_DB SENDQENTRIES;  -- Archivelog status (primary)  \nSHOW DATABASE STANDBY_DB RECVQENTRIES;  -- Received logs (standby)  \nSHOW DATABASE PRIMARY_DB TOPWAITEVENTS; -- Wait events (primary)  <\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Validation<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>VALIDATE DATABASE 'PRIMARY_DB';                 -- Validate config  \nVALIDATE DATABASE VERBOSE 'PRIMARY_DB';         -- Verbose output  \nVALIDATE DATABASE 'STANDBY_DB';                 -- Validate standby  <\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Tracing for Debug<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>-- Enable tracing\nEDIT CONFIGURATION SET PROPERTY TraceLevel = SUPPORT;\nEDIT DATABASE PRIMARY_DB SET PROPERTY LogArchiveTrace = 8191;\nEDIT DATABASE STANDBY_DB SET PROPERTY LogArchiveTrace = 8191;\n\n-- For all RAC instances\nEDIT INSTANCE * ON DATABASE 'PRIMARY_DB' SET PROPERTY LogArchiveTrace = 8191;\n\n-- Disable tracing\nEDIT CONFIGURATION RESET PROPERTY TraceLevel;\nEDIT DATABASE PRIMARY_DB RESET PROPERTY LogArchiveTrace;\nEDIT DATABASE STANDBY_DB RESET PROPERTY LogArchiveTrace;<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Switchover &amp; Convert<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>-- Switchover operation\nCONNECT sys\/password;\nSWITCHOVER TO STANDBY_DB;\n\n-- Convert standby to snapshot\nCONVERT DATABASE 'STANDBY_DB' TO SNAPSHOT STANDBY;\n\n-- Convert snapshot back to physical\nCONVERT DATABASE 'STANDBY_DB' TO PHYSICAL STANDBY;<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Key DGMGRL commands to configure, manage, validate, troubleshoot, and switch over Oracle Data Guard environments. Broker Setup (DB Level) Create &amp; Enable Configuration View Configuration &amp; Status Log &amp; Queue Checks Validation Tracing for Debug Switchover &amp; Convert<\/p>\n","protected":false},"template":"","meta":{"googlesitekit_rrm_CAowu461DA:productID":""},"categories":[952,984],"class_list":["post-3839","cposts","type-cposts","status-publish","hentry","category-notes","category-oracle-dba-d2d-tasks"],"_links":{"self":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/cposts\/3839","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/cposts"}],"about":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/types\/cposts"}],"wp:attachment":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/media?parent=3839"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/categories?post=3839"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}