Results 1 to 9 of 9
  1. #1
    Join Date
    Aug 2006
    Posts
    58

    Unanswered: How to migrate from Oracle 8i to Oracle 10g with 100GB Data?

    Hi, everyone. Thank you in advance!

    Now we are ready to migrate datum with the volume 100GB from Oracle 8i to Oracle 10g. We want to migrate the datum with the tool IMP/EMP. However , there may be many problems, fox examples:
    (1) The migrating process will take many hours, maybe 50 hours and more....
    (2) In the migrating process, if some error will happen, we have to migrate all of the datum again. That is to say, if some error happens, we have to restart the migrating process from the beggining.

    How can I do for the migrating with so large volume 100GB? Please give me some advice. Thank you very much again.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Now we are ready to migrate datum with the volume 100GB from Oracle 8i to Oracle 10g. We want to migrate the datum with the tool IMP/EMP.
    Your requirements are similar to me asking,
    "How do I train my pet pig how to fly?"

    I'm my Production environment, I can complete a full hot backup of a 400GB in about 4 hours.
    So, you should be able to take a full hotbackup & complete the upgrade in about 2 hours if you are willing to remove the exp/imp "requirement".
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Aug 2006
    Posts
    58
    thank you, anacedent.
    As you said, how can I do here? Can you give me more imformation in details. Thank you very much!

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    You provide scant details in OP.
    exp/imp "implies" availability of 2nd system & fallback to original system.
    Do hot backup to 2nd system; then do normal Oracle upgrade.
    When I did 7.3.4.5 to V9.2.07; upgrade took about 45 minutes.
    If/when it works open DB & point clients at new DB.
    If/when problem stay onoriginal DB & learn from your mistakes.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Aug 2006
    Posts
    58
    the Source Oracle Database and the Destination Oracle Database are running the same operating system Solaris. However, the versions are different. The Source Oracle Database is Oracle 8i and the Destination Oracle Database is Oracle 10g. Thank you very much!

  6. #6
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    As anacedent the quickest way is to do the upgrade in place, the second quickest would be to do a rman clone and upgrade (if on a different machine) and the slowest would be imp and exp. I am a bit puzzled why it takes so long (50 hours). If you optimise your imp/exp routing it should be much quicker i.e. do parallel exports and parallel imports, run the new database in no archive log mode while doing the import, specify a large buffer, do direct exports etc..

    Alan

  7. #7
    Join Date
    Aug 2006
    Posts
    58
    Thank you, AlanP.

    Now we have the export file(*.dmp). All of the datum was exported into only one file with the volume 100G. How can I do parallel imports? Moreover, if during importing some error will happen, we have to re-import all of the datum from the start. Right? Can we only re-import the left datum(the datum is not imported when the error happen)?

    Thank you very much!

  8. #8
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    I wish you the best of luck on completing this task & ending up with working database after completing the import.

    To import in parallel, just use multiple imp processes; each working on their own list of schemas while all using the same dump file as input.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  9. #9
    Join Date
    Aug 2006
    Posts
    58
    thanks.
    I will try again.

Posting Permissions

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