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 […]
Category: DATAGUARD
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 […]
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 […]
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 […]
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 […]
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 […]