Donald K. Burleson
Oracle MIG utility
* Performing migration steps out of
order. Obviously, don’t do this.
* Not fulfilling the prerequisites for migration (see the first
* Allowing other users to access the database during migration.
* Database must be at least 7.3.4. I’m not kidding; it checks for
this and errors out if it isn’t.
* If you are re-creating control files in a different location, be
sure permissions are set properly.
* Be sure all tablespaces were either online or in an offline normal
or temporary status when the Oracle8 instance shut down. Be sure
there is no outstanding undo in any of the tablespaces.
As stated earlier, Oracle offers numerous new features. It changes
the fundamental structures of the database, compared to Oracle8 or
earlier versions. The migration to Oracle is not a simple process
of shutting down in one version and starting up in the other; it is
a complex operation requiring planning (at least for large
databases, which must use the MIG or ODMA utilities). However,
according to several DBAs who have done it, as long as you plan
properly and follow directions, you shouldn’t have any problems.
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.
Copyright © 1996 - 2014 by
Burleson. All rights reserved.
Oracle® is the registered trademark
of Oracle Corporation.