Lavoisier S.A.S.
14 rue de Provigny
94236 Cachan cedex
FRANCE

Heures d'ouverture 08h30-12h30/13h30-17h30
Tél.: +33 (0)1 47 40 67 00
Fax: +33 (0)1 47 40 67 02


Url canonique : www.lavoisier.fr/livre/informatique/oracle-database-upgrade-and-migration-methods/ravikumar-y-v/descriptif_4157278
Url courte ou permalien : www.lavoisier.fr/livre/notice.asp?ouvrage=4157278

0 article 

 Frais de port 0,01€*

Exclusivité web : à partir de 35 euros d’achat, frais de port à 1 centime pour les expéditions vers la France métropolitaine, la Suisse et l’UE avec Colissimo ou GLS

Oracle Database Upgrade and Migration Methods, 1st ed. Including Oracle 12c Release 2

Langue : Anglais

Auteurs :

Couverture de l’ouvrage Oracle Database Upgrade and Migration Methods

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

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

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.


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

Date de parution :

Ouvrage de 610 p.

17.8x25.4 cm

Disponible chez l'éditeur (délai d'approvisionnement : 15 jours).

73,84 €

Ajouter au panier