Download - Db Maa Tomkyte Webcast April12 Presentation
1 Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
Oracle Maximum Availability Architecture Best Practices Tom Kyte, Senior Technical Architect
Margaret Hamburger, Director Product Marketing
2 Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
High Availability Business Problem Reducing Risk
DATA
• Are you vulnerable to data loss after any outage?
TIME
• How quickly can you resume operation after any outage?
COST
• Are all your systems utilized with no idle components?
3 Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
Monetary
Impact!
Public Sector
Impact!
The Cost of Downtime Your Business Is At Stake
Cloud Services
Impact!
4 Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
2012 IOUG High Availability Survey 358 participants
51% 47% 51% 66%
Network
Outages are
the leading
cause of
unplanned
downtime
Formal
business
continuity
and disaster
recovery plan
in place
Data growth
is greatest
challenge
followed by
Database
performance
Efficiency
and cost
savings
are top
Priority in
2012
5 Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
• Oracle-optimized architecture to ensure high availability (HA) is maintained
for the Oracle stack despite planned and unplanned outages
• An extensive series of
technical HA best practices on
– Exadata Database Machine
– Oracle Database
– Oracle Fusion Middleware
– Oracle Applications
– Grid Control
– Partner solutions
http://www.oracle.com/goto/maa
Maximum Availability Architecture (MAA) Architecture + Best Practices
6 Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
Storage Mirroring Traditional High Availability
• 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
Database Instance
Database Storage
Primary Site: RAC: All Servers Active
DR Site: All Servers Inactive
Storage Mirroring
7 Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
Edition-based Redefinition,
Data Guard, GoldenGate – Minimal downtime maintenance,
upgrades, and migrations
Production Site
RAC – Scalability
– Server HA
Flashback – Human error
correction
ASM – Volume Management
RMAN & Fast Recovery Area – On-disk backups
Active Data Guard – Data Protection, DR
– Query Offload
GoldenGate – Active-active
– Heterogeneous
Oracle Secure Backup – Backup to tape / cloud
Active Replica
Maximum Availability Architecture (MAA) Low-Cost, Integrated, Fully Active, High ROI
8 Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
Oracle Database High Availability Software
Unplanned
Downtime
Planned
Downtime
Real Application Clusters (RAC)
Flashback
RMAN & Oracle Secure Backup
ASM
Data Guard & GoldenGate
Online Reconfiguration
Rolling Upgrades
Edition-based Redefinition
Ora
cle
MA
A B
est P
ractic
es
Online Redefinition
System
Changes
Application
Changes
Data
Changes
Server
Availability
Data
Availability
9 Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
Server Availability & Scale Out
Unplanned
Downtime
Planned
Downtime
Real Application Clusters (RAC)
System
Changes
Application
Changes
Data
Changes
Server
Availability
Data
Availability
10 Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
HR SALES FINANCE
• Scale workloads across low-cost servers
• Runs all Oracle database applications
• Consolidate into fewer servers and databases
• Built-in High Availability to support mission-critical workloads
Oracle Real Application Clusters (RAC)
11 Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
Trafigura Guarantees Availability, Scalability, and Database
Performance across Global Trading Business
RESULTS
• Reduced storage cost associated with
archiving historical data
• Ensured compliance with Financial
Services Authority regulations
• Enabled traders to easily analyze past
performance and make better
informed decisions in the future
• Simplified management and
programming of data for audits to save
hundreds of work days
January 2012
“With Oracle Real Application
Clusters, we have unlimited
scalability and improved
performance. This scalability is
unique to Oracle. We could not have
achieved it with another vendor.”
– Dean Logan Wood, Global Head of
Database Technology, Trafigura
12 Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
Unplanned
Downtime
Flashback
RMAN & Oracle Secure Backup
ASM
Data Guard & GoldenGate
Server
Availability
Data
Availability
Protection from
Data Corruptions
Protection from
Storage / Site Failures
Enabling Active-
Active Data Centers
Protection from
Human Errors
Oracle Database 11g Data Availability
13 Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
• Flashback revolutionizes error correction:
– View ‘good’ data as of a point in time before error
• Time/work to rewind data depends on the work done
since the error happened, instead of the database size!
• Simple: SQL> flashback database to <timestamp>;
• Flexible: Flashback Query, Table, Transaction, Database, Drop
0
20
40
60
Correction Time = Error Time + f(DB_SIZE)
Oracle Flashback Fast, Granular Error-Correction
14 Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
• Recovery Manager (RMAN): Oracle’s backup
& recovery infrastructure
• RMAN is aware of database file formats &
best recovery procedures, supporting:
– block validation
– online block-level recovery
– unused-block de-duplication
– online, multi-channel backups
– native encryption and compression
• Integrated disk backup: Fast Recovery Area
• Integrated tape and cloud backup:
Oracle Secure Backup (OSB)
Oracle Enterprise
Manager
RMAN
Data Files
Fast Recovery
Area
Tape Drive
Oracle Secure
Backup
Cloud
(Amazon S3)
Oracle Database Backup & Recovery
15 Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
• ASM supports ALL data – database files, filesystems, Clusterware files (OCR, Voting Disk)
• Built-in mirroring protects from disk failures
• Enables auto-repair from corrupt blocks using a valid mirror copy
3rd Party FS Application
Automatic Storage Management (ASM)
ASM Cluster & Single Node File System (ACFS)
Database
ACFS Snapshot
ASM Disk
Group
DB Datafiles, OCR and Voting Files Oracle Binaries 3rd Party File Systems
Dynamic Volume Manager
ASM Instance Managing
Oracle DB Files
Automatic Storage Management (ASM)
16 Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
• Data availability and data protection for the Oracle Database
• Up to thirty standby databases in a single configuration
• Standby database used for queries, reports, test, or backups
Active Data Guard
Standby Database Primary
Database
Sync / Async
Redo Transport
Data Guard Broker
Oracle Data Guard Best Data Protection
17 Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
MetLife, Inc. Saves 37% Using
Disaster Recovery System CUSTOMER PERSPECTIVE
“Oracle Active Data Guard is not an idle
backup system waiting for a failure to occur; it
delivers real value every single day. We use
Oracle Active Data Guard to reduce IT
complexity―cutting the administrative effort
needed to support our PeopleSoft environment
by 25% and reducing maintenance costs by
37%.” Asha V. Santosh, Lead Database
Administrator
COMPANY OVERVIEW
• Leading global provider of insurance, annuities, and employee benefits programs for 90 million customers
• Industry: Insurance • Employees: 66,000 Revenue: US$65 million
CHALLENGES/OPPORTUNITIES
• Reduce IT complexity and management costs by streamlining the disaster recovery environment
• Optimize IT investment while ensuring a highly available disaster recovery environment to protect the insurer’s financial and operational information
• Ensure accurate financial reporting for annuity and life insurance lines of business to help the company meet stringent insurance industry compliance requirements
SOLUTIONS
• Oracle Active Data Guard • Oracle Advanced Compression
RESULTS
• Cut time for batch trail processing
and maintenance by 50%
• Reduced time for data transfer to
just three seconds
April 2012
18 Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
Capture: committed transactions are captured (and can be filtered) as they occur by reading redo logs.
Trail: stages and queues data for routing.
Pump: distributes data for routing to target(s).
Route: data is compressed, encrypted for routing to target(s).
Delivery: applies data with transaction integrity, transforming the data as required.
Source
Oracle & Non-Oracle
Database(s)
Target
Oracle & Non-Oracle
Database(s) Bi-directional
GoldenGate: Active-Active Replication
19 Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
GoldenGate
- Information Distribution
- Heterogeneous
Bi-directional
Replication Subsetting MySQL
Standby
Database
Active Data Guard
- DR & Data Protection
- Real-time Query
Primary
Database
RAC
- Scalability
- Server HA
Powerful Combination Integrated HA, Data Protection, Active-Active
20 Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
Unplanned
Downtime
Planned
Downtime
Online Reconfiguration
Rolling Upgrades
Edition-based Redefinition
Online Redefinition
System
Changes
Application
Changes
Data
Changes
Server
Availability
Data
Availability
Best Online Planned Maintenance
21 Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
• Servers
– Add/Remove RAC nodes online
– No data movement needed
• Storage
– Add/Remove ASM disks or
arrays online
– Automatically rebalance after
change
• Clusterware, ASM
– Upgrade Oracle Clusterware
and ASM in an online manner
Database
Storage
Online Reconfiguration Scaling On Demand
22 Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
• Some one-off patches can be applied to a running
Oracle instance
– Linux-x86, Solaris 10, HP-UX 11i
– [11gR2] Windows 32-bit and 64-bit, AIX v6.1 [TL2 SP1]
• Many one-off patches deployed using RAC via rolling
• Rolling database release/patchset upgrades, OS
upgrades, platform migrations with Data Guard /
GoldenGate – See Support Note 1265700.1
• Data Center moves / SAN migration / Tech refresh,
with minimal downtime via Data Guard / GoldenGate
Online Patches & Upgrades
23 Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
• All index changes can be done online
• Tables can be reorganized and redefined online with package DBMS_REDEFINITION
– Allows changing location, table type, partitioning, columns, column types
– Contents can be transformed as they are copied
Source Table
Update
Tracking
Transform Copy
Table
Transform
Updates
Result Table
Continuous
Queries &
Updates
Store Updates
Online Index & Table Redefinition
24 Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
• Maintains logical versions of changed database
objects. Concepts:
– Edition, Editioning View, and Crossedition Trigger
• Code changes installed in a new edition
• New data changes made to new columns/table are
not seen by old edition
• Editioning view exposes a private projection of a
table into each edition
• Crossedition trigger propagates changes made by
old edition into new’s columns, or viceversa
• Capabilities used mainly by application developers Pre-upgrade Edition
Post-upgrade Edition
Crossedition
Triggers
Online Application Upgrades Edition-based Redefinition
25 Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
Oracle Advanced Customer Support Services Mission Critical Support Services
Maximize availability, accelerate return on investment, and optimize performance
• Tailored mission critical support services for customers with complex IT requirements
• Advanced Support Packs combine unique Oracle Development and Advanced Support expertise with Oracle tools and best practices
• Advanced Support Engineers provide highly proactive and preventive support with diagnostic and monitoring tools to anticipate, identify, and remediate issues for all Oracle mission critical systems
• Strategic support relationships focused on collaborative, long term partnerships
94% of the “S&P Global 100” companies
94% of the Dow Jones STOXX 50*
78% of the global Fortune 100 companies
5 of the top 5 telecommunications companies
9 of the top 10 global banks
4 of the top 5 aerospace and defense companies
Companies that rely on
ORACLE ADVANCED CUSTOMER SUPPORT SERVICES:
*Europe’s leading Blue-chip index for the Eurozone
26 Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
“Oracle ACS has contributed to our success by making the application available. In
addition, even when we had issues, they ensured that the system returned to service as
quickly as possible,” says Bryon Rickey, Director of Production Operations, AT&T. “ACS has
helped AT&T reduce unplanned downtime. We work with them well in advance, a few
months in advance, before any major releases. We work with them very closely and partner
with them to develop deployment and support plans. It has been very successful.”
Oracle Advanced Customer Support Services
Bryon Rickey,Director of Production Operations, AT&T
“AT&T Maximizes Availability with Oracle Advanced Customer Support Services”
video: http://medianetwork.oracle.com/video/player/739268633001
27 Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
WAN
• Comprehensive protection from failures: server, storage, network, site, corruptions
• Protection from human errors: database, table, row, transaction
• Active DR: Real-time remote standby open for query offload
• Online indexing and table redefinition
• Online patching and upgrades
Real Application Clusters
ASM
RMAN / Fast Recovery Area
Active Data Guard / GoldenGate
Oracle Secure Backup
MAA with Exadata Complete, Integrated Availability
28 Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
MAA with Oracle Database Appliance
• Simple to implement
• Designed and priced to scale
• Performance improves as you scale
• Highest levels of serviceability
• Highest availability for this class of
machine
Ideal for SMBs and Departmental Systems
29 Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
Maximum Availability Architecture HA Isn’t HA, Without MAA
Requirements MAA
Data Protection End-to-end Oracle validation
Fast Recovery Time Always on
Zero Risk You know its working
High ROI No idle systems
http://www.oracle.com/technetwork/database/features/availability/twp-databaseha-11gr2-1-132255.pdf
Upcoming Webcast
We invite you to attend our next Database Webcast on
April 26:
• A Smarter Approach to Database Storage Management
The registration link will be included in a follow up communication.
32 Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
For More Information
http://search.oracle.com
oracle database 11g