Logical Standby Database Creation

In the previous article, we have seen Preparation and consideration we need to see before creating Logical Standby Database. Preparing to Create a Logical Standby Database We can use following steps to create Logical Standby Database. Prerequisites : Physical Standby database already created. Step 1: Check Physical Standby Database is created and is synchronized with […]

Read More

Enabling Block Change Tracking on a Physical Standby Database

As with 11g Oracle comes with a new feature for Oracle Data Guard: Active Data guard. And with Active Data Guard enabled we can use Block Change Tracking feature for the physical standby database. Now, what is Block Change Tracking? Block Change Tracking: RMAN change tracking feature for incremental backups improves incremental backup performance by recording […]

Read More

Role Transition Switchover and Failover

In Data Guard environment your database operates in one of two Role. 1.Primary Database 2.Standby Database. To know more about it Oracle Dataguard You can have Physical, Logical or Snapshot database in Standby role. Primary and Standby roles are mutually exclusive. With Data Guard role management service we can change this role dynamically and can achieve […]

Read More

Preparing to Create a Logical Standby Database

Prior to that, we need to create the Physical Standby. Logical Standby Database : SQL Apply Architecture We need to perform following steps before creating Logical Standby Database : 1. Primary Database must be in Archive log mode. Check your database is in archive log mode or not. If not enable it for archive log. […]

Read More

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

Read More

Lag in an Active Data Guard Configuration

Oracle 11g comes up with a New Feature on Oracle Data Guard that is Active Data Guard. In Active Data Guard we can use a real-time query on Standby Database and can gain benefits by offloading read-only workload to Standby Database. To know more about Active Data Guard Oracle Active Data Guard Overview and Architecture […]

Read More

Benefits of Implementing a Logical Standby Database

Logical Standby Database in Data Guard environment stays in a Read, Write mode that is fully updatable mode. Logical Standby Database provides following benefits over any other standby database in data guard : To know more about Logical Standby Architecture: Logical Standby Database: SQL Apply Architecture The database is opened in READ, WRITE mode in logical […]

Read More

Configure DG broker

The Data Guard broker logically groups these primary and standby databases into a broker configuration that allows the broker to manage and monitor them together as an integrated unit. You can manage a broker configuration using either the Oracle Enterprise Manager graphical user interface or the Data Guard command-line interface. To know more about it […]

Read More

Oracle Active Data Guard Overview & Architecture

We have seen 3 types of Standby Databases Physical Standby Database Logical Standby Database Snapshot Standby Database To know more about it Oracle Dataguard Oracle 11g comes with a new option : Oracle Active Data Guard. Oracle Active Data Guard is an optional license for Oracle Database Enterprise Edition. Active Data Guard enables advanced capabilities that that […]

Read More

Converting a Snapshot Standby Database to a Physical Standby Database

In the previous post, we convert Physical Standby to Snapshot Standby . In this post, we can convert Snapshot Standby to Physical Standby. Prerequisites : Snapshot database is already exists Primary Database Snapshot Standby database mgr mgr Step 1 : Check Primary Database Information :

Step 2 : Check Snapshot Database Information :

[…]

Read More