slide1 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Oracle Real Application Clusters (RAC) 12 c PowerPoint Presentation
Download Presentation
Oracle Real Application Clusters (RAC) 12 c

Loading in 2 Seconds...

play fullscreen
1 / 65

Oracle Real Application Clusters (RAC) 12 c - PowerPoint PPT Presentation


  • 1091 Views
  • Uploaded on

Oracle Real Application Clusters (RAC) 12 c. Troy Anthony Database as a Service Centre. Program Agenda. Oracle RAC 12c Overview Oracle RAC 12c for: Better Business Continuity and High Availability Cost-effective Workload Management Standardized Deployment and System Management.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Oracle Real Application Clusters (RAC) 12 c' - neviah


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
oracle real application clusters rac 12 c
Oracle Real Application Clusters (RAC) 12c

Troy AnthonyDatabase as a Service Centre

program agenda
Program Agenda
  • Oracle RAC 12c Overview
  • Oracle RAC 12c for:
    • Better Business Continuity and High Availability
    • Cost-effective Workload Management
    • Standardized Deployment and System Management
slide4

The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.

slide title arial 28 pt two line max
Slide Title: Arial, 28 PTTwo-Line Max

Subtitle: Arial, 20 pt, One-Line Max

  • Bullets are sentence case. Use Arial, 20 pt font.
    • Sub-bullets are Arial, 18 pt font.
  • Keep bullets short.
  • One idea per bullet.
  • No more than five bullets.
  • NOTE: Arial is the ONLY font that should be used in the Oracle corporate presentation template.Times and other serif fonts are not acceptable.

To ensure that slides are properly formatted to this template, see pages 7 and 8for instructions.

Times

Arial

the new oracle rac 12c
The New Oracle RAC 12c

Oracle RAC 12c provides:

  • Better Business Continuity and High Availability (HA)
  • Agility and Scalability
  • Cost-effective Workload Management

CRM

Oracle Real Application Clusters (RAC)

Oracle EM 12 Cloud Control

Utility Computer

the new oracle rac 12c1
The New Oracle RAC 12c

Oracle RAC 12c provides:

  • Better Business Continuity and High Availability (HA)
  • Agility and Scalability
  • Cost-effective Workload Management

Using

  • A standardized and improveddeployment and management
  • A familiar and matured HA stack

CRM

Oracle Real Application Clusters (RAC)

Oracle Grid Infrastructure (GI):

Automatic Storage Management (ASM)

Oracle Clusterware (OCW)

Oracle EM 12 Cloud Control

Oracle Flex ASM

Utility Computer

the utility computer better db management
The Utility Computer – Better DB Management

CRM

  • The Utility Computer concept provides:
    • A central point of management
    • HA for management tools (in cluster)
    • For Oracle (RAC) databases, the utility cluster can serve as central location for
      • Storing diagnostic and performance information
      • Rapid Home Provisioning (used as Grid Home Server)

Oracle Real Application Clusters (RAC)

Oracle EM 12 Cloud Control

Logs / TFA

Home Provisioning

standardize on oracle rac
Standardize on Oracle RAC

Different flavors, same management

Oracle RAC

DBA

DBA

DBA

Oracle RAC One Node

Scalability

DBA

DBA

Oracle Restart

Oracle GI

Oracle GI

DBA

Oracle GI

High Availablity

standardize on oracle rac1
Standardize on Oracle RAC

For better availability during maintenance operations

Oracle RAC

DBA

DBA

DBA

Oracle RAC One Node

Scalability

DBA

DBA

Online (rolling) Patch and PSU Application

Oracle GI

Oracle GI

High Availablity

standardize on oracle rac2
Standardize on Oracle RAC

For all the flexibility you need

Oracle RAC

DBA

DBA

DBA

Oracle RAC One Node

Scalability

Online upgrade

DBA

DBA

Oracle Restart

Oracle GI

Oracle GI

Re-configuration to enable cluster

DBA

Oracle GI

Flexibility

standardize on oracle rac3
Standardize on Oracle RAC

For better agility and consolidation

Oracle RAC

DBA

DBA

DBA

Oracle RAC One Node

Agility

DBA

DBA

Oracle Restart

Oracle GI

Oracle GI

DBA

Oracle GI

Consolidation

standardize on oracle rac and oracle multitenant
Standardize on Oracle RAC and Oracle Multitenant

The new standard for Oracle Database consolidation

Oracle RAC

Oracle RAC One Node

Agility

Oracle GI

Oracle GI

Consolidation

program agenda1
Program Agenda
  • Oracle RAC 12c Overview
  • Oracle RAC 12c for:
    • Better Business Continuity and High Availability
    • Cost-effective Workload Management
    • Standardized Deployment and System Management
dealing with unknown transaction state
Dealing with Unknown Transaction State

Pre-Oracle Database 12c

  • Database outages can cause in-flight work to be lost, leaving users and applications in doubt
  • Often leads to
    • User pains
    • Duplicate submissions
    • Rebooting mid-tiers
    • Developer pains

CRM

DBA

DBA

DBA

DBA

DBA

tackling in flight work for unplanned outages
Tackling In-Flight Work for Unplanned Outages

Two New Features

  • Transaction Guard
    • A Reliable protocol and API that returns the outcome of the last transaction
  • Application Continuity
    • Safely attempts to replay in-flight work following outages and planned operations.
application continuity1
Application Continuity

Masks Unplanned & Planned Outages

  • Replays in-flight (DML)work on recoverable errors
  • Masks many hardware, software, network, storage errors and outages when successful
  • Improves end-user experience and productivity without requiring custom application development

CRM

DBA

DBA

DBA

DBA

DBA

application continuity example
Application Continuity - Example

A reliable replay of in-flight work

User selects product from application and purchases it from the web checkout

End User

User transaction arrives at application infrastructure. It makes it’s way through the application tiers and results in a database transaction being created

Application Servers

Network Switches

Database Servers

application continuity example1
Application Continuity - Example

A reliable replay of in-flight work

End User

The infrastructure hosting the database fails just before the transaction is committed to the database.

Application Servers

Network Switches

Database Servers

application continuity example2
Application Continuity - Example

A reliable replay of in-flight work

The jdbc driver detects the failure and checks with an available node in the cluster, using “Transaction Guard”, whether the transaction committed or needs to be replayed

End User

Application Servers

If the transaction needs to be replayed, “Application Continuity” will submit all of the inflight work to a surviving node in the cluster and perform a commit. This all happens transparently to the application

Network Switches

Database Servers

application continuity example3
Application Continuity - Example

A reliable replay of in-flight work

End User

The user receives confirmation that his order has been successfully completed.

Application Servers

Network Switches

Database Servers

the history of asm
The History of ASM

Why Oracle Developed ASM

  • Pre-Oracle Database 10g storage management was provided by 3rd parties
  • Customer challenges
    • Large databases required considerable storage management
    • Best performance required raw storage
    • NFS solutions, while simple, did not perform as well as raw
    • For RAC, cluster file systems were not available
  • With Oracle 10g, ASM provided
    • Simplicity of management, even better than NFS solutions
    • Performance equal to raw disks
the history of asm1
The History of ASM

The Simple Idea

  • Integrated volume manager and file system
  • Stripe and mirror files across disks in a ASM Disk Group
  • Automatic “Rebalance”
  • Built on the Oracle instance architecture
  • Manage storage as a global cluster “shared Disk Groups”
asm overview
ASM Overview

Simplify the Stack

Server

Server

Oracle Database

Oracle Database

ASM

File System and Volume Management

Operating System

File System

Logical Volume Manager

Operating System

asm overview1
ASM Overview

Oracle Database 11.2 or earlier

RAC Cluster

Node1

Node2

Node3

Node4

Node5

Database Instance

DBA

DBA

DBB

DBB

DBB

DBC

One to One Mapping of ASM Instances to Servers

ASM Instance

ASM

ASM

ASM

ASM

ASM

ASM Cluster Pool of Storage

Shared Disk Groups

Wide File Striping

Disk Group A

Disk Group B

ASM Disk

asm overview2
ASM Overview

Oracle ASM 12c Standard Deployment

RAC Cluster

Node1

Node2

Node3

Node4

Node5

Database Instance

Database Instance

DBA

DBA

DBB

DBB

DBB

DBC

One to One Mapping of ASM Instances to Servers

ASM Instance

ASM Instance

ASM

ASM

ASM

ASM

ASM

Shared Disk Groups

Wide File Striping

ASM Cluster Pool of Storage

ASM Disk

Disk Group A

Disk Group B

introducing oracle flex asm
Introducing Oracle Flex ASM

Removal of One to One Mapping and HA

RAC Cluster

Node1

Node2

Node3

Node4

Node5

Database Instance

DBA

DBA

DBB

DBB

DBB

DBC

Databases share ASM instances

ASM Instance

ASM Instance

ASM

ASM

ASM

Node2 runs as ASM Client to Node3

Node1 runs as ASM Client to Node4

Node1 runs as ASM Client to Node2

Node5 runs as ASM Client to Node4

Shared Disk Groups

Wide File Striping

ASM Cluster Pool of Storage

ASM Disk

Disk Group A

Disk Group B

flex asm
Flex ASM

Remote Access

  • In previous versions, ASM clients use OS-authentication to connect to ASM
    • This works because ASM clients and servers are always on the same server
  • With Oracle Database 12c, ASM clients and ASM servers can be on different servers
    • A default configuration is created when the ASM cluster is configured
  • Benefits of providing a shared password file in ASM Disk Group
supporting pre oracle 12 c databases
Supporting Pre-Oracle 12c Databases

Pre-Oracle 12c Databases require a local ASM instance

RAC Cluster

RAC Cluster

Node1

Node2

Node3

Node4

Node5

Database Instance

DBA

DBA

DBB

DBB

DBB

  • 11gDB

DBC

11gDB

Databases share ASM instances

ASM Instance

ASM

ASM

ASM

ASM

ASM

Shared Disk Groups

Wide File Striping

ASM Cluster Pool of Storage

ASM Disk

Disk Group A

Disk Group B

flex asm1
Flex ASM

Other Flex ASM features

  • Increase maximum number of Disk Groups to 511
    • Previous limit was 63
  • Command for renaming ASM Disk
  • ASM instance Patch-level verification
    • Patch level verification is disabled during rolling patches
  • Replicated Physical Metadata
    • Improves reliability
    • Virtual Metadata has always been replicated with ASM mirroring
small asm features big difference
Small ASM Features – Big Difference

Disk and disk group operations

small asm features big difference1
Small ASM Features – Big Difference

Better availability and performance

program agenda2
Program Agenda
  • Oracle RAC 12c Overview
  • Oracle RAC 12c for:
    • Better Business Continuity and High Availability
    • Cost-effective Workload Management
    • Standardized Deployment and System Management
policy managed databases
Policy-Managed Databases

Highly available workload management

  • Allocate resources
  • As demand requires it
  • As the business requires it:
    • Over the period of one day
  • As the system requires it:
    • For automated management tasks
policy managed databases1
Policy-Managed Databases

Better High Availability for any cluster

  • Improve HA
  • By choosing servers from the least important server pool
  • Accommodating for double or multiple subsequent failures
  • For planned maintenance:
    • Allocate backup servers in the cluster

1

2

policy managed databases2
Policy-Managed Databases

Customer quote: “Policy-managed; It’s all about the workload”

  • Policy Logic defines:
  • Availability
  • Service Levels
  • Maint. windows
  • Performance
  • PCI requirements
  • Regional/business
  • Version

“Server pools are dynamically adjusted”

EMEA

“Uniform services….don’t care where instances are or their name. All about capacity and workload”

Americas

Americas

“Instances are controlled by min/max combined with services. No more add/drop instance.”

“QoS is critical to our management”

policy based cluster management
Policy-based Cluster Management

Server Pools that understand and make a difference

  • Oracle RAC 12.1
    • Scales out easier than ever (addNode)
    • Actively utilizes differently sized servers
  • Server Pool management has been improved to understand server differences in the cluster:
    • Server attributes are stored per server
    • Server Pools are set up using Server Categories
    • Servers are allocated to pools based on categories
      • Combine only test servers in one pool
        • Remove servers from test-pool preferably
      • Ensure a minimum size of servers per pool

Server Attributes

  • NAME
  • MEMORY_SIZE
  • CPU_COUNT
  • CPU_CLOCK_RATE
  • CPU_HYPERTHREADING
  • CPU_EQUIVALENCY
  • Server Categories
  • NAME
  • ACL
  • EXPRESSION
what if command evaluation
What-If Command Evaluation

Complex cluster management made predictable

MAIL

  • Oracle RAC 12.1 What-If Command Evaluation
    • Helps to set up and validate policies
    • Helps to plan for downtime scenarios
      • Analyze the impact beforehand
      • Ensure smooth cluster operations
  • What-If Command Evolution supports:
    • Set Active Policy
    • Server Pool, server or resource modification
      • E.g. addition, relocation or removal
      • Special commands for failure evaluation

PROD

Action: Move server between pools

What

If?

what if command evaluation1
What-If Command Evaluation

How it works

MAIL

The DBA view:

>> srvctl relocate server -servers lnxrac12srv1 -serverpool mail -eval

Database rac will be stopped on node lnxrac12srv1

Server lnxrac12srv1 will be moved from pool ora.prod to pool ora.mail

PROD

The cluster administrator view:

>> crsctleval relocate server lnxrac12srv1 -to ora.mail -f

Stage Group 1:

------------------------------------------------------------------------------

Stage Number Required Action

------------------------------------------------------------------------------

1 Y Server 'lnxrac12srv1' will be moved from pools

[ora.prod] to pools [ora.mail]

2 Y Resource 'ora.rac.db' (1/1) will be in state

[OFFLINE]

------------------------------------------------------------------------------

Action: Move server between pools

[grid@LnxRAC12Srv1 bin]$ ./srvctlconfigsrvpool

...

Server pool name: mail

Importance: 0, Min: 1, Max: 3

...

Candidate server names:

Server pool name: prod

Importance: 0, Min: 1, Max: 2

...

small oracle rac 12 c feature big difference
Small Oracle RAC 12c Feature – Big Difference

Optimized Flexibility and Agility

program agenda3
Program Agenda
  • Oracle RAC 12c Overview
  • Oracle RAC 12c for:
    • Better Business Continuity and High Availability
    • Cost-effective Workload Management
    • Standardized Deployment and System Management
standardize on oracle rac and oracle multitenant1
Standardize on Oracle RAC and Oracle Multitenant

The new standard for Oracle Database consolidation

Oracle RAC

Oracle RAC One Node

Agility

Oracle GI

Oracle GI

Consolidation

oracle rac support for oracle multitenant1
Oracle RAC support for Oracle Multitenant

Start off with a Single Instance, non-CDB

Server

Services

Server

Database Instance

Database Instance

CRM

South

CRM

Reporting

CRM

North

Services

CRM

oracle rac support for oracle multitenant2
Oracle RAC support for Oracle Multitenant

Convert to a RAC Database, non-CDB

CRM Reporting

Node 1

Node 2

Services

Node 1

RAC Instance 1

RAC Instance 1

RAC Instance 2

CRM

South

CRM

North

Services

CRM

oracle rac support for oracle multitenant3
Oracle RAC support for Oracle Multitenant

Convert to a CDB RAC Database

Node1

Node2

Services

CDB Instance 1

CDB Instance 2

CRM

CDB

improved agility with changing workloads
Improved Agility with Changing Workloads

Expand Cluster to Support Flexible Consolidation Model

Node1

Node2

Services

CDB Instance 1

CDB Instance 2

Single SGA per

CDB Instance

DW

HCM

ERP

BI

CRM

Multitenant Container Database (CDB)

improved agility with changing workloads1
Improved Agility with Changing Workloads

Expand Cluster to Support Flexible Consolidation Model

Node1

Node3

Node2

Services

CDB Instance 1

CDB Instance 3

CDB Instance 2

Single SGA per

CDB Instance

DW

HCM

ERP

BI

CRM

Multitenant Container Database (CDB)

private database cloud architectures
Private Database Cloud Architectures

Oracle Database 12c

Virtual Machines

Dedicated Databases

Pluggable Databases

share servers, OS and database

share servers and OS

share servers

Increasing Consolidation

virtualization a black box approach

Dom-0

Dom-0

Bare-Metal Server

Bare-Metal Server

Virtualization – a Black Box Approach

A simple solution without insight

Guest

Guest

Guest

Guest

DOM-0

Hypervisor

DOM-0

Hypervisor

live migration moving a black box

Dom-0

Dom-0

Bare-Metal Server

Bare-Metal Server

Live Migration = Moving a Black Box

Live Migration moves a black box from one server to another

Live Migration

Guest

Guest

Guest

Guest

DOM-0

Hypervisor

DOM-0

Hypervisor

virtual machine ha restarting a black box

Dom-0

Dom-0

Bare-Metal Server

Bare-Metal Server

Virtual Machine HA = Restarting a Black Box

Virtual Machine HA restarts / fails over a virtual machine on failure

Guest

Guest

Guest

Guest

DOM-0

Hypervisor

DOM-0

Hypervisor

virtual machine ha restarting a black box1

Dom-0

Dom-0

Bare-Metal Server

Bare-Metal Server

Virtual Machine HA = Restarting a Black Box

But what if the application needs attention?

?

DBA

Guest

Guest

Guest

DOM-0

Hypervisor

DOM-0

Hypervisor

high availability requires insight

Dom-0

Dom-0

Bare-Metal Server

Bare-Metal Server

High Availability Requires Insight

The Oracle RAC Stack provides the insight

+1

+1

DBA1

DBC1

DBC2

DBA2

Guest

Guest

Guest

Guest

DOM-0

Hypervisor

DOM-0

Hypervisor

high availability requires insight1
High Availability Requires Insight

Why use VMs then?

+1

+1

DBA1

DBC1

DBC2

DBA2

Guest

Guest

Guest

Guest

oracle flex cluster1
Oracle Flex Cluster

Flexibility and High Availability as demand requires it

  • Oracle Flex Cluster
    • A new Oracle Clusterware based High Availability clustering topology
  • Utilizing two types of cluster nodes:
    • Hub nodes
      • Traditional nodes, tightly coupled via network and storage, used for running IO intensive workload
    • Leaf nodes
      • A new type of node that runs a lighter weight stack
      • Maintain their own failure and heartbeat settings
      • Do not require direct shared storage connectivity
      • Used for processing oriented (application) workload
    • Leaf nodes can be virtualized.

Leaf Nodes

Hub Nodes

oracle flex cluster2
Oracle Flex Cluster

The new standard for resource management in the cluster

  • Oracle Flex Cluster:
    • The new standard for flexible resource management in the cluster
      • Use it as demand requires it
      • Inherits all Flex ASM HA capabilities
      • Enables policy-managed clusters.
    • Efficient High Availability and resource management across tiers
      • Lightweight cluster stack on leaf nodes
    • Benefit from virtualization and physical deployments in one cluster

Leaf Nodes

DBB

DBB

DBA

DBA

DBA

Hub Nodes

oracle flex cluster3
Oracle Flex Cluster

Better HA clustering for all applications

  • Standardized management across applications
    • Global resource allocation and dependencies
    • Oracle Bundled Agents (XAG) for application HA
      • www.oracle.com/goto/clusterware

Start

Stop

DBB

DBB

DBA

DBA

DBA

slide title arial 28 pt one line
Slide Title: Arial, 28 PT, One-Line

Subtitle: Arial, 20 pt, One-Line Max

  • Bullets are sentence case. Use Arial, 20 pt font.
    • Sub-bullets are Arial, 18 pt font.
  • Keep bullets short.
  • One idea per bullet.
  • No more than five bullets.
  • NOTE: Arial is the ONLY font that should be used in the Oracle corporate presentation template.Times and other serif fonts are not acceptable.

To ensure that slides are properly formatted to this template, see pages 7 and 8for instructions.