100GB database rehost and upgrade
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: 100GB database rehost and upgrade

  1. #1
    Join Date
    Mar 2004
    Location
    IA USA
    Posts
    257

    100GB database rehost and upgrade

    DBAs,


    One client need to rehost&upgrade a 100 GB 8.7.0.4 to 10g release 2 from Solaris 7 32-bit
    To Solaris 9 64-bit


    We now have two options-
    1. Install the new 1og release 2 and do the export and import.
    But this 100 GB might take a long time. The shutdown window is tight.
    2. Install 8i and 10g first and then copy the old to the new 8i and then upgrade to 10g release 2.

    If choose the export/import, do the whole db export/import or do schema by schema.
    I am afraid that the whole db import will override some 1og system objects.

    Any good suggesting about how to do this task will be greatly appreciated.

    Thanks,

    Lily

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    If possible I'll go with the exp/imp option, schema by schema which will allow you to be importing some schemas in 10g while still exporting other in 8i

    We just did exactly that with a 200 Gig database, unfortunatelly one of the schemas was 190 Gig in size.

    Total exp time: 6 hours
    Total imp time: 7 hours

    What we did was to exp/compress and to uncompress/imp on the fly in order to save disk space and specially network traffic during FTP.

    During Import set target database in noarchivelog mode
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Mar 2004
    Location
    IA USA
    Posts
    257
    Thanks for sharing the experience.

    personally I go for export/import schema by schme

    Another question--
    When I tried t odownload the 10g release 2 for 54bit solaris.
    I found out there are 3 :


    Oracle Database 10g Release 2 (10.2.0.1.0) for Solaris Operating System (x86-64)
    Oracle Database 10g Release 2 (10.2.0.1.0) for Solaris Operating System (SPARC) (64-bit)

    Oracle Database 10g Release 2 (10.2.0.1.0) for Solaris Operating System (x86)

    Our versin is solaris 9, which one I should dowload?

    Thanks,

    Lily

  4. #4
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    What is your server construct of SPARC or Intel/Itanium/zeon(x86)?

    Based on this you have to download, check with your system admin or you can login to the server and see for yourself

    Last one is 32 bit forget it as you do not require.

  5. #5
    Join Date
    Mar 2004
    Location
    IA USA
    Posts
    257
    Thank you very much.

  6. #6
    Join Date
    Feb 2007
    Posts
    212
    I wonder if replication can help here so the updates can be applied immediately while the source db is still active and be ready for cut-over to the new system

  7. #7
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    Quote Originally Posted by jennifer2007
    I wonder if replication can help here so the updates can be applied immediately while the source db is still active and be ready for cut-over to the new system
    what a complete waste of time effort and money to set that up just for migrating to another platform

  8. #8
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Quote Originally Posted by jennifer2007
    I wonder if replication can help here so the updates can be applied immediately while the source db is still active and be ready for cut-over to the new system
    Jenn... you might end adding a problem instead of expediting the solution
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

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