1 / 39

CON1479 Maximize Availability with the Latest Generation of Database Technology

brooklyn
Télécharger la présentation

CON1479 Maximize Availability with the Latest Generation of Database Technology

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. 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. Release timing for Oracle Database 12c is planned for Calendar Year 2013.

  2. CON1479 Maximize Availability with the Latest Generation of Database Technology Wei Hu 胡維 Vice President High Availability Technologies

  3. Oracle Database 12c Extreme Availability • Oracle Database 12c introduces significant new HA capabilities that • Drastically reduces planned and unplanned downtime • Eliminate compromises between HA and Performance • Tremendously increase operational productivity • These take Availability to unprecedented new levels • Next-generation Maximum Availability Architecture (MAA) • Optimized for Oracle

  4. Active Replica • Active Data Guard • Data Protection, DR • Query Offload • GoldenGate • Active-active • Heterogeneous RMAN, Oracle Secure Backup • Backup to tape / cloud Oracle Maximum Availability Architecture Production Site • Application Continuity • Application HA • Global Data Services • Service Failover / Load Balancing • RAC • Scalability • Server HA • Flashback • Human error correction • Edition-based Redefinition, Online Redefinition, Data Guard, GoldenGate • Minimal downtime maintenance, upgrades, migrations

  5. Oracle Database 12cHigh Availability Key New Features • Application Continuity • Global Data Services • Data Guard Enhancements • RMAN Enhancements • Flex ASM • Other HA Enhancements • GoldenGate Update

  6. In-Flight Work: Dealing With Outages Current Situation • Database outages can cause in-flight work to be lost, leaving users and applications in-doubt • Often leads to • User pains • Duplicate submissions • Rebooting mid-tiers • Developer pains End User Application Servers Database Servers

  7. Solving Application Development Pains New in Oracle Database 12c

  8. Transaction Guard Preserve and Retrieve COMMIT Outcome • API providing known commit outcome for every transaction • Without Transaction Guard, transaction retry can cause logical corruption • With Transaction Guard, applications can handle errors correctly • Supports JDBC-thin, OCI, OCCI, ODP.net • Excludes XA in 12.1 • Used transparently by Application Continuity End User Application Servers Database Servers

  9. Application Continuity Masks Unplanned/Planned Outages • Replays in-flight work on recoverable errors • Masks many hardware, software, network, storage errors and outages when successful • Improves end-user experience and productivity without requiring custom app development End User Application Servers Database Servers Transaction Replayed

  10. Oracle Database 12cHigh Availability Key New Features • Application Continuity • Global Data Services • Data Guard Enhancements • RMAN Enhancements • Flex ASM • Other HA Enhancements • GoldenGate Update

  11. Databases in Replicated EnvironmentsChallenges • Cannot efficiently use all the databases • No automated load balancing and failover among the databases Primary Active Standby Active Standby GoldenGate

  12. Global Data Services Load Balancing and Service Failover for Replicated Databases • Extends RAC-style service failover,load balancing (within and across data centers), and management capabilities to a set of replicated databases • Accounts for network latency, replication lag, and service placement policies • Achieves higher availability, improved manageability, and best performance Global Data Services

  13. Global Data Services Active Data Guard Example • Reporting client routed to ‘best’ database • Based on location, response time, data, acceptable data lag • Reports will automatically run on least loaded server • Reporting client failover • If preferred database not available, will route to another database in same region or a remote database • Global service migration • Automatically migrates services based on failover/switchover - if primary database is down, start service on the new primary Reporting Service Call Center Service Active Data Guard

  14. Global Data Services GoldenGate Example • Call Center Client connections and requests transparently routed to the closest / best database • Runtime load balancing metrics give client real-time information on which database to issue next request • If a database fails, its global services restarted on another replica Call Center Service GoldenGate

  15. Oracle Database 12cHigh Availability Key New Features • Application Continuity • Global Data Services • Data Guard Enhancements • RMAN Enhancements • Flex ASM • Other HA Enhancements • GoldenGate Update

  16. Zero Data Loss Challenge Synchronous Communication Leads To Performance Trade-Offs Network Ack Commit Ack The longer the distance, the larger the performance impact Commit Network Send Primary Standby

  17. Data Guard Async – Today Some Data Loss Exposure Upon Disaster Standby ASYNC Primary

  18. Active Data Guard Far Sync Zero Data Loss For Async Deployments • Far Sync: light-weight Oracle instance: control file, standby redo logs, archived redo logs, no data files • Receives redo synchronously from primary, forwards redo asynchronously in real-time to standby • Upon Failover: Async standby transparently obtains last committed redo from Far Sync and applies: zero data loss failover • Second Far Sync Instance can be pre-configured to transmit in reverse direction after failover/switchover • Terminal standbys required to be Active Data Guard Standbys

  19. Active Data Guard Far Sync Operational Flow Standby Primary SYNC ASYNC Far Sync Instance

  20. Active Data Guard Far Sync Operational Flow (contd.) Zero Data Loss Standby Primary SYNC ASYNC Far Sync Instance No Compromise Between Availability and Performance!

  21. Active Data Guard Far Sync Benefits • Best data protection, lowest performance impact • Low cost and complexity • Best way to implement a near DR + Far DR model • Relevant to existing Data Guard ASYNC configurations • Data Guard Failover? No Problem! Just do it – No Data Loss!

  22. Oracle Database 12cHigh Availability Key New Features • Application Continuity • Global Data Services • Data Guard Enhancements • RMAN Enhancements • Flex ASM • Other HA Enhancements • GoldenGate Update

  23. Fine-grained Table Recovery From Backup • Simple RECOVER TABLEcommand to recover one or more tables (most recent or older version) from an RMAN backup • Eliminates time and complexity associated with manual restore, recover & export • Enables fine-grained point-in-time recovery of individual tables instead of the contents of the entire tablespace RMAN Backups

  24. Pluggable Database Backup & Restore Fine-Grained Backup & Recovery to Support Consolidation • Backup and recover specific pluggable databases with new PLUGGABLE DATABASE keywords: RMAN> BACKUP PLUGGABLE DATABASE <PDB1>, <PDB2>; • Familiar BACKUP DATABASE command backs up CDB, including all PDBs • PDB Complete Recovery • RESTORE PLUGGABLE DATABASE <PDB>; • RECOVER PLUGGABLE DATABASE <PDB>; • PDB Point-in-Time Recovery • RMAN> RUN { • SET UNTIL TIME 'SYSDATE-3'; • RESTORE PLUGGABLE DATABASE <PDB>; • RECOVER PLUGGABLE DATABASE <PDB>; • ALTER PLUGGABLE DATABASE <PDB> OPEN RESETLOGS; } • Familiar RECOVER DATABASE command recovers CDB, including all PDBs

  25. Oracle Database 12cHigh Availability Key New Features • Application Continuity • Global Data Services • Data Guard Enhancements • RMAN Enhancements • Flex ASM • Other HA Enhancements • GoldenGate Update

  26. Automatic Storage Management (ASM) Overview Current State RAC Cluster Node1 Node2 Node3 Node4 Node5 Database Instance Database Instance DBA DBA DBB DBB DBB DBC One to One Mapping of ASM Instances to Servers ASM Instance ASM Instance ASM ASM ASM ASM ASM Shared Disk Groups Wide File Striping ASM Cluster Pool of Storage ASM Disk Disk Group A Disk Group B

  27. Flex ASM: Eliminate 1:1 Server Mapping New: ASM Storage Consolidation in Oracle Database 12c RAC Cluster Node1 Node2 Node3 Node4 Node5 Database Instance DBA DBA DBB DBB DBB DBC Databases share ASM instances ASM Instance ASM Instance ASM ASM ASM Node2 runs as ASM Client to Node3 Node1 runs as ASM Client to Node4 Node1 runs as ASM Client to Node2 Node5 runs as ASM Client to Node4 Shared Disk Groups Wide File Striping ASM Cluster Pool of Storage ASM Disk Disk Group A Disk Group B

  28. Flex ASM: Supporting Oracle Database 11g Previous Database Versions Will Host Local ASM Instance RAC Cluster Node1 Node2 Node3 Node4 Node5 Database Instance DBA DBA DBB DBB DBB • 11.2DB DBC 11.2DB Databases share ASM instances ASM Instance ASM ASM ASM ASM ASM Shared Disk Groups Wide File Striping ASM Cluster Pool of Storage ASM Disk Disk Group A Disk Group B

  29. Oracle Database 12cHigh Availability Key New Features • Application Continuity • Global Data Services • Data Guard Enhancements • RMAN Enhancements • Flex ASM • Other HA Enhancements • GoldenGate Update

  30. Other HA Enhancements

  31. Oracle Database 12cHigh Availability Key New Features • Application Continuity • Global Data Services • Data Guard Enhancements • RMAN Enhancements • Flex ASM • Other HA Enhancements • GoldenGate Update

  32. Oracle GoldenGate 12c* Low-Impact, Real-Time Data Integration & Transactional Replication New DB/HW/OS/APP Zero Downtime Upgrade & Migration Fully Active Distributed DB Active-Active High Availability Exact Copy of Primary Oracle Database12c * Disaster Recovery for Non-Oracle Databases Log-based Changed Data Reporting Database Query & Report Offloading Data Warehouse Oracle & Non-OracleDatabase(s) Real-time BI, Operational Reporting, MDM Data Integrator Global Data Centers ODS Data Synchronization within the Enterprise Message Bus Message Bus Event Driven Architecture, SOA *: GoldenGate 12c for Oracle Database 12c will be available in CY2013

  33. GoldenGate Zero Downtime Migration/Upgrade Seamless Migration and Upgrades to Oracle Database 12c* Switchover • Consolidate/migrate/ maintain systems without downtime • Minimize risk with failback option • Validate data before switchover • Use Active-Active replication for phased user migration Oracle Database 12c Compare & Verify using Oracle GoldenGate Veridata Real-Time Replication For Migrations Optional Failback Data Flow Nn-OracleERP Oracle 10.2CRM Oracle 11.2DW *: GoldenGate 12c for Oracle Database 12c will be available in CY2013 Non-Oracle ERP

  34. Oracle GoldenGate for Active-Active Databases Increase ROI on Existing Servers & Synchronize Data • Utilize secondary systems for transactions • Enable continuous availability during unplanned & planned outages • Synchronize data across global data centers • Use intelligent conflict detection & resolution Oracle Database 12c Heterogeneous Bi-Directional Real-Time Replication Oracle 10.2App2 Oracle 11.2App3 *: GoldenGate 12c for Oracle Database 12c will be available in CY2013 Non-Oracle App

  35. Oracle Database 12c Extreme Availability: Summary • Oracle Database 12c offers a tremendously sophisticated set of high availability (HA) capabilities • These capabilities • Further reduce downtime • Significantly improve productivity • Eliminate traditional compromises

  36. The preceding 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. Release timing for Oracle Database 12c is planned for Calendar Year 2013.

  37. Graphic Section Divider

More Related