Książki

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

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

PART I: packetC Background 1







CHAPTER 1: Getting Started 3







Introduction to Database upgrade







Necessities of Database upgrade







Benefits of Database upgrade







Hurdles that affect Database upgrade







decision







Types of Database upgrade







Things to consider before upgrade







Engineers involved in upgrade activity







Upgrade compatibility matrix







Best practices of Database upgrade







Database Migration







Situations demand Migration







Things to consider before migration







summary















PART II: Language Reference 53







n CHAPTER 2: Database Upgrade methods 55







DBUA







Manual/Command line upgrade







Export/Import







Datapump







Transportable Tablespace







Golden Gate







Create Table as Select (CTAS)







Transient Logical Standby







Full Transportable Tablespace







Summary







n CHAPTER 3: Comparison between upgrade methods 151







Comparison between methods 9







Real Application testing (RAT) 10







How to choose best Upgrade method 11







Summary







n CHAPTER 4: Upgrade using Database backup 159







Cold backup







Hot backup (User-Managed)







Logical backup (expdp/impdp)







RMAN backup (using duplicate option)







Summary







n CHAPTER 5: Database Migration methods 171







Export/Import







Datapump







Transportable Tablespace (TTS)







Golden Gate







Copy table as select (CTAS)







Transport Database







Heterogenous Standby database







Oracle Streams







Summary







n CHAPTER 6: Migration of Oracle database from Non-ASM to ASM 175







Introduction







Moving Datafiles Online from NON-ASM <



to ASM







Migrating Oracle 12c CDB with PDBs from







NON ASM to ASM using EM Cloud Control 13c ...............







Migrating Oracle 12c CDB with PDBs from







NON ASM to ASM using RMAN







Summary







n CHAPTER 7: GI and DB upgrade in RAC environment 205







Introduction







CVU Pre-Upgrade Check tool







Execution Steps for ORAchk







Rolling upgrade for Oracle GI







Upgrading 11g RAC to 12c RAC using DBUA







Upgrading 11g RAC to 12c RAC Manual







Upgrading 11g RAC to 12c RAC using EM 13c







Summary















PART III: Developing Applications 215







n CHAPTER 8: Database upgrade in DG environment 217







Dummy Text







Dummy Text







Virtual Dummy Text







Dummy Text







Dummy Text







Dummy Text Flow







Dummy Text







Summary







n CHAPTER 9: Database upgrade in EBS environment 223







Prerequisite steps







Preupgrade steps







Upgrade steps







Post upgrade steps







Summary



CHAPTER 10: Database upgrade in 12c Multitenant environment







Migrate lower version database to Multitenant architecture







Container database upgrade







Pluggable database upgrade







Summary







n CHAPTER 11: Databases migrate in Multitenant environment 237







Pluggable database migrate







Need for Migrate







Migration steps







Summary







n CHAPTER 12: Oracle Database Patching Stratergies 245







Patching Introduction







Opatch tool







Types of patches







Patch apply stratergies (online and offline patching)....







PSU and SPU patching







Patch apply in RAC and DG environment







Datapatch







Queryable patch inventory







Summary







n CHAPTER 13: Database Downgrade 263







Introduction







Limitations of Oracle database downgrade







Database downgrade steps







Downgrade using database flashback







Summary







n CHAPTER 14: Database upgrade in 12.2 281







Preupgrade checks







Upgrade Emulation







DBUA







Manual Database upgrade







Pluggable database upgrade







Downgrade 12.2 database to earlier version...............







Summary







n







n APPENDIX A: Reference Tables 383







n APPENDIX B: Dummy Text 395















INDEX 433