2 Replies Latest reply: Jun 12, 2013 7:44 AM by Zoltan Kecskemethy RSS

    Restoring 10.2.0.4 database to a 10.2.0.5 server?

    user130038

      Hi

       

      If I restore an oracle 10.2.0.4 database (RHEL 4.7, 64bit) to a server which has Oracle 10.2.0.5 binaries (RHEL 4.7 64bit), would it work? Or is there a script that I must run to upgrade the database from 10.2.0.4 to 10.2.0.5?

       

      The reason I am asking is that our database servers are being managed by 3rd party. One server has 10.2.0.4 and other has 10.2.0.5. I have to bring both databases to new server. I cannot upgrade the 10.2.0.4 on 3rd party's server.

       

      I can prepare the new server with 10.2.0.4, restore 10.2.0.4 database and upgrade it to 10.2.0.5. Then bring over the other 10.2.0.5 database (from2nd server). I want to avoid doing this exercise multiple times (for DEV/Tes/QA/PROD). What maybe a better approach?

       

      Best regards