Oracle Data Guard: Difference between revisions

Revision as of 14:07, 30 April 2020

Revision as of 18:00, 29 December 2020

Line 9:

== Configurations ==

For the purposes of Data Guard, each Oracle database functions either in a primary database role or in a standby database role - with the ability to transition from one role to the other.<ref>{{cite book|url=http://docs.oracle.com/cd/E11882_01/server.112/e41134/concepts.htm#i1033808|title=Oracle Data Guard Concepts and Administration 11g Release 2 (11.2)|last=Rich|first=Kathy|publisher=|year=|isbn=|___location=|pages=|display-authors=etal|authorlink=|accessdateaccess-date=8 Mar 2017}}

</ref>

Line 25:

|page= 128

|isbn= 9781467896214

|accessdateaccess-date= 2015-03-17

|quote= [...] a new identifier DBID is assigned to the new database unless the database is a standby database. In this case it retains the same DBID as the source database.

}}

Line 37:

| url = http://www.databasejournal.com/features/oracle/article.php/3860251/Leveraging-Logical-Standby-Databases-in-Oracle-11g-Data-Guard.htm

| title = Leveraging Logical Standby Databases in Oracle 11g Data Guard

| accessdateaccess-date = 2010-07-16

| author =

| last = Czuprynski

| first = Jim

| authorlink =

|date=January 2010

}}</ref> Logical standby may not be appropriate in such a case.

Line 53 ⟶ 50:

| title = Oracle Database Options

| url = http://download.oracle.com/docs/cd/B28359_01/license.111/b28287/options.htm#sthref21

| archiveurl =

| work = Oracle Database Licensing Information 11g Release 1 (12c)

| publisher = Oracle Corporation

| date = January 2009

| accessdateaccess-date = 2009-04-22

| archivedate =

| accessdate = 2009-04-22

| quote = If a physical standby database in a Data Guard configuration has any of the above features enabled, then the Active Data Guard option must be licensed for every such physical standby, and also for the primary database.

}}</ref> extends Oracle Data Guard functionality in Oracle 11g configurations. It allows read-only access on the Physical standby node at the same time as applying archived transactions from the primary node. Also it features Automatic Block Repair and Fast Incremental Backup on Physical Standby,<ref name="Oracle Active data Guard">

Line 67 ⟶ 62:

| publisher = Oracle Corporation

| date = January 2010

| accessdateaccess-date = 2009-04-22

| archivedate =

| accessdate = 2009-04-22

| quote = Oracle Active Data Guard enables read-only access to a physical standby database for queries, sorting, reporting, web-based access, etc., while continuously applying changes received from the production database.

}}</ref>

Line 80 ⟶ 74:

| url = http://www.oracle.com/technology/deploy/availability/pdf/MAA_WP_10gR2_DataGuardNetworkBestPractices.pdf

| title = Data Guard Redo Transport & Network Best Practices: Oracle Database 10g Release 2

| accessdateaccess-date = 2009-03-11

| author =

| last = Smith

| first = Michael T

| authorlink =

|date= February 2007

| format = PDF

| work =

| publisher = Oracle Corporation

| ___location =

| pages = 6, 14

| doi =

| archiveurl =

| archivedate =

| dateformat =

| quote = ... sending processes (LNS and ARC) on the production database....The Data Guard LNS process on the production database performs a network send to the Data Guard RFS process on the standby database.

}}</ref> where the '''RFS''' (remote file server) background process within the Oracle instance performs the task of receiving archived redo logs originating from the primary database and writing them to a standby redo log (SRL).<ref>

Line 121 ⟶ 107:

| last = Ault

| first = Mike

| authorlinkauthor-link = Mike Ault

| series = Oracle In-Focus Series

| others = Madhu Tumma

| title = Oracle 10g Grid & Real Application Clusters: Oracle 10g Grid Computing with RAC

| url = https://books.google.com/books?id=p-XwSIV9ZYIC

| accessdateaccess-date = 2012-08-31

| year = 2004

| publisher = Rampant TechPress

Line 146 ⟶ 132:

|page= 320

|isbn= 9781430244295

|accessdateaccess-date= 2015-02-19

|quote= [...] with Oracle 10g, [u]sing standby redo logs on the standby database server, the redo stream arriving on the destination could be applied to the standby database immediately, without having to wait for the standby redo log to be archived and applied.

}}

Line 182 ⟶ 168:

| title = Oracle Database 10g Linux administration

| url = https://books.google.com/books?id=2ImPFP6Yk64C

| accessdateaccess-date = 2011-09-07

| year = 2005

| publisher = McGraw-Hill Professional

Line 210 ⟶ 196:

It supports heterogeneous configurations in which the primary and standby systems may have different CPU architectures, operating systems (for example, Microsoft Windows and Linux), operating-system binaries (32-bit/64-bit), or Oracle database binaries (32-bit/64-bit).<ref name="Data Guard Operational Prerequisites">

{{cite web

| first =

| last =

| title = Data Guard Operational Prerequisites

| url = http://docs.oracle.com/cd/E11882_01/server.112/e10700/standby.htm#i58150

| archiveurl =

| work = Data Guard Concepts and Administration

| publisher = Oracle Corporation

| accessdateaccess-date = 2013-08-26

| archivedate =

| accessdate = 2013-08-26

| quote = As of Oracle Database 11g, Data Guard provides increased flexibility for Data Guard configurations in which the primary and standby systems may have different CPU architectures, operating systems (for example, Windows & Linux), operating system binaries (32-bit/64-bit), or Oracle database binaries (32-bit/64-bit).

}}</ref>