Oracle Database Upgrade and Migration Methods (eBook)
XXIII, 610 Seiten
Apress (Verlag)
978-1-4842-2328-4 (ISBN)
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
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 stepsPatching to perform changes at the binary and database level to apply bug fixesWhat You Will Learn:Understand the need and importance of database upgrading and migrationBe aware of the challenges associated with database upgrade decision makingCompare all upgrade/migration methodsBecome familiar with database upgrade best practices and recommendationsUnderstand database upgrade concepts in high availability and multi-tenant environmentsKnow the database downgrade steps in case the upgraded database isn't compatible with the environmentDiscover the features and benefits to the organization when it moves from the old database version to the latest database versionUnderstand Oracle 12c patching conceptsWho This Book Is For:Core database administrators, solution architects, business consultants, and database architects
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.
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
| Erscheint lt. Verlag | 1.3.2017 |
|---|---|
| Zusatzinfo | XXIII, 610 p. 235 illus., 189 illus. in color. |
| Verlagsort | Berkeley |
| Sprache | englisch |
| Themenwelt | Informatik ► Datenbanken ► Data Warehouse / Data Mining |
| Informatik ► Datenbanken ► Oracle | |
| Schlagworte | CDB Upgrade • Datapump • golden gate • Oracle Database • Oracle Database Patching Strategies • Oracle Database Upgrade 12c • Oracle Database Upgrading and Migration • PDB Upgrade • Transient Logical Standby • Transportable Table Space |
| ISBN-10 | 1-4842-2328-4 / 1484223284 |
| ISBN-13 | 978-1-4842-2328-4 / 9781484223284 |
| Haben Sie eine Frage zum Produkt? |
PDF (Wasserzeichen)Größe: 19,4 MB
DRM: Digitales Wasserzeichen
Dieses eBook enthält ein digitales Wasserzeichen und ist damit für Sie personalisiert. Bei einer missbräuchlichen Weitergabe des eBooks an Dritte ist eine Rückverfolgung an die Quelle möglich.
Dateiformat: PDF (Portable Document Format)
Mit einem festen Seitenlayout eignet sich die PDF besonders für Fachbücher mit Spalten, Tabellen und Abbildungen. Eine PDF kann auf fast allen Geräten angezeigt werden, ist aber für kleine Displays (Smartphone, eReader) nur eingeschränkt geeignet.
Systemvoraussetzungen:
PC/Mac: Mit einem PC oder Mac können Sie dieses eBook lesen. Sie benötigen dafür einen PDF-Viewer - z.B. den Adobe Reader oder Adobe Digital Editions.
eReader: Dieses eBook kann mit (fast) allen eBook-Readern gelesen werden. Mit dem amazon-Kindle ist es aber nicht kompatibel.
Smartphone/Tablet: Egal ob Apple oder Android, dieses eBook können Sie lesen. Sie benötigen dafür einen PDF-Viewer - z.B. die kostenlose Adobe Digital Editions-App.
Buying eBooks from abroad
For tax law reasons we can sell eBooks just within Germany and Switzerland. Regrettably we cannot fulfill eBook-orders from other countries.
aus dem Bereich
