Keep downtime short on 11i migration: Applications database migration using the exp/imp method

This tip is an excerpt from the paper "Keep downtime short on 11i migration" and is brought to you by the International Oracle Users Group (IOUG). Become a member of the IOUG to access the paper referenced here and a repository of technical content created for Oracle users by Oracle users.

Sequence of steps to perform fast applications database migration using exp/imp method

In this example, we won't get too much in details in export and import or database links nor parallel processing, more attention is paid on methodology to first transfer only database structure to new system during uptime and only data during downtime. Other parameters to exp/imp (direct, buffers and log for example) might be necessary to tune up used tools performance and behavior. The data tr

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT Oracle applications best practices Where can I get more information on the Oracle CRM E-Business Suite? Numbers to words in any language Oracle vs. SAP Oracle apps DBA interview questions The BI application consolidation challenge Upgrading PeopleSoft, part 3: Application-specific conversions and going live Upgrading PeopleSoft, part 2: Installation and the move to production Upgrading PeopleSoft, part 1: The first steps Nine steps for successful CRM implementation: Check IT List Keep downtime short on 11i migration: Reusing a prepared software stack Oracle applications implementation and upgrades Oracle brings Fusion Middleware into the modern age Oracle's Identity Manager features new integration architecture Oracle Application Integration Architecture: Where it is going? OAUG president talks Collaborate '09 and the future of Oracle apps Special Report: Collaborate '09 Oracle bolsters application integration lineup with new AIA packs New OAUG chief riffs on Fusion, Exadata and recession planning Oracle New Year's resolutions, part 2: GRC tips and customer resolutions revealed Oracle's Fusion Applications: Way behind or right on track? Oracle abuzz over Beehive collaboration platform, other updates at OpenWorld 2008 Oracle applications implementation and upgrades Research

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary

ansfer process can have more stages, depending on amount of data and again, allowable downtime.

1. Transfer source database logical structure to target database (can be done before migration, no downtime required) Those operations won't need much tuning, because they can be performed during uptime.

2. Transfer only data from source database to target (done after source database is ready to be upgraded, downtime required)

3. Create indexes and enable constraints (downtime required)

4. Verify, that no object definition has changed in source database since structure export (in parallel with step 2 or 3)

Note that there won't be any huge rollback or redo generation if you use direct load AND don't have any indexes enabled on relevant tables. This is also one reason why primary/unique constraints should be disabled during data load, since those require indexes.