deploying databases in the cloud - oracle · •while maintaining a consistentuser experience! 4...
TRANSCRIPT
Copyright©2018, Oracleand/oritsaffiliates.Allrightsreserved.|
TipsEveryDBAMustKnowforDeployingOracleDatabasestoCloud
LawrenceTo AshishRay SureshTripathiSeniorDirector VPofProductManagement DirectorofIT
OracleDatabaseDevelopment Organization AllianceDataSystems
October23,2018
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.|
SafeHarborStatement
Thefollowingisintended tooutline ourgeneralproductdirection. Itisintended forinformationpurposes only,andmaynotbe incorporatedintoanycontract.Itisnotacommitment todeliver anymaterial,code,orfunctionality,andshouldnotberelieduponinmakingpurchasingdecisions. Thedevelopment, release, timing, andpricingofanyfeaturesorfunctionality described forOracle’sproductsmaychangeandremainsatthesolediscretion ofOracleCorporation.
2
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.|
ProgramAgenda
Introduction:DataManagementintheCloud
OracleDatabaseCloudDeploymentGuidelinesforDBAs
CustomerCaseStudy:DeployingEnterpriseDatabasestoCloud
1
2
3
3
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.|
• OracleDBAs,who…• havebuiltcomplexdatamanagementsystemsoverthelastseveralyears…• tosupportallaspectsoftheenterprise business…• mustnowdealwithstrongmarketforces …• toadoptacloud strategy…• whilemaintainingaconsistent userexperience!
4
DataManagementintheCloud:ProblemStatement
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.| 5
CloudDatabaseBusiness/MarketForcesWe can’t be in the
data center business!!
Our board tells us that we must go to the Cloud,
now!
The money-well for new
hardware purchase has
dried up!
Control?
DataModel? Applications?
Latency?Administration?Migration?
Performance?Availability?
Security? Support?
Manufacturing
Engineering
Marketing
IT/Ops
ServiceHR
CustomerDataCenter
Sales
Finance
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.|
JourneyTowardsOracleDataManagementintheCloud
• Astructuredapproachgoesalongwaytowardsasuccessfulcloudtransition
6
RightDatabasePlatform
CloudSLAs
CloudLifecycle
DatabaseOperations
MigrationStrategy
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.|
DatabaseCloudDeploymentGuidelinesChoosetheRightDatabasePlatform,attheRightLocation,attheRightCost
7
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.|
Oracle’sDatabaseintheCloudPortfolio• DBCS(DatabaseCloudService)
– Entry-leveltoDepartmentalworkload– AvailableinBareMetal(Single-Instanceonly)orVM(max2-nodeRAC)– LimitednumberofCPUsandlimitedstoragecapacity
• ExadataCloudService– Mission-criticalworkload,plusconsolidation (DW,OLTP,In-Memory,…)– HundredsofCPUsandhundreds ofTerabytesofstorage– FullbenefitsofExadata
• ExadataCloudatCustomer– ExadataClouddeployed atcustomerdatacenter
• Autonomous– FullymanagedbyOracle– Built-inself-driving,self-repairingandself-securingcapabilities– Somedatabasefeaturesaredisabled
8
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.| 9
Giventheenterprisefocusofthissession,followingslides,unlessnoted,assumechoiceisExadataCloud
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.|
OracleExadataCloudDeploymentScenarios• Clouddeployedinyourdatacenterorpublicclouddatacenters?
10
Metric ExadataCloudatCustomer ExadataCloudServiceDataCenter facilities Provided by Customer Provided byCloud Provider
Security Leverageexisting datacenter securitycontrols
Adopt Cloud Provider’s security controls
Applications Idealforcaseswhere backend apps aretoocomplex forlift andshift
Applications need tobe deployed inCloudCompute toeliminate latency
Backups /DR Leveragedatacenter infrastructure Adopt Cloud Provider infrastructure
DataResidency Assures compliance with dataresidencylaws
Dataresidency compliance possible onlywhenCloud Provider haslocal datacenters
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.|
CommercialConsumptionModelsforExadataCloud
• OracleDatabaseEnterpriseEditionExtremePerformanceIncluded
• BringYourOwnLicense(BYOL)entitlementstoExadataCloud
11
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.|
ExadataCloudEnterpriseEditionExtremePerformance
12
AllDatabaseOptions,DatabaseEMPacksandExadataSystemSoftwareIncluded
AllExadataDBMachineInnovations
AllOracleDatabase
Innovations
Multitenant
In-MemoryDB
RealApplicationClusters
ActiveDataGuard
Partitioning
AdvancedCompression
AdvancedSecurity,LabelSecurity,DBVaultRealApplicationTestingAdvancedAnalytics,SpatialandGraphManagementPacks forOracleDatabase
InfiniBand Fabric
ColumnarFlash Cache
HCC
10:1I/O I/O I/O
StorageIndexes
HybridColumnarCompressionI/OResourceManagement
ExafusionDirect-to-WireProtocol
Offload SQLtoStorage
NetworkResourceManagement
In-MemoryFaultTolerance
PCIFlashSmart FlashCache,Log
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.|
BYOL:LeverageOn-PremisesLicenseswithExadataCloud
RAC
Partitioning
In-MemoryDB
MultitenantActiveData
Guard
LegacyOn-Premises Infrastructure
TransparentDataEncryption(TDE)DiagnosticsandTuningPackDataMaskingandSubsettingPackRealApplicationTesting
13
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.|
CommercialConsumptionModelsforExadataCloud
• OracleDatabaseEnterpriseEditionExtremePerformanceIncluded
• BringYourOwnLicense(BYOL)entitlementstoExadataCloud
14
TIP• YourchosenClouddeployment
modelmayhaveentitlementsforDatabaseOptionsthatyoudidn’thavepreviously,suchasIn-Memory,orMultitenant
• Usecloudtransitionasanopportunitytore-thinkyourapplicationarchitecture
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.|
DatabaseCloudDeploymentGuidelinesPlanaCloudArchitecturethatDeliverstheRequiredSLAs
15
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.|
• CapacityPlanningandSizing– AllDatabases youwanttoMigrate– EvaluateGrowth– OpportunitytoOptimize/Consolidate
• HARequirements– RTO(recoverytimeobjective)– RPO(dataloss tolerance)– DisasterRecoveryTolerance
16
DeliveringAvailabilityandPerformanceSLAsCloudInfrastructure
Backup/Restore Options RAC ADG
ReplicationacrossADs/Regions
OCI(BM) BackuptoOCIObjectStorage(manual/automatic)BackupcopiesacrossAvailabilityDomains(ADs)
✓ AcrossADsAcrossRegionsviaVCNpeeringorPublicInternet
OCI(VM)(withSIorRAC)
✓* ✓
Exa-OCI (X6/X7) ✓ ✓
OCC BackuptoNFS,LocalObjectStorage,ZDLRAonpremise,CloudObjectStoragewithtiering
✓ AcrossADsandregionswhereavailableExaCC (X6,X7) ✓ ✓
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.|
• CapacityPlanningandSizing– AllDatabases youwanttoMigrate– EvaluateGrowth– OpportunitytoOptimize/Consolidate
• HARequirements– RTO(recoverytimeobjective)– RPO(dataloss tolerance)– DisasterRecoveryTolerance andRTO
17
DeliveringAvailabilityandPerformanceSLAsCloudInfrastructure
Backup/Restore Options RAC ADG
ReplicationacrossADs/Regions
OCI(BM) BackuptoOCIObjectStorage(manual/automatic)BackupcopiesacrossAvailabilityDomains(ADs)
✓ AcrossADsAcrossRegionsviaVCNpeeringorPublicInternet
OCI(VM)(withSIorRAC)
✓* ✓
Exa-OCI (X6/X7) ✓ ✓
OCC BackuptoNFS,LocalObjectStorage,ZDLRAonpremise,CloudObjectStoragewithtiering
✓ AcrossADsandregionswhereavailableExaCC (X6,X7) ✓ ✓
TIPs• CapacityPlanningandSizingmapsto
correctcloudresource
• HArequirementsandSLAsmaptoMAAReferenceArchitectures
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.|
SingleInstance Database
Database Files
Bronze:SingleInstanceDatabasewithBackups
18
LowCostMAASolutionforCustomersWhoCanTolerateHigherRTOandRPO
Bronze Summary
• Single instance database with backups & auto-restart capabilities with Oracle Clusterware
• replication of backup to different Availability Domains
• Restore from backup to resume service following
unrecoverable outages
Features • Oracle Restart Capabilities (enable with Oracle Clusterware)• Multitenant Database with PDB features (12c+ DBs)
• Online Maintenance (available manually)• Corruption Protection (enabled)• Flashback Technologies (flashback undo enabled)
• Recovery Manager and Cloud Storage• Recovery Appliance (future, available for Cloud at Customer)
PrimaryDatacenter
RemoteDatacenter
CloudBackup
ReplicatedBackups
*Oracle Cloud replicates backups across another datacenterorAvailability Domain
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.|
Events Downtime(RTO) DataLossExposure(RPO)
RecoverableDatabaseinstancefailure Minutes Zero
Recoverableserverfailure MinutestoHour Zero
Datacorruptions,unrecoverableinstance,server,databaseorsitefailures Hourstodays Since lastbackup,or Near-zerowith
RecoveryAppliance
Onlinefilemove,reorganization/redefinition,andcertainpatches Zero Zero
Hardwareoroperatingsystemmaintenanceanddatabasepatchesthatcannotbedoneonline MinutestoHours Zero
Databaseupgrades:patchsets andfulldatabasereleases Minutes tohours Zero
Platformmigrations Hoursto aday Zero
Appupgradesthatmodifyback-enddatabaseobjects Hourstodays Zero
Plan
ned
Mai
nten
ance
Unpl
anne
dO
utag
es
19
Bronze - SingleInstanceOracleDatabaseUnplannedOutagesandPlannedMaintenance
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.|
CloudMAABronze:NextSteps• KeyGuidelines
– UseCloudBackupAPIs(defaultssectionsize=64GB,RMANparallelism4/node,LOWcompression)orevaluate RecoveryAppliancewithExaCC forlowerRPO
– AdjustHugePages afteraddingmoredatabases– UseClusterware managedservices– FollowApplication Checklist forContinuous Service– Leverageonlinefilemoveandonlinereorganizationwhenappropriate
• OperationalPractices– CloudTest/Dev/UAT resources andrealworldtesting recommended– UpdateDBandsecuritysoftwareasrecommended andpickupnewcloudinfrastructuresoftwaretoleveragenewfeaturesandincorporateMAApractices
20
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.|
RTOofSeconds forServerFailures,RPOnearZerowithRecoveryApplianceSilver:HighAvailabilitywithFastFailover
§ Active-ActiveclusteringwithOracleRAC– Allnodesactiveatalltimes– Real-timefailover
§ ZerodowntimerollingmaintenanceacrossRACinstances– HardwareandOSmaintenance– QualifiedOracleDatabasepatches– FollowApplicationChecklistforContinuousService
§ AvailableinOraclePublicCloudandExaCC
DBBackupService
ReplicatedBackups
ExaCS/ExaCC
Production– Datacenter#1orAD1 DR– Datacenter#2orAD2
SILVER
21
InOracleCloud,RACNodesforDBCSareinseparatefaultdomains
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.|
Silver– HighAvailabilitywithFastFailoverUnplannedOutagesandPlannedMaintenance
Events Downtime(RTO) DataLossExposure(RPO)
RecoverableorunrecoverableRACinstancefailure Seconds Zero
Recoverableorunrecoverableserverfailure Seconds Zero
Datacorruptions,unrecoverabledatabase,AvailabilityDomainorRegionfailure Hourstodays Since lastbackup,or Near-zerowith
RecoveryAppliance
Onlinefilemove,reorganization/redefinition,andpatching Zero Zero
HardwareorO.S.maintenanceanddatabasepatchesthatcan’tbedoneonlinebutqualifiedforRACrollinginstall Zero Zero
Databaseupgrades:patchsetsandfulldatabasereleases Minutes tohours Zero
Platformmigrations Hoursto aday Zero
Appupgradesthatmodifyback-enddatabaseobjects Hourstodays Zero
Plan
ned
Mai
nten
ance
Unpl
anne
dO
utag
es
22
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.|
CloudMAASilver:NextSteps
• AllPracticesofBronzePlus
• Keyguidelines:– FollowApplication Checklist forContinuous ServiceforRAC
– Ifyouwantlowerdowntimeforinstance andserverfailures,evaluate lowerFAST_START_MTTR_TARGET setting
• OperationalPractices– TotestforHAorperformance impact,onetestsystemshouldbeidentical orsimilartoproduction
23
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.|
RTOofSecondstoMinutes,RPOofZeroorNear-ZeroGold:ComprehensiveHA/DR
§ Real-timedataprotection,HAandDRusingActiveDataGuard
– Bestcorruptionprotection– Zeroornear-zerodataloss– Automaticdatabasefailoverwithpotentialzerodataloss
– Offloadread-onlyandbackups
§ MinimalDowntimeforDatabaseUpgradesusingDBMS_Rolling ortransientlogicalstandby
Primary
Standby
ActiveDataGuard Queries
Test/Dev
Production– Datacenter#1inAD1
DR– Datacenter#2(acrossADoracrossRegion)
GOLD
Reporting
24
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.|
• ProvidesHA,dataprotection andfastfailoverfordatabaseacrossADs
• DataGuardsynchronousmodepossibledueto<1msbetweenADs
• DataGuardFast-startFailoverismanual
• VCNPeeringacrossRegionsavailabletoday– PHX- IADandLHR- FRA– CannotprovisionacrossRegions,so
noDRviacloudtooling
OracleCloudDeploymentModel
25
<1ms Latency
Latency varies
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.|
Gold– ComprehensiveHAandDataProtectionUnplannedOutagesandPlannedMaintenance
Events Downtime Data Loss Exposure
RecoverableorunrecoverableRACinstancefailure Seconds(RAC) Zero
Recoverableorunrecoverableserverfailure Seconds (RAC) Zero
Datacorruptions,databaseunabletorestart,sitefailure Seconds(ActiveDataGuardFSFO*)
Near-zeroifASYNCZeroifSYNCorFARSYNC
Onlinefilemove,reorganization/redefinition,andpatching Zero Zero
HardwareoroperatingsystemmaintenanceanddatabasepatchesthatcannotbedoneonlinebutarequalifiedforRACrollinginstall
Zero(RAC) Zero
Databaseupgrades:patchsets,fulldatabasereleases Seconds(ActiveDataGuard) Zero
Platformmigrations Seconds(ActiveDataGuard) Zero
Applicationupgradesthatmodifydatabaseobjects Hourstodays Zero
Plan
ned
Mai
nten
ance
Unpl
anne
dOu
tage
s
26
*FSFO:Fast-startFailover
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.|
CloudMAAGold:NextSteps• AllPracticesofSilverPlus• Decision:
– DataGuardFSFOacrossADsversusDataGuardFSFOacrossRegions(SiteFailover)
• KeyCustomerActions– FollowApplication Checklist forContinuous ServiceforDataGuardFast-StartFailover– DataGuardFast-Start setupandtuningfailovertimes ismanual(refertoupdatedOracleCloudMAApaper)
– DatabaseRollingUpgradewithDataGuardisalsomanual.RefertogenericMAAdoc
• OperationalPractices– Test complete application +DataGuardroletransitions
27
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.|
CloudMAAGold:NextSteps• AllPracticesofSilverPlus• Decision:
– DataGuardFSFOacrossADsversusDataGuardFSFOacrossRegions(SiteFailover)
• KeyCustomerActions– FollowApplication Checklist forContinuous ServiceforDataGuardFast-StartFailover– DataGuardFast-Start setupandtuningfailovertimes ismanual(refertoupdatedOracleCloudMAApaper)
– DatabaseRollingUpgradewithDataGuardisalsomanual.RefertogenericMAAdoc
• OperationalPractices– Test complete application +DataGuardroletransitions
28
TIP• SetupDataGuardFast-startFailover
acrossADswhenyourequireexistingApplication Tierstofailovertransparently
• Note:DNS+CompleteSiteFailover isrequiredwhenfailingovertoadifferentregion
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.|
MAAEvolution:AutonomousDatabase
On-Premises
On-PremisesExadata
Database/ExadataCloud
AutonomousDatabase
29
• Architecture• DatabaseManagement(Tooling)• Configuration,Tuning • LifecycleOperations(Tooling)• ApplicationPerformance
• Choosing the SLApolicy• Application
performance
• InfrastructureManagement• Architecture• DatabaseManagement• Configuration,Tuning• Lifecycleoperations• ApplicationPerformance
• InfrastructureManagement• Architecture• Configuration,Tuning• DatabaseManagement• LifecycleOperations• ApplicationPerformance
• Blueprints• Feedbackto
products&features
• Blueprints• Exadata isthebest
integratedMAADBplatform
• OracleownsandmanagesthebestintegratedMAADBplatform
• Cloudautomationforprovisioningandlifecycleoperations
• Oracleowns andmanages Infrastructure
• Policy drivendeployments
• MAAIntegratedcloud• Fully automated Self-
Driving, Self-Securing,Self-RepairingDatabase
CustomerOracle
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.|
ExtremeAvailabilityPolicy• RACDatabase,RedundantNetworkingandStorage,ActiveDataGuard,andBackup• Protectionfromhardwarefailures,crashes,corruptions,patches, upgrades,disasters
• ServiceUptime SLAperMonth:99.995NRX%(NRX=NoRidiculousExclusions)– 99.995%Uptime=atmost2m12sofdowntime permonth– Goalisforapplicationimpactfromanyoneeventtobewellunder30seconds
• Suitable forMission Critical productiondatabases
30
PrimaryDatabase
Region#1,AD#1 Region#1,AD#2
Backup
StandbyDatabase
Active Data
Guard
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.|
ExtremeAvailabilityPolicy• RACDatabase,RedundantNetworkingandStorage,ActiveDataGuard,andBackup• Protectionfromhardwarefailures,crashes,corruptions,patches, upgrades,disasters
• ServiceUptime SLAperMonth:99.995NRX%(NRX=NoRidiculousExclusions)– 99.995%Uptime=atmost2m12sofdowntime permonth– Goalisforapplicationimpactfromanyoneeventtobewellunder30seconds
• Suitable forMission Critical productiondatabases
31
PrimaryDatabase
Region#1,AD#1 Region#1,AD#2
Backup
StandbyDatabase
Active Data
Guard
TIP• UseAutonomousDatabaseExtreme
Availability forMAAGoldlevelsolution,withguaranteed99.995uptimeSLAs
WithAutonomousDatabase,customerscanfocusonapplicationandbusinessinnovation,whiledatabasesaremanagedusingOracleAutonomouscapabilities
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.|
DatabaseCloudDeploymentGuidelinesPlanaMigrationStrategythatisLeastDisruptive
32
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.|
Cloud Migration Service ....
MigrationtoCloud
33
MixedPlatformsMixedDBVersionsNon-CDB andPDBsNon-Encrypted (usually)
OracleLinux11.2.0.4(non-CDB)
12.1.0.2, 12.2.0.1,18.3.0, 19.1(CDB)Encrypted
SI,RAC, Exadata
ExaCS
Autonomous
DatabaseCloudService
SimpleMinimal ImpactNearZeroDowntime
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.|
InstantiationOptionsandConsiderations• DataTransferServiceforInstantiation
– DataTransferDisk– DataTransferAppliance
• MigrationConnectivityOptions– FastConnect– IPSecVPNandInternetGateway
• CloudMigrationToolsandDocumentation– ZeroDowntimeMigration(ZDM)– Documentation orMOSnotes
34
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.|
InstantiationOptionsandConsiderations• DataTransferServiceforInstantiation
– DataTransferDisk– DataTransferAppliance
• MigrationConnectivityOptions– FastConnect– IPSecVPNandInternetGateway
• CloudMigrationToolsandDocumentation– ZeroDowntimeMigration(ZDM)– Documentation orMOSnotes
35
TIP• EvaluateDataTransferServices
when(databasesize)/(networkbandwidth) greaterthan7days
• KeepaneyeonZeroDowntimeMigrationnoticesforautomationofnewMAAmigrationsolutions
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.|
MigrationOptions• PhysicalMigrationensurestablespacesareessentiallyidentical
– Option1:CloudRMANbackupandrestoreorRecoveryAppliance backup/restore– Option2:DataGuard(<5minutes downtime)– Option3:ComboMethod includingDBUpgradeandPDBPluginoperations (<1hourdowntimepotential)
• LogicalMigrationprovidesabilitytoreorganizeandtore-optimize– Crossplatformsupport,database andendianness support– Option1:DataPump– Option2:GoldenGate (zerodowntimepotential)
36
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.|
SourceDatabase Destination Database
SOE Day1:FullBackup
Export Import
Read-only
MetaData
SOE
DatabaseMigrationProcess– Oracle10g/11g/12c+ZDLRA• DramaticallyReduced Read-onlyDowntime– FromHours+toMinutes
• Minimaldowntime– DBremainsread-write throughout process• Tablespaces areonly placed inread-only prior tofinal incremental
• Dailyincrementalbackups->virtualfullbackupsonRecoveryAppliance• Restorelatestvirtualfullbackuppriortostartofmigrationwindow
• RESTOREFROMPLATFORM XXX FOREIGNDATAFILEYYY• Finalincrementaltakeninread-only,thenrestored&recoveredontodestination files
• RECOVER FROMPLATFORM XXX FOREIGNDATAFILECOPY YYY• Datapump Export andImport oftablespace definition (Transportable Tablespace)
Virtual FullRestore
Restore&Recover FinalIncremental
Day2->N:Incremental
Backups
Dayn:FinalIncremental
Read-write
ZDMSupportEarly
CY2019
37
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.|
SimpleDataGuardMigrationSteps(MOS2386116.1)SourceDB CloudDB
STBY
STBY
STBY
11.2
2.EnableTDEandEncryptStandby(optional)
Real-timeEncryptedRedo 11.211.2
1.PrepareCloudandInstantiateCloudStandby Instantiate Standby 11.211.2
3.DataGuardSwitchover(5minsdowntime)
SWITCHOVERto CLOUD 11.211.2
SWITCHBACKtoOn-Prem4.FallbackwithZeroDataLoss(Fallbackin5mins)
11.211.2
38
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.|
ZeroDowntimeMigration(ZDM)Automating DataGuardMigration Solution
39
ZDMisexpectedtosupportmigrationusingcloudbackup/restoreandDataGuardbyearlyCY2019.ZDMOTNwebsitecomingsoon.
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.|
Method1:TransientLogicalSolution(Downtime: 30secs <x<30minutes)ComboMigration(MOS2326901.1)
11.2
11.2
SourceDB CloudDB
11.2
STBY6.Fallbackifrequired
Activate11gDatabase(DataLoss)NoDataGuardSwitchover
11.2
4.Switchoverusing physru ..migrate (downtimebegins)11.2 12.2
SWITCHOVERto CLOUD
1. PrepareCloudandInstantiateCloudStandby(2CloudOHs:Source&TargetDBversions)
11.211.2 11.2Instantiate Standby
2.UpgradeStandbyusingTransientLogicalphysru...12.2migrate
11.2 11.2 12.2Real-timeEncryptedRedo
3.Enable TDEandEncryptStandby(optional) 11.2 12.2Real-timeEncryptedRedo
12.2CDB
5.Pluginto CDB(if the source is non-CDB)
40
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.| 41
Upgrade/MigrateUsingGoldenGate orDataIntegrationPlatformCloudServices
Cross-endian possible
Whentouse MigrationProcess
Source version 8i andlater
Migratefromnon-CDB toPDB
Changes todatabase structurepossible
1. Createcloud instance andPDB2. Configure GoldenGate,
GoldenGate orDIPCcloud servicedepending on thesituation
3. Synchronize changes4. Switch clients tocloud database
Upgrade tonew version possible
Minimal downtime migration
GGCS : https://docs.oracle.com/en/cloud/paas/goldengate-cloud/index.htmlDIPC https://docs.oracle.com/en/cloud/paas/data-integration-platform-cloud/index.html
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.|
ZDM:GoldenGate HubforAutonomousDatabase
42
• Simple and Secure• Full Automation ofMigration LifeCycle• Minimal Overhead forSource• Significant Performance Improvements• Supplemental logging, RedoTransport• DataPump for Instantiation (ZDMearlyCY2019)• Powerful GoldenGate inthecloud• EstimatedCY2019
Autonomous Cloud Database
ZDMService
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.|
DatabaseCloudDeploymentGuidelinesPlanHowtoOperateyourCloudDatabases
43
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.|
Management&Maintenance
• Youcontrolandmanagesoftwarethatdirectlyaffectsyourapplication– Database,GridInfrastructure,OS
• Oraclemanages underlying infrastructure– Facilities,servers,storage,storagesoftware,networking, firmware,hypervisor,etc.
• Youhaveadministrator privileges forcomputeVMsanddatabases soyoucanconfigureandrunthesystemastheylike– Initiateautomateddatabaseupdatescriptwhenitisconvenient– Canberunrollingacrossnodes toavoiddatabasedowntime– Createbackupschedule, initiateon-demand backups
Infrastructure
44
Ref.https://www.oracle.com/technetwork/database/exadata/em-exadata-cloud-3959023.pdf
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.|
InfrastructureAdministration
• OracleCloudOpsmanagerelevantinfrastructurerelatedtoyourdatabases– Hardwarefaultsmonitoring– Firmwareupdates– Hypervisor(dom0)updates– ExadataSystemSoftwareupdates– DataCenterFacilities (forExaCS)– CloudControlPlaneupdates
• Systemsoftwareupdatesaredoneonaperiodicbasiswithadvancednotice• CustomerscannotadministerExadataStorageCells,butcanuseAWR
45
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.| 46
FamiliarEMInterfacetoMonitorCloudDatabases
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.| 47
FamiliarExadataAWRforExadataMonitoringInsights
Ref.https://www.oracle.com/technetwork/database/exadata/exadata-awr-5100655.pdf
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.| 48
CloudLifeCycleExamples:DBCSBackups
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.|
ExaCS BackupandRestoreto/fromObjectStorage
49
BackupandRestore Compression RMANChannels SectionSize(GB)None (16*2nodes)=32 64GB
Mosteffectivetoparallelismlarge
datafiles.
Nonegativeimpactforsmaller
files
4TB/hr 1.5%- 4%
None (16*2nodes)=32 13TB/hr 1.5%- 2.5%
LOW
(RMANLOWCOMPRESSION
isDefault)
(4*2nodes)=8
(Defaultis4/node)
14TB/hr 4.0-5.0%
(4*2nodes)=8
(Defaultis4/node)
28TB/hr 4.2-5.0%
Restore(L0only)
(16*2nodes)=32 6.5TB/hr 10-14%
Restore(LO+L1)(recoveryofallL1s+archives)
(16*2nodes)=32 1.5TB/hr 3-7%
EffectiveBkupRate
*Between incrementals,5%ofDBwaschanged.
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.| 50
CloudLifeCycleExamples:DBCSPatching
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.| 51
ReduceSecondsofBlackouttoMinimalBrownoutforExadataDBSoftwareUpdatesReducingBlackoutsandBrownouts
Available only inExadataandwithGI18.3andhigher
NoServiceDrainingTPSvsTime
23secondsblackout
WithAutomaticServiceDrainingandNewExadataOptimizationsTPSvsTime
<1secbrownout
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.| 52
CloudLifeCycleExamples:DataGuardSetup
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.|
DBCSDataGuardTestResults
53
RPO=0withSYNCwithminimal impact. Fastfailoverwithpotential<30seconds
Example isMAA-tuned single instanceDataGuard Fast-startFailover onDBCS
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.|
RESTAPIs• AllDatabase Cloudprovisioning andlifecycle operationsareexposed throughWebInterfacesandRESTfulAPIs– ScaleOCPUs
– ManageVirtualNetwork andSecurityLists
– ManageAccess/SSH Keys
– Start/Stop Compute Nodes
– CreateDatabase
• Allows integrationwithcustomers’ existing automation infrastructure– ServiceNow,OpenStack,CloudFoundry,Terraform
54
– PatchDatabase– Setup/Control DataGuard– ConfigureIOResourceManagement– BackupandRecovery
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.|
RESTAPIs• AllDatabase Cloudprovisioning andlifecycle operationsareexposed throughWebInterfacesandRESTfulAPIs– ScaleOCPUs
– ManageVirtualNetwork andSecurityLists
– ManageAccess/SSH Keys
– Start/Stop Compute Nodes
– CreateDatabase
• Allows integrationwithcustomers’ existing automation infrastructure– ServiceNow,OpenStack,CloudFoundry,Terraform
55
– PatchDatabase– Setup/Control DataGuard– ConfigureIOResourceManagement– BackupandRecovery
TIP• ExploreAPI-driven cloud
orchestrationforyourDatabaselifecycle operations
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.|
ExadataCloudServiceCLIs/APIs- CommandLineUtilities
56
Exad
ata
Clou
dSe
rvic
eCL
Is/AP
Is
dbaasapi CreateandDeleteDatabases
dbaascli
TDEManagement
OracleHomeMaintenance
ListenerControl
PDBLifecycleManagement
Patching
ExaCLI (future) StorageCellMetricsandDiagnostics
bkup_api BackupandRecovery
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.|
DatabaseCloudDeploymentGuidelinesPlanYourCloudLifecycletoMeetDemandFluctuations
57
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.|
ElasticitywithExadataCloud• ExadataCloudenables yougrow/shrinkcomputecapacitywithnodowntime
• Understandsteady-state andpeakburstsofyourworkload– Provision initialsystembasedonyoursteadystatecomputesizing
– Incaseofpeakactivity,simplyscaleupthroughUI,orautomatethroughAPI
– Scaledown oncepeaksubsides– Youarebilledforoveragehours
• Steady-state-sizing enables efficient andcost-effectivesystemsutilization
58
40Scaled-upOCPUsfor24hrs
Scale-up Scale-down
Time
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.|
ElasticitywithExadataCloud• ExadataCloudenables yougrow/shrinkcomputecapacitywithnodowntime
• Understandsteady-state andpeakburstsofyourworkload– Provision initialsystembasedonyoursteadystatecomputesizing
– Incaseofpeakactivity,simplyscaleupthroughUI,orautomatethroughAPI
– Scaledown oncepeaksubsides– Youarebilledforoveragehours
• Steady-state-sizing enables efficient andcost-effectivesystemsutilization
59
40Scaled-upOCPUsfor24hrs
Scale-up Scale-down
Time
TIP• Youdon’tneedtodoconfigure for
peakgrowthworkloadanymore
• Includepossibleburstperiods inyourTCOcalculations
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.| 60
ExadataCloud:Scale-upExample
ExadataCloudSystemDashboard
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.| 61
ExadataCloud:Scale-upExample
Click theExaCSsystemlink
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.| 62
DetailsoftheExaCSSystemshowingthe
currentCPU count(40)
ExadataCloud:Scale-upExample
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.| 63
ExadataCloud:Scale-upExample
Click ScaleUp/Down
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.| 64
ExadataCloud:Scale-upExampleDialogboxtoenterupdatedinformation
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.| 65
ExadataCloud:Scale-upExampleEnternewCPU count
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.| 66
ExadataCloud:Scale-upExampleSystembeingupdated
withnodowntime
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.| 67
ExadataCloud:Scale-upExample ExaCS systemnowupdatedwithnew
CPU count
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.|
DatabaseCloudDeploymentGuidelinesSummary
68
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.| 69
JourneyTowardsOracleDataManagementintheCloud
RightDatabasePlatform
CloudSLAs
MigrationStrategy
DatabaseOperations
CloudLifecycle
1. OracleCloudhasacomplete setofdatamanagement solutionsfortheenterprise
2. CustomerswhoareusedtoasetofperformanceandMAASLAs fortheiron-premisesdeployments, cannowachievesimilar SLAsfortheirclouddeployments
3. Cloudtransition isajourney:astructuredandanalyticalapproachisnecessary
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.|
CustomerCaseStudy:DatabaseintheCloudAllianceDataSystems
70
Alliance Data: Database Migration to Oracle CloudPresented by
Suresh TripathiDirector of IT
Who we are!You might not know our name, but you’ve seen what we do. Alliance Data is the engine
behind loyalty and marketing campaigns for more than 1,000 consumer-facing companies worldwide across all industries: retail, travel, pharmaceutical, financial services, auto, and
more.
That data-driven insight enables us to build dynamic and creative loyalty marketing programs and strengthen and deepen relationships between our clients and their
customers. In today’s changing-by-the-minute digital landscape, that’s more crucial than ever.
Challenges we had : Before Cloud Migration
Multiple data centers for Prod and Dev/QA env
Challenges with datacenter Vendor
Aging hardware
Sub-par DR environment but
always paying for it
High Cost Licensing Support
Slow provisioning
time
DB resources limitations
Patching support Single Oracle Home
Enterprise Applications
Exadata
Peoplesoft Financials
Peoplesoft HR
OBIEE
WebcenterAgilePLM
SOA
Hyperion
Before Migration to Oracle Cloud
Why Oracle Cloud: Why Now
Why not nowBig Oracle Footprint
Centralized Oracle database
dependency
Cost Benefits
Licensing Support
Lower Operational Cost
Existing relationship with
Oracle
Smaller migration Risk
Better DR architecture
Support future state architecture, roadmap
and Strategy
Oracle Cloud Solutions Options
Option 1 – (BYOL) to Exadata Cloud Service
Option 2 – (Non-BYOL) to Exadata Cloud Service
Option 3 – BYOL to 2-Node RAC
Option 4 – BYOL to Single Node Database
Option 5 – BYOL to Bare Metal Compute
What did we Pick and Why
WhatwePicked
Why
Option 2- (Non-BYOL) to Exadata Cloud Service
v Best available cloud offering for enterprise database
v Resources availability on Exadata solution
v Migration impact and efforts expected to be minimum
v Compatible with existing on-prem Exadata Databases
Setup on Oracle Cloud
Implementation : How we did it
Help from vendors (L&T Infotech and others)
Database: Migration to ExaCS X7
Peoplesoft: Lift & Shift
Hyperion: Upgrade & migration to OCI
OBIEE: Upgrade & migration to OCI
AgilePLM: Upgrade & migration to OCI
SOA: Upgrade & migration to OCI
Webcenter: Upgrade & migration to OCI
OCI: Oracle Cloud Infrastructure
Implementation : Lessons we LearntManual provisioning of database
DB Migration from on-premises to Cloud needs special attention
Careful design considerations for Oracle Multitenant
PDB cloning requirements
Container database only
Working with Encryption wallet needed a few iterations
Backup provisioning is manual
Implementation : Lessons we Learnt
Shared or individual Oracle Home
Get the latest DB image on Exadata
Oracle provided utilities Vs Customer utilities
Cloud tool upgrade for patching
Unparalleled Oracle support from their A-team and development team
Post Go-Live : Benefits
Separate Oracle homes
Higher capacity 5x memory2x Disc space3x cores Improved
Performance(30% to 50%
faster)
Simplified patching
Newer hardware CPU’s, Memory, Storage, IB, etc.
Significant Cost Reduction
• Consolidation• Cloud subscription
DBaaS parameter file and command
– simplifies creation
What we Plan to do Now and in Future
Available Built-in Feature Set
Real Application Testing: Database Replay
Data Masking and Data Encryption
Advanced Compression
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.| 85
MovingtoOracleCloudSaves$1MAllianceDataSystems
• AccesstoDBfunctionality• Oracleexpertise• Exadataperformance• LowestCloudTCO• Roadmapalignment
Industry: Marketing /LoyaltyServicesHQ/Locations: US/US
FastConnect
ActiveDataGuard
OracleCloudPROD– Ashburn
PROD DR
ExadataCloudService
CloudDrivers
WhyOracleCloud
• Shrinkdatacenters• ModernizeIT• LowerTCO• IncreaseROI• Consolidation
ApplicationsPeoplesoftHyperionOBIEEAgilePLMSOAWebcenter
OracleCloudDR– Phoenix
BlockVolume&ObjectStorage
Thank you
Copyright©2018,Oracleand/oritsaffiliates.Allrightsreserved.| 87