Call (800) 766-1884 for Oracle support & training
Free Oracle Tips


Oracle Consulting Support
Oracle Upgrades
Use New Oracle Features
Oracle Replication Support
Oracle Training
Remote Oracle DBA
System Documentation
Oracle Tips
Oracle Performance
 

Free Oracle Tips


 

HTML Text

BC Oracle tuning

Oracle training

Oracle support

Remote Oracle

 

 

   
 

Donald K. Burleson

Oracle Tips  

Test the Oracle Migration Process

Take Flight! (or Fall off the Cliff): Migrate the Source Database

Following the pretested methodology, migrate the source database to its new Oracle home. Immediately after the migration completes successfully, shut down and perform a complete cold backup. This gives you a starting point should something go awry with subsequent testing. An export will do nearly as well; but don’t use a hot backup, because a hot backup will not afford full recoverability at this stage of migration! The backup should contain all datafiles, control files, redo logs, parameter files, and SQL scripts used to build any of the database objects.

The Three Ts: Tune, Tweak, and Test the New Database

Using the knowledge you gained from your thorough review of the documents, readme files, and utility scripts, tune and tweak the new Oracle instance to optimum performance. Once the database is tuned, test using your predeveloped test cases.

What Next?

Once the database is migrated to the Oracle instance structure, you need to consider which features you want to implement (after all, if you didn’t want the new features, why migrate?) and how you are going to implement them.
 

This is an excerpt by Mike Ault’s book “Oracle Administration & Management”.  If you want more current Oracle tips by Mike Ault, check out his new book “Mike Ault’s Oracle Internals Monitoring & Tuning Scripts” or Ault’s Oracle Scripts Download.

 

 ”call

  
 

Oracle performance tuning software 
 
 
 
 

Oracle performance tuning book

 

 
 
 
Oracle performance Tuning 10g reference poster
 
 
 
Oracle training in Linux commands
 
Oracle training Excel
 
Oracle training & performance tuning books
 

 

   

Copyright © 1996 -  2014 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.