Oracle数据库平台架构介绍.pptx

Oracle数据库平台架构介绍Oracle架构介绍典型案例介绍URS相关数据库架构探讨Copyright ? 1997-2014 NetEase. All Rights Reserved.基本架构Copyright ? 1997-2014 NetEase. All Rights Reserved.基本架构Copyright ? 1997-2014 NetEase. All Rights Reserved.Oracle 最高可用架构产品：--Oracle Data Guard--Oracle GoldenGate and Oracle Streams--Oracle Real Application Clusters --Recovery Manager Oracle Secure Backup --Oracle Automatic Storage Management --LogMiner --Flashback用于解决的问题：--站点故障--服务器故障--存储故障--数据坏块--人为误操作Copyright ? 1997-2014 NetEase. All Rights Reserved.Oracle 最高可用架构Copyright ? 1997-2014 NetEase. All Rights Reserved.Oracle Real Application Clusters 常用于解决服务器单点故障Copyright ? 1997-2014 NetEase. All Rights Reserved.Oracle Real Application Clusters Copyright ? 1997-2014 NetEase. All Rights Reserved.Oracle Data Guard常用于站点故障Copyright ? 1997-2014 NetEase. All Rights Reserved.Oracle Data GuardOracle Active Data Guard Copyright ? 1997-2014 NetEase. All Rights Reserved.Read-write transactionsRead-only transactionsMaximum Availability Maximum Performance Maximum ProtectionActive Data GuardSYNC/ASYNCOracle Data GuardDG 保护模式network latency+ 117%Read-write service+ 70%Read-only serviceOracle Data GuardADG模式下的性能提升2,6101,530Transactions / sec630290Read-onlyoffloaded to standbyAll servicesrun on primary databaseOracle Data GuardOracle Active Data Guard Copyright ? 1997-2014 NetEase. All Rights Reserved.Oracle GoldenGate 基本原理Copyright ? 1997-2014 NetEase. All Rights Reserved.Oracle GoldenGate 适用场景高可用节点保护、升级迁移、报表系统、ETL挖掘、BICopyright ? 1997-2014 NetEase. All Rights Reserved.Oracle Recovery Manager Copyright ? 1997-2014 NetEase. All Rights Reserved.Oracle Recovery Manager Copyright ? 1997-2014 NetEase. All Rights Reserved.Oracle Automatic Storage Management Copyright ? 1997-2014 NetEase. All Rights Reserved.Oracle Automatic Storage Management Copyright ? 1997-2014 NetEase. All Rights Reserved.Oracle Automatic Storage Management Copyright ? 1997-2014 NetEase. All Rights Reserved.Oracle架构介绍典型案例介绍URS相关数据库架构探讨Copyright ? 1997-2014 NetEase. All R