latest innovations in database as a service enabled by oracle … › technetwork › oem ›...

Latest Innovations in Database as a ServiceEnabled by Oracle Enterprise Manager

Hari SrinivasanConsulting Product Manager, Oracle

Bala KuchibhotlaSr. Director Engineering, Oracle

GurushankarDirector Product Management,Oracle Managed Cloud Services

Hari SrinivasanConsulting Product Manager, Oracle

Bala KuchibhotlaSr. Director Engineering, Oracle

GurushankarDirector Product Management,Oracle Managed Cloud Services

Copyright © 2015, Oracle and/or its affiliates. All rights reserved.

Session Description

Over the last few years, Oracle Enterprise Manager has become the control center fordatabase as a service. It leverages various underlying technologies including multitenantand storage snapshot to offer consolidation planning, rapid provisioning, monitoring,and cloud governance. The innovations in this area continue at a rapid pace with OracleEnterprise Manager Database Consolidation Workbench, hybrid cloud migration, andcontinuous data refresh for DevOps. In this session, attendees learn about theseinnovations and hear successful case studies from other customers.


Over the last few years, Oracle Enterprise Manager has become the control center fordatabase as a service. It leverages various underlying technologies including multitenantand storage snapshot to offer consolidation planning, rapid provisioning, monitoring,and cloud governance. The innovations in this area continue at a rapid pace with OracleEnterprise Manager Database Consolidation Workbench, hybrid cloud migration, andcontinuous data refresh for DevOps. In this session, attendees learn about theseinnovations and hear successful case studies from other customers.

2

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

Copyright © 2015, Oracle and/or its affiliates. All rights reserved

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

3

Program Agenda

1

2

3

Oracle Database as a Service using EM - Overview

Customer Story – Oracle Managed Cloud Services

New Innovations turbo charging your journey to cloud

Q & A

Copyright © 2015 Oracle and/or its affiliates. All rights reserved.

3

4

Oracle Database as a Service using EM - Overview

Customer Story – Oracle Managed Cloud Services

New Innovations turbo charging your journey to cloud

Q & A

4

Database as a Service using Enterprise ManagerBringing self service to databases within your datacenters

Copyright © 2015 Oracle and/or its affiliates. All rights reserved. 5

Oracle Database as a Service usingEnterprise MangerControl center for your Oracle Database Private Cloud


Oracle Database as a Service usingEnterprise MangerControl center for your Oracle Database Private Cloud

6

Oracle Database as a Service using EMCloud Administrator – Automates the platform setup

Ready foruse Database

Cloudplatform

On Premise Cloud


CloudAdministrator


Cloudplatform

CreateQuotas

CreateService

Template

SetupCharge Plans

(optional)

ConfigureRequestSettings

Create resource poolsof Oracle Homes or

Databases or Container DBs

Oracle Database as a Service using EMSelf Service User – Leverages platform to get databases

DatabaseReady for

Use

ConfigureBackups

SelectDatabasefrom thecatalog

ConfigureDatabase


DatabaseReady for

Use

ConfigureBackups


ConfigureDatabase

End Users

Oracle Database as a Service using EMUser Roles and Actions

DatabaseReady for

Use

ConfigureBackups


ConfigureDatabase

End Users


DatabaseReady for

Use


CloudAdministrator


Cloudplatform

On Premise Cloud

CreateQuotas

CreateService

Template

SetupCharge Plans

(optional)

ConfigureRequestSettings

Create resource poolsof Oracle Homes or

Databases or Container DBs

Oracle Database as a Service using EMAutomated Infrastructure

Self ServiceServe the infrastructure requests from usersdirectly. Provide optimized performancebased on service levels. Meter Usage.Standardize deployments, Reducemaintenance.

Database as a ServiceLayer


Auto ScalingCPU and Memory On-Demand. Partitioninto Zones and Pools for High availability. Ondemand scale up, scale down and relocation.

ConsolidationConsolidate the compute & storage tomaximize utilization. Include any generalpurpose h/w, engineered systems, and evenvirtual machines.

Cloud abstractionLayer

Base InfrastructureLayer

On Premise - Physical, Virtual, or Engineered Systems

Oracle Database as a Service using EMAutomated Database Administration

DiagnosticsPerformance, security, availabilitydiagnostics for tuning, problemresolution. Root cause analysisacross topology and the stack.

MonitorUptime, Utilization, Availability, TopActivity, Health, Security profile,comparison to typical. Provide a stripdown, high level version to end users.

ProvisionSetup automated creation of Standardconfigurations of Databases, RACs,Standby’s, Pluggable Databases andSchemas following your corporatestandards. Lockdown configurations.


PatchReduce effort with centralized fleetmaintenance. Rollout updates via gold imagesfrom a subscription based model. Process laysdown a new patched Oracle home andswitches the services, reducing downtime andprovides tenant isolation.

BackupAutomated backups. Bake in the option,schedule as a part of service creation.Track and recover from human error.

CloneAutomate creation of full copies, storageefficient snap clones of a databases.Integrate with Masking, Subsetting to getsecure, efficient copies.

DiagnosticsPerformance, security, availabilitydiagnostics for tuning, problemresolution. Root cause analysisacross topology and the stack.

MonitorUptime, Utilization, Availability, TopActivity, Health, Security profile,comparison to typical. Provide a stripdown, high level version to end users.

SNAPCLONES

FULLCLONES

ProvisionSetup automated creation of Standardconfigurations of Databases, RACs,Standby’s, Pluggable Databases andSchemas following your corporatestandards. Lockdown configurations.

Oracle Database as a Service using EMAutomated Services

Database Service• Standardize Database environmentwith predefined and locked downconfigurations.• Consolidate environments andmaximize utilization withautomated, intelligent placement.

Metering &Governance Service

• Govern utilization with quotas andpolicies tailored to different use casesand user types.• Manage by tracking usage, either docharge or show back based on anymetrics (like configurations, feature-usage, utilization, etc..)


Data Service•Serve data either Full clones or SnapClones (based on copy-on-writetechnology).•Integrated with masking & subsetting fortest environment creation.•Supported on any SAN and NAS storage,get up to 90% storage savings by snapping.

Metering &Governance Service

• Govern utilization with quotas andpolicies tailored to different use casesand user types.• Manage by tracking usage, either docharge or show back based on anymetrics (like configurations, feature-usage, utilization, etc..)

REST Service• Cover the complete operations asadministrator and user.•Integrate with custom portals, 3rdparty tools, ITSM , developer buildprocesses, etc..

REST API

Oracle Database as a Service using EMStandardized offering via Service Catalog

SILVEROracle 11gR4 EE Database

GOLDOracle11gR4 EE RAC Database withStandby


On PremiseDatacenter

SILVEROracle 11gR4 EE Database

SILVEROracle 12c Pluggable Database (MaskedData)

BRONZEHR Schema in Oracle 12c EE Database

AutomatedOr PreferredPlacement

Service Catalog

Small

Medium

Large

Instance Sizeoptions

Service & SLAoptions

Oracle Database as a Service using EMRole driven usage, adapt to IT transformation

End Users Dev Ops Administrators

• Request Database Services• Request Data Services• Monitor and Manage

Deployed DBs• Delete Service DBs

• Platform Mgmt. (Zone, Pools)– Oracle Home Deployment– RAC/CDB Deployment– Data

• Quota & Placement mgmt.• Service Template Creation• Service Catalog Mgmt• Fleet Maintenance


• Request Database Services• Request Data Services• Monitor and Manage

Deployed DBs• Delete Service DBs

• Platform Mgmt. (Zone, Pools)– Oracle Home Deployment– RAC/CDB Deployment– Data

• Quota & Placement mgmt.• Service Template Creation• Service Catalog Mgmt• Fleet Maintenance

Oracle Database as a Service using EMComplete Control of your Private Cloud

CONTROL YOURDATABASE

PRIVATE CLOUD


CONTROL YOURDATABASE

PRIVATE CLOUDWith the CLI/API

With the Portal

DBA’s expertise is a keycomponent of the DBaaSoffering… -IOUG Survey 2015

EfficiencyConsolidated, shared platform

maintained with automation

AccessibilityAutomated request channel via

self-service

Oracle Database as a Service using EM

Dedicated Database Pluggable Database Database Schema

Database

Fully functional Database with any Data on any infrastructure


IntegrationAPI integration with 3rd party tools ,

change requests, dev workflows

ElasticityAgile scale up, scale down, relocation

of services


self-service

AccountabilityMeter usage, quota, compliance and

governance

Data

InfrastructurePhysical, Virtual, or Engineered SystemsOn Premise

Full CloneEmpty Snap clones

OROR

Managed Cloud Database Service

Guru ShashikumarDirector, Product ManagementOracle Managed Cloud Services

Enterprise Manager powers transformation of database Cloud On-premises

Case Study


Guru ShashikumarDirector, Product ManagementOracle Managed Cloud Services

Key Features• Self-service Portal with Service Catalog & Tiered SLAs• Pre-engineered packages for accelerated deployment• Best-in-class Security & Compliance services• REST APIs for integration with On-premises IT Systems• Fully Managed by Oracle

Customer InternalNetwork andApplications

Managed PrivateDatabase Cloud*

Managed Cloud Database Service – OverviewEngineered Systems based offering deployed On-premises with Consumption Billing,Single Contract and Single Invoice


• Self-service Portal with Service Catalog & Tiered SLAs• Pre-engineered packages for accelerated deployment• Best-in-class Security & Compliance services• REST APIs for integration with On-premises IT Systems• Fully Managed by Oracle

Benefits• Increased Agility within your own Datacenter• Improved Service Levels with Availability & Support SLAs• Single vendor offering with Full service OpEx• Data Security, Privacy & Sovereignty• Offload tactical maintenance to Oracle, focus on your core

competence

Oracle RemoteManagement

OMCS IntegrationPlatform

Customer Data Center

*Built on top of Enterprise Manger – Database as a Service

• Oracle provided or Third-party ITSM

• Role based access for Developers & Service Admins

• Services rendered via a “Service Catalog”

• Enable Self-service Provisioning of DBs

• Integrated DB Lifecycle Management

• Metering & Showback for Deployed DBs

• Reporting & Dashboards

MCDS Self-Service PortalEnable Access to Standardized Services for Repeatable and Predictable Results


• Oracle provided or Third-party ITSM

• Role based access for Developers & Service Admins

• Services rendered via a “Service Catalog”

• Enable Self-service Provisioning of DBs

• Integrated DB Lifecycle Management

• Metering & Showback for Deployed DBs

• Reporting & Dashboards

19

MCDS Service Catalog: Business Catalog with Tiered SLAs


MCDS Service Catalog – Offers choice of DB Size and SLAs


Track Service Requests and Perform Lifecycle Management


MCDS Packaging: Small, Medium, and Large ConfigurationsIntegrated Package of Hardware, Software, Support, and Managed Cloud Services

Small Medium LargeEstimated # of DBs Up to 100 Up to 300 Up to 600

Engineered Systems (2) Exadata Quarter Racks (2) Exadata Half Racks (4) Exadata Half Racks

ZFS Storage ZS3-2 (1 Rack, 2 Heads, 1 Tray) ZS3-2 (1 Rack, 2 Heads, 1 Tray) ZS3-2 (1 Rack, 2 Heads, 1 Tray)

Management Servers (2) Oracle Servers X5-2 (2) Oracle Servers X5-2 (2) Oracle Servers X5-2

OEM 12c Cloud Mgmt and DBLM Packs Cloud Mgmt and DBLM Packs Cloud Mgmt and DBLM Packs


OEM 12c Cloud Mgmt and DBLM Packs Cloud Mgmt and DBLM Packs Cloud Mgmt and DBLM Packs

Network Infrastructure Firewall, VPN, Ethernet Switches Firewall, VPN, Ethernet Switches Firewall, VPN, Ethernet Switches

DB Versions 11gR2, 12c 11gR2, 12c 11gR2, 12c

Support HW/SW Premier Support HW/SW Premier Support HW/SW Premier Support

Managed Cloud Services Infra/DB Management Infra/DB Management Infra/DB Management

Oracle Database as a ServiceInnovations turbo charging your cloud journey


Oracle Database as a ServiceInnovations turbo charging your cloud journey

24

Turbo charging Journey to CloudInnovation across 3 Stages of Cloud Adoption & Growth

Copyright © 2015, Oracle and/or its affiliates. All rights reserved. |

Maximize Server Utilization,Streamline Manageability andDrive Down Capital Expenses

Reduce CAPEX, increase Scalethrough extending to Oracle

CloudMaximize Performance with

Advanced Automation






CloudMaximize Performance with

Advanced Automation


CONSOLIDATION

Implement by migrating databasesto new platform using automationImplement by migrating databasesto new platform using automation

Identify candidate databasesUsing AWR Data

Identify candidate databasesUsing AWR Data

Database Consolidation WorkbenchEnd-to-end Consolidation Solution


Validate using Real Application Testing (SPA), runtest workloads on consolidated databasesValidate using Real Application Testing (SPA), runtest workloads on consolidated databases

27

Database Consolidation Workbench

Virtual Image• Database software ready for

install

• Tenant has root privilege

• Does not provide automatedorchestrations

• Only available on generalpurpose infrastructure

• Automated install, patch,upgrade, upsize/downsize,backup/restore, recovery,data guard configuration, TDEencryption, monitoring…


• Oracle monitors and isresponsible for keeping thedatabase available

• Oracle manages install, patch,upgrade, upsize/downsize,backup/restore, recovery

• Oracle maintains privilegeduser access, tenant controlsdata.

Advisor Migration Validation

Copyright © 2015, Oracle and/or its affiliates. All rights reserved. 28

GeneralPurpose

• Database software ready forinstall


• Does not provide automatedorchestrations

• Only available on generalpurpose infrastructure

• Automated install, patch,upgrade, upsize/downsize,backup/restore, recovery,data guard configuration, TDEencryption, monitoring…


• Oracle monitors and isresponsible for keeping thedatabase available

• Oracle manages install, patch,upgrade, upsize/downsize,backup/restore, recovery

• Oracle maintains privilegeduser access, tenant controlsdata.

CaptureWorkload

Create TestSystem

Deploy ReplayClients

ReplayWorkload


• Estimates resource utilization under various consolidation scenarios– Ultra Conservative (peak maximum) Aggressive (average)

• Supported consolidation modes– Database-to-Database (Multitenant) consolidation– Database-to-Server (Server, e.g. Exadata) consolidation– Oracle Public Cloud consolidation

• Consolidation optimization advice– Identifies conflicts based on workload characteristics, Exadata suitability– Storage/Platform advice: impact of compression on I/O & storage, impact of I/O offloading & Flash Cache

Database Consolidation Advisor

Copyright © 2015, Oracle and/or its affiliates. All rights reserved

• Estimates resource utilization under various consolidation scenarios– Ultra Conservative (peak maximum) Aggressive (average)

• Supported consolidation modes– Database-to-Database (Multitenant) consolidation– Database-to-Server (Server, e.g. Exadata) consolidation– Oracle Public Cloud consolidation

• Consolidation optimization advice– Identifies conflicts based on workload characteristics, Exadata suitability– Storage/Platform advice: impact of compression on I/O & storage, impact of I/O offloading & Flash Cache

29

Database Consolidation WorkbenchCREATE CONSOLIDATION PROJECTS

UNDERSTAND SOURCE WORKLOADS

UNDERSTAND SOURCE WORKLOADS

Copyright © 2015, Oracle and/or its affiliates. All rights reserved 30

DIVE INTO STORAGE USAGE & OPTIMIZATIONS


• Multiple migration methods based on source and target database attributes(endian-ness, versions)– Offline: RMAN clone, Data Pump– Online: Data Guard standby , migrate as PDB with minimum downtime

• Transportable TTS is used to minimize downtime in "Migrate as PDB".• Any source database non CDB version 11203, 11204 and 12.x can be moved to 12.x as PDB

• Supports 10g(10.2) to 12c (12.1) databases• SI & RAC, Multitenant and non-CDB modes• Automate using deployment procedures

Database Migration : “Make it so”, Migrate to Consolidated Environment


• Multiple migration methods based on source and target database attributes(endian-ness, versions)– Offline: RMAN clone, Data Pump– Online: Data Guard standby , migrate as PDB with minimum downtime

• Transportable TTS is used to minimize downtime in "Migrate as PDB".• Any source database non CDB version 11203, 11204 and 12.x can be moved to 12.x as PDB

• Supports 10g(10.2) to 12c (12.1) databases• SI & RAC, Multitenant and non-CDB modes• Automate using deployment procedures

31


Consolidation Method Method Performance Test

Before and after “Make it so” SPAtrials, SQL unit testing for responsetime in all consolidation scenarios &Exadata simulation in planning phase

Consolidation Validation using Real Application Testing

CaptureWorkload

Create TestSystem

Deploy ReplayClients

ReplayWorkload


Server, OS, Schema, Multitenant SQL Performance Analyzer (SPA)

Before and after “Make it so” SPAtrials, SQL unit testing for responsetime in all consolidation scenarios &Exadata simulation in planning phase

Server, OS Database Replay Load, performance testing forthroughput

Schema, Multitenant Concurrent Database ReplayReplay multiple workloads againstone database for throughput andscalability

32





CloudMaximize Data as a ServicePerformance with Advanced

Automation


CONSOLIDATION

DATA CLONING

Data as a Service using Enterprise ManagerOn Demand Automated Data Cloning

Deliver Data either as FULL clone or Snap Clones Technology Agnostic – Leverage either natively support

storage hardware or add a software layer to abstract anduse any of your existing storage solution End-to-End Automation – Prod to Test/Dev Designed for DBAs. Use directly as an admin or expose it

as a self service via the DBaaS platform Integrated Masking, Subsetting, Patch, Configuration

change, etc Use either UI or EMCLI and REST API for integrations


Deliver Data either as FULL clone or Snap Clones Technology Agnostic – Leverage either natively support

storage hardware or add a software layer to abstract anduse any of your existing storage solution End-to-End Automation – Prod to Test/Dev Designed for DBAs. Use directly as an admin or expose it

as a self service via the DBaaS platform Integrated Masking, Subsetting, Patch, Configuration

change, etc Use either UI or EMCLI and REST API for integrations

Data MovementTest MasterDatabase

NAME SSN SALARY

MILLER 112-23-4567 10,004

SMITH 111-22-3333 10,006

Masking &Config Mutation

ProductionDatabase

010110011101001010000111010

NAME SSN SALARY

AGUILAR 203-33-3234 40,000

BENSON 323-22-2943 60,000


Prod DB Backups Mask / Subset Test Master Clones

Refresh

Data Guard Standby

Refresh

35

Test Master

t0 t1 t2 …. tN

Scheduled or Manual Storage Snapshots or RMAN Backups of the test master database, called Data Profiles.

• Clones can be created from any profile• Each user gets a personal read-write databaseclone

Agile ‘Data Refresh’Time Travel – Refresh, Rewind across Snapshots


Private backups

Clones

• Clones can be created from any profile• Each user gets a personal read-write databaseclone

Test master isregularly

refreshed withcurrent data from

production Data Refresh

36

Database Snap Clone - Rewind and Refresh Automation


DEMODEMO

Database Snap Clone - Rewind and Refresh Automation


HYBRID CLOUD




CloudMaximize Data as a ServicePerformance with Advanced

Automation


CONSOLIDATION

DATA CLONING

HYBRID CLOUD

Oracle Database Hybrid CloudFull portability between on-premises and cloud

Same ArchitectureSame Software

Same Skills


Same ArchitectureSame Software

Same SkillsOn-Premises Oracle Cloud

Unified ManagementEnterprise Manager manages both On Premise and Cloud

39

Oracle Database Hybrid CloudFull portability between on-premises and cloud

Easily move data and workloads.

Configuration and Schema comparison.


On-Premises Oracle Cloud

40

Unified ManagementEnterprise Manager manages both On Premise and Cloud

Compliance and Drift Management.

Configuration and Schema comparison.

Oracle Database Hybrid CloudLift ‘n’ Shift across clouds using Enterprise Manager

EM 13c Next Release

Move PDBs to/from clouds*

Data Cloning with Masking*

Database Backup / Restore


Database Backup / Restore

Automated Service Provisioning

Service Metering & Governance

*‘Lift n Shift’ feature is also Available in EM12c R5

Data Masking – Either upload masked data or mask on the wire.

Oracle Database Hybrid Cloud

Clone-Mask/Subset-Upload Extract-Mask/Subset-Upload

Mask on Premise and Upload to the Cloud using EM


010010110010101001001001001001001001001001001000100101010010

010010110010101001001001001001001001001001001000100101010010

Oracle Database Hybrid Cloud

Clone & Mask PDB to Cloud Mask/Subset in the Cloud

Masking on the wire or in the Cloud using EM


010010110010101001001001001001001001001001001000100101010010

Lift ‘n’ Shift Databases across cloudsClone Database to Cloud

Pricing RetailPricingCloud

Pricing(Dev2)

Pricing(Dev1)


Cloud-Based Container Database

44

On-Premises Container Database

CustomerDatacenter ORACLE

Cloud

Lift ‘n’ Shift Databases across cloudsClone Database from Cloud

Pricing Retail CRM CRM HR Hiring


Cloud-Based Container DatabaseOn-Premises Container Database

CustomerDatacenter

ORACLECloud

Oracle Database as a Service using EMSummary


Oracle Database as a Service using EMSummary

46

EfficiencyConsolidated, shared platform

maintained with automation


self-service

Oracle Database as a ServiceFully functional Database with any Data on any infrastructure

Dedicated Database Pluggable Database Database SchemaDatabase


IntegrationAPI integration with 3rd party tools ,

change requests, dev workflows

ElasticityAgile scale up, scale down, relocation

of services


self-service

AccountabilityMeter usage, quota, compliance and

governance

Data

Infrastructure

Full CloneEmpty Snap clones

OROR

Physical, Virtual, or Engineered Systems(Hybrid Cloud)

On Premise & On Oracle Cloud

References

• Enterprise Manager Page on O.com• Database as a Service Page on OTN• Snap Clone Page on OTN• Hybrid Cloud Management Page on OTN• Cloud Administration Guide (Documentation)

• MOS Note: EM12c Recommended Plug-Ins and Patches for DBaaS(1549855.1)


• Enterprise Manager Page on O.com• Database as a Service Page on OTN• Snap Clone Page on OTN• Hybrid Cloud Management Page on OTN• Cloud Administration Guide (Documentation)

• MOS Note: EM12c Recommended Plug-Ins and Patches for DBaaS(1549855.1)

Join the ConversationLearn more at : oracle.com/enterprisemanager


latest innovations in database as a service enabled by oracle … › technetwork › oem ›...

Documents