Chinaunix首页 | 论坛 | 博客
  • 博客访问: 1085846
  • 博文数量: 227
  • 博客积分: 6860
  • 博客等级: 准将
  • 技术积分: 2688
  • 用 户 组: 普通用户
  • 注册时间: 2010-07-02 16:06
文章分类

全部博文(227)

文章存档

2015年(7)

2014年(8)

2012年(5)

2011年(62)

2010年(145)

分类: Oracle

2011-01-16 15:13:59

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查看自动备份脚本。
阅读(1684) | 评论(0) | 转发(0) |
0

上一篇:ORA-01152

下一篇:RMAN系列-控制文件丢失

给主人留下些什么吧!~~