Oracle数据库中rman备份脚本非常实用(二)

2015-01-21 12:31:46 · 作者: · 浏览: 6
bsolete;


2级运行脚本


[oracle@oracle122 script]$ cat exec_2_level.sh
ORACLE_HOSTNAME=oracle122; export ORACLE_HOSTNAME
ORACLE_BASE=/u01/app; export ORACLE_BASE
ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1; export ORACLE_HOME
ORACLE_SID=orcl; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH
export DATE=$(date +%Y_%m_%d)
export NLS_LANG="Simplified Chinese_china".AL32UTF8


/u01/app/oracle/product/11.2.0/dbhome_1/bin/rman target sys/sys_admin cmdfile /home/oracle/rmanbak/script/db_bak2.rman log /home/oracle/rmanbak/script/log/rman_$DATE.log append?


定时备份星期天为0级全备,星期三为2级备份,星期一,星期二,星期四,星期五,星期六为1级增量备份晚上11点开始备份


[oracle@oracle122 script]$ crontab -l
*?23 * * ?0 /home/oracle/rmanbak/script/exec_0_level.sh
*?23 * *? 1 /home/oracle/rmanbak/script/exec_1_level.sh
*?23 * *? 2 /home/oracle/rmanbak/script/exec_1_level.sh
*?23 * *? 3 /home/oracle/rmanbak/script/exec_2_level.sh
*?23 * * ?4 /home/oracle/rmanbak/script/exec_1_level.sh
*?23 * *? 5 /home/oracle/rmanbak/script/exec_1_level.sh
*?23 * * ?6 /home/oracle/rmanbak/script/exec_1_level.sh


--------------------------------------推荐阅读 --------------------------------------


--------------------------------------分割线 --------------------------------------