How to DB Export And DB Import MDS and ORASDPM schema's

Applies to:


Oracle SOA Platform - Version: 11.1.1.5.0 and later [Release: 11gR1 and later ]

Information in this document applies to any platform.



Goal

What is the recommended way of exporting and importing the mds and orasdpm schema's using Database (RDBMS) commands?





Solution

These steps make use of the RDBMS command line tools:



•Export (dbexp)

•Import (dbimp)



Set content parameter to all on both export and import.



Export MDS and ORASDPM schema's



First set ORACLE_SID





cmd>export ORACLE_SID=

cmd>nohup expdp " ' / as sysdba ' " parfile=mds_all_expdp.par &

cmd>nohup expdp " ' / as sysdba ' " parfile=pvs2_orasdpm_all_expdp.par &

where is the location of (ie: SID) for your RDBMS instance.



Scripts:



mds_all_expdp.par:





CONTENT=ALL

DIRECTORY=ALT_DUMPDEST

DUMPFILE=MDS.dmp

LOGFILE=exp_MDS.log

PARALLEL=1

SCHEMAS=MDS



orasdpm_all_expdp.par:





CONTENT=ALL

DIRECTORY=ALT_DUMPDEST

DUMPFILE=ORASDPM.dmp

LOGFILE=exp_ORASDPM.log

PARALLEL=1

SCHEMAS=ORASDPM





Import MDS and ORASDPM schema:s:

First set ORACLE_SID





cmd>export ORACLE_SID=

cmd>nohup impdp " ' / as sysdba ' " parfile=mds_dataonly_impdp.par &

cmd>nohup impdp " ' / as sysdba ' " parfile=orasdpm_dataonly_impdp.par &

where sid is the SID of your database instance.



Scripts:



mds_dataonly_impdp.par:





CONTENT=ALL

DIRECTORY=ALT_DUMPDEST

DUMPFILE=MDS.dmp

LOGFILE=imp_MDS.log

PARALLEL=1

SCHEMAS=MDS



pvs2_orasdpm_dataonly_impdp.par:





CONTENT=ALL

DIRECTORY=ALT_DUMPDEST

DUMPFILE=ORASDPM.dmp

LOGFILE=imp_ORASDPM.log

PARALLEL=1

SCHEMAS=ORASDPM