crontab+rman定期删除Oracle测试库的归档日志
来源:互联网 发布:怎么监控sqlite数据库 编辑:程序博客网 时间:2024/05/19 02:02
1、删除的脚本如下,各种环境变量,通过env来获取。若不列出环境变量,则crontab在调度脚本的时候,会提示找不到命令之类的错误
cat clearLog.sh
export ORACLE_HOME=/path/rdbms/12c/12.1.0.2.160119
export SHELL_PATH=/etc/paic/shell
export XDG_SESSION_ID=283283
export HOSTNAME=cnsh281177
export SHELL=/bin/bash
export TERM=vt100
export HISTSIZE=1000
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
export ORACLE_DOC=/path/rdbms/doc
export OLDPWD=/path/rdbms/toracle
export USER=toracle
export LD_LIBRARY_PATH=:/path/rdbms/12c/12.1.0.2.160119/lib:/paic/app/t0parebi/goldengate:/path/rdbms/12c/12.1.0.2.160119/lib
export ORACLE_SID=t0parebi
export ORACLE_BASE=/path/rdbms
export TMOUT=1800
export GGS_HOME=/paic/app/t0parebi/goldengate
export MAIL=/var/spool/mail/toracle
export PATH=/path/rdbms/12c/12.1.0.2.160119/bin:/path/rdbms/toracle/sh:/oracle_grid/12.1.0/grid/bin:/sbin:/usr/sbin:/opt/VRTS/bin:/opt/VRTSvcs/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin:/paic/app/t0parebi/goldengate
export ORA_ENCRYPT_LOGIN=true
export PWD=/path/rdbms/toracle/zad
export EDITOR=vi
export LANG=en_US
/path/rdbms/12c/12.1.0.2.160119/bin/rman nocatalog log /path/rdbms/toracle/zad/del_arch`date +%Y%m%d`.log <<EOF
connect target /
#crosscheck archivelog all;
#delete noprompt expired archivelog all;
DELETE noprompt ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-2';
exit;
EOF
2、编写crontab
crontab -l
53 09 * * * /path/toracle/zad/clearLog.sh
注:
这里在调试程序时,手动运行脚本并不报错。
但通过crontab来调度的时,会出现问题。出错的日志,见/var/spool/mail/os用户
Date: Mon, 10 Jul 2017 09:46:01 +0800 (CST)
Message file RMAN<lang>.msb not found
Verify that ORACLE_HOME is set properly
cat clearLog.sh
export ORACLE_HOME=/path/rdbms/12c/12.1.0.2.160119
export SHELL_PATH=/etc/paic/shell
export XDG_SESSION_ID=283283
export HOSTNAME=cnsh281177
export SHELL=/bin/bash
export TERM=vt100
export HISTSIZE=1000
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
export ORACLE_DOC=/path/rdbms/doc
export OLDPWD=/path/rdbms/toracle
export USER=toracle
export LD_LIBRARY_PATH=:/path/rdbms/12c/12.1.0.2.160119/lib:/paic/app/t0parebi/goldengate:/path/rdbms/12c/12.1.0.2.160119/lib
export ORACLE_SID=t0parebi
export ORACLE_BASE=/path/rdbms
export TMOUT=1800
export GGS_HOME=/paic/app/t0parebi/goldengate
export MAIL=/var/spool/mail/toracle
export PATH=/path/rdbms/12c/12.1.0.2.160119/bin:/path/rdbms/toracle/sh:/oracle_grid/12.1.0/grid/bin:/sbin:/usr/sbin:/opt/VRTS/bin:/opt/VRTSvcs/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin:/paic/app/t0parebi/goldengate
export ORA_ENCRYPT_LOGIN=true
export PWD=/path/rdbms/toracle/zad
export EDITOR=vi
export LANG=en_US
/path/rdbms/12c/12.1.0.2.160119/bin/rman nocatalog log /path/rdbms/toracle/zad/del_arch`date +%Y%m%d`.log <<EOF
connect target /
#crosscheck archivelog all;
#delete noprompt expired archivelog all;
DELETE noprompt ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-2';
exit;
EOF
2、编写crontab
crontab -l
53 09 * * * /path/toracle/zad/clearLog.sh
注:
这里在调试程序时,手动运行脚本并不报错。
但通过crontab来调度的时,会出现问题。出错的日志,见/var/spool/mail/os用户
如下日志报错,可以看到是因为没有设置环境变量ORACLE_HOME,导致rman在执行操作时出错。
tail -20 /var/spool/mail/toracle
Message-Id: <20170710014601.3B21D1801010@cnsh281177.localdomain>Date: Mon, 10 Jul 2017 09:46:01 +0800 (CST)
Message file RMAN<lang>.msb not found
Verify that ORACLE_HOME is set properly
阅读全文
0 0
- crontab+rman定期删除Oracle测试库的归档日志
- ORACLE Rman删除归档日志
- oracle 归档日志删除 RMAN基本入门
- rman删除归档日志
- rman删除归档日志
- rman删除归档日志
- RMAN删除过期的归档日志
- 利用RMAN进行归档日志的删除
- 通过Rman定期删除归档脚本
- RMAN手动删除归档日志
- 手工物理删除Oracle归档日志RMAN备份报错
- oracle rac rman 批量删除归档日志脚本
- Windows平台使用RMAN命令自动删除Oracle过期归档日志的方法
- Oracle RMAN 清除归档日志
- Oracle RMAN 清除归档日志
- Oracle RMAN 清除归档日志
- Oracle RMAN 清除归档日志
- 通过rman的delete命令删除归档日志文件
- 反射
- javascript语言精粹(继承)
- JAVA设计模式之单例模式
- JVM原理和优化
- 订单支付成功,检测本地数据库是否同步,定时查看本地订单状态
- crontab+rman定期删除Oracle测试库的归档日志
- Java获取 ISO 8601格式时间
- poi导出excel指定单元格格式
- Qt 文件创建与内容存储
- HDU1096 A+B for Input-Output Practice (VIII)
- Android Gson:javabean与json字符串之间的转换
- camera摄像原理之三:色温和自动白平衡
- 因修改SYS密码引起的gap问题修复
- Android 基于google Zxing实现二维码、条形码扫描,仿微信二维码扫描效果