High Availability And Disaster Recovery For Oracle Public .
High Availability and Disaster Recoveryfor Oracle Public and Hybrid CloudsOracle MAA Database TechnologiesSridhar Ranganathan,Sr. Principal Product Manager, Oracle Database High AvailabilityAndrew Steinorth,Principal Member of Technical Staff, Oracle Database - MAAPresented withPragnesh Panchal, ArchitectEquinixOct 29, 2015Copyright 2015, Oracle and/or its affiliates. All rights reserved.
Safe Harbor StatementThe following is intended to outline our general product direction. It is intended forinformation purposes only, and may not be incorporated into any contract. It is not acommitment to deliver any material, code, or functionality, and should not be relied uponin making purchasing decisions. The development, release, and timing of any features orfunctionality described for Oracle’s products remains at the sole discretion of Oracle.Copyright 2015, Oracle and/or its affiliates. All rights reserved. 2
Program Agenda1Cloud Backup for On-Premises Databases2DR to Oracle Cloud using Active Data Guard3Oracle Fast Connect using Equinix4HA & DR options for PaaS/SaaS Databases in Oracle Cloud5Customer Use Case: Migrate Test/Dev to Oracle Cloud6Upcoming Oracle Cloud HA/DR Enhancements7SummaryCopyright 2015, Oracle and/or its affiliates. All rights reserved. 3
Program Agenda1Cloud Backup for On-Premises Databases2DR to Oracle Cloud using Active Data Guard3Oracle Fast Connect using Equinix4HA & DR options for PaaS/SaaS Databases in Oracle Cloud5Customer Use Case: Migrate Test/Dev to Oracle Cloud6Upcoming Oracle Cloud HA/DR Enhancements7SummaryCopyright 2015, Oracle and/or its affiliates. All rights reserved. 4
Oracle Database Backup Cloud ServiceCloudDatabasesOffsite Backups with Simple and Low Cost Cloud Storage Backup on-premise or Cloud Databases to OracleDatabase Backup Service hosted in Oracle Cloud Cost effective, scalable cloud storage for databasebackups (10.2 and above) End-to-end enterprise-grade data encryption,Oracle Cloudcompression and protection Clients: Data is always encrypted with keys keptOn-Premiseslocally at client, optionally compressed, andsecurely transmitted Cloud: Encrypted data is protected with 3-waymirroring on every writeOracle DatabaseBackup CloudServicehttps://cloud.oracle.com/database backupCopyright 2015, Oracle and/or its affiliates. All rights reserved. 5
Database Backup Service: Client & Cloud Side ComponentsClient Side (Database Server) Recovery Manager – Primary Interface– Backup, Restore & Recovery– RMAN Compression & RMAN Encryption RMAN Plugin Module (SBT)– Interfaces with Oracle Storage Cloud– Streams data between DB Server & Cloud Connectivity from your Datacenter toOracle Cloud over HTTPS– Over Public Network– Oracle Fast Connect (High Bandwidth)Cloud Side (Object Storage) Subscription––––Identity DomainService NameUser IDPassword ContainerIdentity DomainService NameContainer 2Container 1obj1 obj2 obj1 obj2– User defined or auto created Objects– Stored in the context of the Container– Chunked (20MB) backup piecesCopyright 2015, Oracle and/or its affiliates. All rights reserved. 6
Backup Service: End-to-End FlowSimple 4-Step Process Storage Capacity Identity Domain Service Name User ID/PasswordCloud Subscription& ActivationInstall RMANModule Download & ExecuteInstaller Library moduleinstalled along withconfig file & wallet Tape Interface Encryption Compression ParallelismPerform Backup &Recovery RMAN Interface Full & Incrementalbackups Restore & RecoveryConfigure RMANCopyright 2015, Oracle and/or its affiliates. All rights reserved. 7
Option #1: Purchase Oracle Database Backup ServiceCopyright 2015, Oracle and/or its affiliates. All rights reserved. https://shop.oracle.com/
Option #2: Sign-up for a Trialhttps://cloud.oracle.com/database backupCopyright 2015, Oracle and/or its affiliates. All rights reserved. 9
Option #2: Sign-up for a Trial – Non-Metered Contd.Copyright 2015, Oracle and/or its affiliates. All rights reserved. 10
Option #2: Sign-up for a Trial – Non-Metered Contd.After Submission, wait for the activation email. Then Activate the ServiceCopyright 2015, Oracle and/or its affiliates. All rights reserved. 11
Cloud Service PortalCopyright 2015, Oracle and/or its affiliates. All rights reserved. 12
Download Oracle Database Cloud Backup Module from OTNCopyright 2015, Oracle and/or its affiliates. All rights reserved. 13
Run the Installer[oracle@localhost OPC] unzip opc installer.zip[oracle@localhost OPC] ls opc*opc install.jar opc readme.txt[oracle@localhost OPC] java -jar opc install.jar -serviceName myService –identityDomain myDomain -opcidsridhar.ranganathan@oracle.com -opcPass ’myPassword' -libDir /home/oracle/OPC/lib -walletDir/home/oracle/OPC/walletOracle Database Cloud Backup Module Install Tool, build 2015-05-12Oracle Database Cloud Backup Module credentials are valid.Oracle Database Cloud Backup Module wallet created in directory /home/oracle/OPC/wallet.Oracle Database Cloud Backup Module initialization file /u01/products/db/12.1/dbs/opcodbs.ora created.Downloading Oracle Database Cloud Backup Module Software Library from file opc linux64.zip.Downloaded 23169388 bytes in 152 seconds. Transfer rate was 152430 bytes/second.Download complete.Copyright 2015, Oracle and/or its affiliates. All rights reserved. 14
opc host https://odbs-dom.Storage.oraclecloud.com/odbs svc-odbs domopc wallet 'location file:/abc/opcwlt‘opc container ‘myContainer’Example: End-To-End FlowOn-PremisesDatabase, FRAOracleDatabase BackupCloud ServiceOracleWallet*RMANCloudModule*OPC ConfigFile*RecoveryManagerHTTPS over WAN rman target /RMAN CONFIGURE CHANNEL DEVICE TYPE SBT PARMS 'SBT LIBRARY /opc/libopc.so’ , SBT PARMS (OPC PFILE /opc/opcSID.ora)';RMAN CONFIGURE DEVICE TYPE SBT PARALLELISM 8;RMAN SET ENCRYPTION ON IDENTIFIED BY “mypwd” ONLY;RMAN BACKUP AS COMPRESSED BACKUPSET DATABASE PLUS ARCHIVELOG;* Configured during databasebackup cloud module installprocedureCopyright 2015, Oracle and/or its affiliates. All rights reserved. 15
Support MatrixVersionsOracle Database – EE/SE/SE1/SE210.2, 11g, 12c (64 bits)Platforms (64 bits)Linux, Solaris, SPARC, Windows, HP-UX, AIX, zLinuxRMAN Compression*HIGH, MEDIUM, BASIC, LOW (depends on DB version)RMAN Encryption*Password, TDE, Dual-mode* RMAN encryption & RMAN compression licensing includedCopyright 2015, Oracle and/or its affiliates. All rights reserved. 16
Best Practices for Cloud Backups Backup to Oracle Database Backup Cloud Service–––––Databases (Production or from Standby Database)Backups stored in Local Fast Recovery Area (FRA)Backups stored in External storage (eg. NAS)FRA Backupsets to cloud: BACKUP BACKUPSETFRA Image Copies to cloud: BACKUP COPY OF DATABASE or BACKUP RECOVERY AREA Choose cloud tier based on RTO / RPO for the database– Public network has unpredictable bandwidth & latency– High bandwidth Cloud-Connect options such as Oracle FastConnect to cloud storage All RMAN backup & recovery best practices apply– Incremental Strategy: Weekly full, Daily Incrementals Archivelog– For non-archivelog Databases: Full backupsCopyright 2015, Oracle and/or its affiliates. All rights reserved. 17
Use Cases for Backups in Oracle CloudDatabase Migration toOracle CloudCreate a DR instance in theOracle cloud with periodicupdates from backupsCreate test & dev instancesin the Oracle CloudCreate a Data GuardStandby instance in theOracle cloudCopyright 2015, Oracle and/or its affiliates. All rights reserved. 18
Graphical User Interface by CloudBerry Lab(Oracle Partner)Copyright 2015, Oracle and/or its affiliates. All rights reserved. 19
CloudBerry Backup for Oracle DatabasesBack up your Oracle Database directly to Oracle Database Backup Cloudwith an easy to use GUI application leveraging RMAN & Backup ModuleCentralized Backup Management Centralized management for all your databases Database servers are configured with RMAN Backup Module to Oracle Cloud Specify tags to identify backups Cloudberry sends RMAN commands to the database serverSchedule Backups: Setup schedules for automatic backup Choose the mode best suited for youCloudBerryBackupOracle DatabaseMonitor & Manage Backups Search backup data in the cloud with tag and date. Delete previous backups. View percent of data being transferred and network speeds Remembers configuration for reuse.Oracle Cloud Backup ModuleOracle DatabaseBackup Cloud Service
CloudBerry GUI rMonitoringList ofBackups
Oracle Database Backup Cloud Service: Value PropositionOffsite backup location toprotect from disasters andfor regulatory requirementsNo CAPEX and low OPEXcloud storage and nolicensing for encryption &compressionAdditional (long-term)secured copy in the cloudfor creating sandboxenvironments24x7 accessibility to thebackup dataCopyright 2015, Oracle and/or its affiliates. All rights reserved. 22
Program Agenda1Cloud Backup for On-Premises Databases2DR to Oracle Cloud using Active Data Guard3Oracle Fast Connect using Equinix4HA & DR options for PaaS/SaaS Databases in Oracle Cloud5Customer Use Case: Migrate Test/Dev to Oracle Cloud6Upcoming Oracle Cloud HA/DR Enhancements7SummaryCopyright 2015, Oracle and/or its affiliates. All rights reserved. 23
Cloud-Based Disaster Recovery: Requirements Enterprises that do not have a DR site– Cannot afford CAPEX for deploying an on-prem DR site– Want low OPEX DR site with no active management– Offsite copy for regulatory & compliance reasons– Want a lower RTO / RPOLocal Backups /Local StandbyOn-PremisesSingle Site Enterprises that already have a DR site– Want to reduce cost by migrating DR site to cloud– Want to have a sandbox environment in the cloud– Additional copy in the cloud (offsite)– Want on-demand commission & de-commission of DR siteCopyright 2015, Oracle and/or its affiliates. All rights reserved. On-PremisesPrimaryOn-PremisesDR Site(Standby)24
Disaster Recovery Solution Using Oracle CloudUsing (Active) Data Guard Production: On-Premises Standby: Oracle Cloud– General Purpose DBaaS (or)Exadata Cloud Service (Active) Data Guardreplication MAA Best Practices Currently a Manual Process– White paper published– Automation ht 2015, Oracle and/or its affiliates. All rights reserved. 25
DR To Cloud: Complete Life CycleProvisioning StepsSteady State / DR / Additional Steps Oracle Database Cloud ServiceSubscription Configuration best practices– Throughput: MAA Best Practices– General Purpose DBaaS, Exadata Cloud Monitoring & Management Secure Network Configuration––––– Transport (RPO) and apply (RTO) lagAccess: SSH/NAT IP/Port ForwardingSecurity: Oracle Net encryption/TDE (optional)Oracle Net encryptionVPN connectivity for Exadata Cloud Service Standby Instantiation in Oracle Cloud– Duplicate from Source (or)– From Database Backup Cloud Service Role Transitions– Switchover / Switchback– Failover / Failback Using Cloud Standby for– Reporting, cloning etc.Copyright 2015, Oracle and/or its affiliates. All rights reserved. 26
Database / Platform Support MatrixOn-PremisesDatabase Cloud ServiceOperating System Linux, Windows or Solaris X86 (64-bit) Oracle Enterprise Linux (64-bit)Oracle DatabaseDatabase SizeOracle Database Enterprise Edition11.2.0.4 (64-bit)(or)Oracle Database Enterprise Edition12.1.0.2 (64-bit)Any sizeData GuardDatabase as a Service (or) Virtual Image:Enterprise, High Performance andExtreme Performance editionsActive Data GuardDatabase as a Service (or) Virtual Image:Extreme Performance Edition (or)Exadata Cloud ServiceDBaaS: 2.3TB with backups *DBaaS: 5TB without backups *Exadata Service: Any size* Size may increase in the futureCopyright 2015, Oracle and/or its affiliates. All rights reserved. 27
DR To Cloud: Deployment OptionsOver Public Internet On-Premises ProductionStandby in Oracle Cloud (DBaaS)Secured data transmission over public internetUnpredictable latency / low bandwidthUsing Oracle Fast Connect Production co-located in Equinix Data Center Standby in Exadata Cloud Service Oracle Fast Connect provides a shared 10gigEnetwork Predictable latency / High bandwidthCustomer colowith EquinixOn-Premises DataCenterOracle DatabaseCloud ServiceExadata Cloud ServiceSame Metro AreaCopyright 2015, Oracle and/or its affiliates. All rights reserved. 28
Network Deployment Options: ComparisonPublic InternetOracle Fast Connect(Name Subject to Change)Production DatabaseOn-PremisesEquinix Data Center (Metro)Standby DatabaseGeneral Purpose DBaaSExadata Cloud ServiceOracle Database Exadata Cloud ServiceThroughput observedUp to 20MB/sec*From 100MB/sec – 600MB/sec*(Standby Instantiation: 5-60x faster)LatencyUnpredictable 5msReplication ModeRecommendedAsynchronousSynchronous or AsynchronousRecommendedWorkloadsGood for most OLTP workloadHigh volume transactions, DW,Consolidation with low RPO** Your experience may vary depending on network, client, size of database, change rate etc.Copyright 2015, Oracle and/or its affiliates. All rights reserved. 29
DR to Oracle Cloud: Value PropositionsZero CAPEX, elasticprovisioning of DR site withlow RTO & RPOHigh ROI – utilize DR copyfor reporting and testSatisfy compliance ®ulatory requirements foran off-site copyScale DR for databaseconsolidation and highvolume apps using CloudConnect OptionsCopyright 2015, Oracle and/or its affiliates. All rights reserved. 30
Program Agenda1Cloud Backup for On-Premises Databases2DR to Oracle Cloud using Active Data Guard3Oracle Fast Connect using Equinix4HA & DR options for PaaS/SaaS Databases in Oracle Cloud5Customer Use Case: Migrate Test/Dev to Oracle Cloud6Upcoming Oracle Cloud HA/DR Enhancements7SummaryCopyright 2015, Oracle and/or its affiliates. All rights reserved. 31
Where Opportunity ConnectsPresented by: Pragnesh Panchal – Lead Solution Architect @ EquinixConfidential – 2015 Equinix Inc.Equinix.com32
Our Leading Interconnection Platform Accelerates Your BusinessThe leading, global interconnection platformGlobalData Centers100 Data Centers33 Metros11M Square FeetGreen by DesignConfidential – 2015 Equinix Inc.InterconnectionSolutions160,000 Cross ConnectsBusinessEcosystems6,250 BusinessesCloud Exchange ,Performance Hub , andInternet Exchange100% of Tier 1 Network RoutesEquinix Marketplace Revenue OpportunitiesEquinix.comProvenExpertise99.9999% Uptime RecordWorld Class PartnersSolution Design and ValidationProfessional Services33
Why is a datacenter companytalking during acloud session?Because Oracle Cloud uses Equinix data centersEquinix is an Oracle customerEquinix is partner & enabler of Oracle Fast ConnectConfidential – 2015 Equinix Inc.Equinix.com34
Relevant Use Cases for Equinix IT in Oracle CloudStep 1Use CasesBenefitsStep 3DB Backup in cloudActive – Standby DB ReplicationActive – Active DB ReplicationDR from cloud backupOffload reads to Cloud DBBig Data & IoT serviceDev / Test in cloudMobile & BI service on Cloud DBMulti-cloudLimited throughput and unpredictable latencyChallengesSolutionStep 2Oracle Fast Connect using Equinix Cloud Exchange (ECX)AgilityIs your workloadlatency, throughput orBettersecurityTCO sensitive?Globally scalableFlexibility of Hybrid ITLower RTO & RPOMulti-cloudConfidential – 2015 Equinix Inc.Equinix.com35
Oracle Fast Connect via ECX (Equinix Cloud Exchange)Provides agile, secure, instant interconnection to cloud servicesPoint to point, MPLS, MetroE connectivity fulfilled byNetwork providerMulti-cloud choiceProvision via PortalEquinix IBXswithin metroOracle Fast ConnectEnterpriselocationsConfidential – 2015 Equinix Inc.EnterpriseCageUse case examplesPaaS Services: Database Backup Big Data Service Exadata ServiceIaaS Services: Object Storage ComputeEquinix CloudExchange(ECX)Equinix.com36
Test with Oracle Fast Connect over ECX with Equinix IT as α CustomerFiber to 2*10G redundant ports on ECXGOAL: Test latency, throughput andpredictability of connectivity over ECX vs.InternetA vs. B effective pathInternetEquinix IT Internet connectivity – 1GbpsNATNetwork AddressTranslationOracle public IPAddress SpaceCustomerpublic IPAddress SpaceComputeServiceVM with Oracle DBEquinix IT Private CloudDB BackupServiceOracle Public CloudEquinix Chicago MetroConfidential – 2015 Equinix Inc.Equinix.com37
α Test Results - Oracle Fast Connect over ECXDatabase Backup ServiceTest Scenario: Database size: 1TB, Backup Datasets: 250GB, # of threads: 15, Connectivity Details - Internet bandwidth: 1 Gbps, ECX Bandwidth: 1 & 10GbpsTestInternet (1 Gbps)ECX (1 Gbps)ECX (10 Gbps)ECX ImprovementBackup Time6.5 hours41 minutes26 minutesUp to 6 hrs. fasterBackup Network Throughput0.08 Gbits/sec0.79 Gbits/sec1.25 Gbits/secUp to 15x fasterRestore Time4 hours39 minutes24 minutesUp to 3.5 hrs. fasterRestore Network Throughput0.14 Gbits/sec0.84 Gbits/sec1.36 Gbits/secUp to 9.7x fasterCompute ServiceTest Scenario: # of threads: 15, Connectivity Details - Internet bandwidth: 1 Gbps, ECX Bandwidth: 1 & 10GbpsTestInternet (1 Gbps)ECX (1 Gbps)ECX (10 Gbps)ECX ImprovementNetwork Throughput (iperf3 –P 15)0.08 Gbits/sec0.999 Gbits/sec5.42 Gbits/secUp to 60x fasterLatency (ping avg)3.6 ms2.6 ms27% less latencyHops (traceroute)15940% more direct pathAbove results were collected across multiple samples at different times. Actual customer’s results will depend upon source & destination locations and the connectivity between those locationsConfidential – 2015 Equinix Inc.Equinix.com38
Lessons Learned1ABottlenecks areeverywhere:End – End throughput is asfast as the slowest pipe in thepipeline.Increased networkthroughput by using FastConnect will expose otherbottlenecks – sometimes bydesign Confidential – 2015 Equinix Inc.BBBBCDDDD32EThink parallel:Location matters:Fat pipes means multipleservices are simultaneouslyaccessible using Oracle FastConnect.Location matters especiallyfor latency and throughputsensitive IaaS / PaaSworkloadsEquinix.com39
For more details visit www.equinix.com/partners/oracle/Confidential – 2015 Equinix Inc.Equinix.com40
Program Agenda1Cloud Backup for On-Premises Databases2DR to Oracle Cloud using Active Data Guard3Oracle Fast Connect using Equinix4HA & DR options for PaaS/SaaS Databases in Oracle Cloud5Customer Use Case: Migrate Test/Dev to Oracle Cloud6Upcoming Oracle Cloud HA/DR Enhancements7SummaryCopyright 2015, Oracle and/or its affiliates. All rights reserved. 41
ExadataCloud ServiceOracle Database Cloud – EditionsEnterprise EditionStandard Edition 2Adds Full databaseinstance Limited to 16OCPUs All standard EEfeatures Block (Local) &Database BackupService Data Guard*Transparent DataEncryptionEE High PerformanceGeneralPurpose DBaaSEE Extreme PerformanceAdds Adds MultitenantPartitioningAdvancedCompressionLabel Security,Advanced Security,Database VaultRAC &RAC One NodeIn MemoryActive Data Guard*Real ApplicationTesting* Available soonCopyright 2015, Oracle and/or its affiliates. All rights reserved. 42
Exadata Service: Complete, Compatible, Secure, Available, Scalable37 Years of Database Innovation - Proven at Millions of Mission Critical DeploymentsMultitenantOffload SQL to StorageIn Memory DatabaseInfiniBand FabricReal ApplicationClustersSmart Flash Cache,Smart Flash LogActive Data GuardBackup & RecoveryAdvancedCompressionAdvanced Security,Label Security,Database VaultAll OracleDatabaseInnovationsAll ExadataMachineInnovationsPCI FlashColumnar FlashCacheHybrid ColumnarCompressionI/O ResourceManagementHCC10:1I/OI/OI/ONetwork ResourceManagementReal ApplicationTestingIn-Memory FaultToleranceOLAP, Analytics,Spatial and GraphExafusion Directto-Wire ProtocolManagementPacksCopyright 2015, Oracle and/or its affilia
Oracle Database Cloud Backup Module Install Tool, build 2015- 05-12 . . Synchronous or Asynchronous . Recommended Workloads . Good for most OLTP workload . High volume transactions, DW, . High Availability and Disaster Recovery for Or
NetWorker Server disaster recovery roadmap This guide provides an aid to disaster recovery planning an detailed step-by-step disaster recovery instructions. The following figure shows the high-level steps to follow when performing a disaster recovery of the NetWorker Server. Figure 1 Disaster recovery roadmap Bootstrap and indexes
4.2 State Disaster Recovery policy 4.3 County and Municipal Recovery Relationships 4.4 Recovery Plan Description 4.5 Recovery Management Structure and Recovery Operations 4.6 Draft National Disaster recovery Framework (February 5, 2010) 4.6.1 Draft Purpose Statement of the National Disaster Recovery Framework
1. Post-Disaster Recovery and Disaster Risk Reduction require support from community participation in improving the quality and objectives of Disaster Management; 2. Community-based Disaster Risk Reduction is a key factor in participatory disaster management, including in post-disaster recovery, as indicated by best practices in Yogyakarta and .
High Availability and Disaster Recovery Solutions for Perforce Basic Disaster Recovery This low-cost solution, which is far superior to tape backup alone, validates the usability of backups on a daily basis. This solution consists of two identically configured machines, one in the primary data center and another at a remote disaster recovery site.
community disaster—recognize that preparing for long-term disaster recovery demands as much attention as preparing for short-term response. After a major disaster, the recovery process takes months and even years to bring a community back to a "new normal" and as strong as or better than before the disaster. Disaster Recovery: A Local
Pre-Disaster Recovery Plan: A PDRP provides a framework for leading and managing recovery activities after a disaster. This may include providing human and social services to disaster survivors, gathering data used to develop strategies for an effective recovery, and organizing and managing resources for post-disaster recovery activities.
recovery mechanisms, and a formalized Disaster Recovery Committee that has responsibility for rehearsing, carrying out, and improving the disaster recovery plan. When a disaster strikes, the normal operations of the enterprise are suspended and replaced with operations spelled out in the disaster recovery plan.
1 Introduction to Oracle Fusion Middleware Disaster Recovery 1.1 Overview of Oracle Fusion Middleware Disaster Recovery 1-1 1.1.1 Problem Description and Common Solutions 1-1 1.1.2 Terminology 1-2 1.2 Setting Up Disaster Recovery for Oracle Fusion Middleware Components 1-5 1.2.1 Oracle Fusion Middleware Disaster Recovery Architecture Overview 1-5
