Oracle Database 12c High Availability

Size: px

Start display at page:

Download "Oracle Database 12c High Availability"

효선 전
6 years ago
Views:

Next-generation Maximum Availability Architecture (MAA) Optimized for

2 Oracle Database 12c Extreme Availability Oracle Database 12c 의새로운주요 HA 기능 대폭적인 downtime 감소 가용성과성능간의 trade-off 제거 엄청난운영생산성증대 전에없던새로운수준의가용성제공 Next-generation Maximum Availability Architecture (MAA) Optimized for Oracle 2 Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Maximum Availability Architecture Production Site RAC Scalability Server HA Flashback Human

Failover / Load Balancing Active Replica Active Data Guard Data Protection, DR Query

Redefinition, Data Guard, GoldenGate Minimal downtime maintenance, upgrades, migrations

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

4 Oracle Database 12c High Availability Key New Features Application Continuity Global Data Services Data Guard Enhancements RMAN Enhancements Flex ASM Other HA Enhancements 4 Copyright 2013, Oracle and/or its affiliates. All rights reserved.

시스템에대한불신등을초래 수반되는사항 사용자불편 중복제출 Mid-tiers 리부팅 개발자고충 5

5 실행중인작업 : 오류발생에대한처리 Current Situation End User Application Servers Database Servers Database 서비스중단은실행작업의중단, 사용자이탈, 시스템에대한불신등을초래 수반되는사항 사용자불편 중복제출 Mid-tiers 리부팅 개발자고충 5 Copyright 2013, Oracle and/or its affiliates. All rights reserved.

6 Application 개발고충해결방안 New in Oracle Database 12c Transaction Guard Application Continuity 마지막트랜잭션의결과를반환하는신뢰할수있는프로토콜과 API 장애또는 PM 작업후안전하게실행중인작업의재수행을시도 6 Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Transaction Guard COMMIT 결과의보존및회수 End User Application Servers Database Servers 모든트랜잭션의 commit 결과에대해 API 를통해지원 Transaction Guard 가없다면, 장애시 트랜잭션재시도는논리적손상을일으킬수있음

7 Transaction Guard COMMIT 결과의보존및회수 End User Application Servers Database Servers 모든트랜잭션의 commit 결과에대해 API 를통해지원 Transaction Guard 가없다면, 장애시 트랜잭션재시도는논리적손상을일으킬수있음 Transaction Guard 를통해, application 은에러상황을유연하게대처하고, user experience 의개선이가능 Application Continuity 에의해투명하게사용됨 7 Copyright 2013, Oracle and/or its affiliates. All rights reserved.

8 Application Continuity 계획된 / 계획되지않은서비스중단의보호 Transaction Replayed End User Application Servers Database Servers 복구되는에러에대해서동작중인작업을재수행 많은 hardware, software, network, storage 에러와중단에대해사용자에게투명하게함 별도의 application 개발없이사용자의생산성의개선 8 Copyright 2013, Oracle and/or its affiliates. All rights reserved.

9 Oracle Database 12c High Availability Key New Features Application Continuity Global Data Services Data Guard Enhancements RMAN Enhancements Flex ASM Other HA Enhancements 9 Copyright 2013, Oracle and/or its affiliates. All rights reserved.

10 Databases 복제환경도전과제 Primary Active Standby GoldenGate Active Standby 모든데이터베이스를효율적으로사용할수있는완벽한방법은없음 자동화된 load balancing 과 fault tolerance 는없음 10 Copyright 2013, Oracle and/or its affiliates. All rights reserved.

11 Global Data Services Database 복제환경을위한 Load Balancing 및 Service Failover Global Data Services Database 복제환경에 RAC 스타일의 service failover, load balancing ( 데이터센터내부및전역 ) 및관리기능을확장 Network latency, replication lag, service placement 정책의적용 높은가용성, 향상된관리및극대화된성능달성 11 Copyright 2013, Oracle and/or its affiliates. All rights reserved.

12 Global Data Services Active Data Guard 예제 Reporting Service Call Center Service Active Data Guard Reporting client 는 최상의 DB 에연결 위치, 응답속도, data, 수용가능한 data 지연에근거 보고서는자동적으로가장부하가적은서버에서실행 Reporting client failover 최상의 DB 가가용하지않으면, 같은지역또는원격에위치한다른 DB 로접속됨 Global service 이관 자동적으로 failover/switchover 에의해서비스이관실행 - primary database 에장애발생시, Call Center service 는새로운 primary 에서실행됨 12 Copyright 2013, Oracle and/or its affiliates. All rights reserved.

13 Global Data Services GoldenGate 예제 Call Center Service GoldenGate Call Center Client 연결과요청은투명하게가장가깝고 / 최상의 database 에연결됨 런타임 load balancing metrics 는다음요청을받는데이터베이스에서클라이언트실시간정보를제공 Database 에장애발생의경우, 글로벌서비스는다른복제본에서다시시작 13 Copyright 2013, Oracle and/or its affiliates. All rights reserved.

14 Oracle Database 12c High Availability Key New Features Application Continuity Global Data Services Data Guard Enhancements RMAN Enhancements Flex ASM Other HA Enhancements 14 Copyright 2013, Oracle and/or its affiliates. All rights reserved.

15 Zero Data Loss 도전과제 동기식 Communication 방식에따른 trade-off Commit Ack Network Ack Commit Network Send Primary Standby 거리가멀어짐에따라성능영향도는증가 15 Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Data Guard Async 기존방식장애시잠재적데이터누락위험요소존재 Primary ASYNC Standby 16

17 Active Data Guard Far Sync New in 12.1 비동기방식에대한 Zero Data Loss Far Sync: 가벼운 Oracle Instance: standby control file, standby redo logs, archived redo logs, no data files Primary 로부터 redo 를 Sync 방식으로전송받아 standby 로비동기방식으로보내줌 Failover 상황 : standby 는 commit 된 redo 를 Far Sync 로부터투명하게획득하여적용 : Data loss 없는 failover Second Far Sync Instance 가미리준비되면 failover/switchover 후에반대방향으로의 redo 전송이가능 Terminal standby 들은 Active Data Guard Standby 여야함 17 Copyright 2013, Oracle and/or its affiliates. All rights reserved.

19 Active Data Guard Far Sync Operational Flow (contd.) Primary SYNC ASYNC Zero Data Loss Standby Far Sync Instance 가용성과성능간의 trade-off 없음! 19 Copyright 2013, Oracle and/or its affiliates. All rights reserved.

20 Active Data Guard Far Sync Data Guard Failover? No Problem! Just do it No Data Loss! 최상의데이터보호, 최소의성능영향 저비용, 낮은복잡성 Far Sync 최고의근거리 DR + 원거리 DR 모델 현재의 Data Guard ASYNC 방식과유사 20 Copyright 2013, Oracle and/or its affiliates. All rights reserved.

21 Active Data Guard Real-Time Cascading Propagation Delay 제거 11gR2 에서는 Standby1 은 archived log 를 Standby2 로전송이되기전에는 log switch 가완료되길기다리는상태였다. Primary SYNC or ASYNC Standby 1 ASYNC Standby , Standby 1 은 Standby 2 로실시간으로 redo 를전송함으로 log switch 로발생하는 delay 를제거할수있다. Standby 2 (Active Data Guard Standby) 는 read-only 쿼리와 report 용도로사용가능 21 Copyright 2013, Oracle and/or its affiliates. All rights reserved.

22 Data Guard Fast Sync 동기방식에서의 Primary 영향도최소화 Commit Commit Acknowledge Primary LGWR Redo Logs NSS RFS Standby Redo Logs Standby 동기방식 redo 전송 : remote site 는 standby redo log 에쓰기전에 ACK 를 primary 쪽으로전송 Primary 에서는 commit 에의한지연을최소화 Commit Commit Acknowledge Primary LGWR Redo Logs NSS Acknowledge returned on receipt RFS Standby Redo Logs Standby Better DR Sync 의거리를늘릴수있음 네트웍으로인한지연이 local redo log 적용시간보다적다면동기방식의전송은 primary database 성능에영향을주지않음 22 Copyright 2013, Oracle and/or its affiliates. All rights reserved.

23 Data Guard Oracle Database 12c Data Guard 의신기능 Rolling Upgrade With Active Data Guard 간단한 PL/SQL Package 수행으로낮은복잡도 : DBMS_ROLLING ( onwards) 의사용으로 Init, Build, Start, Switchover, Finish procedures 수행 추가적인 Data Type 지원 : XML, Binary XML, Spatial, Image, Oracle Text, DICOM, ADTs (simple types, varrays), Validate Role Change Readiness 자동화된 health check 로 Switchover 가가능한지 Data Guard 구성검증 log gaps 검증, log switch 수행, 불일치 detect, Standby 에서 redo log 의 clear 검증 DML on Global Temporary Tables Temporary undo 는 redo log 에 logging 되지않음 Active Data Guard 에서 Global temporary tables 에대한 DML 가능 : 다양한 reporting 지원 Active Data Guard standby 에서 default Unique Sequences Primary 가각 Standby 에게고유의 sequence 범위를할당 Active Data Guard 에더유연한 reporting 방법을제공 23 Copyright 2013, Oracle and/or its affiliates. All rights reserved.

24 Oracle Database 12c High Availability Key New Features Application Continuity Global Data Services Data Guard Enhancements RMAN Enhancements Flex ASM Other HA Enhancements 24 Copyright 2013, Oracle and/or its affiliates. All rights reserved.

25 Fine-grained Table Recovery From Backup RMAN Backups RMAN Backup 으로부터단순한 RECOVER TABLE 명령을통해하나이상의테이블을복구가능 수동의 restore, recover, export 에비해시간과복잡도를제거 전체 tablespace 가아닌개개의 table 에대한 point-in-time recovery 가가능 25 Copyright 2013, Oracle and/or its affiliates. All rights reserved.

26 Cross-Platform Backup & Restore Platform Migration 간편화 Source Database (AIX) Destination Database (Solaris) Backup to Disk/Tape (data files, optional endian conversion, metadata export) 플랫폼간의 Migration 절차를단순화 다수의 incremental backup 를통해읽기전용에대한영향도최소화 Restore Backup (optional endian conversion, metadata import) 26 Copyright 2013, Oracle and/or its affiliates. All rights reserved.

27 Oracle Multitenant 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 27 Copyright 2013, Oracle and/or its affiliates. All rights reserved.

28 Better Performance Oracle Database 12c RMAN 의신기능 Multi-section Backup 의개선 : 현재는 image copy 와 incremental backup 만지원 간단한 RMAN 명령으로효율적으로 standby database 동기화 : RECOVER DATABASE FROM SERVICE Enhanced Active Duplicate Cloning 부하는 auxiliary channel 을통해최종 Server 로이관함으로서 Source Database 에대한 resource 부하를줄임 Cloning 시에 RMAN 압축과 multi-section capability 를사용하여성능향상을배가할수있음 28 Copyright 2013, Oracle and/or its affiliates. All rights reserved.

29 Oracle Database 12c High Availability Key New Features Application Continuity Global Data Services Data Guard Enhancements RMAN Enhancements Flex ASM Other HA Enhancements 29 Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Automatic Storage Management (ASM) Overview Current State RAC

Servers DB A DB A DB B DB B DB B DB C ASM Instance Node1 ASM

Groups ASM Cluster Pool of Storage Disk Group A Disk Group B ASM

30 Automatic Storage Management (ASM) Overview Current State RAC Cluster Database Instance One to One Mapping of ASM Instances to Servers DB A DB A DB B DB B DB B DB C ASM Instance Node1 ASM Instance ASM ASM ASM ASM ASM Node2 Node3 Node4 Node5 Shared Disk Groups ASM Cluster Pool of Storage Disk Group A Disk Group B ASM Disk Wide File Striping 30 Copyright 2013, Oracle and/or its affiliates. All rights reserved.

31 Flex ASM: Eliminate 1:1 Server Mapping New: ASM Storage Consolidation in Oracle Database 12c RAC Cluster Database Instance Databases share ASM instances DB A DB A DB B DB B DB B DB C ASM Instance ASM Instance Node1 Node2 ASM ASM ASM Node3 Node4 Node5 Shared Disk Groups Node1 Node2 runs as runs as ASM ASM Client to Client to Node2 Node4 Node3 ASM Cluster Pool of Storage Disk Group A Disk Group B ASM Disk Node5 runs as ASM Client to Node4 Wide File Striping 31 Copyright 2013, Oracle and/or its affiliates. All rights reserved.

32 Oracle Database 12c High Availability Key New Features Application Continuity Global Data Services Data Guard Enhancements RMAN Enhancements Flex ASM Other HA Enhancements 32 Copyright 2013, Oracle and/or its affiliates. All rights reserved.

33 Oracle Database 12c 의향상된가용성기능 Online Datafile Move 사용자가 data 를사용중에 datafile 을재배치가능 : ALTER DATABASE MOVE DATAFILE Storage Migration 중에도 data 의사용가능 Online Redefinition Enhancements sync_interim_table 의성능향상 VPD 정책으로 table 를재구성할수있음 finish_redef_table 의복구력강화 Multi-partition redefinition 의쉬운조작 Separation of Duties SYSDG / SYSBACKUP: Data Guard & RMAN 을위한특별한 administrative 권한 User Data 에대한접근금지 : 전사보안기준의강화 Additional Online Operations Drop index online / Alter index unusable online / Alter index visible / invisible online Drop constraint online / Set unused column online Online move partition: ALTER TABLE MOVE PARTITION ONLINE 33 Copyright 2013, Oracle and/or its affiliates. All rights reserved.

Database 12c HA Downtime 최소화 획기적인생산성의증대 성능과안정성의균형에대한고민제거

34 Oracle Database 12c Extreme Availability: Summary Oracle Database 12c는매우정교한 High Availability (HA) 를제공 Oracle Database 12c HA Downtime 최소화 획기적인생산성의증대 성능과안정성의균형에대한고민제거 34 Copyright 2013, Oracle and/or its affiliates. All rights reserved.

슬라이드 1

슬라이드 1 사례를통해본 ORACLE MAA (Maximum Availability Architecture) 2013. 02. Seungtaek Lee( 放浪 DBA) ORACLE MAA 최고의가용성을보장하기위해 Oracle( 사 ) 의여러솔루션을조합한 Oracle 권고아키텍처 2 ORACLE DB HA Solution Set RAC, Data Guard(ADG), ASM,