About Oracle Data Guard

Oracle Database at a Bank

Monitoring

Backup

Restore and Recover

Finincial 

No Data Loss

Highly avaliable

 No Archive Log

Oracle Data Guard ensures

- No Data loss

- High Availability

Even when Disaster Strikes.

Oracle Data Guard - Standby Databases Overview 

 

 Physical Standby Databases

Cane be Read Only Standby 

 Block by Block Copy 

 Separate DB ID 

Different DB ID  Read Write

 SQL Apply Can have other Objects

 

 

 SNAPSHOT  READ WRITE

 

 

Managing Data Guard and Data Guard Services 

Monitoring Data Guard

• Using SQL
• Using Data Guard Broker(EM : DMON , DGMGRL)

 

 

 

 

 

Summary:

Managing Data Guard

- Manually using SQL

- Data Guard Broker using DGMGRL or Enterprise Manager.

Data Guard Services

- Redo Transport

- Redo Apply

- Role Management

Creating a Physical Standby using RMAN

 

 

 Active Data Guard - Overview

 

 

 

 

 

 

Active Data Guard - Benefits

- Real Time Query in the Standby Database

- Block Change Tracking and Incremental Backups at Standby

- Automatic Recovery of Block Corruption