Migration Doubt
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Migration Doubt

  1. #1
    Join Date
    Aug 2000
    Location
    Singapore
    Posts
    323

    Migration Doubt

    Hi

    We need to upgrade Oracle 7.3.3 from a AIX(4.2.1) machine to Oracle 8i(8.1.7) on a different AIX(4.3.3) machine. We have installed 8i on the AIX(4.3.3) machine.

    I have cold backup of Oracle 7.3.3. Can I rcp these files to AIX(4.3.3) machine, and then recreate the control files, to change the file locations, and then migration using odma utility from 8.1.7?

    Please advice.

    Thanks in Advance
    Nagesh

  2. #2
    Join Date
    Aug 2002
    Posts
    16
    You can user either migration assistant

    or migration utility ( go through the oracle documentation)


    migration assistant is easy to handle

  3. #3
    Join Date
    Aug 2000
    Location
    Singapore
    Posts
    323
    Originally posted by paulosekutty
    You can user either migration assistant

    or migration utility ( go through the oracle documentation)


    migration assistant is easy to handle
    Meaning that, I can use my cold backup to restore on another machine and do migration to 8i using odma.

    Any suggestions from guru's.

    Thanks In Advance.
    Nagesh

  4. #4
    Join Date
    Aug 2000
    Location
    Singapore
    Posts
    323
    Any suggestions Please..


    Regards
    Nagesh

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    I never used migration assistant so I cant help, I only know running upgrade scripts is a piece of cake

  6. #6
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Read the release notes for the version you are upgrading to -- they may tell you that you need to upgrade to an intermediate version first.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  7. #7
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    Is it possible to run a v7 database on 8.1.7 by merely recreating the control files?

    I've never tried.
    David Knight
    OCP DBA 8i, 9i, 10g

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width