Oracle Database Upgrade and Migration Methods: Including Oracle 12c Release 2

✍ Scribed by Y V Ravikumar, K M Krishnakumar, Nassyam Basha (auth.)

• Publisher: Apress
• Year: 2017
• Tongue: English
• Leaves: 621
• Edition: 1
• Category: Library

✦ Synopsis

So it’s time to upgrade Oracle Database to version 12c and you need to choose the appropriate method while considering issues such as downtime. This book explains all of the available upgrade and migration methods so you can choose the one that suits your environment. You will be aware of the practical issues and proactive measures to take to upgrade successfully and reduce unexpected issues. You will learn best practices and recommendations for upgrading and will learn the patching process.

With every release of Oracle Database there are new features and fixes to bugs identified in previous versions. As each release becomes obsolete, existing databases need to be upgraded. Oracle Database Upgrade and Migration Methods explains each method along with its strategy, requirements, steps, and known issues that have been seen so far. The book also compares the methods to help you choose the proper method according to your constraints.

Also included in this book:

• Pre-requisite patches and pre-upgrade steps
• Patching to perform changes at the binary and database level to apply bug fixes
• Steps for upgrading using existing database backup
• Database downgrade steps in case the upgraded database isn’t compatible with your environment
• Steps to upgrade in a variety of environments, including high availability, multi-tenant, and e-business

✦ Table of Contents

Front Matter....Pages i-xxiii
Getting Started....Pages 1-17
Database Upgrade Methods....Pages 19-149
Comparison of Upgrade Methods....Pages 151-167
Upgrade Using a Database Backup....Pages 169-211
Oracle Database Migration....Pages 213-277
Migrating Oracle Database from Non-ASM to ASM Environments....Pages 279-321
Oracle GI and Oracle 12c Database Upgrades in RAC Environments....Pages 323-380
Database Upgrades in Data Guard Environments....Pages 381-424
Database Upgrades in EBS Environments....Pages 425-445
Multitenant Database Upgrades....Pages 447-489
Pluggable Database Migrations....Pages 491-502
Oracle Database Patching Strategies....Pages 503-545
Database Downgrades....Pages 547-563
Oracle Database Upgrades in Oracle Database Release 12.2....Pages 565-601
Back Matter....Pages 603-610

✦ Subjects

Database Management;Data Storage Representation;Information Storage and Retrieval