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