In today’s article we will talk about Real-Time Apply vs Archive Log Apply Test. After setting our Data Guard to Real -Time Apply, we can …

In today’s article, we will examine Data Guard Protection Modes. Data Guard Protection Modes are a decision that we can make by looking at how …

In today’s article, we will examine how to prevent data corruption in Oracle. Oracle Database has processes that check whether the Redos are stable before …

In today’s post, I will describe insert into oracle  temporary tables and Active Data Guard. We will try to insert into temporary tables on active …

In this article, we will create data guard broker configuration. You can see the overview of data guard broker in the article named “What is …

This article contains information about Data Guard Broker architecture, components, commands, configuration file, etc. What is Data Guard Broker? Broker is a distributed management framework …

Sometimes we may need to take a datafile offline and online in oracle. In this article we will take a look at these operations and …

If a database created as Physical Standby is converted to a Logical Standby database while the Broker configuration is enabled, you may receive an error …

Sometimes, we may not want to reflect the operations performed on the Primary database to the Logical Standby database. It can be ensured that DML …

To delete archive logs automatically on standby you should set LOG_AUTO_DEL_RETENTION_TARGET  parameter. The Foreign Archive Logs in Logical Standby Database is automatically deleted by SQL …