Architecture of data guard and oracle 12c and 19c

Question

Accepted Answer

Data Guard is a disaster recovery solution for Oracle databases. Oracle 12c and 19c have improved features for Data Guard.

Data Guard is a high availability solution that provides disaster recovery for Oracle databases.
It maintains one or more standby databases that can be used in case of a primary database failure.
Oracle 12c introduced the concept of Far Sync Instance, which acts as a buffer between the primary and standby databases.
Oracle 19c introduced the feature of Automatic Block Repair, which automatically repairs corrupt blocks on the standby database.
Data Guard can be configured in various modes such as Maximum Availability, Maximum Performance, and Maximum Protection.
Maximum Availability mode provides zero data loss and automatic failover.
Maximum Performance mode provides the highest performance but may result in some data loss in case of a primary database failure.
Maximum Protection mode provides zero data loss but may impact performance.
Data Guard can be configured using either command-line interface (CLI) or graphical user interface (GUI) tools such as Enterprise Manager (EM) and Data Guard Broker.
Data Guard can also be used for database migration and rolling upgrades.
Oracle 12c and 19c have improved features for Data Guard such as Far Sync Instance and Automatic Block Repair.

Top HDB Financial Services Deputy Manager interview questions & answers