Oracle Data Guard ensures high availability, data protection, and disaster recovery for enterprise data. Data Guard provides a comprehensive set of services that create, maintain, manage, and monitor one or more standby databases to enable production Oracle databases to survive disasters and data corruptions. Data Guard maintains these standby databases as transactionally consistent copies of the production database. Then, if the production database becomes unavailable because of a planned or an unplanned outage, Data Guard can switch any standby database to the production role, minimizing the downtime associated with the outage. Data Guard can be used with traditional backup, restoration, and cluster techniques to provide a high level of data protection and data availability.
Software Requirement for creations of Standby DB Two VMWARE Nodes having base OS as ORACLE LINUX ENTERPRISE
- Primary DB :- Oracle Linux Enterprise on which Oracle Universal Installer (OUI) and Database COnfriguration Asssistant (dbca) should be installed.
- Secondary DB:- Only Oracle Linux Enterprise Later this will be converted into StandBy Database or DATAGUARD 3.For Practical SQL COmmands and Further information read the Docx file.