Multiterabyte Database Migration Across OS Platforms - A case study.pptVIP

Multi-terabyte Database Migration Across O.S. Platforms Presenters Saran Shanmugam 9i Oracle Certified Master DBA Team Lead for the platform migration James Madison Application Development Enterprise Architect Project Manager for the platform migration Agenda The Challenge (James) Database Technology Used (Saran) Introduction to Transportable Tablespaces (Saran) Introduction to Data Pump (Saran) Pre-Migration Database Preparation (Saran) Database Migration Process (Saran) Environmental Problems and Solutions (James) Application Problems and Solutions (James) QA The Challenge To move 22 TB of data in 17 databases on 9i Largest single database is 7 TB OS changes: from Tru64 to HP-UX Operating systems use different endian’s Forced to go to 10g due to the endian change OS and database change causes 8 other upgrades Complex application logic must be considered All with a high management profile due to cost (The O.S.’s discussed are Tru64 and HP-UX, but the principles apply to any disparate O.S.’s) Technologies Considered for Data Migration Exp/Imp - Available with 9i and 10g Data pump - Available with Oracle 10g Cross Platform Transportable Tablespace - Available with Oracle 10g Third party tools - Not recognized by Oracle Technology Decision for Data Migration Exp/Imp for metadata transfer Cross Platform Transportable Tablespace and Data Pump - For data Transfer Times faster than any available methods Just 3% slower than any regular copy of datafiles Transportable Tablespace - A background Introduced in 8i TTS between multi-block databases in Oracle 9i TTS between multiplatform databases in Oracle 10g - Compatibility need to be greater than 10.0.0 Cross Platform Transportable Tablespace Features Higher loading speeds Reduced server burden Reduced complexity of process No creation or rebuilding indexes Movement of tablespace between multiple O.S. platforms Sharing of Tablespaces between different O.S. Servers bu