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

IMHO... simple and easy solution is always a winner i.e. method 1. Full export from old, full import into new. No fuss or extra setup as with the other methods.

Regards
/Rauf

fungcheung_at_yahoo.com (James Cheung) wrote in message news:<9d46429.0410061920.32be274a_at_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
>
>
> A. 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.
>
> B. 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 Thu Oct 07 2004 - 06:45:37 CDT