HELP : Move old database in old machine to new database in new machine

From: James Cheung <fungcheung_at_yahoo.com>
Date: 6 Oct 2004 20:20:23 -0700
Message-ID: <9d46429.0410061920.32be274a@posting.google.com>

What are the possible upgrade options for the following situations ?

From(Old machine) To(New machine)

=======================  ================ 
Oracle 8.0.6/AIX 4.3.3   Oralce 9i/AIX 5.2 
Oracle 8.0.6/HP 10.20    Oralce 9i/HP 11.0
Oracle 8.1.5/AIX 4.3.3   Oralce 9i/AIX 5.2 
Oracle 8.1.6/AIX 4.3.3   Oralce 9i/AIX 5.2
Oracle 8.1.7/AIX 4.3.3   Oralce 9i/AIX 5.2
Oralce 8i/Solaris 2.6    Oralce 9i/Solaris 9i
Oralce 8i/Solaris 5.8    Oralce 9i/Solaris 9i
Oralce 8i/Solaris 8i     Oralce 9i/Solaris 9i

1. Background and limitations

   ---

   Data size: Vary from a few gigabytes to a few terabytes Down time: A few hours, such as 8 hours. Old/new machines location: Locate in different countries and connected by WAN.
2. The way forward

   ---

   I am considering the following methods but I am not sure the feasibility and compatibility issues. Your expertise is sought.

Method 1 : Export/Import

---

   Step 1: Setup the new blank database in new machine.
   Step 1: Export the data during down time.
   Step 2: Transfer exported data through the WAN to new machine.
   Step 3: Import the data to the new database.

   Concerns

1. I think it is suitable for small volume data because of time constraint.

Method 2 : DBUA

---

   Step 1: Install both the old/intermediate/new versions in the new machine

   Step 2: Copy the datafiles to new machine during downtime.
   Step 3: Startup the old database using old version.
   Step 4: Upgrade the database to new version using DBUA.

   Concerns

1. I think it is suitable for small volume data because of time constraint.
2. For 8.1.5/8.1.6, I need to upgrade to the intermediate 8.1.7 first.
3. Is this method faster than method 1 ?

Method 3 : Primary/Standby (Don't know if it work or not )

---

   Step 1: Setup the primary/standby databases for old/new databases.
   Step 2: Switch over to the standby database during down time.
   Step 3: Remove the Primary/Standby database relation.
   Step 4: Upgrade the database in the new machine to new version

using DBUA.

   Concerns

1. Does Primary/Standby supports different oralce versions such as 8i/9i ? If yes, then there is no need to upgrade the database.
2. No need to transfer data during down time. It saves time.

Method 4 : Replication (Don't know if it work or not )

---

   Step 1: Create a blank database in the new machine.    Step 2: Setup replication for all tables between the old/new databases.

   Step 3: Drop all the replication during the down time.    Step 4: Upgrade the database in the new machine to new version using DBUA.

   Concerns

1. Does replication supports different oralce versions such as 8i/9i ? If yes, then there is no need to upgrade the database.
2. No need to transfer data during down time. It saves time.

##########################################################################

Your expertise is sought on the feasibility and compatibility of the above methods. If you have better ideas, I would be much appreciate.

##########################################################################

Thks,
James Received on Wed Oct 06 2004 - 22:20:23 CDT