This discussion is archived
3 Replies Latest reply: Oct 22, 2012 6:21 PM by Srini Chavali-Oracle RSS

migrate 11gR1 11.1.0.7.0 database to 11.2.0.X database on separate network

JerryC2 Newbie
Currently Being Moderated
Currently running 11.1.0.7.0 p46 Oracle single database on 2003 R2 32 bit. Need to migrate this over to different Network node running Windows Server 2008 R2 x64 64-bit OS to eventually get to new Oracle 11.2.0.X.0 database. Where do I get a full 11.1.0.7.0 Database install set to upgrade to 64-bit on new OS, to then convert to 11.2.0.X.0 version?
  • 1. Re: migrate 11gR1 11.1.0.7.0 database to 11.2.0.X database on separate network
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    11.1.0.7 is a patch that can only be applied to a 11.1.0.6 install. Since this version is out of support, you will need to create a SR with Support, and they will provide a link to the 11.1.0.6 software, assuming you have paid for Extended Support for 11gR1.

    How big is the database ? How much downtime can you afford ? One option may be to perform a full export from existing hardware, create a new empty 11.2.0.3 database on the new hardware and performing an import - this will bypass the requirement of installing 11gR1 on the target hardware

    HTH
    Srini
  • 2. Re: migrate 11gR1 11.1.0.7.0 database to 11.2.0.X database on separate network
    JerryC2 Newbie
    Currently Being Moderated
    I am guessing the options I used back in December 2011 and January 2012 are no longer available, nolonger supported. No we do not have extended suppport for 11gR1.

    Current database 11.1.0.7.0 is 15.9 GB. Currently available space on oracle directory is 28.6 GB. Flash_recovery_area is at 114 GB so there is room to for an upgrade on this OS by cleaning up the flass recovery area, it will be slow. By the way the OS is Windows Server 2003 x64 AMD 64 x2 Standard Edition, not the 32-bit.

    I can do an export (datapump or export?) and bring over just the schemas from the 11.1.0.7.0 database, to get it into a new 11.2.0.X.0 database? Is this your recommended approach to getting over to another non-conectable network (Widows Server 2008 R2 that will be running? Can we go to 11.2.0.X.0 the lastest release this way? Is there a document with this option?

    Most of Oracle's documentation now shows upgrading to 11.2.0.X.0 on the same box. We do have to get off thie node and its network though, and so not have tha luxurary of closning or using RMAN 'duplicate database' options.

    Will using a 11.1.0.7.0 backup now be out of the question?

    Thanks,

    Jerry C.
  • 3. Re: migrate 11gR1 11.1.0.7.0 database to 11.2.0.X database on separate network
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    Yes, you can upgrade using expdp and impdp - 16G is peanuts ;-)


    http://docs.oracle.com/cd/E11882_01/server.112/e23633/expimp.htm

    HTH
    Srini

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points