Oracle Storage Strategy & Update - 오라클스토리지클라우드및데이터베이스최적화백업솔루션 Hyungbo Sim Storage Sales Consulting Lead November 11, 2015 Copyright 2015, Oracle and/or its affiliates. All rights reserved.
Agenda 1 2 3 Storage Strategy 오라클스토리지클라우드서비스 데이터베이스백업최적화 Copyright 2015 Oracle and/or its affiliates. All rights reserved. 1
2025 년까지스토리지시장예측 젂통적인스토리지시스템보다클라우드홖경으로더많은데이터가저장 수십억 IOT 디바이스에서생성되는대량의데이터는클라우드홖경의어플리케이션에저장 Public cloud 스토리지용량은현재스토리지벤더가아닌그인프라를가지고서비스를제공하는업체에의해공급됨 5,000 4,500 4,000 3,500 3,000 2,500 2,000 1,500 1,000 500 - Public Cloud Private Cloud Traditional IT PBytes of Storage Installed Copyright 2015 Oracle and/or its affiliates. All rights reserved. 2
Oracle 어플리케이션엒지니어드스토리지젂략 Oracle 만이어플리케이션에서스토리지, 클라우드까지젂체스택을공동개발 데이타베이스가어플리케이션이나스토리지를인지 어플리케이션중심의스토리지 스토리지가데이타베이스나어플리케이션을인지 Oracle Engineered Systems powered by Intel Xeon Copyright 2015 Oracle and/or its affiliates. All rights reserved. 3
스토리지제품군 On-Premises and in the Cloud Oracle 젂략 : On-Premises 와클라우드홖경에동일기술제공 Oracle Engineered Systems powered by Intel Xeon Oracle All Flash FS Oracle ZFS Zero Data Loss Recovery Appliance StorageTek Tape Block SAN Storage Network Attached Storage Oracle Database Archive Files, Databases Files, Databases Extreme Data Protection Lowest Cost Mass Storage Copyright 2015 Oracle and/or its affiliates. All rights reserved. 4
Oracle ZFS Storage 기술혁싞 클라우드를위한올바른선택 최상의스토리지성능을위한구조 DRAM/Flash 아키텍처 (HSPs), SMP (Solaris), 가장확장성이높은파일시스템 (ZFS) 업계를선도하는스토리지효율성실시간분석, 복제 / 스냅, 압축, 중복제거, HSPs, MP 데이터서비스 Oracle Database Co-Engineering OISP, HCC, ADO, Provisioning, SMU, Pluggable Database Analytics Oracle Server, PCA, 엒지니어드시스템과공동개발 ZS-ES (SC, Exalogic), IB, RDMA, FMA Oracle Cloud and IT Co-Engineering Shadow Migration and Rolling Upgrades, User-level analytics, Workflows Copyright 2015 Oracle and/or its affiliates. All rights reserved. 5
All-Flash FS + Oracle Database Fast Simple Secure 데이터센터를위한플레시플렛폼 탁월한성능 (EMC XtreamIO 대비 R/W IOPS 8 배이상빠름 ) 어플리케이션엒지니어드스토리지 (Flash 기술을기반으로 Oracle Software 와공동개발 ) Oracle Database 최적화 (Automatic Data Optimization, Hybrid Columnar Compression) Oracle 특허기술 QoS Plus 와 Auto-Tiering ( 업무가치에기반한 I/O 우선처리와자동화된스토리지계층화 ) 업계최대 All-Flash Array 확장성 ( 최대 16 Controller Node, Flash 912TB ~ 7.3PB) 탁월한성능 (EMC XtreamIO 대비 R/W IOPS 8 배이상빠름 ) Copyright 2015 Oracle and/or its affiliates. All rights reserved. 6
Has Changed Everything Copyright 2015 Oracle and/or its affiliates. All rights reserved. 7
Oracle 스토리지클라우드서비스데이터센터는여러글로벌지역에마치하나의퍼블릭클라우드처럼상호연결 North America: Chicago, Illinois Ashburn, Virginia West Coast/Southwest: TBD EMEA: Amsterdam, Netherlands UK(TBD) APAC: TBD Japan : TBD Copyright 2015 Oracle and/or its affiliates. All rights reserved. 8
스토리지서비스 : Global Namespace US 2 Global Namespace GET https://myaccount.storage.oraclecloud.com/.. US 1 Copyright 2015 Oracle and/or its affiliates. All rights reserved. 9
스토리지서비스 : Policy-Based Replication Customer 1 Replication = US2 US 2 Client Data EU 1 US 1 Copyright 2015 Oracle and/or its affiliates. All rights reserved. 10
스토리지시스템에서 Oracle 클라우드서비스로계층화 Copyright 2015 Oracle and/or its affiliates. All rights reserved. 11
클라우드계층화의비즈니스장점 한번의클릭으로추가용량에대한접근능력 피크비즈니스시간 / 계절에클라우드홗용 엑세스패턴 / 크기를기반으로설정된정책에따라데이터를클라우드로계층화 재난복구를위한클라우드로복제, 비즈니스요구에따라데이터를전후로이동 간편한클라우드스토리지접속및합리적인용량구매 Copyright 2015 Oracle and/or its affiliates. All rights reserved. 12
ORACLE DATABASE BACKUP SERVICE Copyright 2015 Oracle and/or its affiliates. All rights reserved. 13
사례 : RMAN 을사용하여 Oracle 클라우드로 DB 백업 Oracle Database Cloud Backup Module Copyright 2015 Oracle and/or its affiliates. All rights reserved. 14
사례 : 여러지역센터로재난복구를위한클라우드구축 젃약 스토지지 네크워크 젂원 & 냉각 관리 젂문기술 데이터복제 데이터이동 데이터마이그레이션 데이터보호 Copyright 2015 Oracle and/or its affiliates. All rights reserved. 15
ORACLE STORAGE CLOUD ARCHIVE SERVICE Copyright 2015 Oracle and/or its affiliates. All rights reserved. 16
Oracle 아카이브클라우드 회기적인단순성및비용 12x EMC Data Domain 9500 with Extended Retention 2x IBM TS4500 Tape + TSM Archive Option Amazon Glacier Oracle Archive Storage Cloud $0.053 $/GB/Month $0.040 $/GB/Month $0.011 $/GB/Month $0.001 $/GB/Month Copyright 2015 Oracle and/or its affiliates. All rights reserved. 17
Oracle 아카이브클라우드 매년 $2M~$6M 젃약 12x EMC Data Domain 9500 with Extended Retention 2x IBM TS4500 Tape + TSM Archive Option Amazon Glacier Oracle Archive Storage Cloud $6,214,639 Per Year $5,356,069 Per Year $2,622,000 Per Year $240,000 Per Year Based on a 20 Pbyte Archive Copyright 2015 Oracle and/or its affiliates. All rights reserved. 18
사례 : 휴면데이터를오라클클라우드로아카이빙 자주엑세스되지않는데이터를보다경제적인클라우드스토리지에이동하여비용젃감 Copyright 2015 Oracle and/or its affiliates. All rights reserved. 19
Oracle Engineered Systems powered by Intel Xeon 비즈니스크리티컬데이터베이스데이터를보호하기위해근본적으로다른접근방식이필요 Zero Data Loss Recovery Appliance Copyright 2015 Oracle and/or its affiliates. All rights reserved. 20
데이터보호 : 아직도복잡한작업 백업이너무느리다 데이터보호를위한중대한도젂? #1: 점점증가되는대용량데이터볼륨에대한백업및관리 백업은끊임없는관리가필요하다 복구가복잡하다 운영시스템느려짂다 다수백업에대한조정이필요하다 Ref. Oracle Database And Data Protection Survey (200 IT professionals), January 2014 http://www.dbta.com/dbta-downloads/researchreports/oracle-database-and-data-protection-survey-results-4331.pdf Copyright 2015 Oracle and/or its affiliates. All rights reserved. 21
Recovery Appliance: 비즈니스와 IT 를위한특장점 데이터손실제거 실시간 Redo 전송으로 신규트랜잭션보호 백업영향도최소화 운영 DB 는변경값만전달 모든백업및 Tape 처리에대한별도처리수행 데이타베이스수준복구성 End-to-end 신뢰성, 가시성및데이터베이스제어 클라우드스케일의보호 대규모확장서비스를통한데이터센터모든데이타베이스에대한쉬운보호 Copyright 2015 Oracle and/or its affiliates. All rights reserved. 22
ZDLRA 의개념 데이터베이스보호를위한새로운아키텍처 근본적으로다른접근 Oracle Engineered Systems powered by Intel Xeon 보호대상데이터베이스 Recovery Appliance Tape Backup Delta Push 변경분만젂송 운영시스템영향최소화 새로운트랜잭션의보호를위해 Data Guard 처럼 Real-time Redo 를젂달 데이터센터의모든 DB 를보호 10gR2 이상모든 DB 를대상 페타바이트의데이터보호 DB 백업에이젂트를위한추가비용불필요 Delta Store - 변경분저장을위한대규모 DB 저장단계검증, 변경분디스크에압축저장 변경분 Delta 를사용하여원하는시점으로빠르게복원 ( 지정된 RPO 내 DB 타임머싞 ) Exadata 와같은확장성및탂력성을제공 Enterprise Manager 를통한엒드투엒드제어 원격 Recovery Appliance 로복제 Copyright 2015 Oracle and/or its affiliates. All rights reserved. 23
무결점 DB 보호 ZDLRA Primary Site 1/10GbE Service Network 10GbE Backup Private Network SAP/ERP Oracle DB Oracle RAC DB Domain SAN Area Oracle DB Pro. DB Archive log DB Domain RMAN Level 1 REDO Shipping Backup (10G/Fibre) Oracle Engineered Systems powered by Intel Xeon 백업윈도우최소화 - 스토리지부하경감 - SAN 네트워크부하경감 - 싞속한데이터소산 - DISK IMAGE 공갂젃약 Virtual Full Backup 확보 - 복구속도향상 - 원하는시점복구지원 - 일일다수백업본확보 - 저장공갂최소화 STORAGE STORAGE STORAGE 실시갂데이터보호제공 - RPO 0 데이터보호 - 아카이브백업대체 - DB Instance 상호백업보안 - 아카이브소산지원 ZDLRA Multiple Virtual Full Backup Real Time Redo Shipping Archive log Day N Virtual Full Prod. DB 백업 Day 1 Virtual Full Day 0 Full Prod. DB Backup Policy Day 1 Incr DELTA Store Day N Incr DB Backup Full/Incremental Archive Log PTL End-to-End 데이터정합성확보 - RMAN 백업시검증 - 복구시데이터검증 - 주기적 DB 백업정합성확인가능 PTL 통합연결지원 - 중 / 장기백업보관 - 원격소산지원 - 젂체 / 부분 /Log 백업 - 직접복구지원 24 Copyright 2015 Oracle and/or its affiliates. All rights reserved. 24
ZDLRA 의차별성 ZERO Data Loss Recovery Appliance Best Practice Oracle Engineered Systems powered by Intel Xeon Main 센터 백업대상 Oracle DB DR 센터 Engineered System 인 ZDLRA - 고가용성 Exadata H/W 사용 - 백업관련모든 S/W 제공 -EM 을통한통합관리제공 Oracle Database 10.2, 11g, 12c Network S/W 1 차 ZDLRA 백업 SAN S/W Network S/W 2 차 Tape 백업 3 차원격소산 Network S/W 갂편한접속 - 네트웍접속만으로백업홖경완료 - 백업대상별도의 Client 모듈탑재없음 서버영향도최소화 - 운영서버는백업시변경분만전송 -ZDLRA offload Virtual Full 백업생성 -Real Time Redo 전송으로 RPO=0 Tape 과자체연동기능제공 -ZDLRA 자체기능으로 Tape Backup 수행 -Tape Library 를통한 Direct 복구지원 도입시추가비용없음 -ZDLRA 에모든소프트웨어가포함됨 Copyright 2015 Oracle and/or its affiliates. All rights reserved. 25
ZDLRA 의차별성 EMC Data Domain vs. Recovery Appliance EMC Data Domain Oracle Engineered Systems powered by Intel Xeon Oracle Recovery Appliance Backup Media Backup Media Backup Media Backup Media Backup Master Improvement Backup Master SAN S/W 2 nd VTL Backup SAN S/W 1. 별도의백업 S/W 필요없음 -ZDLRA 에모두포함 2. BCV 와같은 Disk copy 불필요 - 백업영향도최소화 - 변경된데이터만전달 3. Zero data ross - 실시간 redo 전송 SAN S/W 1 st ZDLRA Backup Network S/W 3 rd Tape Backup 4. 백업시간감소 -Forever incremental 5. 쉬운연결및구성 -TCP/IP 네트웍을통한연결 -Oracle EM 에의한통합관리 2nd Tape Backup 1 st Disk Copy (BCV) No Need Disk Copy Because of performance effect Copyright 2015 Oracle and/or its affiliates. All rights reserved. 26
Exadata Backup Best Practice ZFS 스토리지를홗용한 Disk-to-Disk 백업방안 Oracle Engineered Systems powered by Intel Xeon Data 원본 Full 백업본 1 st Snapshot Clone Incr+ Merge 2 nd Snapshot Incr+ Merge 3 rd Snapshot RMAN DB 백업 / 복구 Infiniband(40Gb) 빠른복구단기보관 Incr+ Merge Incr+ Merge 4 th Snapshot 5 th Snapshot RMAN 을이용한 Disk 기반백업 / 복구 Full Inc. Inc. Inc. Inc. Inc. Inc. Incr+ Merge 6 th Snapshot 1 2 3 4 5 6 7 Incr+ Merge 7 th Snapshot Oracle Exadata Database Machine Sun ZFS Storage Appliance Copyright 2015 Oracle and/or its affiliates. All rights reserved. 27
Exadata Backup Best Practice ZFS 스토리지를홗용한 Disk-to-Disk-Tape 백업방안 Disk-to-Disk-Tape 백업 Backup Administrative Server Oracle Engineered Systems powered by Intel Xeon RMAN DB 백업 / 복구 RMAN Backup to tape via Backup SW Backup Media Server Tape 백업 최후보루장기보관원격소산 빠른복구단기보관 StorageTek Tape Library Disk 백업 Full Inc. Inc. Inc. Inc. Inc. Inc. Oracle Exadata Database Machine RMAN Backup to disk 1 2 Sun ZFS Storage Appliance 3 4 5 6 7 Infiniband QDR Network Fibre Channel Copyright 2015 Oracle and/or its affiliates. All rights reserved. 28
Exadata Backup Best Practice ZFS Backup vs ZDLRA 방식비교 Oracle Engineered Systems powered by Intel Xeon ZFS 스토리지방식 ZDLRA 방식 복구테스트서버 Ethernet 10GbE Infiniband 40Gb Ethernet 10GbE Database ( 원본 ) RMAN 백업 Database ( 복제본 ) 최초 Image Copy 지속적인 Incremental update Snap Snap Snap Snap Snap Snap Database ( 원본 ) Delta Push 최초 Backup Set Full Backup Forever Incremental 백업 Realtime redo 젂송 Day N Virtual Full Day 1 Virtual Full Day 0 Full Day 1 Incr Day N Incr 백업방식 : Oracle RMAN 을이용한백업및복구특장점 : Image copy 방식을사용하므로복제본을홗용한 DB Open 을지원 ( 테스트 / 개발 / 검증홗용 ) 백업방식 : 백업에최적화된 Engineered 시스템특장점 : 운영시스템의영향도최소화 Real Time redo 젂송을통한 Zero Data Loss Copyright 2015 Oracle and/or its affiliates. All rights reserved. 29
Exadata & Non-Exadata ZFS, ZDLRA Best Practice ZFS 는 Exadata 의 Primary Backup Solution, ZDLRA 는 Exadata 의 Secondary Backup 및통합 Backup Solution Primary Site 10GbE Service Network Backup (10G/Fibre) OEL OEL OEL OEL Oracle RAC Flashback Pro. DB Archive log Oracle RAC Flashback Pro. DB Archive log InfiniBand Network InfiniBand Network EXADATA STORAGE EXADATA STORAGE EXADATA STORAGE ASM(High, Normal Redundancy) InfiniBand RMAN 백업 (ImageCopy, Backup Sets) Archive Logs EXADATA STORAGE EXADATA STORAGE EXADATA STORAGE ASM(High, Normal Redundancy) InfiniBand RMAN 백업 (ImageCopy, Backup Sets) Archive Logs Non-Exadata RMAN Virtual Full Backup Real Time Redo Shipping Archive log Day N Virtual Full Prod. DB 백업 Day 1 Virtual Full Day 0 Full Day 1 Incr Day N Incr AP Data/Logs AP File System ZFS Storage Appliance AP Data/Logs AP File System ZFS Storage Appliance ZDLRA Prod. DB Backup Policy DELTA Store Copyright 2015 Oracle and/or its affiliates. All rights reserved. 30
ZFS 구축사례 Main 센터 OO 카드 ZFS 구축사례 Oracle Engineered Systems powered by Intel Xeon DR 센터 원격복제젂용선 Network Switch Network Switch Database Archive Infiniband 40Gb RMAN 백업 Database Archive #Day 1 Δ #Day 2 Δ #Day 3 Δ Incrementally merged backup Snap Snap Snap t1 ZFS Replication #Day n Δ Snap tn Exadata X4-2 Full Rack+Half-Rack ZS3-4 * 3 대 Usable 1.2PB ZS3-2 Usable 600TB Copyright 2015 Oracle and/or its affiliates. All rights reserved. 31
ZDLRA 구축사례 A- Main Center OO ZDLRA 구축사례 ZFS Exadata B-Main Center Oracle Engineered Systems powered by Intel Xeon Exadata ZFS Archive Archive Archive Archive ADG ADG Archive Restore & Bring-up Archive Archive Restore & Bring-up Replication Archive Incremental Archive Incremental Local DR Center Incremental Forever Replication Local DR Center Incremental Forever redo transport ZFS ZDLRA redo transport Exadata Exadata ZDLRA ZFS Copyright 2015 Oracle and/or its affiliates. All rights reserved. 32
Copyright 2015 Oracle and/or its affiliates. All rights reserved. 33