To Oracle Cloud And Beyond

2y ago
33 Views
2 Downloads
3.23 MB
54 Pages
Last View : 1d ago
Last Download : 2m ago
Upload by : Olive Grimm
Transcription

To Oracle Cloud and BeyondTop 5 Considerations ForMigrating Databases To OracleCloudOracle Platinum PartnerMOUSOctober 2020Charles Kim, Viscosity North America, Oracle ACE Director

@racdbaCharles Kim Oracle ACE Director, Author of 10 books Founder and CEO of Viscosity Expertise in Mission Critical Databases and Engineered SystemsRAC, Data Guard, ASM, RMAN, Shareplex/GoldenGate Specialize in “Complex Data Replication & Integration” with Shareplex & GG Oracle Exadata Certified Implementation Specialist, (2014, 2016) Oracle Management Cloud Certified Oracle Certified RAC Expert Oracle Certified Linux Expert

Agenda Why you need to upgrade to OracleDatabase 19c? Modernize to the Cloud Top 5 Considerations forMigrating Databases toOracle Cloud@ViscosityNA

Pluggable Databases Deep DiveReleased @OpenWorld 20172nd Edition @OpenWorld 2019#1.3 PDBs per CDB starting in Oracle Database 19cStarting in 20c, Single Tenant Databases onlyAsk me for a kindle copy @ ckim@ViscosityNA.comPDB Me ASAP!A Lazy DBA’s Guide to MasteringMultitenant Features ofOracle Database 12cR2@ViscosityNA

Evolution of the DBAKind of DBATimelineCLI DBAEarly 90’s DBAsGUI DBALate 90’s and Dot ComGoogle DBADot Com and 2000’siDBADot Com, IOUG iDBA Master CurriculumRAC DBAs (MAA DBAs)2000 after 9.2 (but major spike with 10.2) Data GuardDMA2010 Database Machine AdministratorvDBA / vRAC DBA2010 Evolving role of a DBA in the virtual worldCloud DBA2011 Database Consolidation with Private Database CloudOracle Database 12c Launches June 2013Public Cloud DBA2015 Oracle Public Cloud with Database Cloud Service, Database Backup Cloud Service,Storage Cloud Service, IaaS Cloud ServicePDBAs2017 Multi-Tenant with Oracle Database 12c Release 2GA – March 15, 2017“It is not the strongest or the mostintelligent who will survive but those whocan best manage [adapt to] change.”5

The Future of DBAs@ViscosityNA

DBA 3.0 Future Role Evolution of the Oracle DBA Changing World of the DBA Next Evolution of the DBA Cloud Journey OCI Gen2 Why we need to upgrade to Oracle Database 19c? Converged Database PDB is the future@ViscosityNA7

Changing World of the DBAOracle CloudAWSAzureGCSDockerDevOpsCloudera ScyllaMarkLogicDynamoDBVMwareCloud (VMC)On AWS andOCIDataArchitectureETL / ELTODIInformaticaPDB 19cChanges in20cApp nt

DbA 3.0Cloud DBANow the Autonomous DBAThe Autonomous Data Warehouse CloudThe Autonomous Transaction ProcessingThe Autonomous Transaction Processing - DedicatedThe Changing Role of the DBA: y-Avril-120343.aspxDBA 2.0 Is Dead. Long Live DBA 3.0! By Jim Czuprynskihttps://vimeo.com/204365694Oracle, a Data Company .@ViscosityNA

The Next Evolution of the DbABe RelevantBe SpecializedKind of DBATimelineNiche OracleExadata, ZFS, ODA, ZDLRA, RAC, Performance TuningMulti-Cloud AdministratorsAWS, Azure, Google & Oracle Cloud ArchitectsHybrid CloudHeterogeneous DBAsOracle, SQL Server, MySQL, PostgresLicense Management: Pushing customers to PostgresWeb DatabasesSnowFlake, Redshift, DynamoDB, RDSBig DataCloudera/Hadoop, HDFS, Hive, ImpalaData VirtualizationDelphix, ActifioNoSQLCassandra, MongoDB, Couchbase, MarkLogicGraph DBNeo4J, ArangoDB, Amazon Neptune, OrientDBData Architects, ETL SpecialistsADWC, ATP, ATP-D@ViscosityNA10

Be Data Driven Business FocusedData Management1. Elevate the conversation- It is not always a technology talk- Learn to pitch the ROI2. Understand your new role3. Be relevant- Adapt to the changing technology4. Show value- Understand the business need@ViscosityNA11

What DBAs are asked to doWe need more DBAs than ever Understand what businesses do Cloud is the future (Autonomous Databases, Exadata Cloud, Database Cloud) What is the role of the DBA here? Network Design in the Cloud? Security in the Cloud Hybrid Cloud Security Data-at-rest security Data-in-motion security Yet on-premises DBAs are still needed Skilled (niche expertise, heterogeneous) DBAs will have a bright future@ViscosityNA

DBA Jobs are not going away . Why?Complexity of IT Systems Databases are growingDatabase vendors automate more each year Vendors have generated more work for DBAs in the future DBAs are needed more than everThen you have Customers are trying to get off of Oracle Not as easy as it soundsThe DBA job maybe going away at your company BUT the DBA jobs will be available at other companies Even during Covid, organizations are hiring DBAs with expertiseNiche database need will never go away@ViscosityNA

Why Cloud?Common Use Cases

Accelerated Cloud Consumption - During Covid More cost-effective for companies to provision in the Cloud Who is going to rack and stack during Covid? Every hardware vendor is delayed on shipping Cost of cloud adoption 3-5 year TCO and ROI It is cheaper for companies to go to the cloud for the next year Even if the 1st year of cloud is lot more expensive During Covid, customers are willing to save money short term over long term costs

@ViscosityNA

The Cloud JourneyHybrid Cloud

Remember, Cloud is a JourneyInvest in the Right Cloud Licensing implication More to come: Oracle Universal Credits and BYOL Security concerns Data at rest Data in motion Look at the TCO Short term is always cheaper Look at 3 to 5 years of cost Cloud Bursting Bare Metal Cloud Dynamic CPU Spin Up and Down to address workload

Initial Cloud ExperienceLow Hanging Fruit Backup to the Cloud Eliminate off-site tape storage Leverage Object Storage On-Premise CommVault has backup replication to Cloud Oracle Storage Cloud Software Appliance Leverage Archive Storage

Use the Cloud as an Insurance PolicyCloud Experience - Tackle the Low Hanging Fruit First

Cloud BuzzHybrid Cloud? On-Premiseis going away?Which cloud is better foryou?Who is moving to theCloud? SMB? Fortune 500?What applications are goingto the cloud?What is realistic today?

Your Cloud Journey Oracle’s Cloud FirstPolicyHybrid CloudCloud Only CompaniesDrivers for CloudMulti-CloudLicensing on CloudCloud PitfallsCustomer’s Virtualize First Policy What does not mean?Customer’s Cloud First StrategyNext 5-7 Years?Who?The company that does IT-aaSCIOs want to get out of the Data Center BusinessCapEx versus OpExIssues and Concerns?Implications of Oracle licensing on Other CloudHidden CostsPay-as-you-goSecurity Concerns

Hybrid CloudVMware Cloud Solutions - On OCI– VMware Cloud on AWS Services– Google Cloud support VMware Cloud– Now Oracle Cloud Infrastructure supportsVMware Cloud Foundation– Run in Bare Metal Services– vSphere– Virtual network software NSX– Virtual storage software vSAN True Lift and Shift vMotion@ViscosityNA

Oracle 20c New Features Native blockchain table Secure ledger table managed by a trusted provider who has the bestsecurity in the world Create blockchain table [ledger of tables] Insert only Rows are cryptographically chained and trusted New JSON datatype Binary JSON datatype for SQL and PL/SQL SCANS up to 10x faster Updates up to 4x faster SQL Update now allows SET and REMOVE of JSON elements@ViscosityNA

Oracle 20c New Features In-Memory Support for Spatial and Text options 10x faster for Spatial 3x faster for Text Hybrid Scans In-memory scans get missing values from the buffer cache 10x faster hybrid queries Self-Managing In-Memory Auto In-Memory populate and evict No need to declare tables INMEMORY Persistent Memory For workloads that need lower latency than flash memory Keeps Data and Redo on local persistent Memory (PMEM) Eliminates I/O code path, no need for large buffer cache Can scale out using Native Database Sharding@ViscosityNA

Oracle 20c New Features Automatic Machine Learning (Auto ML) Automatically build and compare Machine Learning models Bring algorithms to the data, not data to the algorithm Oracle DB natively includes dozens of ML algorithms including deep learning Extend in-database algorithm with Pthon and R Easily deploy models via REST API Perform parallel ML directly in Data Warehouses or OLTP for fast modelbuilding and real-time scoring of the new data@ViscosityNA

The Autonomous Database Cloud (ADB) Self-Scaling AdministrationAdaptiveMachine Learning Fully automated patching, upgrades, backups, and availability architecture Foundation on Exadata, PDB With 18c/19c, Machine Learning, DW or OLTP Performance Workload@ViscosityNA

State of Oracle CloudOracle ClassicFY16@ViscosityNA

State of Oracle CloudOracle Added Some SpiceFY16@ViscosityNAFY17

State of Oracle CloudOracle is on the attackFY16@ViscosityNAFY17FY18

State of Oracle CloudOracle is on fireFY16@ViscosityNAFY17FY18FY19On Fire

State of Oracle CloudFY20Oracle is in it to win itFY16@ViscosityNAMicrosoft PartnershipVMware PartnershipMore RegionsFY17FY18FY19On Fire

Oracle’s Autonomous LinuxOracle Disclaimer: The following is intended to outline Oracle's general product direction. It is intended for information purposes only, and may not be incorporated into anycontract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The33development, release,and timing of any features or functionality described for Oracle's products remains at the sole discretion of Oracle.

Oracle Cloud at Customer Gen 2Oracle Exadata X8 Cloud Service - 25% of the Fortune Global 100 have adopted Exadata CloudOn-premise at the customer data centerSome Customers Cannot Move Gen 2 Exadata Cloud On-Premiseto Public CloudExadata Cloud Simplicity & ElasticityConsiderationsRegulationsDatabase as a service at your datacenterVirtualizedLatencyPublic Cloud Hardware & SoftwarePublic Cloud APIsDomU managed by thecustomerIntegrationPublic Cloud Operational ModelOracle ManagedGI managed by thecustomerRisk (Security, Compliance,QoS)Public Cloud Billing ModelSubscriptionNo noisy neighborsSeamless Integration with OCIDedicated to you@ViscosityNA

Migrate to CloudPerformance Considerations

PerformancePreserve StatisticsGather accurate performance statistics from productionAccurate means: Starting at least 1 month before the upgradeUse Automatic Workload Repository (AWR) Snapshots interval 30-60 minutes and retention 40daysExtract AWR:SQL @?/rdbms/admin/awrextr.sqlPerformance snapshot comparison using AWR DIFF reports:SQL select * from table(DBMS WORKLOAD REPOSITORY.AWR DIFF REPORT HTML( DBID , 1, 101, 121, DBID , 1, 201, 221));MOS Note:1477599.1 Best Practices Around Data Collection For Performance Issues

Pre-Upgrade/Migrate ConsiderationsMigrate Upgrade to Cloud Set Guaranteed Restore Points accordingly Ensure AWR retention is long enough to capture historical data for comparison Backup your database statistics, in case an older SQL plan needs restoring Definitely consider RAT for real workload testing, instead of synthetic workloads tests If upgrading older version of RAC to new version in place, special consideration need to be understood 9i RAC to 12c RAC Upgrade to 12c GI stack first, Flex ASM or not Legacy clients may not support new Net connections Execute dbupgdiag.sql (MOS 556610.1 to download this script) SQL alter session set nls language 'American';SQL @dbupgdiag.sql

Workload UtilizationNoisy Neighbors Know your current on-premise utilization Know your cloud subscription model capabilities When choosing the right cloud, make sure that you arecomparing apples to apples Customers often compare apples to watermelons

MonitoringDuring and After the Migration

Oracle Enterprise Manager 13c Cloud ControlCentralized Monitoring and Management6, 22, 38724903OEM OMS152122, 7802, 7102DesktopVMsGG: 5555, 555922 (ssh equivalenceoptionalas viscosity)Additional forViscosityMonitoringvmstats.ksh: 1521Database capacity: 15214034

AlertNotificationandEscalationCentralized MonitoringAlert NotificationSend alerts toDBAs, CellPhonesAlert NotificationMonitor DBsOEM Server(s)Alert NotificationMonitor DBsMonitor via OEMMonitor via Custom ScriptsSend alerts toDBAs, CellPhonesPerpetualPhone CallAlert NotificationMessages toCentralizedConsoleEscalatedPhone CallEscalatedPhone CallPrimary OncallDBASecondary OncallDBAManagement EscalationSend alerts toDBAs, CellPhones

Oracle Database19cEasily and Securely Migrate to Cloud-- Zero Downtime Live Migrate PDBs to Cloud-- Encrypt TDE Online

Mission CriticalZero Downtime MigrationsZero Risk With Reverse Replication

SharePlex Architecture With Oracle DatabasesMigration to Cloud Architecture44Confidential

Architecture for Database Migrationand UpgradePost Queue holds all transactions since activation of new config fileAll new transactions are being piled up in the post queueImportProcessLinuxStopped PostQueuetegraAIXActivate the newconfig for schemasASMCaptureQueuenoiatmfrocerutotso①Perform TTS Metadataimport②Perform no rows import③ Perform schema compares④Disable triggers, disablecascade delete constraintslicpeASMRPerform RMANImage Copy Backto file systemExportQueue①Create users,roles,profiles②RMAN convert ofendian format fromAIX to LinuxStaging ServerNoSPLEXscp database files source to target database serverSwing file system from source server to stagingserver (Same version OS, same version of DBbinaries)Synchronize StageServer DatabaseImage WithProduction DataCreate production image copy that is in sync with the source databaseTarget outage window: Zero or 5 minutes with database outage

Architecture for Database Migrationand Upgrade& Zero RISKPost Queue holds all transactions since activation of new config fileAll new transactions are being piled up in the post e the newconfig for schemasASMCapture QueuePerform RMANImage Copy Backto file systemExport Queueersvetoreckxle n baep tio tar ca rgeSh pli tar e om efr urcso① Disable triggers② Disable cascade delete constraintsmorftneoti targalic topRe urceso①① Start Post② Activate reverseconfig for schemasPerform TTS Metadataimport②Perform no rows import③ Perform schema compares④Disable triggers, disablecascade delete constraintsASMExportQueueCaptureQueue①Create users,roles,profiles②RMAN convert ofendian format fromAIX to LinuxStaging ServerNoSPLEXscp database files source to target database serverSwing file system from source server to stagingserver (Same version OS, same version of DBbinaries)LinuxStopped PostQueueSynchronize StageServer DatabaseImage WithProduction DataCreate production image copy that is in sync with the source databaseTarget outage window: Zero or 5 minutes with database outage

Fallback Strategy – Strategy Never start an upgrade or migration without evaluating and testing your options for goingback . Complete RMAN Online Backup is always a must Clarify: Fallback requirements in minutes/hours/daysHow to deal with issues happening during the upgradeHow to deal with issues hours/days after the upgradeWill you get additional downtime to change COMPATIBLE?Upgrade, Migrate & Consolidate to Oracle Database47

Multi-Cloud CustomerMigration Path to OCI Case Study Migration path to Oracle Cloud scp database files from on-premise to OCI Spend 2 days copying files over their fast connect Leverage GoldenGate for near zero downtime migration Leverage GoldenGate for near zero downtime upgrade to Oracle Database18c Upgraded from Standard Edition to Enterprise Edition TDE for on-line 256 AES encryption for every tablespace Including SYS, SYSTEM and SYSAUX Data Vault to keep DBAs out Step by Step Guide: How to Configure SSL/TLS on ORACLE RAC (withSCAN) (Doc ID 1448841.1)@ViscosityNA

Oracle Cloud InfrastructureBattle Wounds K.I.S.S. Continue to adopt N-1 Don’t chase after new OCI new features Oracle Database 19c on OCI has same kind of bugs like on-premise For mission critical databases, do not mix production and nonproduction on the same server With CDB, the ROI factor will want you to consolidate PROD andnon-PROD on the same container Treat PROD like PROD and isolate@ViscosityNA

Oracle Cloud InfrastructureBattle Wounds #2 Outage Maintenance Window from Oracle Remember that this customer is a mission critical customer Keep current of Oracle Cloud tooling Architect a like for like environment for PROD and lower environments For VLDB environments, make sure to test in the lower environmentfirst. A 100GB PDB clone works fine. A 2TB PDB clone needs to betested out.@ViscosityNA

Oracle Cloud InfrastructureRecommendations Routine Maintenance Notice from Oracle Be on top of it Work with partners like Viscosity to work with PMs Put your company at a priority to reduce the outage window What do DBAs need to know? We have this discussion within our own internal management? Why do we expect DBAs to know network, when we do not expect DBAs toknow network infrastructure on AWS?@ViscosityNA

Oracle Cloud InfrastructureOther Cloud Customers to Think About K.I.S.S Another customer who over architected Complex network architecture Complete isolation of PROD and non-PROD Configured a remote desktop to log into the PROD environment Financial customer Majority Microsoft SQL Server footprint Migrating data center to Equinix Upgrading Databases to 18c on 100% VMware@ViscosityNA

Follow Us y/Viscosity-North-America@ViscosityNAViscosity North AmericaFacebook.com/ViscosityNA@Viscosity NA53

Why you need to upgrade to Oracle Database 19c? . Public Cloud DBA 2015 Oracle Public Cloud with Database Cloud Service, Database Backup Cloud Service, Storage Cloud Service, IaaS Cloud Service PDBAs 2017 Multi-Tenant with O

Related Documents:

Visit cloud.oracle.com for information on our free 30-day trial, and visit our Oracle Data Visualization Cloud Service web page. Connect. Oracle Events Oracle Blog Get Social. Twitter: Oracle Cloud Zone Facebook: Oracle Cloud Computing LinkedIn: Oracle Cloud Solutions YouTube: Oracle Cloud Computing Qualogy Leverages Data Storytelling

Oracle Cloud Infrastructure Data Integration 5D992.c NLR Oracle Cloud Watch Dog EAR99 NLR Oracle Compute Cloud Service Bare Metal VMI EAR99 NLR Oracle Container Cloud Service 5D992.c NLR Oracle Container Registry Cloud Service 5D992.c NLR Oracle DataFox Cloud Service 5D992.c NLR Oracle

Oracle e-Commerce Gateway, Oracle Business Intelligence System, Oracle Financial Analyzer, Oracle Reports, Oracle Strategic Enterprise Management, Oracle Financials, Oracle Internet Procurement, Oracle Supply Chain, Oracle Call Center, Oracle e-Commerce, Oracle Integration Products & Technologies, Oracle Marketing, Oracle Service,

Oracle is a registered trademark and Designer/2000, Developer/2000, Oracle7, Oracle8, Oracle Application Object Library, Oracle Applications, Oracle Alert, Oracle Financials, Oracle Workflow, SQL*Forms, SQL*Plus, SQL*Report, Oracle Data Browser, Oracle Forms, Oracle General Ledger, Oracle Human Resources, Oracle Manufacturing, Oracle Reports,

E-Business Suite and HCM Cloud E-Business Suite and ERP/SCM Cloud E-Business Suite and CX Cloud 10 Oracle E-Business Suite and Practical Coexistence Scenarios Extend with SaaS –Hybrid is the New Normal 1.EBS ERP to Oracle HCM Cloud 2.EBS Payroll with Oracle HCM Cloud 3.EBS HCM to Oracle Taleo Cloud 4.EBS HCM to Oracle Talent Management Cloud .

7 Messaging Server Oracle Oracle Communications suite Oracle 8 Mail Server Oracle Oracle Communications suite Oracle 9 IDAM Oracle Oracle Access Management Suite Plus / Oracle Identity Manager Connectors Pack / Oracle Identity Governance Suite Oracle 10 Business Intelligence

Advanced Replication Option, Database Server, Enabling the Information Age, Oracle Call Interface, Oracle EDI Gateway, Oracle Enterprise Manager, Oracle Expert, Oracle Expert Option, Oracle Forms, Oracle Parallel Server [or, Oracle7 Parallel Server], Oracle Procedural Gateway, Oracle Replication Services, Oracle Reports, Oracle

Oracle Compute hosting Oracle Data Integrator, the Oracle BI Applications Configuration Manager and Oracle Database Cloud Service. See detailed deployment documentation published on Oracle Support. (Figure 2) Hybrid solutions deploy the BI semantic model, analyses and dashboards on Oracle Analytics Cloud with Oracle Data Integrator and Oracle .