Using the RMAN Recovery Catalog in a Data Guard Configuration

Recover Catalog: A base recovery catalog is a database schema that contains RMAN metadata for a set of target databases. Benefits and Restrictions of RMAN in DataGuard In easy words, RMAN metadata is stored in a different database instead of the control file. That database works as a repository. Recovery catalog and data guard : Use of the RMAN recovery […]

Read More

Benefits and Restrictions of RMAN in DataGuard

As we use RMAN to backup and restore the database in Simple scenarios. We can use it in Data Guard Environment same way. Oracle Dataguard Even we can use Physical Standby database backup to restore the Primary database and to recover the Primary database. But with some consideration as follow : The recovery catalog is […]

Read More

Benefits of Using Data Guard Broker

Oracle Data Guard Broker automates configuration and monitoring tasks for data guard. Data Guard Broker Architecture With Oracle Data Guard Broker we can enable FAST_START FAILOVER which helps in case of crash scenario or inoperativeness of production, it directs Primary Database role to standby database in this scenarios. It provides simplified switchover and failover operations. […]

Read More

Prerequisites a Data Guard Broker Configuration

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 […]

Read More

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 […]

Read More

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 […]

Read 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 […]

Read 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 […]

Read More

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 […]

Read More