Visit Counter

Monday, February 1, 2021

Upgrade Oracle 11g to 19c using Expdp/Impdp

 

Upgrade Oracle 11.2.4 to 19.3.0 Using Expdp / Impdp


Example of Using Oracle Data Pump The steps for using Oracle Data Pump to upgrade or migrate a database have not changed from previous releases. If you would like to migrate with Oracle Data Pump using conventional dump files, the steps would be as follows: 

SQL> create directory bkup_dir as '/u02/oradb/bkup';

1. Export the source database to a dump file:

2.$ expdp srcadmin/password  DIRECTORY=bkup_dir DUMPFILE=expfulldb.dmp LOGFILE=expfulldb.log FULL=Y METRICS=Y PARALLEL=4 EXCLUDE=STATISTICS 

3. Make the dump file available on the destination system, either by copying it to the destination           

   system or placing it on a network-mounted disk. 

4. Create a CDB on the destination system, including a PDB into which you will import the source 

    database. 

5. In the destination PDB, create a directory object for the dump file to be imported.

6. SQL> create directory bkup_dir as '/u02/oradb/bkup'';

7. SQL> create user test identified by test123

 8. Import the Data Pump dump file into the destination PDB: 

$ impdp test/test123@pdb DIRECTORY=bkup_dir DUMPFILE=expfulldb.dmp LOGFILE=expfulldb.log PARALLEL=4 METRICS=Y LOGTIME=ALL 

In this example, we take advantage of Oracle Data Pump features such as the PARALLEL parameter to improve performance. In other cases, you might use network mode to eliminate the need for a dump file. Oracle Data Pump is fully documented in Oracle Database Utilities Guide.

No comments:

Post a Comment