What is Dataguard and standby?

Question

Accepted Answer

Dataguard is a feature of Oracle Database that provides high availability, data protection, and disaster recovery.

Dataguard is used to create and maintain one or more standby databases that can be used for failover or disaster recovery purposes.
It works by continuously applying changes from the primary database to the standby database(s) to keep them synchronized.
In case of a failure or disaster, the standby database can be activated to take over the role of the primary database.
Dataguard provides various modes such as maximum availability, maximum performance, and maximum protection to meet different requirements.
It also supports automatic failover and switchover, allowing for seamless transitions between the primary and standby databases.
Dataguard can be used for both physical standby databases (replicating the entire database) and logical standby databases (replicating only the logical changes).

Top CMS IT Services Oracle Database Administrator interview questions & answers