EST

Call for paper
April Edition 2017

International Journal of Applied Information Systems solicits high quality original research papers for the
March 15, 2017
April 2017 Edition of the journal.
The last date of research paper submission is
March 15, 2017
SUBMIT YOUR PAPER

Number 5

Role of Oracle Active Data Guard in High Availability Database Operations

journal image
 Download
1788

Export

  • Rab Nawaz and Tariq Rahim Soomro 2013. Role of Oracle Active Data Guard in High Availability Database Operations. International Journal of Applied Information Systems. 5, 5 (April 2013), 18-21. DOI=http://dx.doi.org/10.5120/ijais450914 
  • @article{10.5120/ijais2017451568,
author = {Rab Nawaz and 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 = {},
month = {April},
year = {2013},
issn = {},
pages = {18-21},
numpages = {},
url = {/archives/volume5/number5/450-0914},
doi = { 10.5120/ijais13-450914},
publisher = { xA9 2012 by IJAIS Journal},
address = {}
}

  • %1 450914
%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
%@ 
%V 5
%N 
%P 18-21
%D 2013
%I  xA9 2012 by IJAIS Journal

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

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

Index Terms

Computer Science
Information Sciences