Oracle Data Guard: Difference between revisions
No edit summary |
|||
| Line 103: | Line 103: | ||
Data Guard provides [[high availability]] for a database system. It can also reduce the human intervention required to switch between [[databases]] at [[disaster recovery|disaster-recovery]] ("failover") or [[upgrade]]/[[Preventive maintenance|maintenance]] ("switchover") time. |
Data Guard provides [[high availability]] for a database system. It can also reduce the human intervention required to switch between [[databases]] at [[disaster recovery|disaster-recovery]] ("failover") or [[upgrade]]/[[Preventive maintenance|maintenance]] ("switchover") time. |
||
[http://www.quest.com/shareplex-for-oracle/ SharePlex for Oracle Database Replication] can be used in combination with Data Guard to provide 99.999% Maximum Availability for a ZeroIMPACT™ solution. |
|||
== Disadvantages == |
== Disadvantages == |
||
Revision as of 15:36, 5 June 2011
The software which Oracle Corporation markets as Oracle Data Guard forms an extension to the Oracle RDBMS. It aids in establishing and maintaining secondary "standby databases" as alternative/supplementary repositories to production "primary databases".
Oracle Corporation provides both GUI and command-line tools for managing Data Guard configurations.
Data Guard supports both physical standby and logical standby sites. Oracle Corporation makes Data Guard available only as a bundled feature included within its "Enterprise Edition" of the Oracle RDBMS.[1]
With appropriately set-up Data Guard operations, DBAs can facilitate failovers or switchovers to alternative hosts in the same or alternative locations.
Configurations
Physical standby (Redo Apply)
A Physical standby database replicates the exact contents of its primary database across the Oracle Net network layer. While the physical storage locations can be different, the data in the database will be exactly the same as the primary database. It can function either in managed Recovery mode or in read-only mode, but not in both modes at the same time unless the databases are at Oracle Database 11.1 or higher and the Active Data Guard option is licensed (See below).
Logical standby (SQL Apply)
Logical standby databases convert the redo generated at the Primary database into data and SQL and then re-apply those SQL transactions on the Logical standby, thus physical structures and organization will be different from the Primary database. Users can read from logical standby databases while the changes are being applied and, if the GUARD is set to STANDBY (ALTER DATABASE GUARD STANDBY;), write to tables in the Logical standby database that are not being maintained by SQL Apply.
Unfortunately there are a number of unsupported objects (ie: tables or sequences owned by SYS, tables that use table compression, tables that underlie a materialized view or Global temporary tables (GTTs)) and unsupported data types (ie: Datatypes BFILE, ROWID, and UROWID, user-defined TYPEs, Multimedia data types like Oracle Spatial, ORDDICOM, and Oracle Text Collections (e.g. nested tables, VARRAYs), SecureFile LOBs, OBJECT RELATIONAL XMLTypes and BINARY XML).[2] Physical standby may be appropriate in such a case.
Active Data Guard
The "Oracle Active Data Guard" option, an extra-cost facility,[3] extends Oracle Data Guard physical standby functionality in Oracle 11g configurations. It allows read-only access on the standby node at the same time as archiving transactions from the primary node.[4]
Operation
LNS (log-write network-server) and ARCH (archiver) processes running on the primary database select archived redo logs and send them to the standby database,[5] 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.
Alternatively, a supplementary mechanism may transfer the archived redo logs. On the standby database a Fetch Archive Log (FAL) client monitors for gaps in the sequence of received logs. If it finds a gap, it may invoke one or more Fetch Archive Log (FAL) servers to run on the primary database to forward the missing item(s).[6]
Once the archived redo logs have arrived, other processes (such as an ARCH (Archiver process), an MRP (Managed Recovery Process), and/or an LSP (Logical Standby Process)) may set about applying the log contents to the standby database.
Advantages
Data Guard provides high availability for a database system. It can also reduce the human intervention required to switch between databases at disaster-recovery ("failover") or upgrade/maintenance ("switchover") time.
SharePlex for Oracle Database Replication can be used in combination with Data Guard to provide 99.999% Maximum Availability for a ZeroIMPACT™ solution.
Disadvantages
Data Guard restricts use to like platform and Oracle RDBMS versions. As mentioned in this reference, [3]
Active Data Guard is an added cost option bundled within "Enterprise Edition" of the Oracle RDBMS and allows purely read-only access. [4]
Substantial costs savings are possible using Oracle Standard Edition (SE), Oracle Standard Edition One (SE1) or even Oracle Express (XE) with use of a third-party products such as Dbvisit Standby Database Technology, SharePlex for Oracle Database Replication or Wisdomforce DatabaseSync for Oracle or AsBase® DataGuard Suite to provide high availability for a database system. [7]
References
- ^ http://download.oracle.com/docs/cd/B28359_01/server.111/b28294/standby.htm#insertedID3 Data Guard Concepts and Administration, 11g Release 1 (11.1); Section 2.3.2: "Oracle Software Requirements" Retrieved 2007-10-01
- ^
Czuprynski, Jim (2010). "Leveraging Logical Standby Databases in Oracle 11g Data Guard" (HTML). Retrieved 2010-07-16.
{{cite web}}: Cite has empty unknown parameter:|coauthors=(help); Unknown parameter|month=ignored (help) - ^ a b
Lorentz, Diana (01/2009). "Oracle Database Options". Oracle Database Licensing Information 11g Release 1 (11.1). Oracle Corporation. Retrieved 2009-04-22.
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.
{{cite web}}: Check date values in:|date=(help); Unknown parameter|month=ignored (help)CS1 maint: date and year (link) - ^ a b
"Oracle Active data Guard". Oracle Database. Oracle Corporation. 01/2010. Retrieved 2009-04-22.
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.
{{cite web}}: Check date values in:|date=(help); Cite has empty unknown parameter:|month=(help) - ^
Smith, Michael T (2007). "Data Guard Redo Transport & Network Best Practices: Oracle Database 10g Release 2" (PDF). Oracle Corporation. pp. 6, 14. Retrieved 2009-03-11.
... 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.
{{cite web}}: Cite has empty unknown parameters:|dateformat=and|coauthors=(help); Unknown parameter|month=ignored (help) - ^ Oracle-Base site summary of Data Guard, retrieved 2007-09-05; Oracle Corp version 11.1 documentation links, retrieved 2007-09-05.
- ^
"Consider Oracle Standard Edition to Reduce Database Management System Costs". Gartner RAS Core Research Note G00174599. Gartner Publicationzs. 03/2010. Retrieved 2010-03.
With servers becoming more powerful, Oracle Standard Edition One and Oracle Standard Edition should be considered as an alternative to Oracle Enterprise Edition as a DBMS platform with potentially large cost savings.
{{cite web}}: Check date values in:|accessdate=and|date=(help); Cite has empty unknown parameter:|month=(help)
 | This database software-related article is a stub. You can help Wikipedia by expanding it. |