Oracle7 Server Migration Guide Go to Product Documentation Library
Go to books for this product
Go to Contents for this book
Go to Index

Go to previous file in sequence Go to next file in sequence

Migration Overview

This chapter gives you an overview of the migration processes and procedures for migrating Oracle databases.

Oracle migration processes and procedures transform existing versions or releases of Oracle databases (including their applications) into different versions or releases. All Oracle7 Server releases are upwardly compatible with all earlier Oracle versions and releases. Therefore, databases transformed using the migration processes described in this book work in the same manner as in earlier versions and, optionally, permit the use of functionality available with the new release.

You must perform several preparatory steps in the migration process before you begin to migrate the data in your current, production database. Also, once you have migrated your current database, you should perform several additional steps that deal with testing and adding the functionality available with the new version or release.

The topics covered in this chapter are

For information about upgrading and downgrading between the Version 7 releases, see Chapter 9 "Upgrading and Downgrading between Oracle7 Releases".

If you are migrating to Trusted Oracle, see the Trusted Oracle7 Server Administrator's Guide.

Migrating a Database from One Version to Another

Careful planning and proper tools can greatly reduce the complexity of migrating a database. Oracle provides several tools, such as the Export/Import and Migration utilities, to make the migration process as simple as possible.

Note: The Migration Utility can be used only to transform an earlier version to a later version of the Oracle database. The Migration Utility cannot be used for reverse migration. For example, the Migration Utility cannot be used to transform a Version 7 database into a Version 6 database.

The following Oracle features aid in the migration process:

Overview of the Migration Process

This section contains the following topics:

Before attempting to migrate your database, you should understand the requirements and procedures involved with each step of the migration process. The following list is a step-by-step overview of the migration process. The details of each step are discussed in later chapters. This list is a guideline for approaching migration. Note that the migration steps presented are generic; they do not depend on a specific operating system.

Step 1: Prepare to Migrate

There are several preparatory steps that you are advised to follow. Although the following steps are not mandatory, they will ensure that the final migration proceeds smoothly:

Step 2: Rehearse the Migration Process

Rehearse the migration of your database with a subset of the source database. If you are using the migration utility, create a "test" version of the source database; then migrate the test database. At this point, do not migrate the entire production (source) database.

Step 3: Test Your Applications

Test your applications with the Release 7.x database. Be certain that your applications run correctly with Release 7.x before migrating your production database.

Step 4: Preserve the Source Database

There are a few, remaining preparation steps that will protect the contents of your source database and ensure a completely successful migration.

Step 5: Migrate the Source Database

Migrate the source database to the format of the target database using the migration method that you chose (such as Export/Import or the Migration Utility).

Attention: Both the Migration Utility and Export/Import methods require the installation of the target database during this step.

Step 6: Make Initial Adjustments to the New Production Database

The basic migration steps have now been completed. However, there are several remaining steps that will ensure that the migrated database is ready to serve as your new production database.

After completing this process, your database should be completely transformed into a new production database.

Role of the Database Administrator During Migration

Typically, the database administrator is responsible for ensuring the success of the migration process. Specific duties of the database administrator might include scheduling the migration process, making backups of the database to be migrated and the new database, and performing the actual migration procedure. The database administrator should arrange to meet with everyone involved in the migration process to define clearly everyone's roles during migration.

The database administrator typically becomes involved in each step of the process, except for steps that are concerned with testing applications in the target database and selecting new features of the target database, which are generally performed by application developers.

Role of the Application Developer During Migration

While the database administrator is responsible for migration of the database, the application developer is responsible for ensuring that applications designed for the source database work in the same way using the target database.

Before the migration process begins, the database administrator or application developer should install a target database for testing so that applications can be tested and modified, if necessary, to work with the same (or enhanced) functionality. Migration of production users to the target database should not begin until all applications have been tested and operate properly.

The application developer should note changes in the target database that may affect particular applications. Many of these changes are described in Appendices A, B, C, and D of this manual. Oracle7 Parallel Server Concepts & Administration and Oracle7 Server SQL Reference give additional descriptions of changes in Release 7.3.

Appendices A, B, C, and D of this manual also list changed data dictionary views upon which an application might depend. The application developer should use all of these sources to identify any modifications that need to be made in existing applications. In addition, Chapter 8 "Migrating Your Version 6 Applications", describes the changes necessary to enable applications accessing a Version 6 database to access a Release 7.x database in a backwards compatibility mode, as well as how to upgrade these applications to take advantage of new Release 7.x functionality.

Downgrading to a Previous Database

You might want to return (downgrade) to a previous database after migrating to the target database. If you have not entered any new data in the target database, you can restore a complete backup of a previous database and open it again. Be certain to use a complete backup that contains the original initialization parameters that were used in the previous database. Once you have entered data in a target database, you cannot reverse the methods of migration described in this manual.

Warning: You must disable certain features of the target database before you return to a previous database. For more information about setting the COMPATIBLE parameter and other downgrading issues, see Chapter 9 "Upgrading and Downgrading between Oracle 7 Releases"

There are, however, the following methods of sending table data from a target database to a source database:

For more information on the COPY command, see the SQL*Plus User's Guide and Reference manual.

For more information on performing a Version 6 export of Release 7.x files, see Oracle7 Server Utilities.

For more information on the AS clause of the CREATE TABLE command, see Oracle7 Server SQL Reference.

For more information about upgrading and downgrading between the Version 7 releases, see Chapter 9 "Upgrading and Downgrading between Oracle7 Releases".

Migrating from Single Instance to Parallel Server

You may wish migrate from a single instance Oracle7 database to a multi-instance Oracle7 database which uses the parallel server option.

For more information about migrating from single instance to parallel server, see Oracle7 Parallel Server Concepts & Administration.

Go to previous file in sequence Go to next file in sequence
Prev Next
Copyright © 1996 Oracle Corporation.
All Rights Reserved.
Go to Product Documentation Library
Go to books for this product
Go to Contents for this book
Go to Index