oracle rman 增量备份脚本
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了oracle rman 增量备份脚本,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含2442字,纯文字阅读大概需要4分钟。
内容图文
![oracle rman 增量备份脚本](/upload/InfoBanner/zyjiaocheng/464/89fe0435c6424a66816965b887b3b4a9.jpg)
配置控制文件备份路径
- RMAN > CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO ‘/u01/backup/rmanbk/ccontrolfile_%F‘;
- $ mkdir -p /u01/backup/rmanbk
- RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
0级备份脚本
- vim rman_bk_level0.sh
- ------0级备份----------------
- #! /bin/bash
- export ORACLE_SID=orcl
- export NLS_LANG=‘AMERICAN_AMERICA.ZHS16GBK‘
- /u01/app/oracle/11.2.0/dbhome_1/bin/rman target / <<EOF
- run{
- allocate channel d1 type disk;
- allocate channel d2 type disk;
- backup incremental level 0 database format ‘/u01/backup/rmanbk/level0_%d_%s_%p_%u.bkp‘;
- sql ‘alter system archive log current‘;
- backup archivelog all delete input format ‘/u01/backup/rmanbk/log_%d_%s_%p_u%.bkp‘;
- }
- crosscheck backup;
- delete noprompt obsolete;
- exit;
- <<EOF
- ------------------
1级备份脚本
- vim rman_bk_level1.sh
- ---------1级增量备份---------------
- #! /bin/bash
- export ORACLE_SID=orcl
- export NLS_LANG=‘AMERICAN_AMERICA.ZHS16GBK‘
- /u01/app/oracle/11.2.0/dbhome_1/bin/rman target / <<EOF
- run{
- allocate channel d1 type disk;
- allocate channel d2 type disk;
- backup incremental level 1 database format ‘/u01/backup/rmanbk/level1_%d_%s_%p_%u.bkp‘;
- sql ‘alter system archive log current‘;
- backup archivelog all delete input format ‘/u01/backup/rmanbk/log_%d_%s_%p_u%.bkp‘;
- }
- crosscheck backup;
- delete noprompt obsolete;
- exit;
- <<EOF
- vim rman_bk_level2.sh
- ---------2级增量备份---------------
- #! /bin/bash
- export ORACLE_SID=orcl
- export NLS_LANG=‘AMERICAN_AMERICA.ZHS16GBK‘
- /u01/app/oracle/11.2.0/dbhome_1/bin/rman target / <<EOF
- run{
- allocate channel d1 type disk;
- allocate channel d2 type disk;
- backup incremental level 2 database format ‘/u01/backup/rmanbk/level2_%d_%s_%p_%u.bkp‘;
- sql ‘alter system archive log current‘;
- backup archivelog all delete input format ‘/u01/backup/rmanbk/log_%d_%s_%p_u%.bkp‘;
- }
- crosscheck backup;
- delete noprompt obsolete;
- release d1;
- exit;
- <<EOF
加入到crontab中
- crontab -e
- -----------
- #周日0级备份
- 00 23 * * 0 /u01/backup_shell/rman_bk_level0.sh
- #周一、二、四、五、六2级增量备份
- 00 23 * * 1,2,4,5,6 /u01/backup_shell/rman_bk_level2.sh
- #周三1级增量备份
- 00 23 * * 3 /u01/backup_shell/rman_bk_level1.sh
oracle rman 增量备份脚本
标签:
本文系统来源:http://www.cnblogs.com/lizheng19822003/p/5501897.html
内容总结
以上是互联网集市为您收集整理的oracle rman 增量备份脚本全部内容,希望文章能够帮你解决oracle rman 增量备份脚本所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。