By
Published: 26 Oct 2009
What would be best strategy for upgrading the following Oracle databases?
- Small size Oracle database
(15gb to 100 gb)
(from 9.2.0.6 to 10.2.0.4) on AIX 5.x
- Large size Oracle database
(200 GB to 1 TB)
(from 9.2.0.8 to 10.2.0.4) on AIX 5.x
For both scenarios, I would use the
Database Upgrade Assistant (DBUA) in Oracle. The DBUA works well on both large and small databases. The DBUA is one of the few upgrade methods that works well and is relatively quick for large databases. And since you are staying on the same OS during your upgrades, the DBUA will work for your needs. For more information on the DBUA, please refer to the 10g Migration Guide.
Dig Deeper on Oracle database design and architecture
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs.
Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.
Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.
Continue Reading