• Oracle

    Oracle Data Guard standby-27

    Data Guard It’s a standby database. A copy of primary database. Oracle Data Guard ensures high availability, data protection, and disaster recovery for enterprise data. Primary and standby will be in sync mode. Standby is used for high availability. It will reduce the recovery and downtime and used for D/R. Technologies in standby data guard Physical standby (Redo apply technologies P–Archive–S) Logical Standby (SQL statement will run) Switchover (Changing) Failover (For server shutdowns) Data guard broker (Third server for witness) Use of broker: Data guard broker will be managed as centralized. The switchover and failover will be automated. We need separate listener for data guard broker. A primary can have…