Database upgrade on VMX
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Database upgrade on VMX

Hybrid View

  1. #1
    Join Date
    Mar 2000
    Posts
    39
    Hello everyone, we are going to be upgrading our oracle 7.1 to 8i soon. There are several 200M-2G databases running on the database. Can you please tell me what is the best way of doing the upgrade and what to look for, etc. Basically, any knowledge or experience that you have had on this would be great. Thanks in advance.
    Thanks,
    Afshin.

  2. #2
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    You can use the Migration Assistant to migrate. On the other hand, since the size of the dbs are small, you can just perform an export and import.

  3. #3
    Join Date
    Mar 2000
    Posts
    39
    We are not migrating, we are upgrading from 7.1 to 8.
    Thanks,
    Afshin.

  4. #4
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    Well, based on what you are saying, it's a migration, not an upgrade. Upgrade is something like 7.1 to 7.3, but a migration is something like 7.x to 8.x

  5. #5
    Join Date
    Mar 2000
    Posts
    39
    I didn't know that, so if I wanted to go from 7.1 to 8, I have to migrate? What is the best way of doing that?
    Thanks,
    Afshin.

  6. #6
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    Yes, you have to migrate. You will have to use the Migration Assistant and probably run a script or too. Check the Migration Guide for details. The other way, which I had suggested to you was an export and import since the size of the dbs are small. If you decide to use export/import then:
    -
    1. take full cold backups and exports of all the databases.
    2. install v8i, create the dbs, configure them and run import.

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