σʔλϕʔεͷ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