6 Replies Latest reply: Jul 31, 2013 7:32 AM by Srini Chavali-Oracle RSS

    Oracle 9.2.0.6 upgrade to 11gR2

    ManojDBA

      Hi,

       

      My database is 2TB in size. The database is 9.2.0.6 running on Solaris 8. It is configured with Physical Standby dataguard.

      The current plan is to upgrade the database to 11.2.0.3. 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?

       

      Regards,

      Manoj Devan