Oracle Database Upgrade, Migration & Transformation Tips & Techniques

by Edward Whalen, Jim Czuprynski

Overview

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

Product Details

ISBN-13:	9780071846066
Publisher:	McGraw-Hill Education
Publication date:	06/12/2015
Sold by:	Barnes & Noble
Format:	eBook
Pages:	512
File size:	104 MB
Note:	This product may take a few minutes to download.

About the Author

Edward Whalen, Oracle ACE, is chief technologist at Performance Tuning Corporation (www.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.

Table of Contents

Part I – Planning a Smooth Migration
1.Overview of Migration Methodologies
2.Choosing the Right Migration Path
3.Migration / Upgrade Methodology

Part II – Cross-Platform Migration
4.Data Guard
5.Recovery Manager (RMAN)
6.Transporting Tablespaces and Databases

Part III – Migration with Enhancement / Upgrade
7.Export / Import
8.GoldenGate
9.Cross-Platform Tablespace Migration with Incremental Backups
10.Migrating to New Storage Platforms Using ASM

Part IV – Optimized Upgrades / Migrations
11.Database Upgrade Assistant
12.Moving to Oracle 11g
13.Moving to Oracle 12c
14.Moving to Oracle Engineered Systems

Part V – Best Practices and Tips
15.Using OEM 12c To Migrate Databases
16.Summary of Best Practices, Tips and Techniques