5 pts.
 upgrading oracle 8i to 10gR2 with 3.5TB database size
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

Software/Hardware used:
ASKED: June 13, 2008  3:36 AM
UPDATED: June 16, 2008  10:50 AM

Answer Wiki:
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
Last Wiki Answer Submitted:  June 16, 2008  10:50 am  by  FreCho   80 pts.
All Answer Wiki Contributors:  FreCho   80 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _