rac one node – the always on single instance database
TRANSCRIPT
<Insert Picture Here>
RAC One Node – The “Always On” Single Instance Database
© 2009 Oracle Corporation – Proprietary and Confidential 2
RAC One Node The “Always On” Single Instance Database
• Always On Single Instance Database• Online replacement of servers and storage • Online patching and upgrades of operating system
and infrastructure software• Online database patching• Automated cluster failover
• Better consolidation • Extreme consolidation of servers & storage• Load balancing to protect service levels
• Enhanced virtualization• Extends and improves database availability and
flexibility when running in a virtual server
New in 11.2
© 2009 Oracle Corporation – Proprietary and Confidential 3
Oracle Grid InfrastructureOracle Grid Infrastructure
Cluster and Storage Management
Oracle Database 11g Enterprise EditonOracle Database 11g Enterprise Editon
Database
Oracle Real Application Clusters One NodeOracle Real Application Clusters One Node
High Availability Database Essentials
RAC One Node Database Option primarily targets the failover market
• Option to Oracle Database 11g Release 2 Enterprise Edition
• $10,000 per processor• Eligible for list-to-list upgrade
credit when upgrading to full RAC
• All nodes on which RAC One Node is installed must be licensed for RAC One Node
• Exception: One spare node for cold failover/Online Database Relocation need not be licensed under the 10-day use rule
• Example: In a two-node cluster, customers can license RAC One Node on ONE node; 10-day rule applies for spare node
• RAC One Node capabilities also bundled with RAC
© 2009 Oracle Corporation – Proprietary and Confidential 4
RAC One Node deployment
DB1 DB2
Common Shared Storage
Single Cluster
DB4 DB5DB3
Server A Server B Server C
Key Attributes:• Instance Caging • Single Cluster• Shared storage
© 2009 Oracle Corporation – Proprietary and Confidential 5
RAC One Node deploymentInstance Caging
Common Shared Storage
Single Cluster
DB4 DB5DB3
Server B Server C
DB1 DB2
Server A
Key Attributes:• Instance Caging • Single Cluster• Shared storage
DB1 DB2
5 core limit 3 core limit
© 2009 Oracle Corporation – Proprietary and Confidential 6
Online Database Relocation
DB1 DB2
Common Shared Storage
Single Cluster
DB4 DB5DB3
Client Connections
Server A Server B Server C
© 2009 Oracle Corporation – Proprietary and Confidential 7
Online Database Relocation
DB1 DB2
Common Shared Storage
Single Cluster
DB2 DB4 DB5DB3
Client Connections
Server A Server CServer B
© 2009 Oracle Corporation – Proprietary and Confidential 8
Online Database Relocation
DB1 DB2
Common Shared Storage
Single Cluster
DB2 DB4 DB5DB3
Client Connections
Server A Server B Server C
© 2009 Oracle Corporation – Proprietary and Confidential 9
Online Database Relocation
DB1 DB2
Common Shared Storage
Single Cluster
DB2 DB4 DB5DB3
Client Connections
Server A Server B Server C
© 2009 Oracle Corporation – Proprietary and Confidential 10
Online Database Relocation
DB1
Common Shared Storage
Single Cluster
DB2 DB4 DB5DB3
Client Connections
Server A Server B Server C
© 2009 Oracle Corporation – Proprietary and Confidential 11
Online Rolling Patches
DB1
Common Shared Storage
Single Cluster
DB2 DB4 DB5DB3
Client Connections
Server A Server B Server C
Database Binaries
© 2009 Oracle Corporation – Proprietary and Confidential 12
Online Rolling Patches
DB1
Common Shared Storage
Single Cluster
DB2 DB4 DB5DB3
Client Connections
Server A Server B Server C
Database Binaries
Patch
© 2009 Oracle Corporation – Proprietary and Confidential 13
Online Rolling Patches
DB1
Common Shared Storage
Single Cluster
DB2 DB4 DB5DB3
Client Connections
Server A Server B Server C
Patched Database Binaries
© 2009 Oracle Corporation – Proprietary and Confidential 14
Online Rolling Patches
DB1 DB2
Common Shared Storage
Single Cluster
DB2 DB4 DB5DB3
Client Connections
Server A Server B Server C
Patched Database Binaries
© 2009 Oracle Corporation – Proprietary and Confidential 15
Online Rolling Patches
DB1 DB2
Common Shared Storage
Single Cluster
DB2 DB4 DB5DB3
Client Connections
Server A Server B Server C
Patched Database Binaries
© 2009 Oracle Corporation – Proprietary and Confidential 16
Online Rolling Patches
DB1 DB2
Common Shared Storage
Single Cluster
DB2 DB4 DB5DB3
Client Connections
Server A Server B Server C
Patched Database Binaries
© 2009 Oracle Corporation – Proprietary and Confidential 17
Online Rolling Patches
DB1 DB2
Common Shared Storage
Single Cluster
DB4 DB5DB3
Client Connections
Server A Server B Server C
Patched Database Binaries
© 2009 Oracle Corporation – Proprietary and Confidential 18
Cluster Failover
DB1 DB2
Server A
Common Shared Storage
Single Cluster
DB3 DB4
Server B Server C
© 2009 Oracle Corporation – Proprietary and Confidential 19
Cluster Failover
DB1 DB2
Server A
Common Shared Storage
Single Cluster
DB3 DB4
Server B Server C
© 2009 Oracle Corporation – Proprietary and Confidential 20
Cluster Failover
DB1 DB2
Server A
Common Shared Storage
Single Cluster
DB4
Server B Server C
DB3
Key Capabilities:• Database failover• Fast storage failover
© 2009 Oracle Corporation – Proprietary and Confidential 21
Create RAC One Node Database with DBCA
© 2009 Oracle Corporation – Proprietary and Confidential 22
RAC One Node Demo…
RACOne
Server dadzaa07
Common Shared Storage
Single Cluster
Server dadzaa08
Workload
© 2009 Oracle Corporation – Proprietary and Confidential 23
Demo
© 2009 Oracle Corporation – Proprietary and Confidential 24
Summary – RAC One Node The “Always On” Single Instance Database
• Always On Single Instance Database• Online replacement of servers and storage • Online patching and upgrades of operating system
and infrastructure software• Online database patching• Automated cluster failover
• Better consolidation • Extreme consolidation of servers & storage• Load balancing to protect service levels
• Enhanced virtualization• Extends and improves database availability and
flexibility when running in a virtual server
New in 11.2
© 2009 Oracle Corporation – Proprietary and Confidential 25