Skip to main content
  • Book
  • © 2017

Oracle Database Upgrade and Migration Methods

Including Oracle 12c Release 2

Apress
  • Explains each database upgrade/method in detail with its applicable environment
  • Provides steps for upgrading Oracle database using an existing database backup
  • Includes additional upgrade steps required for databases in high availability, e-Business, and multi-tenant environments
  • Presents upgrade best practices to ensure success without any unexpected issues
  • Covers Oracle Database 12c patching concepts

Buy it now

Buying options

eBook USD 59.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 74.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access

This is a preview of subscription content, log in via an institution to check for access.

Table of contents (14 chapters)

  1. Front Matter

    Pages i-xxiii
  2. Getting Started

    • Y V Ravikumar, K M Krishnakumar, Nassyam Basha
    Pages 1-17
  3. Database Upgrade Methods

    • Y V Ravikumar, K M Krishnakumar, Nassyam Basha
    Pages 19-149
  4. Comparison of Upgrade Methods

    • Y V Ravikumar, K M Krishnakumar, Nassyam Basha
    Pages 151-167
  5. Upgrade Using a Database Backup

    • Y V Ravikumar, K M Krishnakumar, Nassyam Basha
    Pages 169-211
  6. Oracle Database Migration

    • Y V Ravikumar, K M Krishnakumar, Nassyam Basha
    Pages 213-277
  7. Migrating Oracle Database from Non-ASM to ASM Environments

    • Y V Ravikumar, K M Krishnakumar, Nassyam Basha
    Pages 279-321
  8. Oracle GI and Oracle 12c Database Upgrades in RAC Environments

    • Y V Ravikumar, K M Krishnakumar, Nassyam Basha
    Pages 323-380
  9. Database Upgrades in Data Guard Environments

    • Y V Ravikumar, K M Krishnakumar, Nassyam Basha
    Pages 381-424
  10. Database Upgrades in EBS Environments

    • Y V Ravikumar, K M Krishnakumar, Nassyam Basha
    Pages 425-445
  11. Multitenant Database Upgrades

    • Y V Ravikumar, K M Krishnakumar, Nassyam Basha
    Pages 447-489
  12. Pluggable Database Migrations

    • Y V Ravikumar, K M Krishnakumar, Nassyam Basha
    Pages 491-502
  13. Oracle Database Patching Strategies

    • Y V Ravikumar, K M Krishnakumar, Nassyam Basha
    Pages 503-545
  14. Database Downgrades

    • Y V Ravikumar, K M Krishnakumar, Nassyam Basha
    Pages 547-563
  15. Oracle Database Upgrades in Oracle Database Release 12.2

    • Y V Ravikumar, K M Krishnakumar, Nassyam Basha
    Pages 565-601
  16. Back Matter

    Pages 603-610

About this book

Learn all of the available upgrade and migration methods in detail to move to Oracle Database version 12c. You will become familiar with database upgrade best practices to complete the upgrade in an effective manner and understand the Oracle Database 12c patching process.

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. 

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. This 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
What You Will Learn:

  • Understand the need and importance of database upgrading and migration
  • Be aware of the challenges associated with database upgrade decision making
  • Compare all upgrade/migration methods
  • Become familiar with database upgrade best practices and recommendations
  • Understand database upgrade concepts in high availability and multi-tenant environments
  • Know the database downgrade steps in case the upgraded database isn’t compatible with the environment
  • Discover the features and benefits to the organization when it moves from the old database version to the latest database version
  • Understand Oracle 12c patching concepts



Who This Book Is For:


Core database administrators, solution architects, business consultants, and database architects

Authors and Affiliations

  • Chennai, India

    Y V Ravikumar

  • Bangalore, India

    K M Krishnakumar

  • Nellore, India

    Nassyam Basha

About the authors

Nassyam Basha is an Oracle DBA, OCM 11g, Oracle ACE Director, author of the Data Guard 11gR2 book, blogger, OTN Super Hero, MOSC Guru, and writer with OTN, and DELL.  He has 9 years of hands-on experience in High Availability technologies such as Oracle RAC, Data Guard, Exadata, and much more. He currently works with The Pythian Group, In the past he has worked for AT&T (Bell Labs), dbaDirect, and SLK software services.


YV RaviKumar is an Oracle ACE and Oracle Certified Master (OCM) with over 17 years of experience in banking, financial services and insurance (BFSI), and played various roles such as Senior Database Architect and Production DBA Support for BFSI. He has written more than 30 OTN articles on Oracle Exadata, Oracle RAC, and Oracle Golden Gate in OTN-Spanish, OTN-Portuguese, and OTN-English. He also has written articles on Oracle Exadata, Oracle RAC, GoldenGate in TOAD World (Connected Intelligence), All Things ORACLE from Redgate &OTech Magazine-summer 2015. He is a member of the All India Oracle User Group (AIOUG) and a frequent Oracle speaker in OTN Yathra, AIOUG Sangam ,IOUG, and Exadata SIG. He designed, architected, and implemented the Core Banking System (CBS) Database for the Central Banks of two countries - India & Mahe, Seychelles. 


KM Krishna Kumar is a Database Administrator. He holds a Master of Business Administration degree from Anna University. He started working with Oracle technologies from 2004 as a DBA and worked with the Oracle Corporation for 5 years. He was involved in beta testing the database upgrade and wrote Oracle knowledge articles. He is an Oracle 11g and 12c Certified professional and has knowledge of Oracle technologies in areas such as installation, patching, migration, DB upgrade using various methods, Data Guard, RMAN, and RAC. He has delivered presentations to customers through various channels.





Bibliographic Information

Buy it now

Buying options

eBook USD 59.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 74.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access