oracle 增量备份脚本
来源:互联网 发布:送货单打印软件注册码 编辑:程序博客网 时间:2024/05/16 20:32
OS :RHEL AS 4 oracle 10g
0备份脚本
#!/bin/bash
# incremental level 0 backup script
source /home/oracle/.bash_profile
current_day=`date +%Y%m%d`
mkdir /home/oracle/RMANBACKUP/$current_day
rman target / <<EOF
run
{
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/RMANBACKUP/$current_day/PID-%F';
allocate channel dev1 type disk;
allocate channel dev2 type disk;
allocate channel dev3 type disk;
backup incremental level 0 tag='db0'
format '/home/oracle/RMANBACKUP/$current_day/%n_%T_%U' database;
sql 'alter system archive log current';
backup archivelog all format '/home/oracle/RMANBACKUP/$current_day/arc_%n_%T_%U' delete all input;
release channel dev1;
release channel dev2;
release channel dev3;
}
EOF
1级累积增量脚本
#!/bin/bash
# incremental level 1 backup script
source /home/oracle/.bash_profile
current_day=`date +%Y%m%d`
incr_day=incr$current_day
mkdir /home/oracle/RMANBACKUP/$incr_day
rman target / <<EOF
run
{
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/RMANBACKUP/$incr_day/PID-%F';
allocate channel dev1 type disk;
allocate channel dev2 type disk;
allocate channel dev3 type disk;
backup incremental level 1 cumulative tag='db1'
format '/home/oracle/RMANBACKUP/$incr_day/%n_%T_%U' database;
sql 'alter system archive log current';
backup archivelog all format '/home/oracle/RMANBACKUP/$incr_day/arc_%n_%T_%U' delete all input;
release channel dev1;
release channel dev2;
release channel dev3;
}
EOF
每天RMAN出来的backup set集合到一个文件夹下面
- oracle 增量备份脚本
- oracle 增量备份脚本
- windows下 Oracle 增量备份脚本文件
- [Rman]Oracle Rman增量备份Level012脚本
- Oracle的差异增量备份和累积增量备份,RMAN增量备份脚本
- rman增量备份脚本
- oracle 增量备份
- oracle rman增量备份
- oracle 数据库增量备份
- oracle增量更新备份
- oracle 数据库增量备份
- Oracle RMAN 增量备份
- oracle 数据库增量备份
- oracle rman 增量备份
- oracle增量备份
- Oracle增量备份原理
- Oracle RMAN-增量备份
- oracle定时备份-增量备份
- 初步
- Struts1 的环境搭建
- java中try catch finally与return的执行顺序
- ASM的磁盘创建过程
- 图片自动缩放 expression
- oracle 增量备份脚本
- ads编译时所发生的错误
- @@IDENTITY,SCOPE_IDENTITY,IDENT_CURRENT,吉祥3宝
- struts流程
- 第二课:Showing an application icon
- 数据库备份方案
- 经典语录
- [转载]p中影响编码的属性及其设置小结(contentType,pageEncoding,charset,setCharacterEncoding)
- log --fprintf()