Atjaunināt sīkdatņu piekrišanu

Oracle Database Upgrade, Migration & Transformation Tips & Techniques [Mīkstie vāki]

4.50/5 (2 ratings by Goodreads)
,
  • Formāts: Paperback / softback, 464 pages, height x width x depth: 229x191x25 mm, weight: 796 g, 114 Illustrations
  • Izdošanas datums: 16-Jul-2015
  • Izdevniecība: McGraw-Hill Inc.,US
  • ISBN-10: 0071846050
  • ISBN-13: 9780071846059
Citas grāmatas par šo tēmu:
  • Mīkstie vāki
  • Cena: 72,91 €
  • Grāmatu piegādes laiks ir 3-4 nedēļas, ja grāmata ir uz vietas izdevniecības noliktavā. Ja izdevējam nepieciešams publicēt jaunu tirāžu, grāmatas piegāde var aizkavēties.
  • Daudzums:
  • Ielikt grozā
  • Piegādes laiks - 4-6 nedēļas
  • Pievienot vēlmju sarakstam
Oracle Database Upgrade, Migration & Transformation Tips & TechniquesPalielināt
  • Formāts: Paperback / softback, 464 pages, height x width x depth: 229x191x25 mm, weight: 796 g, 114 Illustrations
  • Izdošanas datums: 16-Jul-2015
  • Izdevniecība: McGraw-Hill Inc.,US
  • ISBN-10: 0071846050
  • ISBN-13: 9780071846059
Citas grāmatas par šo tēmu:
Permanent link: https://www.kriso.lv/db/9780071846059.html
Keywords:
"This Oracle Press guide provides best practices for migrating between different operating systems and platforms, transforming existing databases to use different storage or enterprise systems, and upgrading databases from one release to the next. Based on the expert authors' real-world experience, Oracle Database Upgrade, Migration & Transformation Tips & Techniques will help you choose the best migration path for your project and develop an effective methodology. Code examples and detailed checklists are included in this comprehensive resource"--

A practical roadmap for database upgrade, migration, and transformation

This Oracle Press guide provides best practices for migrating between different operating systems and platforms, transforming existing databases to use different storage or enterprise systems, and upgrading databases from one release to the next. Based on the expert authors’ real-world experience, Oracle Database Upgrade, Migration & Transformation Tips & Techniques will help you choose the best migration path for your project and develop an effective methodology. Code examples and detailed checklists are included in this comprehensive resource.

  • Leverage the features of Oracle Active Data Guard to migrate an Oracle database
  • Use Oracle Recovery Manager, transportable tablespace sets, and transportable database toolsets to migrate between platforms
  • Migrate databases with export/import
  • Use Oracle GoldenGate for zero or near-zero downtime migrations
  • Take advantage of the cross-platform transportable Tablespace Set utility
  • Migrate to new storage platforms using the Oracle Automatic Storage Management feature
  • Upgrade to Oracle Database 12c with the Database Upgrade Assistant tool
  • Move seamlessly to Oracle Engineered Systems
  • Migrate to the cloud
Acknowledgments xv
Introduction xvii
Part I Planning a Smooth Migration
1 Overview of Migration, Transformation, and Upgrade Methodologies
3(6)
Database Upgrade Methodologies
4(3)
Data Migration Methodologies
5(2)
Migration with Transformation Methodologies
7(1)
Future Migration, Transformation, and Upgrade Techniques
7(1)
Summary
8(1)
2 Choosing the Right Migration Method
9(20)
Evaluating Your Environment
10(13)
Migration Goals
11(1)
Downtime Requirements
12(1)
Transformation Goals
12(1)
Migration Methods Review
13(5)
Resources
18(2)
Budget
20(1)
Additional Considerations
21(2)
Making Your Decision
23(4)
How Downtime Affects Your Choice of Method
23(1)
How Versions Affect Your Choice of Method
24(1)
How Architecture Affects Your Choice of Method
24(1)
How Database Transformation Affects Your Choice of Method
25(1)
Decision Summary
26(1)
Hybrid Solutions
27(1)
GoldenGate Migration Example
27(1)
Summary
28(1)
3 Migration/Transformation/Upgrade Methodologies
29(24)
Planning the Migration Process
30(4)
Determining the "Window of Inopportunity"
30(1)
Application Workload Categorization
31(3)
Capturing Your Migration/Transformation/Upgrade Plan: The Master Checklist
34(3)
Milestones
34(1)
Tasks, Responsibilities, and Actions
35(1)
Timelines and Expected Task Timings
35(1)
Fallback Plans
35(1)
Expected Results
36(1)
Testing Your Chosen Migration/Transformation/Upgrade Path
37(1)
Building a Migration Plan
37(7)
Migration Steps
39(2)
Resource Al location
41(1)
Milestones
42(1)
Quality Assurance
43(1)
Change Requests
43(1)
User Acceptance Testing
43(1)
Production Cutover
44(5)
Planning the Cutover to Production
45(1)
Database Verification
45(1)
Ensuring the Database's Data Integrity
46(1)
Application Server Migration
47(1)
Evaluating Application Performance
47(2)
Summary
49(4)
Part II Cross-Platform Migration
4 Oracle Data Guard
53(20)
Data Guard Overview
54(5)
What Is Data Guard?
54(1)
How Does Data Guard Work?
54(3)
Data Guard Components
57(1)
Data Guard Modes
58(1)
Data Guard Broker
59(1)
Requirements for Migrating with Data Guard
59(2)
Configuring Data Guard
61(10)
Set Up the Primary and Standby in Preparation of Data Guard
61(5)
Modify init.ora Parameters on the Primary
66(2)
Create the Standby System
68(1)
Duplicate the Database to the Standby
68(2)
Configure the Data Guard Broker
70(1)
Test and Validate
71(1)
Migrating with Data Guard
71(1)
Summary
72(1)
5 Using Recovery Manager (RMAN) for Cross-Platform Migration
73(46)
RMAN: Intrinsic Benefits
74(3)
Reliability
74(1)
Processing Efficiency
75(1)
Security
76(1)
RMAN Backup, Restore, and Recovery Techniques
77(11)
Fundamental Changes
77(1)
Fast Recovery Area
78(2)
Elements of Oracle's Recommended Backup Strategy
80(8)
Advanced RMAN Features
88(2)
RMAN Enhancements in Oracle 11g: Multi-Piece Backup Sets
88(1)
RMAN Enhancements in Oracle 12c
89(1)
Migrating Between ASM and Other File Systems
90(28)
Non-ASM to ASM Migration: Complete Migration
90(21)
Non-ASM to ASM Migration: Phased Migration
111(5)
Monitoring RMAN Performance During Database Migration
116(2)
Summary
118(1)
6 Transporting Tablespaces and Databases
119(42)
Migrating Between Operating Systems
120(6)
TTS Migration vs. TDB Migration: Variables to Consider
121(2)
Cross-Platform Migration: The Triumvirate
123(1)
Overcoming Endian Boundaries
124(2)
Transporting Tablespace Sets: The Basics
126(9)
TTS Operations: Prerequisites
127(3)
TTS: Performing the Migration Operation
130(5)
TTS: Advanced Techniques
135(9)
Create Transportable Tablespace Set as of Specific SCN
136(6)
Transport Datafiles and Metadata from Source Platform to Destination Platform
142(1)
Perform Endian Conversion at Destination
143(1)
Import Source Tablespace Metadata via Data Pump
143(1)
Switch Transported Tablespaces to READ WRITE Mode at Destination
144(1)
Revert Selected Tablespaces to READ WRITE Mode on Source Database
144(1)
TDB: Transporting Entire Databases
144(13)
TDB: Advantages and Drawbacks
144(1)
TDB: A Practical Example
145(12)
Summary
157(4)
Part III Migration with Enhancement/Upgrade
7 Migrating Oracle Databases with Export/Import
161(20)
Introduction to Export/Import
162(4)
Overview of Migrating a Database with Export/Import
163(1)
Transformations and Export/Import
164(1)
Using Export/Import for Backup and Recovery and Data Movement
165(1)
Types of Exports
165(1)
Using Export/Import to Migrate Metadata
166(1)
Using Legacy Export/Import to Migrate Oracle Databases
167(5)
Exporting Metadata with Legacy Export/Import
167(1)
Exporting with Legacy Export/Import
168(2)
Importing with Legacy Export/Import
170(2)
Legacy Export/Import Summary
172(1)
Using Data Pump Export/Import to Migrate Oracle Databases
172(6)
Data Pump Export/Import Directory Objects
173(1)
Exporting Metadata with Data Pump Export/Import
174(1)
Exporting with Data Pump
174(2)
Importing with Data Pump Import
176(2)
Data Pump Export/Import Summary
178(1)
Point-in-Time Export Using FLASHBACK_SCN
178(1)
Summary
179(2)
8 Zero or Minimal Downtime Migrations with Oracle GoldenGate
181(24)
Introduction to Oracle GoldenGate
182(2)
Uses of Oracle GoldenGate
182(1)
How Does GoldenGate Work?
182(1)
GoldenGate Components
183(1)
GoldenGate Workflow
184(1)
Planning a Migration with GoldenGate
184(1)
Migrating a Database with GoldenGate
185(18)
Set Up GoldenGate
185(4)
Configure and Validate the Database
189(2)
Enable GoldenGate Replication
191(4)
Activate a Physical Standby for GoldenGate Export/Import
195(3)
Sync Target with Source
198(1)
Monitor Until Cutover
199(1)
GoldenGate Cutover Procedure
200(2)
GoldenGate Cleanup (Optional)
202(1)
Summary
203(2)
9 Cross-Platform Transportable Tablespace Migration Utilities
205(24)
XTTS Migration Phases
206(1)
XTTS Migration Scenario
207(21)
Phase One: Migration Preparations
208(4)
Phase Two: Initial Migration, Method A: RMAN
212(4)
Phase Two: Initial Migration, Method B: DBMS_FILE_TRANSFER
216(3)
Phase Three: Incremental Synchronization
219(4)
Phase Four: Final Synchronization and Migration
223(5)
Summary
228(1)
10 Migrating to New Storage Platforms Using ASM
229(20)
ASM Overview
230(1)
ASM Configuration
231(4)
crsctl
231(1)
srvctl
232(1)
OEM Cloud Control 12c
232(1)
SQL Statements
232(2)
asmcmd
234(1)
Storage System Overview
235(2)
SAN Storage
236(1)
NAS Storage
236(1)
Migration Process Using ASM
237(9)
Add New Storage to the System
237(4)
Add Storage to the ASM Disk Group(s)
241(3)
Remove Old Disks from ASM Disk Group(s)
244(1)
Validate
245(1)
Remove Old Storage from the System
245(1)
Best Practices, Tips, and Techniques
246(1)
Summary
246(3)
Part IV Optimized Upgrades/Migration
11 Database Upgrade Assistant
249(34)
Upgrade vs. Migration
250(1)
Upgrading the Grid Infrastructure
251(11)
Installing the New Database Software
262(1)
Using the Database Upgrade Assistant to Plan an Upgrade
263(10)
Running the Pre-Upgrade Script
263(5)
Running the Database Upgrade Utility Scripts
268(5)
Using the Database Upgrade Assistant to Perform an Upgrade
273(8)
Summary
281(2)
12 Migrating from Microsoft SQL Server to Oracle
283(16)
Introduction to Oracle GoldenGate
284(3)
Uses of Oracle GoldenGate
284(1)
How Does GoldenGate Work?
284(1)
GoldenGate Components
285(1)
GoldenGate Workflow
286(1)
Planning a SQL Server Migration with GoldenGate
287(1)
Oracle GoldenGate for SQL Server Database Profile Script
287(1)
Migrating a Database with GoldenGate
288(9)
Set Up GoldenGate on MS SQL Server and Oracle 11g
289(2)
Configure and Validate the Database
291(1)
Enable Replication from SQL Server to Oracle 11g
291(3)
Perform the Initial Migration from MS SQL Server to Oracle
294(1)
Sync Target with Source
295(1)
Monitor Until Cutover
296(1)
Perform Pre-Cutover Validation
296(1)
GoldenGate Cutover Procedure
296(1)
GoldenGate Cleanup (Optional)
297(1)
Summary
297(2)
13 Moving to Oracle Database 12c
299(62)
Oracle Database 12c: A Brave New World
300(1)
Container and Pluggable Databases: A Primer
301(11)
Common vs. Local Database Files
304(2)
Common vs. Local Tablespaces and Datafiles
306(2)
Common vs. Local Users and Objects
308(1)
CDB Security: Local vs. Common Privileges and Roles
309(1)
CDB Data Dictionary and Dynamic Views
310(2)
Directly Upgrading a Pre-12c Database to a 12c CDB
312(1)
Creating an Empty Container Database
312(13)
"Upgrating" a Pre-12c Database to a 12c PDB: Mixed-Mode Methods
325(6)
Upgrading via Oracle GoldenGate
327(1)
Conversion via Cross-Platform Transportable Tablespace
328(1)
Conversion via Transportable Tablespace Sets, Cross-Platform Transport, or Full Transportable Export
329(2)
PDB Cloning Methods
331(29)
Scenario 1: Cloning a New Empty PDB from PDB$SEED and Transferring Data Into It
333(7)
Scenario 2: Cloning a New PDB from an Existing PDB
340(3)
Scenario 3: Unplugging and Replugging an Existing PDB
343(8)
Scenario 4: Plugging In an Existing Non-CDB as a New PDB
351(9)
Summary
360(1)
14 Moving to Oracle Engineered Systems
361(38)
Engineered Systems: Not Our Father's Mainframe
362(9)
Why Engineered Systems?
362(1)
A Brief Survey of Oracle Engineered Systems
363(8)
Moving to Exadata DBM
371(9)
Exadata: Rules of Thumb
371(4)
I/O Resource Manager
375(5)
Migrating Databases to an Exadata Environment
380(9)
Logical Migration Methods
380(3)
Physical Migration Methods
383(6)
Handling External Data Efficiently for Exadata: Oracle Database File System
389(9)
Oracle DBFS: A Practical Example
390(8)
Summary
398(1)
15 Migrating to Oracle in the Cloud
399(16)
Cloud Computing: What Is It?
400(3)
Public Cloud
401(1)
Private Cloud
402(1)
Hybrid Cloud
402(1)
Oracle VM
402(1)
Oracle Cloud Offerings
403(1)
Why Use Cloud Computing?
403(1)
Considerations for Migrating to Cloud Computing
404(3)
Cloud Security
404(1)
Support and SLA
404(1)
Network Performance and SLA
405(1)
Application Customizations
405(1)
The Real Cost of Cloud Computing
405(1)
Data Access
406(1)
Data Migration
406(1)
Oracle VM and Cloud Computing
407(1)
Benefits of Running Oracle Databases on Oracle VM
408(1)
Migration Options for Cloud Computing
408(4)
Planning the Migration
409(2)
Application Migration
411(1)
Data Synchronization (Replication)
411(1)
Summary
412(3)
Part V Best Practices and Tips
16 In Summary: Recommendations, Reminders, and Best Practices
415(10)
Planning a Smooth Migration
416(1)
Migration Methodologies
416(1)
Choosing the Right Migration Path
416(1)
Migration/Transformation/Upgrade Methodology
417(1)
Cross-Platform Migration
417(2)
Data Guard
418(1)
Migration Using Recovery Manager
418(1)
Cross-Platform Tablespace Migration Utilities
418(1)
Migration with Enhancement/Upgrade
419(2)
Export/Import
419(1)
Zero or Minimal Downtime Migrations with Oracle GoldenGate
419(1)
Cross-Platform Tablespace Migration with Incremental Backups
420(1)
Migrating to New Storage Platforms Using ASM
420(1)
Optimized Upgrades/Migration
421(1)
Database Upgrade Assistant
421(1)
Migrating from Microsoft SQL Server to Oracle
421(1)
Moving to Oracle Database 12c
421(1)
Moving to Oracle Engineered Systems
422(1)
Migrating to Oracle in the Cloud and Recommendations, Reminders, and Best Practices
422(1)
Migrating to the Oracle in the Cloud
423(1)
Summary of Best Practices
423(1)
A Final Word...
423(2)
Index 425
Edward Whalen is a senior Enterprise Architect with over 25 years of experience in cloud computing, applications, operating systems, computer hardware and database technologies. He is experienced with designing and implementing high performance Enterprise systems and data centers, including primary and disaster recovery systems. The range of skills and experience covers all layers of applications, software and hardware technologies including the latest technologies. Edward Whalen is the author of 10 books covering a wide range of topics including virtualization technologies, and database technologies from Oracle and Microsoft. In addition, Edward Whalen is a recognized expert on Oracle performance tuning, Oracle RAC, SAN implementation, and application workload testing. He currently holds a Top Secret clearance.