oracle enterprise manager 13c - amazon s3 · oracle enterprise manager 13c cloud management pack...

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

Oracle Enterprise Manager 13c

Cloud Management Pack For Oracle Database

Oracle Confidential – Internal/Restricted/Highly Restricted 1

Mark Overbey Principal Sales Engineer

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

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.

Safe Harbor Statement


Program Agenda

1

2

3

4

Current Challenges

Solution Overview

Demonstration

Solution Details

Summary 5


Developer Request DB Get access to DB

Manager Approval

DBA Request HW and

Storage Configure Cluster

and create DB

System Admin

Setup OS & Network

Storage Admin

Allocate Storage

Current Database Provisioning Process Time Consuming and Inefficient

Copyright © 2014 Oracle Corporation | Oracle Confidential

Evolution of Datacenter Changing Dynamics of Database Management

Internet 2003

END USERS

DBAs

Challenges • Lengthy process, mostly manual • Lack of scalability • Operations are at single target level

Goals •Higher Agility- Self Service, Elasticity •Lower cost- Shared Resources,

Automation •Reduced Risk – High Availability

Challenges • Complex process • Time Consuming • Need mass automation • Downtime management

RAC RAC

END USERS

DBAs

5 Volume Complexity Complexity Volume Complexity Volume

DBAs

Cloud & Consolidation 2014

PORTAL END USERS

Grid, Clustering, Virtualization 2008, ….

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

Database Cloud Service: Build New Apps, Move Existing Apps Power and Flexibility of Oracle Database in the Cloud

Database as a Service • Full-featured, dedicated 11gR2 or 12c instance

• Single node or highly available DBMS cluster

• Customer or Oracle backs up, patches, manages DBMS

• Full SQL*Net, root access, all DBMS tools

• Full portability – on-premises & cloud

• Primary Use Case: Dev/Test, new apps, “lift & shift” existing

apps

Database Schema Service • Each tenant gets dedicated schema(s)

• Fully managed service

• Application development: APEX, SQL Developer, Java, RESTful

Web Services

• Primary Use Case: Dev/Test, new apps, SaaS extensions


EM13c: Automation for Databases

Dedicated Databases

Schemas Pluggable Databases

Clones

Runs on any Infrastructure : Physical, Virtual, Engineered Systems

Service Governance: Access Controls, Compliance, Quota, Showback, etc

Elasticity Service Provisioning incl’ REST APIs

Ongoing Operations and Performance Management

Consolidation Planning and Real App Testing

Database Private Cloud


Service Catalog

Definition

• A collection of standardized services available to selected consumers for on demand, self service provisioning

Benefits

• Establish and enforce effective standardization

• Repeatable and predictable deployment

• Helps identify service costs

• Helps reduce the database management overhead


Intelligent Service Placement The Best Fit Rule

Placement Constraints

Current Population

Current Load

CPU, Memory, and

Storage usage

No. of Service Instances Limits set on zones

and pools

Automatically find suitable target for placement:

• nodes for single instance and RAC databases • databases for schema • container database for PDBs*

* PDBaaS allows for custom placement - selection of the container database


Demo EM13c Database as a Service



Self-Service Portal APIs Comprehensive RESTFUL APIs for Integration and Orchestration List Zones

List Service Templates

List Service Instances List

DBaaS Portal &

API

Deploy

Delete Manage

Request DBs

Request PDBs

Request Schemas

Track request progress

Service Control (start/stop)

Backup

Restore

Snapshot

Get Chargeback info

Delete Service

Extend reservation


EM Solution – Data Clone and Refresh

Supports full and snap (thin) database clones

Technology (and Storage) Agnostic

End-to-End Automation – Prod to Test/Dev

Integrated Masking & Patching (PSUs and Patch

Sets)

Available via Admin Flows and Self Service portal

EMCLI and REST API


Data Cloning Options

Software Solution [Vendor Agnostic]

Hardware Solution [Vendor Specific]

Full Clones Snap (Thin) Clones

NAS SAN

Database Native [Storage Agnostic]

RMAN Restore

RMAN Duplicate

Data Pump

• Leverage your existing investments • Cater to both functional and stress testing needs • Maximize for best performance

Use Snap Clone whenever you need >1 clones!

ACFS


Data Movement

Test Master Database

NAME SSN SALARY

MILLER 112-23-4567 40,000

SMITH 111-22-3333 60,000

Masking & Sub setting

Source Database

010110011 101001010 000111010

NAME SSN SALARY

AGUILAR 203-33-3234 40,000

BENSON 323-22-2943 60,000

Source DB Backups Mask / Subset Test Master Clones

Refresh Refresh


Snap Clone is an on-demand way of creating rapid and space efficient clones of Oracle Databases

EM Snap Clone Benefits

On-Demand Empower the DB consumer to create ad-hoc clones in a controlled manner

Rapid Clone databases in minutes not days/weeks

Space Efficient Significantly reduce the database storage footprint


Demo Snap Cloning



Cloud Management Pack for Oracle Database Summary

Metering, Chargeback

Supports Databases, Schema, and PDBs

Database Cloning Full clones and Snap Clones (thin clones)

Quota and Policy based Management

Self-Service Provisioning

Enforces governance and control

Supports Database, Schema, and PDBs

Comprehensive REST and EMCLI APIs For all self service and admin functions

Enterprise-wide Service Catalog Role based, Single catalog, to enforce standardization across the DB estate


For More Information

Twitter Facebook Blog LinkedIn YouTube

oracle.com/enterprisemanager

oracle.com/cloud

oracle.com/database/solutions/dbaas.html

oracle enterprise manager 13c - amazon s3 · oracle enterprise manager 13c cloud management pack...

Documents