CFP last date
15 April 2024
Reseach Article

Role of Oracle Active Data Guard in High Availability Database Operations

by Rab Nawaz, Tariq Rahim Soomro
International Journal of Applied Information Systems
Foundation of Computer Science (FCS), NY, USA
Volume 5 - Number 5
Year of Publication: 2013
Authors: Rab Nawaz, Tariq Rahim Soomro
10.5120/ijais13-450914

Rab Nawaz, Tariq Rahim Soomro . Role of Oracle Active Data Guard in High Availability Database Operations. International Journal of Applied Information Systems. 5, 5 ( April 2013), 18-21. DOI=10.5120/ijais13-450914

@article{ 10.5120/ijais13-450914,
author = { Rab Nawaz, Tariq Rahim Soomro },
title = { Role of Oracle Active Data Guard in High Availability Database Operations },
journal = { International Journal of Applied Information Systems },
issue_date = { April 2013 },
volume = { 5 },
number = { 5 },
month = { April },
year = { 2013 },
issn = { 2249-0868 },
pages = { 18-21 },
numpages = {9},
url = { https://www.ijais.org/archives/volume5/number5/450-0914/ },
doi = { 10.5120/ijais13-450914 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2023-07-05T17:58:34.791299+05:30
%A Rab Nawaz
%A Tariq Rahim Soomro
%T Role of Oracle Active Data Guard in High Availability Database Operations
%J International Journal of Applied Information Systems
%@ 2249-0868
%V 5
%N 5
%P 18-21
%D 2013
%I Foundation of Computer Science (FCS), NY, USA
Abstract

Data Guard is one of the high availability, disaster recovery and data protection architecture from Oracle. The Active Data Guard in Oracle Database 11g has brought significant changes in the existing architecture. This paper will study these changes and will see how active Data Guard is providing high availability with offloading workload to one or more standby databases and providing the opportunity to query real time data in standby databases. Finally this study will see how it provides the way to perform different write operations on primary database through standby databases.

References
  1. Larry Carpenter, Joe Meeks, Charles Kim, Bill Burke,2009,Oracle Data Guard 11g Handbook, 978-0-07-162148-9
  2. Scott Jesse, Bill Burton, Bryan Vongray,2011,Oracle Database 11gRelease 2 HighAvailability,978-0-07-175207-7
  3. Steven Chan, 2008, Comparing Oracle Data Guard Vs. Active Data Guard for EBS Environment, https://blogs. oracle. com/stevenChan/entry/comparing_oracle_data_guard_vs_active_data_guard_f
  4. Virginia Beecher, VivSchupmann, Janet Stern, 2011, Oracle Database High Availability Overview, 11g Release 2 (11. 2), E17157-08
  5. Oracle Data Guard Broker , From Oracle Documentation, http://docs. oracle. com/cd/B28359_01/server. 111/b28295/sofo. htm
  6. Oracle-Base (www. Oracle-base. com) http://www. oracle-base. com/articles/11g/data-guard-setup-11gr2. php, Retrieved January 2013Forman, G. 2003. An extensive empirical study of feature selection metrics for text classification. J. Mach. Learn. Res. 3 (Mar. 2003), 1289-1305.
  7. Oracle MaximumAvailability Architecture (White Paper September 2011), Michael T. Smith http://www. google. ae/url?sa=t&rct=j&q=write%20operations%20with%20oracle%20active%20data%20guard&source=web&cd=1&ved=0CCsQFjAA&url=http%3A%2F%2Fwww. oracle. com%2Ftechnetwork%2Fdatabase%2Ffeatures%2Favailability%2Fmaa-wp-11gr1-activedataguard-1-128199. pdf&ei=W6XuUPCdCOvs0gWMtIDwDg&usg=AFQjCNHwurnyrbQzD5xJf5_kD7HUqGvjhQ&bvm=bv. 1357700187,d. d2k
  8. Data Disk (www. datadiskco. uk), http://www. datadisk. co. uk/html_docs/oracle_dg/active_dg. htm, Retrieved January 2013
  9. Larry M. Carpenter , October 2011, Oracle OpenWorld Active Data Guard Hands on Lab
Index Terms

Computer Science
Information Sciences

Keywords

Oracle Active Data Guard Data Guard Stand by database Fail over switch over Primary or secondary database High availability in databases data protection Return on investment