14. Strategies for Migrating Data Quickly between Databases

Migrating data that has been stored in an existing source database to a new destination database is probably one of the most nerve-wracking experiences any Oracle DBA will encounter during her career. (Granted, patching a database is no less tedious; but if it’s been done correctly, it’s possible to rewind a database from the results of a failed patching opportunity, and that’s not always the case for a failed data migration attempt.) The good news is that Oracle offers numerous utilities and methodologies to successfully migrate all or part of an Oracle database’s data to a new destination with virtually no service interruptions, but the bad news is that there are so many different ...

Get Oracle Database Problem Solving and Troubleshooting Handbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.