1

I'm fairly new to Oracle databases and have been tasked with assessing the implications of upgrading our application's database from 11g to 12c.

I have managed a successful in-place upgrade but a number of stakeholders will be looking to upgrade to new hardware so I need to access the viability of a migration upgrade.

Is it possible to migrate the current active database to a fresh installation of 12c and which would be the most effective method for this?

1
  • As always, it depends, there is no silver bullet. You did not provide enough information for us to recommend the most effective method. Data Pump is the easiest for people new to Oracle databases. – Balazs Papp Aug 23 '16 at 13:10
0

You can use expdp and impdp utility by Oracle for migration of database from 11g to 12c.

First of all we will use expdp utility to export the whole database into a dumpfile (.dmp) by issuing the following command:

expdp system/password@db11g full=Y directory=TEST_DIR dumpfile=DB11G.dmp logfile=expdpDB11G.log

Here, FULL parameter indicates that the whole database will be exported Directory --> The directory on server in which you want to place the dumpfile DUMPFILE --> The name of dumpfile LOGFILE --> The name of logfile (that logs the status of export process)

After the export is done successfully you will get something like: Job "SYSTEM"."SYS_EXPORT_FULL_01" successfully completed at 10:35

Now, your whole database is stored in a dumfile(.dmp) in the 'DIRECTORY' mentioned in the expdp command.

We will now start import of the database into 12c database with the help of impdp utility.

impdp system/password@db10g full=Y directory=TEST_DIR dumpfile=DB11G.dmp logfile=impdpDB12c.log

*Before starting import you might need to transfer the dumpfile to the new server (i.e. 12c)

After import has been successfully completed you will get successfull completion message.

Reference link --> https://oracle-base.com/articles/10g/oracle-data-pump-10g

Happy Migration !!

4
  • 1
    It's worth noting that datapump can be done across the network, avoiding the creation and transfer of massive dump files – Andrew Brennan Aug 22 '16 at 13:29
  • 1
    @AndrewBrennan Yes absolutely correct :) – Bibhuti Bhusan Padhi Aug 22 '16 at 13:32
  • As I am working with a completely fresh 12c installation on the destination server I assume that I will need to create a new database instance into which I will import the dumpfile. Does this new instance need to be set up in any way to match the source database or can I simply create a new instance and import into it, allowing the import tool to construct the database for me? – djaustin Aug 22 '16 at 14:06
  • Sorry my bad. I am late for reply. Thank you for marking this answer. I hope it has helped you. You can create a similar instance otherwise a new instance will work fine before import :) yes the import utility will create the new database. – Bibhuti Bhusan Padhi Sep 1 '16 at 6:00

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.