Before configuring Data Guard Broker, following prerequisites must be fulfilled. To know about DG Broker Architecture Data Guard Broker Architecture 1. To configure Data Guard Broker , we need an enterprise edition of a database. 2. We can configure data guard broker on a single instance and RAC [multiple] instance. 3. DG_BROKER_START initialization parameter must […]
Articles Tagged: DATAGUARD
Data Guard Broker Architecture
Before understanding, Architecture let us first understand the components of Data Guard Broker. To know more about it Oracle Dataguard Data Guard Components : Oracle Data Guard Broker consists of Client side and Server side components. Client Side Components Oracle Enterprise Manager DGMGRL [command line interface] 2. Server Side Components DMON Process Configuration Files DMON Process […]
Manual Failover in Data Guard
We understood roles of the database in the previous article and explored SwitchOver of database roles. Manual SwitchOver in Oracle In this article, we will see FailOver of the Database role. When we have planned maintenance activity we can simply switch roles of Primary and Standby database. But what if Primary Database crashes and […]
Changing Protection Modes in Oracle
We have seen Protection Modes in depth in my previous Article. To read protection modes in data guard : Protection modes in Oracle Dataguard In this article, we will see changing protection modes . First, we need to decide what protection mode we want in our environment. Which protection mode suits better.What is important for […]
Checking the Standby’s Open Mode & Setup active Data Guard – REAL TIME APPLY
In this article, we will see steps to enable Active Data Guard-Real Time Apply. To read about Active Data Guard Oracle Active Data Guard Overview & Architecture Prerequisites : Physical Standby database is already created and is in sync with Primary Database. Step 1 : Let us first check Active Data Guard is not enabled. […]
Setting Protection Modes in Dataguard
In this article, we will see parameters that we can set while setting different protection modes and its impact on primary database and standby database. Protection modes in Oracle Dataguard We have already seen Protection Modes in Data Guard Protection modes in Oracle Dataguard Now let us see Redo Transport Attributes required for setting different protection […]
Physical Standby Data Guard Health Check
Physical Standby Data Guard Health Check : After creating any DR server, our main concern is that it should be in synchronized state So if an outage occurs at Production database, we can move to standby database as soon as possible. To know more about it Oracle Dataguard We have following steps to check Data Guard […]
Activating a Snapshot Standby Database:Issues and Cautions and Target Restriction
We have already seen overview of snapshot standby database. But while converting snapshot standby database few things we need to consider. Corruption of log files : As we already know snapshot database accepts redo log files from primary when it is converted to snapshot mode but it does not apply redo log to snapshot standby. […]
Snapshot Standby Databases: Overview & Architecture
Snapshot Standby Database : We have already seen types of standby database in Data Guard. Oracle Dataguard In this article we are going to see Snapshot Standby Database in deep. In snapshot standby type database stays in a read,write mode that is fully update-able database. Snapshot standby database is created by converting physical standby database […]
Start transport and Application of redo in Data Guard
In a previous post, we have seen various methods to create Physical Standby Database. Create Standby Database using duplicate database for standby RMAN command In this post, we will see how archive logs are transferred and recovered from a standby database and concern processes for redo transport and recovery. There are main two processes in […]