Oracle Database Upgrade - NEOOUG
Oracle Database UpgradeRoy SwongerVice PresidentDatabase Upgrade and UtilitiesOracle CorporationUpdated: 5-MAY-2019Copyright 2019, Oracle and/or its affiliates. All rights reserved. Upgrade / Migrate / Consolidate to Oracle 19cPhoto by DJ Johnson on UnsplashFallback Strategies In Action
Roy F. SwongerVice PresidentOracle Database Upgrade and UtilitiesRoyFSwongerCopyright 2019, Oracle and/or its affiliates. All rights reserved. Upgrade / Migrate / Consolidate to Oracle 19c2
Slides and more https://MikeDietrichDE.comCopyright 2019, Oracle and/or its affiliates. All rights reserved. Upgrade / Migrate / Consolidate to Oracle 19c3
Photo by Hermes Rivera on UnsplashFallback StrategiesLive in ActionCopyright 2019, Oracle and/or its affiliates. All rights reserved. Upgrade / Migrate / Consolidate to Oracle 19c4
Photo by asoggetti on UnsplashConsiderationsFallback IntroductionCopyright 2019, Oracle and/or its affiliates. All rights reserved. Upgrade / Migrate / Consolidate to Oracle 19c5
Considerations Service Level Agreements COMPATIBLE Change?COMPATIBLECopyright 2019, Oracle and/or its affiliates. All rights reserved. Upgrade / Migrate / Consolidate to Oracle 19c6
Fallback Strategy COMPATIBLE?COMPATIBLE Recommendation:– Update COMPATIBLE 7-10 days after upgrade Why wait?– Allows fallback options: downgrade, flashback Why change?– Enable new features (e.g. online datafile move, sharding etc)– Minimum COMPATIBLE for 18c is 11.0.0– COMPATIBLE is independent of OPTIMIZER FEATURES ENABLE How?– alter system set compatible '19.0.0' scope spfile;Copyright 2019, Oracle and/or its affiliates. All rights reserved. Upgrade / Migrate / Consolidate to Oracle 19cnDowTime7
Fallback Strategy COMPATIBLE When should you change COMPATIBLE?– -should-you-change-compatible/?COMPATIBLE Should you change COMPATIBLE when youapply an RU?– ange-compatible-when-you-apply-an-ru/Copyright 2019, Oracle and/or its affiliates. All rights reserved. Upgrade / Migrate / Consolidate to Oracle 19c8
Fallback Strategy Install and PatchingUpdate in Place123 Complex Error prone Longest down-time andmaintenance window No fallback No standardizationClone, Update and Switch1 Complex Error prone23 Shorter down-time andmaintenance window Built-in Fallback No standardizationDeploy Gold Image, Switch12 Build gold image once,use everywhere Fewest steps, simplestprocess Shorter down-time andmaintenance window Built-in Fallback Built-in standardizationCopyright 2019, Oracle and/or its affiliates. All rights reserved. Upgrade / Migrate / Consolidate to Oracle 19c9
Database Upgrade Blog Fallback Exercises llback-strategies/Copyright 2019, Oracle and/or its affiliates. All rights reserved. Upgrade / Migrate / Consolidate to Oracle 19c10
Protection Issues during upgradeDuring Upgrade Issues after upgradeAfter UpgradeCopyright 2019, Oracle and/or its affiliates. All rights reserved. Upgrade / Migrate / Consolidate to Oracle 19c11
Fallback Strategy Issues during upgrade Online Backup– Solution: Restore online backup– Recommendation: Mandatory strategyCOMPATIBLE Partial Offline Backup– Solution: Restore partial offline Backup– Recommendation: Only for VLDBs anddatabases in NOARCHIVELOGmode For Standard Edition DBsCOMPATIBLEDuring Upgrade Guaranteed Restore Point– Solution: Flashback to GRP– Recommendation: Very fast, simply - but EE onlyCOMPATIBLECopyright 2019, Oracle and/or its affiliates. All rights reserved. Upgrade / Migrate / Consolidate to Oracle 19c12
Fallback Online Backup Strategy: Restore a backup and recover– Complete online backup (RMAN)– Please verify: Where is your backup located? Tapes, HD, off site.Does the restore work?How long will the restore take?How long will the recovery take?– Recommendation: Have a valid online backup in any case – and test the restore/recovery!!!Copyright 2019, Oracle and/or its affiliates. All rights reserved. Upgrade / Migrate / Consolidate to Oracle 19c13
Fallback Offline Backup Restore a partial offline TDOWN IMMEDIATE----USERSReadCOPYOnly ALL FILESSYSAUXRead OnlyUNDOSHUTDOWN IMMEDIATE----COPY ALL ILESDRSYSODMREDOREDOREDOCopyright 2019, Oracle and/or its affiliates. All rights reserved. Upgrade / Migrate / Consolidate to Oracle 19c14
Copyright 2019, Oracle and/or its affiliates. All rights reserved.
Fallback Guaranteed Restore Point COMPATIBLE must not be changedPre Upgrade EnvironmentPost Upgrade EnvironmentCREATE RESTORE POINT grptGUARANTEE FLASHBACK DATABASE;UPGRADESHUTDOWN IMMEDIATESTARTUP MOUNT;FLASHBACK DATABASE TO RESTORE POINT grpt;SHUTDOWN IMMEDIATESTARTUP MOUNT;ALTER DATABASE OPEN RESETLOGS;DROP RESTORE POINT grpt;Copyright 2019, Oracle and/or its affiliates. All rights reserved. Upgrade / Migrate / Consolidate to Oracle 19c16
Copyright 2019, Oracle and/or its affiliates. All rights reserved.
Fallback Strategy Issues after upgrade Data Pump– Solution: Reimport data– Recommendation: Simple but potentially slowCOMPATIBLE Oracle GoldenGate– Solution: Apply changes to previoussystem– Recommendation: Fastest and best solutionCOMPATIBLEAfter Upgrade Downgrade– COMPATIBLE change: No– Solution: Run the downgrade scripts– Recommendation: Fast and easyCOMPATIBLECopyright 2019, Oracle and/or its affiliates. All rights reserved. Upgrade / Migrate / Consolidate to Oracle 19c18
Fallback Data Pump Downgrade with expdp/impdp MOS Note:553337.1– Prepare an empty database for the import “just in case”– Then:– Run expdp from the 12.1 database home with the VERSION parameter equal to the target databaseCOMPATIBLE setting– Import using impdp from the targetdatabase home– NETWORK LINK can be usedfor downgrades as wellCopyright 2019, Oracle and/or its affiliates. All rights reserved. Upgrade / Migrate / Consolidate to Oracle 19c19
Fallback Data Pump11.2.0.418cimpdpexpdp VERSION 11.2.0.4DUMP FILEDUMP FILECopyright 2019, Oracle and/or its affiliates. All rights reserved. Upgrade / Migrate / Consolidate to Oracle 19c20
Fallback GoldenGate Downgrade with Oracle GoldenGate– Version/platform wngrade”1Copyright 2019, Oracle and/or its affiliates. All rights reserved. Upgrade / Migrate / Consolidate to Oracle 19c21
Fallback Database Downgrade Downgrade with catdwgrd.sql Resources:– Upgrade Guide – Downgrading a database to an earlier terupgrade.html– MOS Notes about downgrade: Oracle DB 18c - How to Downgrade a 18c Non CDB Database to Previous Release (Doc ID 2416661.1) Oracle 18c - How to Downgrade a Single Pluggable Oracle Database ( PDB ) from 18c Database toprevious release (Doc ID 2421060.1) Downgrade possible to: Oracle 11.2.0.4 and up (for non-CDB) and Oracle 12.1.0.2 and up (CDB/PDB) Do not change COMPATIBLECopyright 2019, Oracle and/or its affiliates. All rights reserved. Upgrade / Migrate / Consolidate to Oracle 19c22
Fallback Database Downgrade Basic steps to downgrade with catdwgrd.sql– In Oracle Database 18c environment:SQL SQL SQL SQL SQL SPOOL /tmp/downgrade.logSTARTUP DOWNGRADE@catdwgrd.sqlSHUTDOWN IMMEDIATESPOOL OFF– In Oracle Database 11.2.0.3 - 12.2.0.1 environment:SQL SQL SQL SQL STARTUP UPGRADESPOOL /tmp/reload.log@catrelod.sqlSPOOL OFFCopyright 2019, Oracle and/or its affiliates. All rights reserved. Upgrade / Migrate / Consolidate to Oracle 19c23
Copyright 2019, Oracle and/or its affiliates. All rights reserved.
Fallback Grid Infrastructure Downgrade For details BAF-8E84ECEBCC58Copyright 2019, Oracle and/or its affiliates. All rights reserved. Upgrade / Migrate / Consolidate to Oracle 19c25
Photo by Satyawan Narinedhat on UnsplashFallback is importantNever approach an upgrade or migrationwithoutyour fallback options!Copyright 2019, Oracle and/or its affiliates. All rights reserved. Upgrade / Migrate / Consolidate to Oracle 19c
Slides and more https://MikeDietrichDE.comCopyright 2019, Oracle and/or its affiliates. All rights reserved. Upgrade / Migrate / Consolidate to Oracle 19c27
More Information www.oracle.com/goto/upgradeCopyright 2019, Oracle and/or its affiliates. All rights reserved. Upgrade / Migrate / Consolidate to Oracle 19c28
Copyright 2019, Oracle and/or its affiliates. All rights reserved. Upgrade / Migrate / Consolidate to Oracle 19c29
Oracle DB 18c -How to Downgrade a 18c Non CDB Database to Previous Release (Doc ID 2416661.1) Oracle 18c -How to Downgrade a Single Pluggable Oracle Database ( PDB ) from 18c
Direct Upgrade to Oracle Database 12c A direct upgrade is one where either the Database Upgrade Assistant (DBUA) or command-line upgrade script is used to upgrade your database to Oracle Database 12c. Direct upgrade is supported when the source database is running one of the releases shown in the following table: TABLE 1.File Size: 545KBPage Count: 23
ORACLE DATABASE UPGRADE MOHAMMAD SHOAIB ANSARI Page 2 of 37 Oracle database upgrade steps can be summarised as follows 1. PRE-REQUISITES a. Check Database Upgrade Certification Matrix b. Check OS Certification Matrix c. Oracle 19c Binaries Installation for Upgrade d. Oracle 12c Database RMAN Backup e. Check For Invalid Objects f.
viii Related Documentation The platform-specific documentation for Oracle Database 10g products includes the following manuals: Oracle Database - Oracle Database Release Notes for Linux Itanium - Oracle Database Installation Guide for Linux Itanium - Oracle Database Quick Installation Guide for Linux Itanium - Oracle Database Oracle Clusterware and Oracle Real Application Clusters
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,
2 Installing Oracle Database and Creating a Database 2.1 Overview of Installing Oracle Database Software and Creating a Database 2-1 2.1.1 Checking Oracle Database Installation Prerequisites 2-2 2.1.2 Deciding on Oracle Database Installation Choices 2-3 2.1.2.1 Install Option for Oracle Database 2-3 2.1.2.2 Installation Class for Oracle .
3 ZERO DOWNTIME DATABASE UPGRADES USING ORACLE GOLDENGATE Database Upgrade Options A database upgrade advances the Oracle Database software release number from one version to another. There are two primary ways to perform an upgrade. There are numerous methods to upgrade a database, a
Getting Started with Database Classic Cloud Service. About Oracle Database Classic Cloud Service1-1. About Database Classic Cloud Service Database Deployments1-2. Oracle Database Software Release1-3. Oracle Database Software Edition1-3. Oracle Database Type1-4. Computing Power1-5. Database Storage1-5. Automatic Backup Configuration1-6
