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 […]
All posts by Jagruti Jasleniya
Jagruti Jasleniya
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 […]
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. […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 : SQL> select name,open_mode,database_role from v$database; NAME OPEN_MODE DATABASE_ROLE ——— ——————– […]
Converting a Physical Standby Database to a Snapshot Standby Database
In the previous post, we can read about Snapshot Standby Overview. In this post, we can convert to Snapshot Standby. Prerequisites : Physical Standby Database is already created and synchronized with Primary Database . Database Details : Step 1: Check Primary database : [oracle@localhost admin]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Fri […]