ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 典型的一周备份脚本

典型的一周备份脚本

原创 Linux操作系统 作者:jasoname 时间:2011-01-16 19:12:21 0 删除 编辑
bakl0----->backup incremental level 0 database format '/oracle/orabak/databak/%T_%u.dbf' plus archivelog format  '/oracle/orabak/logbak/%T_%u.arc' delete input;
bakl1----->backup incremental level 1 database format '/oracle/orabak/databak/%T_%u.dbf' plus archivelog format  '/oracle/orabak/logbak/%T_%u.arc' delete input;
bakl2----->backup incremental level 2 database format '/oracle/orabak/databak/%T_%u.dbf' plus archivelog format  '/oracle/orabak/logbak/%T_%u.arc' delete input;

rman target/ msglog=/oracle/orabak/script/bakl0.log cmdfile=/oracle/orabak/script/bakl0
rman target/ msglog=/oracle/orabak/script/bakl1.log cmdfile=/oracle/orabak/script/bakl1
rman target/ msglog=/oracle/orabak/script/bakl2.log cmdfile=/oracle/orabak/script/bakl2

crontab -e -n oracle

45 23 * * 0 rman target/ msglog=/oracle/orabak/script/bakl0.log cmdfile=/oracle/orabak/script/bakl0
45 23 * * 1 rman target/ msglog=/oracle/orabak/script/bakl2.log cmdfile=/oracle/orabak/script/bakl2
45 23 * * 2 rman target/ msglog=/oracle/orabak/script/bakl2.log cmdfile=/oracle/orabak/script/bakl2
45 23 * * 3 rman target/ msglog=/oracle/orabak/script/bakl1.log cmdfile=/oracle/orabak/script/bakl1
45 23 * * 4 rman target/ msglog=/oracle/orabak/script/bakl2.log cmdfile=/oracle/orabak/script/bakl2
45 23 * * 5 rman target/ msglog=/oracle/orabak/script/bakl2.log cmdfile=/oracle/orabak/script/bakl2
45 23 * * 6 rman target/ msglog=/oracle/orabak/script/bakl2.log cmdfile=/oracle/orabak/script/bakl2

crontab -l - n oracle查看自动备份脚本。

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/22741583/viewspace-683928/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2010-01-22

  • 博文量
    146
  • 访问量
    260098