3 Replies Latest reply: Jul 16, 2013 5:01 PM by Srini Chavali-Oracle RSS

    Any specific disadvantage of using DataPump for upgrade ?

    learner1

      Hi,

       

      Here's my config

       

      SERVER A

      Source O/S : Win 2003

      Source DB : 10.2.0.4 ( 32 bit )

      DB Size : 100 GB

       

      SERVER B

      Target O/S : Win 2008 R2 sp1

      Target DB : 11.2.0.3 ( 64 bit )

       

      I have to upgrade 10g Database of server A , by installing 11g on Server B. I have not used database upgrade assistant or RMAN or similar utilities to perform a 10g upgrade to 11g anytime in the past.

       

      Here is my question ...

       

      a) I was planning to use datapump to perform this upgrade ( Downtime is not a issue ), since I know how to use datapump, do you guys see any potential problem with this approach ? OR

      b) Based on your exp. would you suggest that i should avoid option (a) because of potential issues and use other methods that oracle suggests like upgrade assistants etc

       

      I am open to both options, it's just that since i am not a expert at this point of time, i was hesitating a bit to go with option (b)

       

      db is supposed to undergo from 32 to 64 bit. Not sure if this would be deal breaker.

       

      Note : The upgrade is suppose to happen on 2nd server. Can somebody provide high level steps as pointer.

       

      -Learner