Oracle Server Automatic Backup
1.
$sqlplus/nolog$conn sys/as sysdbasql> Create directory Expdata as '/home/oracle/oraclebak ';D irectory created. Sql> Grant Read,write on the directory expdata to public; Sql> exit
2.
$mkdir/home/oracle/oraclebak
3. Create Backup corner book, give execution permission
----------------------
#!/bin/sh export oracle_base =/home/oracle/app/oracle export oracle_home= $ORACLE _base/db11g export oracle_sid=x export path= $PATH: $HOME/bin: $ORACLE _home/bin export data_dir=/home/oracle/ Oraclebak export del_time= ' date -d ' 5 days ago " +%y%m%d ' export bakup_time= ' date +%Y%m% d%h%m%s ' echo starting bakup ... ' echo "bakup file path $DATA _dir/$BAKUPTIME. DMP" expdp system/' password ' directory=expdata dumpfile= $BAKUP _time.dmp full=y logfile= $BAKUP _ time.log echo "Delete the file bakup before 5 days " rm -rf $DATA _dir/$DEL _time*.dmp $ data_dir/$DELTIME *.log echo "Delete the file bakup successfully. "
4.
$crontab-E
#!/bin/sh 3 * * */home/oracle/orale.bak.sh
This article is from the "Starseven" blog, make sure to keep this source http://lcpljc.blog.51cto.com/200989/1901188
Oracle Server Automatic Backup