Showing posts with label Data Guard Broker. Show all posts
Showing posts with label Data Guard Broker. Show all posts
Tuesday, July 16, 2024

How to check StaticConnectIdentifier and other properties using Data Guard Broker

›
DGMGRL> show database cdb 'StaticConnectIdentifier' StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=or...
Wednesday, May 29, 2024

How I removed a data guard config completely

›
Here is my config: DGMGRL> show configuration; Configuration - DGConfig1 Protection Mode: MaxPerformance Members: kej01 ...
Thursday, September 7, 2023

Syntax for switching over a container database using data guard broker

›
Here I am switching over a container database called cdb, to the standby server which is running a container database with unique name cdb_...
Wednesday, January 11, 2023

More on setting redo routes property when adding a terminal standby database to your data guard broker configuration

›
As described in an earlier post , it is possible to set up a "terminal standby database" which fetches its redo information from ...
Tuesday, May 3, 2022

How to take a standby database out of a data guard configuration and convert it to a standalone read/write database using the Data Guard Broker

›
Deactive the Data Guard Broker configuration: dgmgrl / show configuration # disable log shipping edit database 'stdb' SET STATE=...
Tuesday, April 5, 2022

Workaround for Automatic Diagnostic Repository Errors when executing "validate database" through Data Guard Broker

›
If you have a Data Guard setup and using the broker, you may see the following error when validating your setup before a switchover: DGMGR...
Thursday, March 17, 2022

How to solve message from broker Warning: standby redo logs not configured for thread 1 on primary

›
DGMGRL> validate database 'proddb01'; Database Role: Primary database Ready for Switchover: Yes Flashback Database...
Thursday, May 27, 2021

How to fix error message from data guard broker "Property 'DbFileNameConvert' has inconsistent values"

›
After a rebuild of a physical standby database, I was tailing the broker log file drcSALES.log, and noticed the following warning: Proper...
Thursday, April 15, 2021

How to set up "RedoRoutes" in a Data Guard Broker configuration

›
In this example, the following members participate in my Data Guard Configuration:  Database Name Role Open Mode Functi...
Thursday, March 25, 2021

How to view a specific property for a databasen using dgmgrl

›
DGMGRL> show database 'PROD_STB' 'DbFileNameConvert';
Thursday, September 3, 2020

Potential solution to dgmgrl error ORA-16665: time out waiting for the result from a member

›
After having added a terminal standby database to an existing configuration, the Data Guard Broker configuration seemed unhappy with commu...
Monday, August 10, 2020

How to set parallelism for a data guard recovery process

›
If you need to manually set the apply-process DOP (Degree of Parallelism), you can do this by setting the property ApplyParallel= num whe...
Friday, July 31, 2020

How to connect to and start a specific database using dgmgrl

›
The data guard broker allows you to connect to any of the participating members of the configuration: oracle@myserver:[hdal]# dgmgrl / as s...
Tuesday, April 21, 2020

Potential solution to ORA-1033 during configuration of standby database in data guard broker

›
In my environment, the following message was displayed in dgmgrl when trying to configure a data guard environment: DGMGRL> add databa...
Thursday, March 12, 2020

Workaround for error Warning: ORA-16714: the value of property LogFileNameConvert is inconsistent with the member setting

›
Error from data guard: oracle@oric-dbserver01:[vegdb01]# dgmgrl / DGMGRL for Linux: Release 18.0.0.0.0 - Production on Thu Mar 12 08:02:5...
Tuesday, July 30, 2019

How do identify a transport error in a Data Guard setup using the broker

›
Applicable to Oracle 12.2 If the broker has been setup, check the configuration basics: dgmgrl / show configuration; Configuration - DGC...
2 comments: