Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
データベースのDR環境をORACLE_CLOUD上に立ててみた.pdf
Search
koyapig
January 28, 2020
Technology
0
1.6k
データベースのDR環境をORACLE_CLOUD上に立ててみた.pdf
koyapig
January 28, 2020
Tweet
Share
More Decks by koyapig
See All by koyapig
jtf_2019_データベースのDR環境をoracle_cloud上に立ててみた.pdf
koyapig
0
1.7k
DR_disaster_recovery_環境について考えていますか_.pdf
koyapig
0
420
Oracle_Cloudによる_Database環境づくりの事始め.pdf
koyapig
1
250
Oracle環境をより早く作るには
koyapig
0
1.8k
Other Decks in Technology
See All in Technology
rubygem開発で鍛える設計力
joker1007
2
270
なぜ私はいま、ここにいるのか? #もがく中堅デザイナー #プロダクトデザイナー
bengo4com
0
1.3k
AWS Organizations 新機能!マルチパーティ承認の紹介
yhana
1
220
CursorによるPMO業務の代替 / Automating PMO Tasks with Cursor
motoyoshi_kakaku
2
790
Node-REDのFunctionノードでMCPサーバーの実装を試してみた / Node-RED × MCP 勉強会 vol.1
you
PRO
0
130
Amazon S3標準/ S3 Tables/S3 Express One Zoneを使ったログ分析
shigeruoda
5
590
20250625 Snowflake Summit 2025活用事例 レポート / Nowcast Snowflake Summit 2025 Case Study Report
kkuv
1
370
Oracle Cloud Infrastructure:2025年6月度サービス・アップデート
oracle4engineer
PRO
2
310
Fabric + Databricks 2025.6 の最新情報ピックアップ
ryomaru0825
1
160
Should Our Project Join the CNCF? (Japanese Recap)
whywaita
PRO
0
290
How Community Opened Global Doors
hiroramos4
PRO
1
130
MySQL5.6から8.4へ 戦いの記録
kyoshidaxx
1
300
Featured
See All Featured
Helping Users Find Their Own Way: Creating Modern Search Experiences
danielanewman
29
2.7k
4 Signs Your Business is Dying
shpigford
184
22k
Optimising Largest Contentful Paint
csswizardry
37
3.3k
What's in a price? How to price your products and services
michaelherold
246
12k
Testing 201, or: Great Expectations
jmmastey
42
7.6k
Git: the NoSQL Database
bkeepers
PRO
430
65k
Building a Scalable Design System with Sketch
lauravandoore
462
33k
Learning to Love Humans: Emotional Interface Design
aarron
273
40k
Build The Right Thing And Hit Your Dates
maggiecrowley
36
2.8k
Build your cross-platform service in a week with App Engine
jlugia
231
18k
Chrome DevTools: State of the Union 2024 - Debugging React & Beyond
addyosmani
7
720
Product Roadmaps are Hard
iamctodd
PRO
54
11k
Transcript
σʔλϕʔεͷDRڥΛORACLE CLOUD ্ʹཱͯͯΈͨ Oistudy #5 - GAUSS͞ΜͱΦΠϥେͷOracleCloud 1 Masashi Koyasu
ࣗݾհ ࢠ҆ɹਖ਼࢙ʢMasashiɹKoyasuʣ @koyapig ΦΠγοΫεɾϥɾେגࣜձࣾ Oracle / MySQL / PostgreSQL /
ͦͷଞ DBA4 ~ SRE2~ 2
About DR ࣄۀܧଓϚωδϝϯτʹ͓͚Δ֓೦ͷͻͱͭͰɺࡂ ͳͲʹΑΔඃ͔Βͷճ෮ાஔɺ͋Δ͍ඃΛ࠷খݶ ʹ͑ΔͨΊͷ༧ાஔͷ͜ͱͰ͋Δ Ҿ༻ʣWikipediaɿσΟβελϦΧόϦ https://ja.wikipedia.org/wiki/ %E3%83%87%E3%82%A3%E3%82%B6%E3%82%B9%E3%82%BF%E3%83%AA%E3%82%AB%E3%83%90%E3%83%AA σΟβελϦΧόϦʢӳޠɿdisaster recoveryʣ
3
About DR ࣄۀܧଓϚωδϝϯτʹ͓͚Δ֓೦ͷͻͱ ͭͰɺࡂͳͲʹΑΔඃ͔Βͷճ෮ા ஔɺ͋Δ͍ඃΛ࠷খݶʹ͑ΔͨΊͷ ༧ાஔͷ͜ͱͰ͋Δ Ҿ༻ʣWikipediaɿσΟβελϦΧόϦ https://ja.wikipedia.org/wiki/ %E3%83%87%E3%82%A3%E3%82%B6%E3%82%B9%E3%82%BF%E3%83%AA%E3%82%AB%E3%83%90%E3%83%AA σΟβελϦΧόϦʢӳޠɿdisaster
recoveryʣ 4 ཁ͢Δʹɾɾɾ ࡂͳͲʹΑΓɺαʔόʔ͕ ͍͜ͱʹͳͬͨ࣌ʹૣٸʹ෮چͰ ͖ΔΑ͏උ͑Δ͜ͱ
About RPO & RTO ඪ෮چ࣌(Recovery Point Objective) ͍ͭ࣌ͷσʔλ·ͰͤΔͷ͔ ඪ෮چ࣌ؒ(Recovery Time
Objective) ͍ͭ·ͰʹʢԿ࣌ؒͰʣ෮چͰ͖Δͷ͔ 5
എܠ ۙɺຖͷΑ͏ʹࣗવࡂ͕ൃੜ͍ͯ͠Δ طʹDRڥ͋Δ͕ɺສશͳͷͰͳ͍ ࡂ࣌ʹαʔϏεҡ࣋Ͱ͖ΔΈʹ৽͢Δ 6
త ҰҊͱͯ͠ฐࣾͷDRڥΛͬͯ΄͍͠ ฐࣾͷOracle Cloudͷ͍ํ DRڥΛߏ͍ͯ͠ΔιϑτΣΞ 7
ͳͥDRඞཁͳͷ͔ ࡂ࣌ͷૣظ෮چͷͨΊͷରࡦ σʔλͷܽଛ͕ͳ͍Α͏ʹ͢ΔͨΊͷରࡦ ͓٬༷ͷӨڹΛ࠷খݶʹ͑ΔͨΊͷରࡦ (※)RPO, RTOʹج͖ͮ෮چͰ͖ΔΑ͏ʹ͢Δ 8
ࣗࣾͷDRڥେৎͰ͔͢ʁ
γεςϜશମ૾ʢࢀߟʣ On-Premises Cloud-VM ECαʔόʔ جװܥαʔόʔ ྲྀܥαʔόʔ • ECαΠτɺجװܥγεςϜɺྲྀܥγεςϜ…etcΛࣗࣾߏ ஙɾӡ༻ •
αʔόʔओཁαʔόʔ͚ͩͰ20 • Ұ෦Λআ͖શͯͷॲཧͰOracle Database͕ΘΕ͍ͯΔ όοναʔόʔ 11gR2 SE 2node RAC 10
͜Ε·ͰͷDRڥ - ߏ On-Premises(ຊ൪) Archive Logs Full Backup File Amazon
S3 Archive Logs AWS EC2(DR) temp area ECαʔόʔ جװܥαʔόʔ11 ᶃ ᶄ ᶅ ᶆ ᶇ
͜Ε·ͰͷDR - ՝ DBͷࠩಉظ͕ͪΐͪ͘ΐࣦ͘ഊ ىಈʢOPENʣͰ͖Δ͔͕Θ͔Βͳ͍ ӡ༻͕ଐਓԽ͍ͯ͠Δ͔Β୲ऀͷෛ୲ ͕͍͢͝ 12
͜Ε·ͰͷDRڥ - ߏ Archive Logs Full Backup File Amazon S3
Archive Logs AWS EC2(DR) temp area ECαʔόʔ جװܥαʔόʔ 13 On-Premises(ຊ൪)
৽͍͠DRڥ - ඞཁͳཁ݅ Standard EditionʢOracle DatabaseͷEditionʣͰͰ͖Δ͜ͱ σʔλࢀর͕Ͱ͖Δ͜ͱʢಉظঢ়گͷ֬ೝʣ ϑΣΠϧΦʔόʔɺεΠονΦʔόʔ͕Ͱ͖Δ͜ͱ ӡ༻͕ଐਓԽ͠ͳ͍͜ͱ ίετΛͳΔ͑͘Δ͜ͱ
14
৽͍͠DRڥ - ߏ Virtual Cloud Network(VCN) subnet subnet subnet DBaaS
Compute Block Storage Object Storage Nat Server(vm) mount Oracle Cloud Infrastructure(US East (Ashburn)) Oracle cloud(DR) 15 11gR2 SE 2node RAC ᶃ ᶄ On-Premises(ຊ൪)
৽͍͠DRڥ - ߏ Virtual Cloud Network(VCN) subnet subnet subnet DBaaS
Compute Block Storage Object Storage Nat Server(vm) mount Oracle Cloud Infrastructure(US East (Ashburn)) Oracle cloud(DR) 16 11gR2 SE 2node RAC ᶃ ᶄ On-Premises(ຊ൪)
৽͍͠DRڥ - ߏ Virtual Cloud Network(VCN) subnet subnet subnet DBaaS
Compute Nat Server(vm) mount Oracle Cloud Infrastructure(US East (Ashburn)) Oracle cloud(DR) 17 11gR2 SE 2node RAC Block Storage Object Storage On-Premises(ຊ൪)
৽͍͠DRڥ - Platform Platform Oracle Could InfrastructureʢOCIʣ Bare Metal, VM,
and ExadataʢDBaaSʣ Compute Block Volume Object Storage 18
৽͍͠DRڥ - Platform 19 OCI AWS DATABASE DBaaS RDS SERVER
Compute EC2 DISK Block Volume EBS STORAGE Object Storage S3
৽͍͠DRڥ - Software Software Dbvisit Standby Oracle Database͚ࡂରࡦιϑτΣΞ 20
৽͍͠DRڥ - Dbvisitͱ Dbvisit͕ࣾఏڙ͍ͯ͠ΔOracle Database͚σΟβελϦ ΧόϦιϑτΣΞ ࠓճ૯ཧళͷInsight Technology༷͔Βߪೖɾαϙʔτ Enterprise Editionͷ(※)Data
GuardͷସҊͱͯ͠࡞ΒΕͨ ιϑτΣΞɻػೳॆ࣮͓ͯ͠ΓɺैདྷͷOracleʹ ൺ҆ՁͰಋೖՄೳɻ 21
ิɿAbout Data Guard ओʹσʔλอޢΛతͱͨ͠ϨϓϦέʔ γϣϯػೳ ෳͷಉظϞʔυΛඋ͑ΔʢಡΈऔΓઐ ༻/ॻ͖ࠐΈՄೳʣ 22
৽͍͠DRڥ - OCIΛ͏ཧ༝ DBaaSଞͷManagedDBͱҧ͍VMʹssh ଓͰ͖Δ ଞCloudΛ͏ΑΓOracleͷϥΠηϯεί ετͷݮ͕Մೳ 23
৽͍͠DRڥ - DbvisitΛ͏ཧ༝ Standard EditionͰDataGuardʹ͍ۙػೳ͕҆ՁͰར༻Մೳ ಡΈऔΓઐ༻ͰDBΛىಈ(OPEN)͢Δ͜ͱͰσʔλࢀর ͕Մೳ ಉظঢ়ଶʹͯࠩ͠ಉظ࠶։͕Մೳ ϑΣΠϧΦʔόʔɺεΠονΦʔόʔ͕༰қ GUI͕͑Δ͜ͱͰӡ༻ʹDBAҎ֎ͰରԠՄೳ
24
৽͍͠DRڥ - ຊߏͷϝϦοτ DbvisitΛ͏͜ͱʹΑΓ՝Λղফ ϑΣΠϧΦʔόʔɺεΠονΦʔόʔͳͲͷ ࡞ۀ͕ʢ࠷ѱͷ߹ʣDBAҎ֎ͰରԠՄೳ Oracle Cloud & DbvisitΛ͏͜ͱʹΑΓɺϥ
ΠηϯείετΛେ෯ݮ͕Մೳ 25
ࢀߟ·Ͱʹ - ίετ ڥ ͜Ε·ͰͷDR ڥ ৽͍͠DR ڥ ࠩ ʢ৽ن
- ͜Ε·Ͱʣ DB ********** ********** ▼51% DBVISIT (ϥΠηϯεඅ) ********** ********** ˛ DBVISIT (อकඅ) ********** ˛ ߹ܭ ********** ********** ▼19% 26
తʢ࠶ܝʣ ҰҊͱͯ͠ฐࣾͷDRڥΛͬͯ΄͍͠ ฐࣾͷOracle Cloudͷ͍ํ DRڥΛߏ͍ͯ͠ΔιϑτΣΞ 27
We are hiringʂ ΦΠγοΫεɹ࠾༻ https://recruit.oisixradaichi.co.jp/ 28
Thank You!! ࣭͋͝Γ·ͨ͠Βɺ͓ؾܰʹDM͍ͩ͘͞ʂ @koyapig