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 we can’t recover it in a time.

Data Guard has a solution for that. We can Fail Over Primary database (more...)

Manual SwitchOver in Oracle

Let us understand today whole switchover the scenario in Oracle Data Guard. I have written many articles of Oracle Data Guard that explains the architecture of Oracle Data Guard, Benefits of having Data Guard as your DR solution, different methods of creating Data Guard.

Today, we will see How your database works before switchover after switchover, Preparing for the switchover and we will actually perform switchover task.

There main two database roles in Oracle Data (more...)

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 us Database Availability , Database Performance or Data protection??

After choosing what protection mode we want to use , we (more...)

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.

DGMGRL> show database std_mgr

Database - std_mgr

  Role:            PHYSICAL STANDBY
  Intended State:  APPLY-ON
  Transport Lag:   0 seconds (computed 0 seconds  (more...)