the following is intended to outline our general any ... oracle database... · oda media server...

1 | © 2011 Oracle Corporation – Proprietary and Confidential

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.

© 2011 Oracle Corporation

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.

<Insert Picture Here>

Oracle Database Appliance Gian Luigi Cavalli PreVendita Oracle


Growing Business Critical Services and Data High Availability solutions desiderable, but not easily deployed

Complex andCostly

Specific Skills Required

High Risk of Failure


Value PropositionSimple High Availability Database

• Easy to Implement– One Box: server, storage, networking– One Button Install of SW

• Easy to manage & maintain– One button patching– Self-managing storage– Auto-detects and auto-corrects

• Easy to diagnose and support– Automated Service Request filing (phone home)– Relevant logs gathered and packaged for support


Highly Available Database Appliance• Simple, quick, complete, affordable HA Cluster

Database System in a single enclosure• Plug-n-Go– Plug the power– Plug the network– Name the system

• Key Features– Triple-mirrored storage with Oracle Automatic Storage

Manager– Hot serviceable customer replaceable components– Redundant Power, Server Nodes, Cooling, Networking…– Oracle Real Application Cluster– Oracle Appliance Manger

• Oracle Database Appliance also known as– ODA


Oracle Exadata Database MachineOracle Database

Appliance

Quarter Rack

Half Rack

Full Rack

Engineered Systems for Oracle Database

Oracle Red Stack


Oracle Database ApplianceIdeal for SMBs and Departmental Systems

• Simple to implement• Designed and priced to scale• Performance improves as you scale• Highest levels of serviceability• Highest availability for this class of

machine




Oracle Database Appliance Hardware


Oracle RAC architecture in ODARAC-in-a-box

Node 0 Node 1InterconnectShared Storage


Low Entry Cost To High Availability

• 24 processor cores• Manual configuration & installation• Multiple-vendor support contracts• Minimum 12 processor core licenses

Low cost, no complexity, high availability

HP

• 24 processor cores• One-button configuration & installation• Single-vendor support contract• Minimum 2 processor core licenses

DB Server

Redundant SAS or FC HBA’s

External

Network

Oracle Appliance Oracle Appliance ManagerManager

Installation Installation ExpertiseExpertise

Optimization Optimization ExpertiseExpertise

Network Network AdministrationAdministration

Storage Storage AdministrationAdministration

System System AdministrationAdministration

Database Database AdministrationAdministration

Savings

DB Server

Storage HA-Controller + DiskArray


Chassis

• 4U Redundant Storage Server• 2 Server Nodes (SN)

– Two internal boot disks per SN

• 24 3.5” dual ported SAS/SATA/SSD disk slots– 20x 600GB 15K RPM SAS (slots 0-19)

(Triple-mirrored:12 TB RAW, 4 TB Usable)– 4x 73GB STEC GEN3 SSD (slots 20-23)

for redo logs (Triple-mirrored)• 2 Hot-swap redundant power• Redundant 5V and 12V disk backplane power• Independent power, locate buttons and status

per SN• Fixed configuration• One order number for the hardware + another

for the power cord• Plus SFP+ Transceivers and/or cables when

using 10GbE

FRONT VIEW

REAR VIEW


SN0

SN1

Chassis - Rear View


Server Node Hardware ArchitectureHardware ElementsFeatures Description

Compute • 2 Server Nodes• On each Server Node

• 2x 6-Core Intel Xeon 5675 3.06GHz 95Watt CPUs• 2-12 CPU cores per SN enabled on demand• 12MB L3 cache per socket• 3x full-width bi-directional Intel QuickPath Interconnects per socket• Upto 25.6GB/s per QPI Ports• 96 GB RAM (12 x DDR3-1333 8GB DIMMs)• 3x Channel per socket and 2x DIMMs per channel

I/O • 4x 73GB SAS2 SSDs• 20x 600GB SAS2 15K RPM Disks (12 TB Raw)• 2x 500GB SATA boot disks (rear accessed) per Server Node• 3x PCIe Gen2 8-lanes slots per Server Node• 2x LSI SAS PCIe Erie HBA per Server Node

Network • Dual GigE as the Cluster Interconnect (within chassis for SN to SN connectivity)

• 2 x on-board GigE per Server Node• 1 x Quad GigE (Intel Northstar) per Server Node (2^ PCIe slot)• 1 x 10GigE Dual-ports (Intel Niantic) per Server Node (3^ PCIe slot)



OS Boot Disk

Internal HBA

Internal USB

PCI Riser

CPU0

CPU1

Server Node View

SAS, Chassis, FIM, +5V disk, PSU Signals


Network port bonding


Architectural Overview

• Each Node– plugs into the chassis– operates independent of the other– has full access to the 24 front

mounted disks– contains a dual port Ethernet

controller internally connected• eliminates the need for external cables

• Failure on one Node will not result in a service interruption on the other Node

• Any service requests on a failed Node are maintained through the surviving Node


Four possible Backup Strategies• Back up to a Flash Recovery Area (FRA) on disk• Back up to a file system such as NAS (RMAN)• Back up to tape (OSB: Oracle Secure BackUp; 3rd BU SW)• Remote replication using Data Guard (Disaster Recovery)

- RMAN backup sets on external Third-party media server

- DRP if in other location- Long-term data protection on

tape

Gb/s or 10Gb/s ODA

Media server

Oracle StorageTekTape library

Immediate restoreif still on disk, fast restore fromtape

Backupto disk or tape

Oracle StorageTekDisk: ZFSSA


Supported Third Party Agents for the ODA

Company Backup Application

Version RMAN Client Media Server OS

Symantec Netbackup 7.1 7.1 Client OEL 5.7CommVault Simpana 9 SP3 iDA for Oracle

Databases - Linux

OEL 5.7

EMC Networker 7.6.2 "SP2" Networker Module for Databases and Application (NMDA) V1.1

OEL 5.7

IBM Tivoli Storage Manager

6.3 Data Protection for Oracle 6.3

OEL 5.7

HP Data Protector

A.06.20 A.06.20 Client OEL 5.5

• Beginning immediately software release, all Oracle or 3rd-party software agents, including management, monitoring, and authorization agents, will be supported on ODA

• We will no longer maintain a white list of agents that will be supported

• Customers may load any software agent, or write and deploy their own agents

• Oracle will provide patches for Oracle software and Linux libraries. Agents that ship as part of the Oracle Linux distribution will be automatically patched as part of our appliance patching process

New


Build SystemBuild System Image FirmwareImage Firmware

Install OS Install OS

Connect System to Network & Power ON

Connect System to Network & Power ON

Download SW from MOS

Download SW from MOS

Provide Basic info to Configurator

Provide Basic info to Configurator

Deploy Grid, DB with best Practices

Deploy Grid, DB with best Practices

Initiate Health Check

Initiate Health Check

Fully Configured Database

Fully Configured Database

Deployment Overview


Three Tiers of Availability



‘Pay-as-you-Grow’ Database Licensing

• Purchase single hardware configuration• Start with minimum of 2 processor core licenses• Scale to maximum of 24 processor core licenses• No hardware upgrades required• License database software just for the cores you

use



‘Pay-as-you-Grow’ Database LicensingOracle Database Appliance


Server Node 1 Server Node 2

- Activated

- Licensed

• 4 cores must be activated at a time


• Customer can license only 2 cores for EE or RAC One Node


‘Pay-as-you-Grow’ Database LicensingOracle Database Appliance: Enterprise Edition SingleInstance/RacOneNode


- Activated

- Licensed

• 2 Cores activated• 1x Processor License EE: 37 K oppure 25 NamedUser EE: 18.5 K• 1x RacOneNode: 8K• 1x Advanced Compression: 9K• 1x Partitioning: 9K • 1x Diagnostic&Tuning: 8K


• Customer can license 2 cores for EE or RAC One Node

Costo del SW a Listino:

• TOT EE NU: 18.5K • TOT EE: 37K• TOT EE+RacOne: 45K

Manut: 22% Anno

Costo dell’HW a Listino: • ODA+SisOp+Mngt: 39K

Manut: 12% Anno


‘Pay-as-you-Grow’ Database LicensingOracle Database Appliance: Enterprise Edition RAC


- Activated

- Licensed

• 4 Cores activated• 2x Processor License EE: 74K oppure 50 Named User EE: 37K• 2x RAC: 36K oppure 50 RAC NamedUser: 18K• 2x Advanced Compression: 18K• 2x Partitioning: 18K • 2x Diagnostic&Tuning: 16K


• Customer can license 4 cores for EE or RAC

Costo del SW a Listino:

• TOT EENU +RACNU = 56K • TOT EE+RAC: 110 K• TOT EE+RAC+OPT: 162K Manut: 22% Anno

Costo dell’HW a Listino: • ODA+SisOp+Mngt: 39K

Manut: 12% Anno



Oracle Database Appliance Software


Oracle Database Appliance Full Oracle Stack

• Oracle Linux 5.5• Choice of Oracle Database EE, RAC, or RAC One

Node (11.2.0.2) and other options• Oracle Grid Infrastructure 11g Release 2 (11.2.0.2)– Oracle Clusterware– Oracle Automatic Storage Management

• Oracle Enterprise Manager Database Control• Oracle Automatic Service Requests (Phone home)• Oracle Appliance Manager


Oracle Clusterware

• Allows clustering of independent servers so that they cooperate as a single system– Presented as one server to applications and end users

• Capable of protecting any kind of application in a failover cluster– Increased HA

• Fully integrated with Oracle RAC


Oracle Automatic Storage Management

• Volume manager and file system for Oracle database– Single-Instance Oracle Database– Oracle RAC configurations

• Uses disk groups to store datafiles– ASM presents a file system for Oracle database files

• Provides flexible server-based mirroring options– Enables two-way and three-way mirroring for increased

HA– Can replace failed or pre-failed drives without affecting

operation of file system• Improves I/O performance– Consolidates data storage into small number of disk

groups– Provides dynamic rebalancing ensuring every file is

evenly spread across all the disks in a disk group


Oracle Enterprise Manager Database Control

• Provides interface to perform database administrative tasks– Creating schema objects (tablespaces, tables, indexes)– Managing user security– Backing up and recovery of the databases– Importing and exporting of data

• Provides performance and status information about databases


Automatic Service Request (ASR)

• Optional offering for enhanced support experience• Automatically opens service requests with

Oracle for specific hardware faults– Service requests filed electronically and securely– Fast and accurate resolution of the hardware faults– Improved availability, less downtime

• Can be integrated with existing monitoring tools– ASR manager can send SR notifications via SNMP traps

to existing monitoring tools


Oracle Appliance Manager

• Provides One Button functionality to easily install, manage, maintain & validate the system.• Performs discovery of the storage subsystem.• Monitors disks for hard & soft failures.• Recovers ASM disk groups on shared disk

failure.• Automates procedures after remove/replace

disks


Oracle Appliance Manager

• Configurator Module• Deployment Module• Storage Management Module • Patching Module• Validation & Diagnostic Tools Module


Oracle Appliance Manager Configurator• Hides the complexity of setting up the cluster• GUI-based enquiry collects configuration

information- Cluster name- Domain- Networking information- Database size

• Validates gathered information• Configures OS & Networks• Deploys the Grid Infrastructure & Database


Oracle Appliance Manager Configurator

Setup the customized System Name

Select from three Database Deployment Configurations: RAC, RAC One Node, or Single Instance



Node and IP information for 2nd Node is automatically generated & filled

SCAN name is auto generated

VIP Name & IP information automatically generated & filled for both nodes



Setup the customized Database Name

Select the Database Class type


Oracle Appliance Manager Deployment Module• Oracle Database Class Options

- Very Small200 Processes, 16 MB log buffer, SGA: 4096-8192 MB, PGA: 2048-4096 MB. 1 GB redo log file

- Small400 Processes, 16 MB log buffer, SGA: 8192-16384 MB, PGA: 4096-8192 MB, 1 GB redo log file

- Medium800 Processes, 32 MB log buffer, SGA:16384-24576 MB, PGA: 8192-12288 MB, 2 GB redo log file

- Large 1200 Processes, 64 MB log buffer, SGA: 24576-49152 MB, PGA: 12288-24576 MB, 4 GB redo log file

- Very Large2400 Processes, 64 MB log buffer, SGA:49152 MB, PGA: 24576 MB, 4 GB redo log file

SGA= System Global Area, PGA= Program Global Area


Oracle Appliance Manager Deployment Module

• Deploys OS, Oracle Appliance Manager, Grid Infrastructure & Database• Configures GI & RDBMS (Oracle Database)• Ensures correct configuration of disks &

networks• Consistent implementation of known Best

Practices• Configures optimal disk layout for ASM• Performs initial configuration of disks & ASM

DG(s)


Oracle Appliance Manager Storage Management Module

• Oracle Appliance Manager Daemon (oakd) is started during boot • Discovers storage subsystem• Tracks configuration by storing metadata• Monitors status of disks• Generates alerts on failures• Takes corrective action on appropriate events• Interacts with ASM for complete automation


Oracle Appliance Manager Patching Module

• Patching Module provides tools to patch OS, Oracle Application Manager Modules, Grid Infrastructure(GI), RDBMS

• Provides a single interface and command to patch all the components including OS, firmware, BIOS , GI and RDBMS

• Patching Module will update the repository to reflect the newly installed patches and firmware's

• Bundle Patches for all components that is to be patched.


Oracle Appliance Manager Validation & Diagnostic Tools Module

• A set of tools for validation & diagnostics• Validation tool provides detailed information

about the components – both HW & SW• Diagget tool collects all the diagnostics

information and can be used when experiencing problems.

• Healthcheck can be used to check the health of OS, DB, Clusterware and other Oracle Database Appliance components to ensure they are healthy and functionally optimally.


Oracle Application ManagerCommand Line (oakcli)• OAKCLI leverages current OneCommand Toolset with

Oracle Database Appliance specific enhancements.• Commands

oakcli show - show storage, license, expander, controller, diskgroup, disk

oakcli locate - locates a diskoakcli apply - applies the core_configuration_key <key file location>oakcli deploy - deploys the Database Applianceoakcli update - updates the Database Applianceoakcli validate - validates the Database Applianceoakcli manage - manages the oak repository, diagcollect e.t.coakcli unpack - unpack the given bundle to oak repositoryoakcli configure - configures the networkoakcli copy - copies the deployment config file


Le Business Issues indirizzabili

• Business Continuity• Storage Optimization• System Management• Database Security


DB Appliance: Business Continuity

• Good Availability• Oracle Database 11g

Enterprise Edition

Single Instance

• Best Availability• Oracle Database 11g

Enterprise Edition• Oracle Real

Application Clusters• Mutual failover and

loadbalancing

Active – Active

• Better Availability• Oracle Database 11g

Enterprise Edition• Oracle Real

Application Clusters One Node• Can have mutual

failover

Active – Passive


Durante l’installazione possibile scegliere fra tre tipologie di installazione automatica con differenti livelli di protezione dal punto della Alta Affidabilita’.


Service

Real Application cluster

public network

Node1

Operating System

Clusterwarecluster

interconnect

instance 1

ASM

Node 2

Operating System

Clusterware

instance n

ASM

Redo / Archive logs all instances

shared storage

Database / Control files

OCR and Voting Disks

VIP1 VIPn

Listener ListenerService

Grid

Infrastructure


• Automated Failover within Grid• Live migration of across Grid• Rolling Patches• Online Upgrade to multi-node RAC instances

DB C DB ADB B

DB DDB E

DB F

Oracle Database 11g Release 2RAC ONE Node – RAC for mass consolidation


RAC-One Node

DB1 DB2

Server A

Common Shared Storage

Single Cluster

DB3

Server B


Data Guard StandbyDatabase

ProductionDatabase

NetworkNetworkDIGITAL DATA STORAGE

OptionalOptionalDelayDelay

DIGITAL DATA STORAGE

BackupSync or Async Sync or Async

Transaction ShippingTransaction Shipping

Recovery O ReadOnlyRecovery O ReadOnly


Active Data Guard StandbyDatabase

ProductionDatabase

StandbyDatabase

ContinuouslyContinuouslyOpen for ReportsOpen for Reports

NetworkNetwork

OptionalDelay


OptionalOptionalDelayDelay


Backup

Recovery E ReadOnlyRecovery E ReadOnly

Sync or Async Sync or Async Transaction ShippingTransaction Shipping

Recovery O ReadOnlyRecovery O ReadOnly




DB Appliance: Storage OptimizationAdvanced Compression Option

• Oracle 9i Data Compressio comprime i dati solamente durante le operazioni “bulk load”, quindi utile per DW e ILM• Oracle 11g Advanced Compression

comprime anche su operazioni di insert e update• La “compression ratio” tipica e’ 2x to 3x• Il DB legge direttamente i dati in formato

compresso eliminando l’overhead delle decompressione.

Relativamente alla slide appena mostrata che elenca alcune delle Business Issues indirizzate dalla Enteprise Edition con le sue Features ed Opzioni e avendo notato che la macchina dispone di 4 Terabyte di spazio disco utile, come posso eventualmente ottimizzare lo storage?


DB Appliance: System Management

• EM MANAGEMENT PACKS: funzionalita’ avanzate per la gestione ed il monitoraggio dell’intero ecosistema Oracle

- Diagnostic Pack- Tuning Pack- Database Lifecycle Management Pack- Test Data Management Pack- Data Masking Pack

Oltre alle opzioni prima elencate, riconducibili alle aree evidenziate, con Oracle EE sono inoltre disponibili alcune opzioni dello strumento di amministrazione :


DB Appliance: System ManagementReal Application Testing

• SQL Performance Analyzer (SPA)• SQL unit testing for response time tuning

• Database Replay• Concurrent load testing using production workloads

ReplayWorkload

CaptureWorkload

Deploy Replay Clients

Create Test System

End-to-End Workflow


• Test and predict impact of system changes on SQL query performance

• Analyze performance changes for improvements or regression• Comprehensive performance analysis and reporting• Re-execute SQL queries in test environment• End-to-end solution: STS, SQL Plan Baselines, & SQL Tuning Advisor

Real Application TestingSQL Performance Analyzer

SQL WorkloadSTS

SQL Plans + StatsPre-Change Trial

SQL Plans + StatsPost-Change Trial

Compare SQL Performance

Analysis Report


Database Load Testing TodayTest – 1-2 testers trying to be 1,000s of users

PRODUCTION TEST

• Infrastructure load testing not adequately performed

• Many issues go undetected

• Testing expensive in time and money with poor results

• Changes such as db upgrades, platform migrations, etc., can produce issues uncovered during proper load testing only

• Challenge is to generate a test workload that is representative of production environment


• Reduce costs and risks of database changes

• Fully automated workflow• Change Assurance for

– Database and O/S upgrades– Configuration changes, e.g.,

conversion from SI to RAC– Storage changes– O/S migrations

• Supports upgrades from Oracle 9iR2 to 10gR2 and 11g!

TestProductionReplay DriverClients

Storage Storage

Real Application Testing Database Replay


Oracle Database Security Defense-in-Depth

Access Control

• Oracle Database Vault• Oracle Label Security

• Oracle Advanced Security• Oracle Secure Backup• Oracle Data Masking

Encryption and Masking

Auditing and Tracking• Oracle Audit Vault• Oracle Configuration Management• Oracle Total Recall

• Oracle Database Firewall

Monitoring and Blocking


Summary

• Simple to deploy– Pre-configured with validated components– Best practices implemented– Reduced risk in deploying HA

• Simple to manage– Automatically detects problems & takes corrective

actions– Patch all components with single command– End-to-end management – hardware to software

• Simple to troubleshoot– ASR configuration– Validates system configuration– Gathers relevant logs for support

© 2011 Oracle Corporation – Proprietary and Confidential

the following is intended to outline our general any ... oracle database... · oda media server...

Documents