oracle增量备份
来源:互联网 发布:手机淘宝首页超链接 编辑:程序博客网 时间:2024/05/16 01:34
采用0112111增量备份策略,7天一个轮回
也就是周日0级备份,周1 2 4 5 6 采用2级增量备份,周3采用1级增量备份
配置控制文件备份路径
RMAN > CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u01/backup/rmanbk/ccontrolfile_%F';
数据备份目录
$ mkdir -p /u01/backup/rmanbk
首先将过期天数设为7天
RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
下面开始创建0级 1级 2级备份脚本
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
2级备份脚本
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
-------------
也就是周日0级备份,周1 2 4 5 6 采用2级增量备份,周3采用1级增量备份
配置控制文件备份路径
RMAN > CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u01/backup/rmanbk/ccontrolfile_%F';
数据备份目录
$ mkdir -p /u01/backup/rmanbk
首先将过期天数设为7天
RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
下面开始创建0级 1级 2级备份脚本
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
2级备份脚本
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
-------------
0 0
- oracle 增量备份脚本
- oracle 增量备份脚本
- oracle 增量备份
- oracle rman增量备份
- oracle 数据库增量备份
- oracle增量更新备份
- oracle 数据库增量备份
- Oracle RMAN 增量备份
- oracle 数据库增量备份
- oracle rman 增量备份
- oracle增量备份
- Oracle增量备份原理
- Oracle RMAN-增量备份
- oracle定时备份-增量备份
- oracle定时备份-增量备份
- oracle增量备份及应用
- Oracle增量备份与恢复
- Oracle 增量备份的机制
- 001-Two sum
- Visual Studio 2015
- 【动态规划】完全背包、多重背包
- DBT3514W The db2prereqcheck utility failed to find the following 32-bit library file: "libstdc++.so
- TypeScript学习-类
- oracle增量备份
- java线程并发处理之Volatile关键字
- Redhat Enterprice Linux 6.2上安装g++编译器
- 笔试题一点问题总结
- 会话跟踪技术介绍——cookie,url 重写, 隐藏表单域
- http 错误代码表
- LogoView加载图片的设置及跳转
- Raspberry Pi 树莓派入门
- 数据库中的并发