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