In disaster management we need to consider high availability of database. Reason of disaster is any but database needs to up and running and available for end users. Deployment of disaster management strategy we never miss to get chance of Oracle standby databases and Dataguard. Using Dataguard we can able to provide high availability assurance to 24*7 running database.
Microsoft Oracle Exam Training , Oracle Certification and over 2000+
Exams with Life
Time Access Membership at https://www.actualkey.com
Especially when we are deploying high availability of database from any disaster we need to make one copy of production database to any other location. To prevent of natural disaster we make standby database to another location. This standby database is receiving all archives from production database using network channel.
Oracle standby database is replica of production database. There are two type of standby database available one is physical standby and second is Logical standby database. In production database, each and every database changes are being logged in archives. These archives are transferring to physical standby database through network and apply directly. Means all production database changes are applying directly to physical standby using archives. In contrast, the sql is derived from archives and apply in to logical standby database. In both cases standby database refreshes and synchronize with production database.
Dataguard has 3 services are redo transport service, log apply service and role Transitions service. Redo transport service is managing archive transferring to standby database from production database. Log apply service is applying database changes in to standby database and synchronize standby database with production database. Role transition service cares switchover and failover operations. Dataguard broker is the management utility for administrating and managing dataguard. We can manage standby databases using Oracle Enterprise Manager Console (GUI) or command line utility.
Using dataguard we can able to manage all standby (either physical or standby) easily. Dataguard is the Oracle utility for managing and administrating all standby databases. Easy switchover and failover task is performed in dataguard. Without dataguard it is not simple to manage all standby databases effectively.
Dataguard ensures database disaster recovery and data corruption from any failure. Dataguard is fastest way to manage more standby databases and more production databases very efficient and trustfully. It provides maximum protection from data loss in any calamity.
Indeed Dataguard is ultimate anti disaster weapon because it ensures to protect data loss and high availability. Without dataguard we are not able to protect our database from any disaster. Using dataguard we can able to survive from planned and unplanned downtime of production database.