RMAN自动备份脚本
环境:Linux4U5+ORACLE10GR2
1.备份脚本如下:
level 0级备份脚本
#!/bin/sh
export ORACLE_SID=hdi26
export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
export PATH=.:$ORACLE_HOME/bin:$PATH:.
rman target / << EOF
run
{
backup incremental level 0 database;
backup archivelog from time 'sysdate-0.98';
}
exit
EOF
level 1级备份脚本
#!/bin/sh
export ORACLE_SID=hdi26
export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
export PATH=.:$ORACLE_HOME/bin:$PATH:.
rman target / << EOF
run
{
backup incremental level 1 database;
backup archivelog from time 'sysdate-0.98';
}
exit
EOF
2.在oracle用户下crontab中添加如下内容:
crontab –e
# *** rman backup *** #
55 23 * * 7 sh /home/oracle/backupscript/incr0.sh
55 23 * * 1,2,3,4,5,6 sh /home/oracle/backupscript/incr1.sh
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/7419833/viewspace-512226/ ，如需转载，请注明出处，否则将追究法律责任。
最新文章
- UPGRADE CATALOG
- Linux oracle 10g 直接使用LUN创建ASM DISKGROUP
- How To : OCR / Vote disk Maintenance Operations: (ADD/REMOVE/REPLACE/MOVE)
- DataGuard ORA-01119 ORA-27054错误解决
- Redhat Linux 5.6双网卡绑定
- RAC实验 新增节点
- RAC Failover测试及VIP漂移观察
- RAC客户端连接测试
- asm:ORA-00600: internal error code, arguments: [kfgFinalize_2]
- 清除10g RAC CRS的方法
