upgrading oracle 8i to 10gR2 with 3.5TB database size

5 pts.
Tags:
AIX 5L
Oracle 10g
Oracle 8i
Oracle migration
sirs, what is the best way to migrate a 3.5TB database from oracle 8i to 10gR2 on the same machine? the OS is AIX L5, with 10TB storage size

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hi,

in my opinion the better way is to reproduce the same identical environment and use this one for the
test phase.
You should manage two identical installation (same version) in the same server and this can add some additional work (but this should not be a problem) but in this way if something goes wrong during the upgrade, you can fast go back online whit the original installation.
You can leave the production live db on line while working to upgrade the test db or you can stop it. Depending on the chosen scenario, you will be able to switch to new upgraded db in only one step (see bottom).
Of course you’ll use a backup copy of your original database to run the upgrade test.

Once this one is finished you can choose between switch here the production, or repeat the upgrade to the live database. This mainly depends on the state of the original db: if this one has been up & running during the test, you cannot move the production directly to the upgraded one (data will be different).

remember that the direct upgrade is possible only from 8.1.7.4. Otherwise you must patch the db before start the upgrade (see documentation for details).

The steps involved upgrading in this way are suggested by my experience: NEVER work in production without TEST TEST TEST everything before!

my 2 cents

Marco

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following