Download as PDF, PPTX
Uploaded byYudi Herdiana
Oracle Database 12c Multitenant for Consolidation
The document details Oracle Database 12c's multitenant architecture, specifically how it simplifies database consolidation and enables database as a service. It discusses efficiencies in resource utilization, high availability, and the upgrade process, alongside features such as automatic storage management and flashback technology for data recovery. Additionally, it covers Oracle Goldengate for low-impact data integration and transactional replication across different database platforms.
Oracle Database 12c Multitenant for Consolidation
- 1. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.1 Oracle Database 12c Multitenant for Consolidation Rony Ihsan Senior Technical Advisor
- 2. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.2 Performance Management Identity & Access Mgmt Middleware Platform Data Integration Operating Systems Monitoring & Management Virtualisation Content & Collaboration Business Intelligence Cloud Continuous Innovation Acquisitions + Development Complete – Open – Integrated – Best-of-Breed
- 3. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.3 Security & Compliance Big Data & Data Warehousing Consolidation Database as a Service Application Development High Availability In-Memory Performance & Scalability Data Optimization Released on June 25th 2013
- 4. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.4 Database Consolidation on Clouds Traditional consolidation methods ConsolidationDensity Schema Consolidation Share Servers, OS & Database Virtual Machines Share Servers Clustered Databases Share Servers & OS
- 5. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.5 ConsolidationDensity Oracle Multitenant Simplifies consolidation, enables Database as a Service Share Servers, OS & Database Pluggable DatabasesClustered Databases Share Servers & OS Virtual Machines Share Servers
- 6. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.6 Oracle Database Architecture Requires memory, processes and database files System Resources
- 7. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.7 New Multitenant Architecture Memory and processes required at container level only System Resources
- 8. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.8 Oracle Multitenant for Consolidation More efficient utilization of system resources System Resources
- 9. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.9 0 0,5 1 1,5 2 2,5 3 CRM HCM ERP BI GB Pluggable Database MEMORY 0 0,5 1 1,5 2 2,5 3 CRM HCM ERP BI DW GB Pluggable Database MEMORY Multitenant Scalability Only small increments in memory as additional PDBs are added 0 0,5 1 1,5 2 2,5 3 CRM HCM ERP GB Pluggable Database MEMORY
- 10. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.10 Multitenant Architecture Multitenant architecture can currently support up to 252 PDBs A PDB feels and operates identically to a non-CDB You cannot tell, from the viewpoint of a connected client, if you’re using a PDB or a non-CDB Database Link
- 11. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.11 Oracle Multitenant for Test and Development Fast, flexible copy and snapshot of pluggable databases
- 12. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.12 Multitenant for Simplified Patching Apply changes once, all pluggable databases updated Upgrade in-place
- 13. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.13 Multitenant for Upgrades Flexible choice when patching & upgrading databases
- 14. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.14 Upgrading to Multitenant Step 1: Upgrade databases in-place Upgrade in Place
- 15. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.15 Upgrading to Multitenant Step 2: Plug-in upgraded databases
- 16. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.16 Upgrading to Multitenant No application changes required. Step 3. Change applications to work with MultitenantStep 3. Change applications to work with Multitenant
- 17. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.17 Upgrade to Multitenant from Oracle Database 11g Upgrade 11g database and plug in ① Upgrade 11.2 database to 12.1 in place ② Place the non-CDB into read-only mode ③ Connect to non-CDB and generate a description file (manifest) ④ Shutdown the non-CDB ⑤ Plug in non-CDB to CDB ⑥ Post-plug script to remove redundant metadata for the Oracle system
- 18. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.18 High Avaibility
- 19. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.19 • Storage failure • Data recovery • Backups • Instance failure • Server failure • RAC rolling maintenance • Performance scale-out • Consolidation • Continuous point-in-time recovery • Granular repair of logical corruptions • Transaction • Table • Database • Database failure • System failure • Site failure • Automatic database failover • Lost-write protection • Database rolling upgrade • Offload read-only workload and backups • Some migrations • Online platform and application upgrades • Bi-directional and multi-master replication • Distribute read-only & read-write workload • An alternative to physical replication for site protection • Flexible planned maintenance and heterogeneous migrations • Zero downtime upgrades and migrations Five Steps to Maximize Availability ASM, RMAN Oracle RAC Flashback Active Data Guard Oracle GoldenGate
- 20. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.20
- 21. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.21 High Avaibility
- 22. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.22 Real Application Cluster (RAC)
- 23. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.23 Standard Oracle Architecture Instance Database
- 24. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.24 Shared Nothing Architecture Database Instance 1 Database Instance 2 Database Instance 3 Table A Table B Table C
- 25. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.25 Shared Disk Architecture Table A Table B Table C Database Instance 1 Database Instance 2 Database Instance 3
- 26. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.26 RAC Architecure Database Instance 1 Database Instance 2 Database Instance 3 Table A Table B Table C HighSpeedInterconnect Cache Fusion • Works with ALL applications • High availability and scalability • Runs on low cost, commodity hardware
- 27. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.27
- 28. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.28 Oracle Real Application Clusters (RAC) Load Balancing Failover
- 29. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.29 High Avaibility ASM
- 30. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.30 Automatic Storage Management ( A S M)
- 31. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.31 Data Mirroring with ASM ASM mirrors data across low cost modular storage arrays – Automatically remirrors when disk or array fails ASM is free Next Release Sneak Preview – Automatically repair corrupt blocks from mirror copy – Temporarily freeze I/O to unresponsive storage and replay writes when it returns Designed to Tolerate Failure of Low Cost Storage Database Storage
- 32. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.32 Automatic Storage Management Low Cost – Eliminates need for volume manager and file systems – Works well with inexpensive, modular storage – Gives better storage utilization – Easy – up to 50% less DBA/Sys Admin work Fault tolerant Raw disk performance Capacity on demand Automatic I/O load balancing Introduce New Features 11g R2 : ASM Cluster File System (ACFS)
- 33. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.33 ASM Lowers Data Management Costs 0 1 2 3 4 5 6 7 8 NbrSteps Install Add Storage Remove Storage Migrate Storage Tune I/O Manage Space ASM Traditional 7 7 6 8 6 6 5 2 2 4 0 0 “Best way to save costs is to remove complexity”
- 34. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.34 High Avaibility Flashback
- 35. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.35 Flashback Technology
- 36. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.36 Flashback Correct errors at any level Database – Flashback Database - restore database to time Table – Flashback Table - restore contents of tables to time – Flashback Drop - restore dropped table Row – Flashback Query - restore individual rows Order Database Customer
- 37. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.37 Investigate Errors using Time Navigation Flashback Query – Query all data at point in time Tx 1 Tx 2 Tx 3 select * from Emp AS OF ‘2:00 P.M.’ where … select * from Emp VERSIONS BETWEEN ‘2:00 PM’ and ‘3:00 PM’ where … select * from FLASHBACK_TRANSACTION_QUERY where xid = ‘000200030000002D’; Flashback Transaction Query – See all changes made by a transaction Flashback Version Query – See all versions of a row between times – See transactions that changed the row
- 38. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.38 High Avaibility RMAN
- 39. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.39 Recover Manager ( RMAN )
- 40. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.40 RMAN - Best Tool for Repairing Corruptions RMAN’s deep integration with the database engine makes it the best tool for DB backup & recovery – Smart Sophisticated backup and recovery strategies – Fast Optimized backup to disk for fastest recovery No extra redo during backup Block level incremental backup – Reliable Block contents validated during backup – Easy Simple management with Enterprise Manager – Supports over 20 Media Managers Veritas, Legato, Tivoli, HP, Oracle Secure Backup, etc. – FREE Tape Libraries Oracle Database RMAN is used at thousands of enterprise sites Enterprise Manager & 3rd Party Tools
- 41. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.41 Automated Disk Backup RMAN fully automates DB backup and recovery to disk – Set and Forget Nightly incremental backup rolls forward recovery area backup – Changed blocks are tracked in production DB Full scan is never needed – Dramatically faster – Blocks validated to prevent corruption of backup copy Use low cost ATA disk array for recovery areaTwo Independent Disk Systems Flash Recovery Area Nightly Apply Validated Incremental Archive To Tape Database Area
- 42. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.42 High Avaibility
- 43. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.43 Data Guard / Active Data Guard ( DRC )
- 44. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.44 What Is Oracle Data Guard? Primary database Standby database Database Database copy Redo transport OracleNet
- 45. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.45 Continuous redo shipment & apply Real-time Queries Oracle Data Guard Low-cost disaster recovery from site failure Standby Database Production Database
- 46. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.46 Traditional Physical Standby Databases Investment in Disaster Recovery only • Applications, backups, reports run on production only
- 47. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.47 With Oracle Active Data Guard Offload production reporting to standby Real-time Queries Standby Database Production Database
- 48. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.48 With Oracle Active Data Guard Offload database backups to standby Standby Database Production Database
- 49. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.49 With Oracle Active Data Guard Test changes Production Database • Switch to ‘snapshot’ standby for testing purposes – Preserves zero data loss, although no real-time query or failover Standby Database • Switch back to standby – Backs out changes, applies production logs
- 50. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.50 Simulation Production Database Physical Standby Database 1 HR.Regions = 5 records HR.Regions = 5 records Insert into HR.Regions Values (80, ‘Solo’) 2 Continuous redo shipping, validation, and apply 3 HR.Regions = 6 records HR.Regions = 6 records Select * from HR.Regions4 Reporting
- 51. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.51 Simulation Production Database Physical Standby Database tProducts = 10 records tProducts = 10 records Daily Activity1 Continuous redo shipping, validation, and Apply
- 52. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.52 Oracle’s Integrated HA Solution Set
- 53. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.53 Oracle GoldenGate (OGG)
- 54. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.54 Oracle GoldenGate 11g Low-Impact Real-Time Data Integration & Transactional Replication New DB/HW/OS/APP Fully Active Distributed DB Reporting Database Data Warehouse Global Data Centers ODS Data Integrator Zero Downtime Upgrade & Migration Query Offloading, Disaster Recovery Data Synchronization across the Enterprise Real-time BI, Operational Reporting, MDM Event Driven Architecture, SOA Highly Available / Disaster Recovery Log-based, changed data Database Message Bus Legacy Message Bus
- 55. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.55 Databases O/S and Platforms Oracle GoldenGate Capture: Oracle DB2 for v 9.7 DB2 for v 10 on z/OS Microsoft SQL Server for 2008 R1, R2 Sybase ASE, 15.5 Teradata Enscribe SQL/MP SQL/MX MySQL Oracle GoldenGate Delivery: All listed above, plus: TimesTen, IBM System I, Netezza & Greenplum ETL product Linux Sun Solaris Windows 2000, 2003, XP, 2008 HP NonStop HP-UX IBM AIX IBM z Series zLinux 55 Oracle GoldenGate 11g Supported Platforms
- 56. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.56 Unidirectional Query Offloading Zero-Downtime Migration Bi-Directional Hot Standby or Active-Active for HA Peer-to-Peer Load Balancing Multi-Master Broadcast Data Distribution Integration/Consolidation Data Warehouse BPM BAM CEP Data Distribution via Messaging Oracle GoldenGate Differentiator: Flexibility
- 57. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.57 How Oracle GoldenGate Works Source Oracle & Non-Oracle Database(s) Target Oracle & Non-Oracle Database(s) Capture: committed transactions are captured (and can be filtered) as they occur by reading the transaction logs.
- 58. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.58 How Oracle GoldenGate Works Source Oracle & Non-Oracle Database(s) Target Oracle & Non-Oracle Database(s) Capture: committed transactions are captured (and can be filtered) as they occur by reading the transaction logs. Trail: stages and queues data for routing.
- 59. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.59 How Oracle GoldenGate Works Source Oracle & Non-Oracle Database(s) Target Oracle & Non-Oracle Database(s) Capture: committed transactions are captured (and can be filtered) as they occur by reading the transaction logs. Trail: stages and queues data for routing. Pump: distributes data for routing to target(s).
- 60. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.60 How Oracle GoldenGate Works Source Oracle & Non-Oracle Database(s) Target Oracle & Non-Oracle Database(s) Capture: committed transactions are captured (and can be filtered) as they occur by reading the transaction logs. Trail: stages and queues data for routing. Pump: distributes data for routing to target(s). Route: data is compressed, encrypted for routing to target(s).
- 61. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.61 How Oracle GoldenGate Works Source Oracle & Non-Oracle Database(s) Target Oracle & Non-Oracle Database(s) Capture: committed transactions are captured (and can be filtered) as they occur by reading the transaction logs. Trail: stages and queues data for routing. Pump: distributes data for routing to target(s). Route: data is compressed, encrypted for routing to target(s). Delivery: applies data with transaction integrity, transforming the data as required.
- 62. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.62 Capture: committed transactions are captured (and can be filtered) as they occur by reading the transaction logs. Trail: stages and queues data for routing. Pump: distributes data for routing to target(s). Route: data is compressed, encrypted for routing to target(s). Delivery: applies data with transaction integrity, transforming the data as required. Source Oracle & Non-Oracle Database(s) Target Oracle & Non-Oracle Database(s)Bi-directional How Oracle GoldenGate Works
- 63. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.63 Has basic configuration, management, monitoring, and alerting. Based on legacy pull infrastructure. Works on legacy GoldenGate instances. Oracle GoldenGate Director Oracle Management Pack for OGG Complete Visibility (1 / 2): Director
- 64. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.64 Has advanced monitoring, alerting (SNMP support), lag graphs, and historical repository. Based on new agent infrastructure, which will be the foundation for all future integration projects. Supports OGG 11.1.1.1.1+ Oracle Management Pack for OGG Complete Visibility (2 / 2): Monitor Oracle GoldenGate Monitor
- 65. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.65 Eliminate unplanned downtime with Active Data Guard & GoldenGate Active Data Guard for disaster recovery and data protection for: – Oracle-to-Oracle Oracle GoldenGate for disaster recovery and data protection for: – Non-Oracle platforms – Active-Active – Cross-OS and Oracle database version requirements
- 66. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.66 Complementary and Used Together Active Data Guard and GoldenGate Data Distribution / Synchronization Oracle GoldenGate Disaster Recovery & Data Protection Oracle Active Data Guard Oracle Active Data Guard Oracle DB Primary Oracle DB Standby Heterogeneous Distributed Subset Replicas Oracle GoldenGate
- 67. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.67 Eliminate Downtime During Upgrades to Oracle 11g R2 • Zero database downtime for upgrades from 8i, 9i, 10g to 11g • Leverage new features of Oracle Database 11g without impacting business operations • Minimize risks with failback option Failback Data Flow Oracle Database 8i/9i/10g Oracle Database 11g Release 2 Application Switchover Compare & Verify With Oracle GoldenGate Veridata
- 68. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.68 Active - Active • Utilize secondary systems for transactions • Enable continuous availability during unplanned and planned outages • Synchronize data across data centers around the globe Source & Target Region A Source & Target Region B ApplicationApplication
- 69. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.69 D E M O Oracle Golden Gate
- 70. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.70 Questions...
- 71. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.71
- 72. Copyright © 2012,Oracle and/or its affiliates. All rights reserved.72