1 2 Previous Next 15 Replies Latest reply: Jul 30, 2012 9:24 AM by Srini Chavali-Oracle RSS

    Migrate Oracle 10.2.0.3 to Oracle 11.2.0.3

    AbhijitDey
      Source:
      Oracle 10.2.0.3, Solaris: 10 (SunOS usahsarmp090 5.10 Generic_144488-17 sun4u sparc SUNW,Netra-440)

      Target:
      Oracle 11.2.0.3, RHEL 5.6 (Tikanga)

      I am considering two approaches:
      1) Datapump export to a NFS, Datapump import to Target db(same version 10g-10.2.0.3) from NFS, Upgrade Target Db from 10g(10.2.0.3) to 11gR2 (11.2.0.3)
      2) Install target db (11.2.0.3) and do a Datapump Export/Import straight from the 10.2.0.3 db to 11.2.0.3 db

      Which one is preferable.. current the database size is quite small - 50GB. My gut feeling is all will be over in 2-3 hours maxed out (provided we have the degree of parallelism set properly, network/NFS storage are enough).

      Any suggestions/advice will be greatly received :)

      Best Regards,
      Abhijit
        1 2 Previous Next