Export / Import in Oracle 11g with PARALLEL

Export Script with Parallel 

[oracle@primoda1 ~]$ cat expdp_ultimus_moend.sh 

#!/bin/bash

export ORACLE_HOME=/u01/app/oracle/product/11.2.0.3/dbhome_1

PATH=$HOME/bin:/u01/app/oracle/product/11.2.0.3/dbhome_1/bin:.:/usr/local/bin:/bin:/usr/bin

export PATH

ORACLE_SID=pbldb1; export ORACLE_SID;

Date=`date +%d%b%Y`.`date +%I`.`date +%M%p`

Dat=`date +%d%b%Y`

mkdir -p /cloudfs/oracle/DAILY_DUMP/PBLDB.$Dat

sqlplus / as sysdba <<!

!Dat=`date +%d%b%Y`

create or replace directory test_dir as '/cloudfs/oracle/DAILY_DUMP/PBLDB.$Dat';

!$ORACLE_HOME/bin/expdp system/passwd directory=test_dir dumpfile=exp1%U_$Date.dmp schemas=ultimus job_name=exp_ultimus logfile=test_dir:pbldb_$Date.log COMPRESSION=ALL PARALLEL=8

EXIT;

cd /cloudfs/oracle/DAILY_DUMP

du -h PBLDB.$Dat > size_before.$Date.txt

gzip PBLDB.$Dat

du -h PBLDB.$Dat.gz > size_after.$Date.txt

ftp -i -v -n 192.168.1.41 <

binary

cd /u01/backdump

put PBLDB.$Dat.gz 

END_FTP

[oracle@primoda1 ~]$ 

----------------------------------------------------------------------

[oracle@STANDBY ~]$ cat expisldb.sh
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1
export ORACLE_SID=ISLPRIM

Date=`date +%d%b%Y`.`date +%I`.`date +%M%p`
Dat=`date +%d%b%Y`
mkdir -p /asm/ISLDB.$Dat
sqlplus / as sysdba <<!
!Dat=`date +%d%b%Y`
create or replace directory test_dir as '/asm/ISLDB.$Dat';
!expdp system/sys123 directory=test_dir dumpfile=exp1%U_$Date.dmp schemas=ultimusisl PARALLEL=8 ENCRYPTION_PASSWORD=123456 logfile=test_dir:isldb1_$Date.log
EXIT;
[oracle@STANDBY ~]$


[oracle@STANDBY ~]$ cat impisldb.sh
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1
export ORACLE_SID=ISLPRIM

Date=`date +%d%b%Y`.`date +%I`.`date +%M%p`
Dat=`date +%d%b%Y`
#mkdir -p /asm/ISLDB.$Dat
sqlplus / as sysdba <<!
!Dat=`date +%d%b%Y`
create or replace directory test_dir as '/asm/ISLDB.26Oct2014';
!impdp system/sys123 directory=test_dir dumpfile=exp1%U_26Oct2014.12.11PM.dmp schemas=ultimusisl PARALLEL=8 ENCRYPTION_PASSWORD=123456 logfile=isldb_$Date.log
EXIT;
[oracle@STANDBY ~]$