Notes on webinar “#Oracledatabase Maximum Availability Architecture Best Practices” by Tom Kyte.


Notes on webinar “Oracle Maximum Availability Architecture Best Practices” by Tom Kyte.

High Availability Business Problem

The High Availability Business Problem is about reducing risk in the following areas:

  • Data—how much data can be lost through an outage? No transactions? One (1) hour’s worth? A day’s worth?
  • Time—how quickly can service be restored to the customers?
  • Cost—how much idle capacity can you afford? 100% replication of production environment? Only critical components with purchase of extra capacity on demand?

Need to calculate cost of downtime. Estimates are between USD100,100 and USD200,000 per hour.

Network Outages are the leading cause of unplanned downtime (2012 IOUG HA Survey).

Tom recommends testing of the HA infrastructure regularly.

Maximum Availability Architecture (MAA)

Oracle Maximum Availability Architecture – MAA.

Traditional HA is use of storage mirroring. But this suffers from the following problems:

  • Limited protection from physical data corruptions or administrator errors.
  • DR systems are offline during mirroring — NO real-time data validation.
  • High network consumption, manual failover — NO rolling upgrades.

Slide #7

Slide #8 lists the following products for the MAA:

  • RAC
  • Flashback
  • Edition-based Redefinition
  • Data Guard
  • GoldenGate
  • ASM
  • RMAN with FRA
  • Active Data Guard
  • Oracle Secure Backup

Slide #9 offers the following solutions:

  • Unplanned Downtime
    • Server Availability
      • RAC
    • Data Availability
      • Flashback
      • RMAN & Oracle Secure Backup
      • ASM
      • Data Guard & GoldenGate
  • Planned Downtime
    • System Changes
      • Online Reconfiguration
      • Rolling Upgrades
    • Data Changes
      • Online Redefinition
    • Application Changes
      • Edition-based Redefinition

Data Availability

Oracle Flashback offers fast, granular error-correction. The speed is achieved through only considering the amount of work to undo to get back to a good copy of the database.

FLASHBACK DATABASE TO TO_DATE('2012/07/26 18:46:25', 'YYYY/MM/DD HH24:MIS:SS');

This assumes that there is only one (1) application in a database.

RMAN can catch block errors early. RMAN allows recovery of individual blocks.

Active Data Guard allows for testing of production code changes.

GoldenGate allows bi-directional replication of data among heterogenous databases.

Pre-Packaged Solutions

Exadata has MAA builtin

Oracle Data Appliance for departments and SMB

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s