Introduction Introduction History of Oracle Dataguard History Data

Introduction

Introduction

History of Oracle Dataguard

History Data Guard Standby Database

Oracle High Availability Options Oracle Data Guard –Physical Standby Database –Logical Standby Database • Oracle Active Data Guard –Read only Physical Standby Database • Oracle Golden Gate –Sort of Active Read/Write Logical Standby Database • Oracle RAC –HA option within Data Center

Types of Standby Databases

Standby Database Types q. Physical standby database q. Logical standby database q. Oracle Active Data Guard(11 g) q. Snapshot standby database (11 g) q. Cascading standby database q. Far Sync Instance(12 c) q. Heterogeneous Data. Guard.

Physical Standby Database Data Guard configuration with ARCH transportation mode.

Physical Standby Database .

Physical Standby Database Exact, block for block copy of a primary database • Maintained through a process called as Redo Apply • Redo Received from Primary is continuously applied to a physical Standby database • Can be opened for a read only access • Redo Apply can still be active while Database is open –Active Data Guard • Additional License is required. .

Logical Standby Database Initially created as Identical copy of Physical database • Can be altered to have different Structure at later stage • It always remain “OPEN”. • Maintained through a process called “SQL APPLY” • Additional objects, schema’s can be created apart from what is maintained by SQL APPLY. • Tricky part is to protect the data set being maintained by Dataguard (SQL Apply).

Logical Standby Database

Oracle Active Data Guard q. Oracle Active Data Guard - Oracle active data guard is an option for Oracle Database 11 g Enterprise Edition. Enhances Quality of Service by offloading resource-intensive activities from a production database to one or more synchronized standby databases. q. 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. q. Oracle Active Data Guard also enables the use of fast incremental backups when offloading backups to a standby database, and can provide additional benefits of high availability and disaster protection against planned or unplanned outages at the production site. .

Oracle Active Data Guard.

Snapshot Standby Database This is an Updatable Standby database • Additional Feature over and above Physical Standby Database. • Database is open for read write operations while Redo Apply is stopped. • Still receives Redo data and store as Archive Log files. • Uses Flashback and Guaranteed Restore Points to perform the action. • Useful in for performing any testing when it cannot be done on Primary. • Need to maintain FRA with adequate size depending on the load.

Snapshot Standby Database

Cascading Standby Database qcascading standby database is a standby database that receives its redo logs from another standby database, not from the original primary database. The standby database, which serves the cascading standby database, is created from the primary database using RMAN (active) duplication method or restored from a backup of the primary. q. The following image shows a primary database sending redo data over Oracle network to a physical standby database and a logical standby database. The physical standby database retransmits the redo data to another physical standby database (Cascading standby 1). The logical standby database generates the redo data into SQL statements, which are then transmitted to another physical standby database (Cascading standby 2).

Cascading Standby Database

Far Sync Instance • New in Oracle 12 c • Accepts Redo from Primary Database • Send Redo to other Standby databases • Contains Control Files and Standby Redo Logs • Does Nothave Datafiles. • Require very less disk and memory resources • Preferred to be in same geographic location as of Primary • Useful during the time of maintenance on Standby Site • Require Additional License (Oracle Active Dataguard)

Far Sync Instance