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 […]
All posts by Jagruti Jasleniya
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 […]
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. […]
Managing Remote Archived Log File Retention
In the previous article of Automatic deletion of archived redo log, we have seen automatic deletion is enabled by default in the Logical Standby database. Automatic Deletion of Redo Log Files by SQL Apply LOG_AUTO_DEL_RETENTION_TARGET parameter is responsible for this. It has default value 1440 minutes. However, we can manage this parameter and set retention […]
Automatic Deletion of Redo Log Files by SQL Apply
Archive log files which are used by SQL apply process at Logical Standby database is said to be Foreign Archive Logs or Remote Archived Logs. Foreign Archive log files are managed by SQL Apply process. To know more about it Oracle Dataguard After all the redo entries of Archive log files are applied using SQL apply process, these […]
Securing Your Logical Standby Database
The logical standby database is in Read-Write mode means a fully updatable mode. A database can be accessed and potential data may be changed. So Oracle data guard provides a lock. We can configure GUARD on the database at a different level according to our requirement. Logical Standby Database Creation A user access can be […]
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 […]