This video will guide you to create an active data guard in ORACLE.
What is active dataguard?
Oracle Data Guard is an effective and comprehensive method of achieving data availability, data protection, and disaster recovery solution for Oracle enterprise databases.
It provides the management, monitoring, and automation software infrastructure to create and maintain one or more synchronized standby databases to protect data from failures, disasters, errors, and corruptions.
What does it mean?
A standby database is initially created from a backup copy of the primary database.
Once created, Data Guard automatically maintains the standby database as a transactional consistent copy of the primary database.
Data Guard helps you protect your Data.
Takes your data and automatically puts it elsewhere
Makes it available for Failover in case of failure.
When To Implement Data Guard?
Failover A failover is done when the primary database (all instances of an Oracle RAC primary database) fails or has become unreachable and one of the standby databases is transitioned to take over the primary role. Failover should be performed when the primary database cannot be recovered in a timely manner. Failover may or may not result in data loss depending on the protection mode in effect at the time of the failover.
Switchover A switchover is a role reversal between the primary database and one of its standby databases. A switchover guarantees no data loss and is typically done for planned maintenance of the primary system. During a switchover, the primary database transitions to a standby role, and the standby database transitions to the primary role.
Components of Active Data Guard?
Primary Database: A primary database is a production database. The primary database is used to create a standby database. Every standby database is associated with one and only one primary database.
Standby Database: A physical or logical standby database is a database replica created from a backup of a primary database . A Data Guard configuration consists of one production (or primary) database and up to nine standby databases. The databases in a Data Guard configuration are connected by Oracle.
Data Guard Benefits?
Disaster/Failure Recovery and High Availability
Complete Data Protection
Efficient Utilization of System Resources
Flexibility in Data Protection to Balance Availability Against Performance Requirements
Protection from Communication Failures
Fast-Start Failover Capabilities
Centralized and Simple Management
Integrated with Oracle Database
Fast Connection Failover