Sumário Itens Encontrados: 319Chapter 1: Getting Started 1Chapter 2: Database Upgrade Methods 19Chapter 3: Comparison of Upgrade Methods 151Chapter 4: Upgrade Using a Database Backup 169Chapter 5: Oracle Database Migration 213Chapter 6: Migrating Oracle Database from Non-ASM to ASM Environments 279Chapter 7: Oracle GI and Oracle 12c Database Upgrades inRAC Environments 323Chapter 8: Database Upgrades in Data Guard Environments 381Chapter 9: Database Upgrades in EBS Environments 425Chapter 10: Multitenant Database Upgrades 447Chapter 11: Pluggable Database Migrations 491Chapter 12: Oracle Database Patching Strategies 503Chapter 13: Database Downgrades 547Chapter 14: Oracle Database Upgrades in Oracle Database Release 12.2 565Index 603Why Are Database Upgrades Necessary? 1New Innovations 3Bug Fixes 3Supporting Environment 4Certification 4Database Support Level 4Benefits of a Database Upgrade 4Hurdles That Affect the Database Upgrade Decision 5Types of Database Upgrade 6Things to Consider Before Upgrading 7Engineers Involved in the Upgrade Activity 9Database Administrator 10Storage Administrator 11System Administrator 11Network Administrator 11Solution Architect 11Application Team 12Upgrade Compatibility Matrix 12Best Practices for a Database Upgrade 14Database Migration 16Situations That Demand a Migration 16Things to Consider Before Migration 17What This Book Covers 17Summary 17Oracle Binary Relinking 19Relinking Process 20Known Issues 21Database Upgrade Methods 21The Database Upgrade Assistant 22Prerequisites for the DBUA 23Upgrade Compatibility Matrix 24Pre-upgrade Checks 25Activities Performed by the DBUA 26Best Practices with the DBUA 26Upgrade Steps 28Sample Restore Script 3112c DBUA New Features 42DBUA Upgrade Steps 54How to Make Sure the Upgrade Is Successful 56DBUA in Silent Mode 57Comparison Between 11g R2 DBUA and 12c R1 DBUA 59Database Manual Upgrade 61Pre-upgrade Tasks 62Execution Method 63Recommended Steps for the Source Database 66Upgrade Steps 7112c Upgrade Script Execution 73Parallelism 73Phases 74Post-upgrade Steps 75Comparison Between 11g R2 and 12c R1 79Traditional Export/Import 81Compatibility Version Matrix 81Upgrade Steps 82Data Pump 85Parallel 85Upgrade Steps 87Transportable Tablespace 90Things to Consider 91Prerequisites to Perform Transportable Tablespace 91Upgrade Steps 92Limitations 97Advantages 98Database Upgrade Using Oracle GoldenGate 98Planning Phase with Oracle GoldenGate 98Configuration Setup at the Source Database (Oracle 11g) 105Configuration Setup at the Target Database (Oracle 12c) 111Configuration Setup at the Target Database (Oracle 12c for Oracle GoldenGate 12c) 113High Availability or Fallback Option Using the Source Database (Oracle 11g) 119Configuration Setup at Target Database Oracle 12c and Implementing BidirectionalData Replication Between Target Database (pdb12c) and Source Database (Oracle 11g) 120Configuration Setup at Source Database Oracle 11g and Implementing BidirectionalData Replication Between Target Database (pdb12c) and Source Database (Oracle 11g) 123Summary 126Create Table As Select (CTAS) 126CTAS vs. COPY 127Advantages of CTAS 127Disadvantages with CTAS 127How Does CTAS Work? 127Requirements 128Parallel Usage with CTAS 130Order By with CTAS 130Summary 131Database Upgrades Using Transient Logical Standby 131Create a Restore Point 135Enable Supplementary Logging 136Upgrade of Logical Standby Database 136Manual Upgrade Using the 12c Method 137Switchover 137Initiate Flashback 138Convert Logical to Physical Standby 138Starting MRP 138Switchover 138Full Transportable Export/Import 139Prerequisites 140Upgrade Steps 140Summary 149The DBUA 151Features 151Limitations 152Manual/Command-Line Upgrade 152Features 153Limitations 153Comparison of the DBUA and Manual Processes 154Traditional Export/Import and Data Pump 155Features 155Limitations 155Data Pump 155Transportable Tablespaces 156Steps in Summary 156Features 157Limitations 157Full Transportable Export/Import 157Limitations 158Transient Logical Standby 158Switchover Best Practices 159Features 159Limitations 159Oracle GoldenGate 160Comparison of All Methods 161Real Application Testing 161Benefits of Using RAT 162How to Choose the Best Upgrade Method 162Database Downtime 163Getting Additional Storage 165Number of Actions and Required Skill Set 165Total Time Allotted 166Unsupported Features 166Number of User Objects 166Source Database Version 166Change of Platform 167Summary 167Introduction 169What Are the Various Backup Techniques? 170Cold Backup (Traditional) 171Hot Backup (User-Managed) 180Logical Backup (expdp/impdp) 190Prerequisites 191Objects Count 191Check NLS Settings 192Datafiles and Metadata 193Check the Invalid Objects from the Target Database 194Registry Components at the Target Database 194Create Triggers of the SYS Schema 195Database Export Using expdp 196Importing the Database (impdp) 197RMAN Backup 201Summary 211Traditional Export/Import 213Export 214Output 215Import 216Output 216Data Pump 217Data Pump Working Process 218Features 218Partition 220Merge 221Departition 221REMAP_DATAFILES 222REUSE_DATAFILES 222REMAP_TABLESPACE 222Transportable Tablespaces 223Oracle GoldenGate 228Environment Setup 228Oracle GoldenGate Setup on the Source Database 229Oracle GoldenGate Setup on the Target Database 230Configure Oracle GoldenGate on the Source Database 232Changes in Parameters in the Source Database 233Start Oracle GoldenGate Manager 239Configure Oracle GoldenGate on the Target Database 243Method 2: Initial Load with Bulkload 246CTAS 249Transport Database 252Migrate Steps 253Heterogeneous Standby Database 268Oracle Streams 270Summary 277Scenario 1: Moving datafiles online from a non-ASM location to an ASM location 281Scenario 2: Migrating an Oracle Database 12c CDB with PDBs from anon-ASM to ASM using EM 13c 297Scenario 3: Migrating an Oracle Database 12c CDB with PDBs from anon-ASM to ASM using RMAN 310Summary 321Run the CVU Pre-upgrade Check Tool 324Running the Oracle RAC Configuration Audit Tool (ORAchk) Tool 326Execution Steps for ORAchk 326Consider Real Application Testing 328Performing a Rolling Upgrade Using Oracle GI 328Scenario 1: Upgrading Oracle 11g RAC (11.2.0.3.0) to Oracle 12c RAC (12.1.0.2.0) 341Scenario 2: Manual upgrade of Oracle 11g RAC (11.2.0.3.0) toOracle 12c RAC (12.1.0.2.0) 369Scenario 3: Upgrading of Oracle 11g RAC (11.2.0.3.0) toOracle 12c RAC (12.1.0.2.0) with GI and Database using EMCC 13c 378Summary 380Upgrading Data Guard from 11.2.0.4 to 12.1.0.2 382Pre-upgrade Steps 382Review of the Pre-upgrade Log 384Upgrade the Data Guard Environment 389Post-upgrade Tasks 405Summary 410Rolling Database Upgrades Using DBMS_ROLLING in 12c 410Rolling Upgrades in 11g vs. DBMS_ROLLING in 12c 410DBMS_ROLLING: 12c 411Summary 424Prerequisite Steps 425Pre-upgrade steps 426Upgrade Steps 427Post-upgrade Steps 427Example 428Apply the Prerequisite Patches to the Apps Home 438Apply the Prerequisite Patches to the Database Home 438Shut Down the Application Process 439Execute cr9idata.pl 439Drop the sys.enabled$indexes Table 439Execute the Pre-upgrade Scripts 439Check the Database Componentsâ Status 440Check the Invalid SYS/SYSTEM Schema Objects 440Drop the MGDSYS Schema 440Upgrade the Database to the 12c Version 441Post-upgrade Steps for an EBS Database Upgrade 442Summary 445Multitenant Architecture 448Move the Lower-Version Database to the Multitenant Architecture 450Container Database Upgrade 454Database Upgrade Assistant 458Manual Database Upgrade or Command-Line Upgrade 463Upgrade Steps 468Post-upgrade Tasks 479Pluggable Database Upgrade 479Summary 489The Need for Migration 491Migration Steps 492Same Endian Format 492Different Endian Format 496Summary 502What a Patch Contains 504inventory.xml 504actions.xml 506How Patching Works 506Central Inventory 506Re-creation Steps 509How to Remove from the Central Inventory 511Local Inventory 512Using the Opatch Tool 513Types of Patches 516Patch Set Update (PSU) 516Security Patch Update (SPU) 516Bundle Patches 517One-Off Patches 517Proactive Bundle Patches. 517Conflicts 517Overlay Patches 517Patch Apply Strategies (Online and Offline Patching) 518Patch Apply Steps 524Applying Patch in Offline Mode 524Patching in Online Mode 527Post-Patch Steps 528Patch Rollback 528Opatch Debug 529PSU and SPU Patching 529PSU Patch Apply Steps 530How to Confirm the PSU Patch Apply Is Successful 532PSU Rollback 533SPU Patching 535Patch Apply Steps in RAC and Data Guard Environments 537Patching in an RAC Environment 537Patching in a Data Guard Environment 539PSU/SPU Patch Apply in a Data Guard Environment 540Datapatch 540Queryable Patch Inventory 542Limitations of Downgrading 547Downgrade Steps for Multitenant Databases 550Downgrade Steps Using Database Flashback 554Upgrade Steps 554Downgrade Steps 555Downgrade Steps Using Database Flashback for Multitenant Databases 558Upgrade Steps 558Downgrade Steps 559Known Issues 563Summary 563Upgrading to the 12.2 Release (12.2.0.1.0) 565Pre-upgrade Checks: Whatâs New in 12.2 565Steps 566Upgrade Emulation 570Database Upgrade Assistant 573Upgrade Steps 574DBUA in Silent Mode 583New 12.2 DBUA Features 583Manual Database Upgrade/Command-Line Upgrade 583Upgrade Steps 586Post-upgrade Tasks 588Oracle 12.2 New Manual Upgrade Features 590Pluggable Database Upgrade 590Pluggable Database Upgrade Steps 591Manual Upgrade of Pluggable Database in 12c R2 596Target 12.2 Environment 597Start PDB12cR2 in Upgraded Mode 598Downgrade 12.2 to Earlier Versions 598Prerequisites 599Downgrade Steps for the Entire Container Database 599Summary 601Abou