DB BACKUP & RESTORE

DB BACKUP & RESTORE Commands
-----------------------------


go to bin folder of oracle  /u01/app/oracle/product/11.2.0/dbhome_1/bin

export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
export ORACLE_SID=iportald


./expdp iportald/iportald@XXX.XXX.XXX.XXX:1521/iportald schemas=iportald directory=DATA_PUMP_DIR dumpfile=iportald.dmp logfile=expdpiportald.log

./impdp iportald/iportald@XX.XXX.XXX.XX:1521/iportald schemas=iportald directory=DATA_PUMP_DIR dumpfile=iportald.dmp logfile=impdpiportald.log


DB dump folder path:

/u01/app/oracle/admin/iportald/dpdump