Muutke küpsiste eelistusi

Oracle Database Upgrade and Migration Methods: Including Oracle 12c Release 2 1st ed. [Pehme köide]

, ,
  • Formaat: Paperback / softback, 610 pages, kõrgus x laius: 254x178 mm, kaal: 1193 g, 189 Illustrations, color; 46 Illustrations, black and white, 1 Paperback / softback
  • Ilmumisaeg: 02-Mar-2017
  • Kirjastus: APress
  • ISBN-10: 1484223276
  • ISBN-13: 9781484223277
Teised raamatud teemal:
  • Pehme köide
  • Hind: 67,40 €*
  • * hind on lõplik, st. muud allahindlused enam ei rakendu
  • Tavahind: 79,29 €
  • Säästad 15%
  • Raamatu kohalejõudmiseks kirjastusest kulub orienteeruvalt 3-4 nädalat
  • Kogus:
  • Lisa ostukorvi
  • Tasuta tarne
  • Tellimisaeg 2-4 nädalat
  • Lisa soovinimekirja
Oracle Database Upgrade and Migration Methods: Including Oracle 12c Release 2 1st ed.Suurem pilt
  • Formaat: Paperback / softback, 610 pages, kõrgus x laius: 254x178 mm, kaal: 1193 g, 189 Illustrations, color; 46 Illustrations, black and white, 1 Paperback / softback
  • Ilmumisaeg: 02-Mar-2017
  • Kirjastus: APress
  • ISBN-10: 1484223276
  • ISBN-13: 9781484223277
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9781484223277.html
Märksõnad:
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 its 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 isnt 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
About the Authors xvii
About the Technical Reviewer xix
Acknowledgments xxi
Foreword xxiii
Chapter 1 Getting Started
1(18)
Why Are Database Upgrades Necessary?
1(2)
New Innovations
3(1)
Bug Fixes
3(1)
Supporting Environment
4(1)
Certification
4(1)
Database Support Level
4(1)
Benefits of a Database Upgrade
4(1)
Hurdles That Affect the Database Upgrade Decision
5(1)
Types of Database Upgrade
6(1)
Things to Consider Before Upgrading
7(2)
Engineers Involved in the Upgrade Activity
9(1)
Database Administrator
10(1)
Storage Administrator
11(1)
System Administrator
11(1)
Network Administrator
11(1)
Solution Architect
11(1)
Application Team
12(1)
Upgrade Compatibility Matrix
12(2)
Best Practices for a Database Upgrade
14(2)
Database Migration
16(1)
Situations That Demand a Migration
16(1)
Things to Consider Before Migration
17(1)
What This Book Covers
17(1)
Summary
17(2)
Chapter 2 Database Upgrade Methods
19(132)
Oracle Binary Relinking
19(1)
Relinking Process
20(1)
Known Issues
21(1)
Database Upgrade Methods
21(1)
The Database Upgrade Assistant
22(1)
Prerequisites for the DBUA
23(1)
Upgrade Compatibility Matrix
24(1)
Pre-upgrade Checks
25(1)
Activities Performed by the DBUA
26(1)
Best Practices with the DBUA
26(2)
Upgrade Steps
28(3)
Sample Restore Script
31(11)
12c DBUA New Features
42(12)
DBUA Upgrade Steps
54(2)
How to Make Sure the Upgrade Is Successful
56(1)
DBUA in Silent Mode
57(2)
Comparison Between 11g R2 DBUA and 12c R1 DBUA
59(2)
Database Manual Upgrade
61(1)
Pre-upgrade Tasks
62(1)
Execution Method
63(3)
Recommended Steps for the Source Database
66(5)
Upgrade Steps
71(2)
12c Upgrade Script Execution
73(1)
Parallelism
73(1)
Phases
74(1)
Post-upgrade Steps
75(4)
Comparison Between 11g R2 and 12c R1
79(2)
Traditional Export/Import
81(1)
Compatibility Version Matrix
81(1)
Upgrade Steps
82(3)
Data Pump
85(1)
Parallel
85(2)
Upgrade Steps
87(3)
Transportable Tablespace
90(1)
Things to Consider
91(1)
Prerequisites to Perform Transportable Tablespace
91(1)
Upgrade Steps
92(5)
Limitations
97(1)
Advantages
98(1)
Database Upgrade Using Oracle GoldenGate
98(1)
Planning Phase with Oracle GoldenGate
98(7)
Configuration Setup at the Source Database (Oracle 11g)
105(6)
Configuration Setup at the Target Database (Oracle 12c)
111(2)
Configuration Setup at the Target Database (Oracle 12c for Oracle GoldenGate 12c)
113(6)
High Availability or Fallback Option Using the Source Database (Oracle 11g)
119(1)
Configuration Setup at Target Database Oracle 12c and Implementing Bidirectional Data Replication Between Target Database (pdb12c) and Source Database (Oracle 11g)
120(3)
Configuration Setup at Source Database Oracle 11g and Implementing Bidirectional Data Replication Between Target Database (pdb12c) and Source Database (Oracle 11g)
123(3)
Summary
126(1)
Create Table As Select (CTAS)
126(1)
CTAS vs. COPY
127(1)
Advantages of CTAS
127(1)
Disadvantages with CTAS
127(1)
How Does CTAS Work?
127(1)
Requirements
128(2)
Parallel Usage with CTAS
130(1)
Order By with CTAS
130(1)
Summary
131(1)
Database Upgrades Using Transient Logical Standby
131(4)
Create a Restore Point
135(1)
Enable Supplementary Logging
136(1)
Upgrade of Logical Standby Database
136(1)
Manual Upgrade Using the 12c Method
137(1)
Switchover
137(1)
Initiate Flashback
138(1)
Convert Logical to Physical Standby
138(1)
Starting MRP
138(1)
Switchover
138(1)
Full Transportable Export/Import
139(1)
Prerequisites
140(1)
Upgrade Steps
140(9)
Summary
149(2)
Chapter 3 Comparison of Upgrade Methods
151(18)
The DBUA
151(1)
Features
151(1)
Limitations
152(1)
Manual/Command-Line Upgrade
152(1)
Features
153(1)
Limitations
153(1)
Comparison of the DBUA and Manual Processes
154(1)
Traditional Export/Import and Data Pump
155(1)
Features
155(1)
Limitations
155(1)
Data Pump
155(1)
Transportable Tablespaces
156(1)
Steps in Summary
156(1)
Features
157(1)
Limitations
157(1)
Full Transportable Export/Import
157(1)
Features
157(1)
Limitations
158(1)
Transient Logical Standby
158(1)
Switchover Best Practices
159(1)
Features
159(1)
Limitations
159(1)
Oracle GoldenGate
160(1)
Comparison of All Methods
161(1)
Real Application Testing
161(1)
Benefits of Using RAT
162(1)
How to Choose the Best Upgrade Method
162(1)
Database Downtime
163(2)
Getting Additional Storage
165(1)
Number of Actions and Required Skill Set
165(1)
Total Time Allotted
166(1)
Unsupported Features
166(1)
Number of User Objects
166(1)
Source Database Version
166(1)
Change of Platform
167(1)
Summary
167(2)
Chapter 4 Upgrade Using a Database Backup
169(44)
Introduction
169(1)
What Are the Various Backup Techniques?
170(1)
Cold Backup (Traditional)
171(9)
Hot Backup (User-Managed)
180(10)
Logical Backup (expdp/impdp)
190(1)
Prerequisites
191(1)
Objects Count
191(1)
Check NLS Settings
192(1)
Datafiles and Metadata
193(1)
Check the Invalid Objects from the Target Database
194(1)
Registry Components at the Target Database
194(1)
Create Triggers of the SYS Schema
195(1)
Database Export Using expdp
196(1)
Importing the Database (impdp)
197(4)
RMAN Backup
201(10)
Summary
211(2)
Chapter 5 Oracle Database Migration
213(66)
Traditional Export/Import
213(1)
Export
214(1)
Output
215(1)
Import
216(1)
Output
216(1)
Data Pump
217(1)
Data Pump Working Process
218(1)
Features
218(2)
Partition
220(1)
Merge
221(1)
Departition
221(1)
REMAP_DATAFILES
222(1)
REUSE_DATAFILES
222(1)
REMAP_TABLESPACE
222(1)
Transportable Tablespaces
223(5)
Oracle GoldenGate
228(1)
Environment Setup
228(1)
Oracle GoldenGate Setup on the Source Database
229(1)
Oracle GoldenGate Setup on the Target Database
230(2)
Configure Oracle GoldenGate on the Source Database
232(1)
Changes in Parameters in the Source Database
233(6)
Start Oracle GoldenGate Manager
239(4)
Configure Oracle GoldenGate on the Target Database
243(3)
Method 2: Initial Load with Bulkload
246(3)
CTAS
249(3)
Transport Database
252(1)
Migrate Steps
253(15)
Heterogeneous Standby Database
268(2)
Oracle Streams
270(7)
Summary
277(2)
Chapter 6 Migrating Oracle Database from Non-ASM to ASM Environments
279(44)
Scenario 1 Moving datafiles online from a non-ASM location to an ASM location
281(16)
Scenario 2 Migrating an Oracle Database 12c CDB with PDBs from a non-ASM to ASM using EM 13c
297(13)
Scenario 3 Migrating an Oracle Database 12c CDB with PDBs from a non-ASM to ASM using RMAN
310(11)
Summary
321(2)
Chapter 7 Oracle GI and Oracle 12c Database Upgrades in RAC Environments
323(58)
Run the CVU Pre-upgrade Check Tool
324(2)
Running the Oracle RAC Configuration Audit Tool (ORAchk) Tool
326(1)
Execution Steps for ORAchk
326(2)
Consider Real Application Testing
328(1)
Performing a Rolling Upgrade Using Oracle GI
328(13)
Scenario 1 Upgrading Oracle 11g RAC (11.2.0.3.0) to Oracle 12c RAC (12.1.0.2.0)
341(28)
Scenario 2 Manual upgrade of Oracle 11g RAC (11.2.0.3.0) to Oracle 12c RAC (12.1.0.2.0)
369(9)
Scenario 3 Upgrading of Oracle 11g RAC (11.2.0.3.0) to Oracle 12c RAC (12.1.0.2.0) with GI and Database using EMCC 13c
378(2)
Summary
380(1)
Chapter 8 Database Upgrades in Data Guard Environments
381(44)
Upgrading Data Guard from 11.2.0.4 to 12.1.0.2
382(1)
Pre-upgrade Steps
382(2)
Review of the Pre-upgrade Log
384(5)
Upgrade the Data Guard Environment
389(16)
Post-upgrade Tasks
405(5)
Summary
410(1)
Rolling Database Upgrades Using DBMS_ROLLING in 12c
410(1)
Rolling Upgrades in 11g vs. DBMS_ROLLING in 12c
410(1)
DBMS_ROLLING: 12c
411(13)
Summary
424(1)
Chapter 9 Database Upgrades in EBS Environments
425(22)
Prerequisite Steps
425(1)
Pre-upgrade steps
426(1)
Upgrade Steps
427(1)
Post-upgrade Steps
427(1)
Example
428(10)
Apply the Prerequisite Patches to the Apps Home
438(1)
Apply the Prerequisite Patches to the Database Home
438(1)
Shut Down the Application Process
439(1)
Execute cr9idata.pl
439(1)
Drop the sys.enabled$indexes Table
439(1)
Execute the Pre-upgrade Scripts
439(1)
Check the Database Components' Status
440(1)
Check the Invalid SYS/SYSTEM Schema Objects
440(1)
Drop the MGDSYS Schema
440(1)
Upgrade the Database to the 12c Version
441(1)
Post-upgrade Steps for an EBS Database Upgrade
442(3)
Summary
445(2)
Chapter 10 Multitenant Database Upgrades
447(44)
Multitenant Architecture
448(2)
Move the Lower-Version Database to the Multitenant Architecture
450(4)
Container Database Upgrade
454(4)
Database Upgrade Assistant
458(5)
Manual Database Upgrade or Command-Line Upgrade
463(5)
Upgrade Steps
468(11)
Post-upgrade Tasks
479(1)
Pluggable Database Upgrade
479(10)
Summary
489(2)
Chapter 11 Pluggable Database Migrations
491(12)
The Need for Migration
491(1)
Migration Steps
492(1)
Same Endian Format
492(4)
Different Endian Format
496(6)
Summary
502(1)
Chapter 12 Oracle Database Patching Strategies
503(44)
What a Patch Contains
504(1)
inventory.xml
504(2)
actions.xml
506(1)
How Patching Works
506(1)
Central Inventory
506(3)
Re-creation Steps
509(2)
How to Remove from the Central Inventory
511(1)
Local Inventory
512(1)
Using the Opatch Tool
513(3)
Types of Patches
516(1)
Patch Set Update (PSU)
516(1)
Security Patch Update (SPU)
516(1)
Bundle Patches
517(1)
One-Off Patches
517(1)
Proactive Bundle Patches
517(1)
Conflicts
517(1)
Overlay Patches
517(1)
Patch Apply Strategies (Online and Offline Patching)
518(6)
Patch Apply Steps
524(1)
Applying Patch in Offline Mode
524(3)
Patching in Online Mode
527(1)
Post-Patch Steps
528(1)
Patch Rollback
528(1)
Opatch Debug
529(1)
PSU and SPU Patching
529(1)
PSU Patch Apply Steps
530(2)
How to Confirm the PSU Patch Apply Is Successful
532(1)
PSU Rollback
533(2)
SPU Patching
535(2)
Patch Apply Steps in RAC and Data Guard Environments
537(1)
Patching in an RAC Environment
537(2)
Patching in a Data Guard Environment
539(1)
PSU/SPU Patch Apply in a Data Guard Environment
540(1)
Datapatch
540(2)
Queryable Patch Inventory
542(5)
Chapter 13 Database Downgrades
547(18)
Limitations of Downgrading
547(3)
Downgrade Steps for Multitenant Databases
550(4)
Downgrade Steps Using Database Flashback
554(1)
Upgrade Steps
554(1)
Downgrade Steps
555(3)
Downgrade Steps Using Database Flashback for Multitenant Databases
558(1)
Upgrade Steps
558(1)
Downgrade Steps
559(4)
Known Issues
563(1)
Summary
563(2)
Chapter 14 Oracle Database Upgrades in Oracle Database Release 12.2
565(38)
Upgrading to the 12.2 Release (12.2.0.1.0)
565(1)
Pre-upgrade Checks: What's New in 12.2
565(1)
Steps
566(4)
Upgrade Emulation
570(3)
Database Upgrade Assistant
573(1)
Upgrade Steps
574(9)
DBUA in Silent Mode
583(1)
New 12.2 DBUA Features
583(1)
Manual Database Upgrade/Command-Line Upgrade
583(3)
Upgrade Steps
586(2)
Post-upgrade Tasks
588(2)
Oracle 12.2 New Manual Upgrade Features
590(1)
Pluggable Database Upgrade
590(1)
Pluggable Database Upgrade Steps
591(5)
Manual Upgrade of Pluggable Database in 12cR2
596(1)
Target 12.2 Environment
597(1)
Start PDB12cR2 in Upgraded Mode
598(1)
Downgrade 12.2 to Earlier Versions
598(1)
Prerequisites
599(1)
Downgrade Steps for the Entire Container Database
599(2)
Summary
601(2)
Index 603
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.