Oracle Server Automatic Backup

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