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
急成長を支える基盤作り〜地道な改善からコツコツと〜 #cre_meetup
stefafafan
0
130
OpenHands🤲にContributeしてみた
kotauchisunsun
1
460
【TiDB GAME DAY 2025】Shadowverse: Worlds Beyond にみる TiDB 活用術
cygames
0
1.1k
AIエージェント最前線! Amazon Bedrock、Amazon Q、そしてMCPを使いこなそう
minorun365
PRO
15
5.3k
GeminiとNotebookLMによる金融実務の業務革新
abenben
0
230
PHPでWebブラウザのレンダリングエンジンを実装する
dip_tech
PRO
0
210
Абьюзим random_bytes(). Фёдор Кулаков, разработчик Lamoda Tech
lamodatech
0
350
Observability infrastructure behind the trillion-messages scale Kafka platform
lycorptech_jp
PRO
0
140
監視のこれまでとこれから/sakura monitoring seminar 2025
fujiwara3
11
3.9k
Amazon S3標準/ S3 Tables/S3 Express One Zoneを使ったログ分析
shigeruoda
4
540
How Community Opened Global Doors
hiroramos4
PRO
1
120
製造業からパッケージ製品まで、あらゆる領域をカバー!生成AIを利用したテストシナリオ生成 / 20250627 Suguru Ishii
shift_evolve
PRO
1
140
Featured
See All Featured
GraphQLとの向き合い方2022年版
quramy
48
14k
What’s in a name? Adding method to the madness
productmarketing
PRO
23
3.5k
Designing Experiences People Love
moore
142
24k
Balancing Empowerment & Direction
lara
1
380
ReactJS: Keep Simple. Everything can be a component!
pedronauck
667
120k
Done Done
chrislema
184
16k
The MySQL Ecosystem @ GitHub 2015
samlambert
251
13k
Building Better People: How to give real-time feedback that sticks.
wjessup
367
19k
Measuring & Analyzing Core Web Vitals
bluesmoon
7
490
The World Runs on Bad Software
bkeepers
PRO
69
11k
Distributed Sagas: A Protocol for Coordinating Microservices
caitiem20
331
22k
Principles of Awesome APIs and How to Build Them.
keavy
126
17k
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