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