My database is 2TB in size. The database is 220.127.116.11 running on Solaris 8. It is configured with Physical Standby dataguard.
The current plan is to upgrade the database to 18.104.22.168. What will be the best way to do the upgrade? I am thinking on the Logical Standby method.
Is it possible to do logical standby between 9i and 11g?
Can i convert the physical standby database I have now to logical standby and upgrade the database to 11g?
Is there any limitation on logical standby database? eg. data types?
There are two concerns about your upgrade.
Direct upgrade to 11.2.0 is not support from version 22.214.171.124, at least you should be on version 126.96.36.199.
188.8.131.52 is not supported on solris8, at least you should be on OS version - Solaris 10.
Please refer MOS tech notes:
Upgrading to 9i with Standby Database in Place (Doc ID 165296.1)
Upgrading Oracle Database with a Logical Standby Database In Place (Doc ID 437276.1)
Complete Checklist for Manual Upgrades to 11gR2 (Doc ID 837570.1)
X A H E E R
Thanks for your reply. Yes, the new database server will be on Solaris 10. Looking at the MOS tech notes its not possible for me to use logical standby to upgrade from 9i to 11g. Only way is to upgrade to 184.108.40.206 than to 220.127.116.11. Is there any other way you would suggest?
The upgrade process itself will take about 4 hours. Pl review this presentation View content for various options that are available to minimize downtime. These options will likely incur additional cost