oracle database 12c · pdf filefast provisioning and cloning secure and highly available no...
TRANSCRIPT
![Page 1: Oracle Database 12c · PDF fileFast provisioning and cloning Secure and highly available No application changes Manage many as one Greater resource utilization ... Oracle Database](https://reader031.vdocuments.us/reader031/viewer/2022021509/5a7ec8517f8b9a66798ecac1/html5/thumbnails/1.jpg)
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 1
Oracle Database 12c
In association with
![Page 2: Oracle Database 12c · PDF fileFast provisioning and cloning Secure and highly available No application changes Manage many as one Greater resource utilization ... Oracle Database](https://reader031.vdocuments.us/reader031/viewer/2022021509/5a7ec8517f8b9a66798ecac1/html5/thumbnails/2.jpg)
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 2
Private Database Cloud Architectures Using Oracle Database 11g
Dedicated Databases
share servers and OS
Virtual Machines
share servers
Schema Consolidation
share servers, OS and database
Increasing Consolidation
![Page 3: Oracle Database 12c · PDF fileFast provisioning and cloning Secure and highly available No application changes Manage many as one Greater resource utilization ... Oracle Database](https://reader031.vdocuments.us/reader031/viewer/2022021509/5a7ec8517f8b9a66798ecac1/html5/thumbnails/3.jpg)
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 3
Private Database Cloud Architectures Using Oracle Database 12c
Dedicated Databases
share servers and OS
Virtual Machines
share servers
Pluggable Databases
share servers, OS and database
Increasing Consolidation
![Page 4: Oracle Database 12c · PDF fileFast provisioning and cloning Secure and highly available No application changes Manage many as one Greater resource utilization ... Oracle Database](https://reader031.vdocuments.us/reader031/viewer/2022021509/5a7ec8517f8b9a66798ecac1/html5/thumbnails/4.jpg)
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 4
Isolation and multitenancy
Fast provisioning and cloning
Secure and highly available
No application changes
Manage many as one
Greater resource utilization
Performant and scalable
Lower IT costs
Consolidating Databases on Clouds Key requirements…
![Page 5: Oracle Database 12c · PDF fileFast provisioning and cloning Secure and highly available No application changes Manage many as one Greater resource utilization ... Oracle Database](https://reader031.vdocuments.us/reader031/viewer/2022021509/5a7ec8517f8b9a66798ecac1/html5/thumbnails/5.jpg)
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 5
David
Storage Manager
Mike
IT Manager
James
CIO
Laura
Dev. Manager
Amy
Systems Manager
The Data Center Team
Mark
Security Manager
Justin
DBA
![Page 6: Oracle Database 12c · PDF fileFast provisioning and cloning Secure and highly available No application changes Manage many as one Greater resource utilization ... Oracle Database](https://reader031.vdocuments.us/reader031/viewer/2022021509/5a7ec8517f8b9a66798ecac1/html5/thumbnails/6.jpg)
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 6
Consolidating Databases
v
Challenge #1
![Page 7: Oracle Database 12c · PDF fileFast provisioning and cloning Secure and highly available No application changes Manage many as one Greater resource utilization ... Oracle Database](https://reader031.vdocuments.us/reader031/viewer/2022021509/5a7ec8517f8b9a66798ecac1/html5/thumbnails/7.jpg)
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 7
Database Consolidation Challenges
Reduce the
number of separate
databases
Reduce IT costs by
consolidating more
servers
Keep database
applications isolated
and unchanged
![Page 8: Oracle Database 12c · PDF fileFast provisioning and cloning Secure and highly available No application changes Manage many as one Greater resource utilization ... Oracle Database](https://reader031.vdocuments.us/reader031/viewer/2022021509/5a7ec8517f8b9a66798ecac1/html5/thumbnails/8.jpg)
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 8
Oracle Database Architecture Requires memory, processes and database files
System Resources
![Page 9: Oracle Database 12c · PDF fileFast provisioning and cloning Secure and highly available No application changes Manage many as one Greater resource utilization ... Oracle Database](https://reader031.vdocuments.us/reader031/viewer/2022021509/5a7ec8517f8b9a66798ecac1/html5/thumbnails/9.jpg)
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 9
New Multitenant Architecture Memory and processes required at container level only
System Resources
![Page 10: Oracle Database 12c · PDF fileFast provisioning and cloning Secure and highly available No application changes Manage many as one Greater resource utilization ... Oracle Database](https://reader031.vdocuments.us/reader031/viewer/2022021509/5a7ec8517f8b9a66798ecac1/html5/thumbnails/10.jpg)
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 10
New Multitenant Architecture Memory and processes required at container level only
System Resources
![Page 11: Oracle Database 12c · PDF fileFast provisioning and cloning Secure and highly available No application changes Manage many as one Greater resource utilization ... Oracle Database](https://reader031.vdocuments.us/reader031/viewer/2022021509/5a7ec8517f8b9a66798ecac1/html5/thumbnails/11.jpg)
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 11
Consolidating Databases Step1: Upgrade databases in-place
Upgrade in Place
![Page 12: Oracle Database 12c · PDF fileFast provisioning and cloning Secure and highly available No application changes Manage many as one Greater resource utilization ... Oracle Database](https://reader031.vdocuments.us/reader031/viewer/2022021509/5a7ec8517f8b9a66798ecac1/html5/thumbnails/12.jpg)
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 12
Consolidating Databases Step2: Plug-in upgraded databases
![Page 13: Oracle Database 12c · PDF fileFast provisioning and cloning Secure and highly available No application changes Manage many as one Greater resource utilization ... Oracle Database](https://reader031.vdocuments.us/reader031/viewer/2022021509/5a7ec8517f8b9a66798ecac1/html5/thumbnails/13.jpg)
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 13
v
Demo
Consolidating
Databases
![Page 14: Oracle Database 12c · PDF fileFast provisioning and cloning Secure and highly available No application changes Manage many as one Greater resource utilization ... Oracle Database](https://reader031.vdocuments.us/reader031/viewer/2022021509/5a7ec8517f8b9a66798ecac1/html5/thumbnails/14.jpg)
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 14
OLTP benchmark comparison
Only 3GB of memory vs. 20GB memory used for 50 databases
Pluggable databases scaled to over 250 while separate database instances maxed at 50
Pluggable vs Separate Databases Highly Efficient: 6x Less H/W Resource, 5x more Scalable
![Page 15: Oracle Database 12c · PDF fileFast provisioning and cloning Secure and highly available No application changes Manage many as one Greater resource utilization ... Oracle Database](https://reader031.vdocuments.us/reader031/viewer/2022021509/5a7ec8517f8b9a66798ecac1/html5/thumbnails/15.jpg)
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 15
Managing Shared Resources Resource management for consolidated databases
High Priority
Medium Priority
Low Priority
![Page 16: Oracle Database 12c · PDF fileFast provisioning and cloning Secure and highly available No application changes Manage many as one Greater resource utilization ... Oracle Database](https://reader031.vdocuments.us/reader031/viewer/2022021509/5a7ec8517f8b9a66798ecac1/html5/thumbnails/16.jpg)
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 16
Simplified Patching Apply changes once, all pluggable databases updated
Upgrade
in-place
![Page 17: Oracle Database 12c · PDF fileFast provisioning and cloning Secure and highly available No application changes Manage many as one Greater resource utilization ... Oracle Database](https://reader031.vdocuments.us/reader031/viewer/2022021509/5a7ec8517f8b9a66798ecac1/html5/thumbnails/17.jpg)
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 17
Simplified Upgrades Flexible choice when patching & upgrading databases
![Page 18: Oracle Database 12c · PDF fileFast provisioning and cloning Secure and highly available No application changes Manage many as one Greater resource utilization ... Oracle Database](https://reader031.vdocuments.us/reader031/viewer/2022021509/5a7ec8517f8b9a66798ecac1/html5/thumbnails/18.jpg)
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 18
Manage Many Databases as One Backup databases as one, recover at pluggable database Level
One Backup
Point-in-time recovery
at pluggable database level
![Page 19: Oracle Database 12c · PDF fileFast provisioning and cloning Secure and highly available No application changes Manage many as one Greater resource utilization ... Oracle Database](https://reader031.vdocuments.us/reader031/viewer/2022021509/5a7ec8517f8b9a66798ecac1/html5/thumbnails/19.jpg)
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 19
Manage Many Databases as One One standby database covers all pluggable databases
![Page 20: Oracle Database 12c · PDF fileFast provisioning and cloning Secure and highly available No application changes Manage many as one Greater resource utilization ... Oracle Database](https://reader031.vdocuments.us/reader031/viewer/2022021509/5a7ec8517f8b9a66798ecac1/html5/thumbnails/20.jpg)
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 21
Creating Databases for Test and Development Fast, flexible copy and snapshot of pluggable databases
![Page 21: Oracle Database 12c · PDF fileFast provisioning and cloning Secure and highly available No application changes Manage many as one Greater resource utilization ... Oracle Database](https://reader031.vdocuments.us/reader031/viewer/2022021509/5a7ec8517f8b9a66798ecac1/html5/thumbnails/21.jpg)
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 22
Multitenant Architecture for SaaS Each customer’s data in private pluggable database
![Page 22: Oracle Database 12c · PDF fileFast provisioning and cloning Secure and highly available No application changes Manage many as one Greater resource utilization ... Oracle Database](https://reader031.vdocuments.us/reader031/viewer/2022021509/5a7ec8517f8b9a66798ecac1/html5/thumbnails/22.jpg)
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 23
Isolation and multitenancy
Fast provisioning and cloning
Secure and highly available
No application changes
Manage many as one
Greater resource utilization
Performant and scalable
Lower IT costs
New Multitenant Architecture Ideal for consolidating databases on Clouds
![Page 23: Oracle Database 12c · PDF fileFast provisioning and cloning Secure and highly available No application changes Manage many as one Greater resource utilization ... Oracle Database](https://reader031.vdocuments.us/reader031/viewer/2022021509/5a7ec8517f8b9a66798ecac1/html5/thumbnails/23.jpg)
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 25
Lowering Storage Costs
v
Challenge #2
![Page 24: Oracle Database 12c · PDF fileFast provisioning and cloning Secure and highly available No application changes Manage many as one Greater resource utilization ... Oracle Database](https://reader031.vdocuments.us/reader031/viewer/2022021509/5a7ec8517f8b9a66798ecac1/html5/thumbnails/24.jpg)
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 26
Managing Storage Challenges
Compress data,
without impacting
performance
Manage more data
without incurring
additional cost
Tier and
compress data
based on usage
![Page 25: Oracle Database 12c · PDF fileFast provisioning and cloning Secure and highly available No application changes Manage many as one Greater resource utilization ... Oracle Database](https://reader031.vdocuments.us/reader031/viewer/2022021509/5a7ec8517f8b9a66798ecac1/html5/thumbnails/25.jpg)
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 28
Automatic Data Optimization Add compression and tiering policies to tables
Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Confidential – Oracle Restricted 28
Oldest Data Most Recent Data
Po licy 1
Po licy 2
Compress Partitions with
Row Compression
if they haven’t been modified in
30 days
Compress Partitions with
Hybrid Columnar Compression
if they haven’t been modified in
180 days
![Page 26: Oracle Database 12c · PDF fileFast provisioning and cloning Secure and highly available No application changes Manage many as one Greater resource utilization ... Oracle Database](https://reader031.vdocuments.us/reader031/viewer/2022021509/5a7ec8517f8b9a66798ecac1/html5/thumbnails/26.jpg)
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 29
Automatic Data Optimization A heat map tracks the activity of segments and blocks
Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Confidential – Oracle Restricted 29
Oldest Data Most Recent Data
Po licy 1
Po licy 2
![Page 27: Oracle Database 12c · PDF fileFast provisioning and cloning Secure and highly available No application changes Manage many as one Greater resource utilization ... Oracle Database](https://reader031.vdocuments.us/reader031/viewer/2022021509/5a7ec8517f8b9a66798ecac1/html5/thumbnails/27.jpg)
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 30
Automatic Data Optimization Policies are automatically applied to tables
Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Confidential – Oracle Restricted 30
Oldest Data Most Recent Data
Po licy 1
Po licy 2
![Page 28: Oracle Database 12c · PDF fileFast provisioning and cloning Secure and highly available No application changes Manage many as one Greater resource utilization ... Oracle Database](https://reader031.vdocuments.us/reader031/viewer/2022021509/5a7ec8517f8b9a66798ecac1/html5/thumbnails/28.jpg)
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 31
Automatic Data Optimization Policies are automatically applied to tables
Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Confidential – Oracle Restricted 31
Oldest Data Most Recent Data
Po licy 1
Po licy 2
![Page 29: Oracle Database 12c · PDF fileFast provisioning and cloning Secure and highly available No application changes Manage many as one Greater resource utilization ... Oracle Database](https://reader031.vdocuments.us/reader031/viewer/2022021509/5a7ec8517f8b9a66798ecac1/html5/thumbnails/29.jpg)
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 32
Automatic Data Optimization Policies are automatically applied to tables
Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Confidential – Oracle Restricted 32
Oldest Data Most Recent Data
Po licy 1
Po licy 2
![Page 30: Oracle Database 12c · PDF fileFast provisioning and cloning Secure and highly available No application changes Manage many as one Greater resource utilization ... Oracle Database](https://reader031.vdocuments.us/reader031/viewer/2022021509/5a7ec8517f8b9a66798ecac1/html5/thumbnails/30.jpg)
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 33
Automatic Data Optimization Reduce storage footprint, read compressed data faster
Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Confidential – Oracle Restricted 33
Oldest Data Most Recent Data
Po licy 1
Po licy 2
![Page 31: Oracle Database 12c · PDF fileFast provisioning and cloning Secure and highly available No application changes Manage many as one Greater resource utilization ... Oracle Database](https://reader031.vdocuments.us/reader031/viewer/2022021509/5a7ec8517f8b9a66798ecac1/html5/thumbnails/31.jpg)
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 35
v
Demo
Automatic Data
Optimization
![Page 32: Oracle Database 12c · PDF fileFast provisioning and cloning Secure and highly available No application changes Manage many as one Greater resource utilization ... Oracle Database](https://reader031.vdocuments.us/reader031/viewer/2022021509/5a7ec8517f8b9a66798ecac1/html5/thumbnails/32.jpg)
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 36
Oracle Database Security Solutions
Defense-in-Depth for Maximum Security
Activity Monitoring
Database Firewall
Auditing and Reporting
DETECTIVE
Redaction and Masking
Multi-Factor
Authorization
Encryption
PREVENTIVE ADMINISTRATIVE
Data Discovery
and Classification
Vulnerability Scanning
Database Lifecycle
Management
![Page 33: Oracle Database 12c · PDF fileFast provisioning and cloning Secure and highly available No application changes Manage many as one Greater resource utilization ... Oracle Database](https://reader031.vdocuments.us/reader031/viewer/2022021509/5a7ec8517f8b9a66798ecac1/html5/thumbnails/33.jpg)
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 37
Redacting Data
v
Challenge #3
![Page 34: Oracle Database 12c · PDF fileFast provisioning and cloning Secure and highly available No application changes Manage many as one Greater resource utilization ... Oracle Database](https://reader031.vdocuments.us/reader031/viewer/2022021509/5a7ec8517f8b9a66798ecac1/html5/thumbnails/34.jpg)
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 38
Redacting Data Challenges
Redact data in
applications,
queries and reports
Secure sensitive
personal
information
Avoid changing
applications,
queries and reports
![Page 35: Oracle Database 12c · PDF fileFast provisioning and cloning Secure and highly available No application changes Manage many as one Greater resource utilization ... Oracle Database](https://reader031.vdocuments.us/reader031/viewer/2022021509/5a7ec8517f8b9a66798ecac1/html5/thumbnails/35.jpg)
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 39
Soc. Sec. # 115-69-3428
DOB 11/06/71
PIN 5623
Policy enforced redaction of sensitive data
Redacting Sensitive Data Mask Application Data Dynamically
Call Center
Operator
Payroll
Processing
![Page 36: Oracle Database 12c · PDF fileFast provisioning and cloning Secure and highly available No application changes Manage many as one Greater resource utilization ... Oracle Database](https://reader031.vdocuments.us/reader031/viewer/2022021509/5a7ec8517f8b9a66798ecac1/html5/thumbnails/36.jpg)
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 40
v
Demo
Redacting Data
![Page 37: Oracle Database 12c · PDF fileFast provisioning and cloning Secure and highly available No application changes Manage many as one Greater resource utilization ... Oracle Database](https://reader031.vdocuments.us/reader031/viewer/2022021509/5a7ec8517f8b9a66798ecac1/html5/thumbnails/37.jpg)
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 41
Security & Compliance
Big Data
Consolidation
Data Optimization
Application Development
High Availability
In-Memory
Performance & Scalability
Data Warehousing
Plug into the Cloud
![Page 38: Oracle Database 12c · PDF fileFast provisioning and cloning Secure and highly available No application changes Manage many as one Greater resource utilization ... Oracle Database](https://reader031.vdocuments.us/reader031/viewer/2022021509/5a7ec8517f8b9a66798ecac1/html5/thumbnails/38.jpg)
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 42
The Customer’s View
v
Oracle Database 12c
![Page 39: Oracle Database 12c · PDF fileFast provisioning and cloning Secure and highly available No application changes Manage many as one Greater resource utilization ... Oracle Database](https://reader031.vdocuments.us/reader031/viewer/2022021509/5a7ec8517f8b9a66798ecac1/html5/thumbnails/39.jpg)
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 44
Oracle Database 12c What partners are saying…
“Our enterprise customers will appreciate the benefits of less complexity and maintenance with
Oracle Database 12c, which features a multitenant architecture enabling delivery of pluggable
databases. Consolidation of databases in the powerful combination of Oracle Database 12c running
on Fujitsu’s robust server and storage platform will benefit customers.“ Akira Ohshima, Fujitsu
“With Oracle Database 12c, we can now copy an entire database from one instance to another
using full transportable export/import. This minimizes the downtime when migrating clients’
databases." Julian Dontcheff, Accenture
“Oracle Database innovation continues on Oracle Database 12c by optimizing the use of Intel®
Xeon® Processors for the compute and storage nodes. The performance and energy efficiency of
Intel Xeon Processors further enables Oracle to drive this innovative approach to IT, creating a
better way to scale critical information processing needs in any company.” Pauline Nist, Intel
![Page 40: Oracle Database 12c · PDF fileFast provisioning and cloning Secure and highly available No application changes Manage many as one Greater resource utilization ... Oracle Database](https://reader031.vdocuments.us/reader031/viewer/2022021509/5a7ec8517f8b9a66798ecac1/html5/thumbnails/40.jpg)
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 45
Foundation of Private and Public Clouds
![Page 41: Oracle Database 12c · PDF fileFast provisioning and cloning Secure and highly available No application changes Manage many as one Greater resource utilization ... Oracle Database](https://reader031.vdocuments.us/reader031/viewer/2022021509/5a7ec8517f8b9a66798ecac1/html5/thumbnails/41.jpg)
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 46
![Page 42: Oracle Database 12c · PDF fileFast provisioning and cloning Secure and highly available No application changes Manage many as one Greater resource utilization ... Oracle Database](https://reader031.vdocuments.us/reader031/viewer/2022021509/5a7ec8517f8b9a66798ecac1/html5/thumbnails/42.jpg)
Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 47