Oracle Data Pump Steps

Oracle Oracle Data Pump Step 2004/08/27
These two days in the test ora10g data pump, will carry out the steps to post it for everyone to see
Because my test database data is not much, the speed of data pump is not obvious, but the backup file size than exp out of a lot.


-----Lisalan 20040825 Oracle Data Pump
----Create a directory
$ MKDIR/HOME/ORACLE/BACKUP/DATA/EXPDP

----To assign permissions to users using System login
Sql> Grant Create any directory for * * *;
If you need to delete a user directory, you need to:
Sql> Grant Drop any directory for * * *;

----Create Directory with * * * Login
Sql> Create directory Backup_expdp_dir as '/HOME/ORACLE/BACKUP/DATA/EXPDP '
If you need to delete a directory, you need to:
sql> Drop directory Backup_expdp_dir;

----Back up * * * User data (keep seven days of backup data)
backup_expdp.sh
#!/bin/sh
. $HOME/.bash_profile

day= ' Date +%a '
File_target=backup_expdp_ ' expr $DAY '. DMP
File_log=backup_expdp_ ' expr $DAY '. LOG

Cd/home/oracle/backup/data/expdp
Rm-f $FILE _target
Rm-f $FILE _log

Export File_target File_log

EXPDP ***/***@*** schemas=*** directory=backup_expdp_dir dumpfile= $FILE _target logfile= $FILE _log Job_name=cases_ Export parallel=4

----the imported command line
IMPDP ***/***@*** schemas=*** directory=backup_expdp_dir dumpfile=backup_expdp_fri.dmp logfile=backup_expdp_in.log Job_name=cases_export