Upgrading an Oracle Data Guard Broker Configuration

Step 1: Login to dgmgrl and disable configuration before upgradation

DGMGRL> disable configuration;
Disabled.

Step 2: set dg_broker_start parameter to a false value.

SQL> alter system set dg_broker_start=false;

System altered.

Step 3: upgrade database using dbua

Step 4: Start dg_broker by setting dg_broker_start to the true value.

SQL> alter system set dg_broker_start=true;

System altered.

Step 5: connect to dgmgrl

DGMGRL> ENABLE CONFIGURATION;
Enabled.

If you want to be updated with all our articles send us an Invitation or Follow us:

Telegram Channel: https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

Tagged:

About The Author

I am 11g OCP and OCE(RAC and GRID Infrastructure). Currently working as Oracle Database Administrator at _VOIS and Blogger (Freelancer) at Oracle-help . Previously I worked with Acute Informatics pvt ltd. and Mobile Tornado where I handled Banking Data Migration , created DR using log shipping , Golden Gate and Data Guard. I have experience of handling planned and unplanned DB role switchover and failovers and monitoring and troubleshooting Database Performance. Key skills : RMAN , GG , DG , RAC , Virtualization in OVMM.I have experience in Banking and Telecom domain. Reach me at : https://www.linkedin.com/in/jagruti-jasleniya

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.