Oracle Database Upgrade, Migration & Transformation Tips & Techniques
- 4h 21m
- Edward Whalen, Jim Czuprynski
- Oracle Press
- 2015
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
About the Authors
Edward Whalen, Oracle ACE, is chief technologist at Performance Tuning Corporation (perftuning.com), a consulting company specializing in database performance, administration, virtualization, and disaster recovery solutions. He is the author of Oracle Enterprise Manager Cloud Control 12c Deep Dive and other Oracle Press books.
Jim Czuprynski, OCP, is an Oracle Database administrator and teaches core Oracle University database administration courses on behalf of Oracle and its Education Partners throughout the United States and Canada. He is the author of nearly 100 articles and a blog on Oracle technologies.
In this Book
-
Oracle Database Upgrade, Migration & Transformation Tips & Techniques
-
Introduction
-
Overview of Migration, Transformation, and Upgrade Methodologies
-
Choosing the Right Migration Method
-
Migration/Transformation/Upgrade Methodologies
-
Oracle Data Guard
-
Using Recovery Manager (RMAN) for Cross-Platform Migration
-
Transporting Tablespaces and Databases
-
Migrating Oracle Databases with Export/Import
-
Zero or Minimal Downtime Migrations with Oracle GoldenGate
-
Cross-Platform Transportable Tablespace Migration Utilities
-
Migrating to New Storage Platforms Using ASM
-
Database Upgrade Assistant
-
Migrating from Microsoft SQL Server to Oracle
-
Moving to Oracle Database 12c
-
Moving to Oracle Engineered Systems
-
Migrating to Oracle in the Cloud
-
In Summary: Recommendations, Reminders, and Best Practices
