Oracle Database Upgrade, Migration & Transformation Tips & Techniques

A practical roadmap for database upgrade, migration, and transformation

This Oracle Press guide provides best practices for migrating between different operating systems and platforms, transforming existing databases to use different storage or enterprise systems, and upgrading databases from one release to the next. Based on the expert authors’ real-world experience, Oracle Database Upgrade, Migration & Transformation Tips & Techniques will help you choose the best migration path for your project and develop an effective methodology. Code examples and detailed checklists are included in this comprehensive resource.

• Leverage the features of Oracle Data Guard to migrate an Oracle Database
• Use Oracle Recovery Manager, transportable tablespace sets, and transportable database toolsets to migrate between platforms
• Migrate databases with export/import
• Use Oracle GoldenGate for zero or near-zero downtime migrations
• Take advantage of the Cross-Platform Transportable Tablespace Set utility
• Migrate to new storage platforms using the features of Oracle Automatic Storage Management
• Upgrade to Oracle Database 12c with the Database Upgrade Assistant tool
• Move seamlessly to Oracle’s engineered systems
• Migrate to the cloud

Table of Contents

Part I: Planning a Smooth Migration
Chapter 1 Overview Of Migration, Transformation, And Upgrade Methodologies
Chapter 2 Choosing The Right Migration Method
Chapter 3 Migration/Transformation/Upgrade Methodologies

Part II: Cross-Platform Migration
Chapter 4 Oracle Data Guard
Chapter 5 Using Recovery Manager (Rman) For Cross-Platform Migration
Chapter 6 Transporting Tablespaces And Databases

Part III: Migration with Enhancement/Upgrade
Chapter 7 Migrating Oracle Databases With Export/Import
Chapter 8 Zero Or Minimal Downtime Migrations With Oracle Goldengate
Chapter 9 Cross-Platform Transportable Tablespace Migration Utilities
Chapter 10 Migrating To New Storage Platforms Using Asm

Part IV: Optimized Upgrades/Migration
Chapter 11 Database Upgrade Assistant
Chapter 12 Migrating From Microsoft Sql Server To Oracle
Chapter 13 Moving To Oracle Database 12C
Chapter 14 Moving To Oracle Engineered Systems
Chapter 15 Migrating To Oracle In The Cloud

Part V: Best Practices and Tips
Chapter 16 In Summary: Recommendations, Reminders, And Best Practices