Far SYNC is a feature introduced with 12c. It is the dummy instance that sends the Redos from the Primary Database to other Standby Databases …

Reporting users who query the “Active Data Guard” may want that the data be synchronized with Production. Others may not care whether LAG has occurred …

What is Oracle Active Data Guard? Oracle Active Data Guard is a Physical Standby Option available with Enterprise Edition. Thanks to Active Data Guard, we …

We will configure linux for oracle database in this article. We will edit the host file. We will do this in both nodes. (with root …

We will install Oracle grid infrastructure 11g on linux in this article. We are starting the Grid Infrastructure installation. We do this only on one …

We will install Oracle RAC 11g in this article. First, We check cluster services before starting Oracle installation. We do this in both nodes. (with …

What is real time apply in dataguard? If media recovery is started with the following command after installing Data Guard in versions prior to Oracle …

We will check data guard status in SQL Plus in this article in many ways. Check 1: Check for LAG from V$DATAGUARD_STATS View. [crayon-67402af8c7cdd713951065/] [crayon-67402af8c7ce1705379102/] …

You can find all standby databases for a primary database in data guard by using one of the queries below. [crayon-67402af8c822f326657252/] or [crayon-67402af8c8232344426298/] Standby -> …

Check Data Guard Recovery Mode You can find database_mode, recovery mode and protection mode of your Data Guard as follows. [crayon-67402af8c844d276989858/] Data Guard Recovery Modes …