Posts

Showing posts from December, 2020

Standby Database and Data Guard

Oracle Dataguard is a High availabity  software solution  designed for   data availability, data protection and disaster recovery solutions on enterprise data. It is only available with database enterprise edition . The Solution is achieved  by Creating a single  Standby database or multiple Standbys databases  for major Database in which enterprise  data is handled  A standby database is Transactional- consistent  copy of the Production or Primary Database  Whenever a Primary Database becomes unavailable due to planned or unplanned outages ,the application traffic can be switched over to one of Standby to maintain a Business continuity . Data Guard can be used in combination with other Oracle High Availability (HA) solutions such as Real Application Clusters (RAC), Oracle Flashback and Oracle Recovery Manager (RMAN), to provide a very high level of data protection and data availability This data guard configuration ban be manged by tools like SQL command-line interfaces (SQLPLUS), Dat