The oracle data guard forms an extension of the oracle relational database management system (RDBMS). It mainly aids in the establishing and maintaining of secondary databases “standby databases” as an alternative or supplementary repositories to production of “primary databases”. Oracle provides with both graphical user interface (GUI) and command–line tools for managing data guard configurations.

Data guard provides both physical standby and logical standby sites. Oracle corporation makes Data guard available only as a bundled feature included within its “enterprise edition” of the oracle RDBMS. With appropriate set-up of Data guard operations, database administrators can facilitate failovers or switchovers to alternative hosts in the same or alternative locations.

For the purpose of Data guard, each Oracle database functions either in …

Read More →