编写
批处理脚本:
#!/bin/sh
# source /home/oracle/.bash_profile
PATH=$PATH:$HOME/bin
export PATH
export ORACLE_BASE=/opt/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
export ORACLE_SID=tumooracle
export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib:/usr/lib:/usr/local/lib
export SQLPATH=/opt/oracle/product/11.2.0/db_1/sqlplus/admin
rman target / log=/u02/rman/logs/db_fullbak_tumo_`date +%Y%m%d%H%M`.log <<EOF
run {
configure retention policy to recovery window of 14 days;
configure controlfile autobackup on;
configure controlfile autobackup format for device type disk to '/opt/oracle/oradata/backup/%F';
configure archivelog deletion policy to applied on standby;
allocate channel c1 device type disk format '/opt/oracle/oradata/backup/BAK_%U';
backup database skip inaccessible
plus archivelog filesperset 2
delete input;
backup current controlfile;
release channel c1;
crosscheck backup;
delete noprompt obsolete;
}
EOF
保存为 /u02/script/db_fullback_tumo.sh
设定执行任务
crontab -e
添加如下:
0 24 * * * /u02/script/db_fullback_tumo.sh
(*/3 * * * * /u02/script/db_fullback_tumo.sh)
注,括号内的可以是做测试的时候用的,每分钟执行一次备份,例为每天凌晨24点执行备份
执行验证
在root 下执行 tail -f /var/log/cron 监视crontab 日志
查看对应目录是否生成了备份文件:
cd /opt/oracle/oradata/backup
ll
可以进一步查看 rman 日志看备份过程是否有错误。
参考:
《涂抹ORACLE-三思笔记之一步一步学Oracle》
http://www.2cto.com/os/201109/106291.html
http://blog.sina.com.cn/s/blog_67be3b45010180wy.html
#!/bin/sh
# source /home/oracle/.bash_profile
PATH=$PATH:$HOME/bin
export PATH
export ORACLE_BASE=/opt/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
export ORACLE_SID=tumooracle
export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib:/usr/lib:/usr/local/lib
export SQLPATH=/opt/oracle/product/11.2.0/db_1/sqlplus/admin
rman target / log=/u02/rman/logs/db_fullbak_tumo_`date +%Y%m%d%H%M`.log <<EOF
run {
configure retention policy to recovery window of 14 days;
configure controlfile autobackup on;
configure controlfile autobackup format for device type disk to '/opt/oracle/oradata/backup/%F';
configure archivelog deletion policy to applied on standby;
allocate channel c1 device type disk format '/opt/oracle/oradata/backup/BAK_%U';
backup database skip inaccessible
plus archivelog filesperset 2
delete input;
backup current controlfile;
release channel c1;
crosscheck backup;
delete noprompt obsolete;
}
EOF
保存为 /u02/script/db_fullback_tumo.sh
设定执行任务
crontab -e
添加如下:
0 24 * * * /u02/script/db_fullback_tumo.sh
(*/3 * * * * /u02/script/db_fullback_tumo.sh)
注,括号内的可以是做测试的时候用的,每分钟执行一次备份,例为每天凌晨24点执行备份
执行验证
在root 下执行 tail -f /var/log/cron 监视crontab 日志
查看对应目录是否生成了备份文件:
cd /opt/oracle/oradata/backup
ll
可以进一步查看 rman 日志看备份过程是否有错误。
参考:
《涂抹ORACLE-三思笔记之一步一步学Oracle》
http://www.2cto.com/os/201109/106291.html
http://blog.sina.com.cn/s/blog_67be3b45010180wy.html
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/30168575/viewspace-1769412/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/30168575/viewspace-1769412/