RMAN 备份案例-shell 脚
通过shell 结合RMAN建立数据库的备份，可以简化数据库备份的工作，以下为一个备份案例：
系统环境：
操作系统：RedHat EL6
Oracle： Oracle 11gR2
本方案结合RMAN的Catalog DB建立备份，通过Catalog DB可以很方便的存储RMAN的备份脚本，方便备份的调用。
备份案例：
1、删除obsolete bakcup script
------按照备份保留策略，删除recovery windows 15 天以上的备份（obsolete)
create global script global_del_obso comment 'A script for obsolete backup and delete it'
{
crosscheck archivelog all;
delete noprompt expired archivelog all;
allocate channel ch1 device type disk;
delete noprompt obsolete recovery window of 15 days;
release channel ch1;
}
2、backup controlfile script
------备份控制文件
create global script global_bkctl comment 'A script for backup control file'
{
allocate channel ch1 device type disk;
backup as compressed backupset
current controlfile reuse
format='/dsk4/backup/backupctl.ctl'
tag='bkctl';
release channel ch1;
}
3、backup archivelog script
-----备份归档日志
create global script global_arch comment "backup archivelog and then delete it" {
allocate channel ch1 device type disk;
allocate channel ch2 device type disk;
sql "alter system archive log current";
set limit channel ch1 readrate=10240;
set limit channel ch1 kbytes=4096000;
set limit channel ch2 readrate=10240;
set limit channel ch2 kbytes=4096000;
backup as compressed backupset
format='/dsk4/backup/arch_%d_%U'
tag='bkarch'
archivelog all delete input;
release channel ch1;
release channel ch2;
}
对于数据文件建立增量备份
4、backup datafile script（level 0）
------增量备份 0级
create global script global_inc0 comment "backup database as incrmental level 0"{
execute global script global_del_obso;
allocate channel ch1 device type disk;
allocate channel ch2 device type disk;
set limit channel ch1 readrate=10240;
set limit channel ch1 kbytes=4096000;
set limit channel ch2 readrate=10240;
set limit channel ch2 kbytes=4096000;
backup as compressed backupset
incremental level 0 database
format='/dsk4/backup/inc0_%d_%U'
tag='inc0';
release channel ch1;
release channel ch2;
execute global script global_arch;
execute global script global_bkctl;
}
5、backup datafile script（level 1）
------差异备份 1级
create global script global_inc1 comment "backup database as incrmental level 1"{
execute global script global_del_obso;
allocate channel ch1 device type disk;
allocate channel ch2 device type disk;
set limit channel ch1 readrate=10240;
set limit channel ch1 kbytes=4096000;
set limit channel ch2 readrate=10240;
set limit channel ch2 kbytes=4096000;
backup as compressed backupset
incremental level 1 database
format='/dsk4/backup/inc1_%d_%U'
tag='inc1';
release channel ch1;
release channel ch2;
execute global script global_arch;
execute global script global_bkctl;
}
6、backup datafile script（level 1 cumulative）
----累积增量备份 1级
create global script global_inc1_cu comment "backup database as incrmental cumulative level 1"{
execute global script global_del_obso;
allocate channel ch1 device type disk;
allocate channel ch2 device type disk;
set limit channel ch1 readrate=10240;
set limit channel ch1 kbytes=4096000;
set limit channel ch2 readrate=10240;
set limit channel ch2 kbytes=4096000;
backup as compressed backupset
incremental level 1 cumulative database
format='/dsk4/backup/inc1_%d_%U'
tag='inc1';
release channel ch1;
release channel ch2;
execute global script global_arch;
execute global script global_bkctl;
}
7、list scripts
------查看catalog 库里的备份脚本
RMAN> list script names;
List of Stored Scripts in Recovery Catalog
Global Scripts
Script Name
Description
-----------------------------------------------------------------------
global_arch
backup archivelog and then delete it
global_bkctl
A script for backup control file
global_del_obso
A script for obsolete backup and delete it
global_inc0
backup database as incrmental level 0
global_inc1
backup database as incrmental level 1
global_inc1_cu
backup database as incrmental cumulative level 1
RMAN>
8、test scripts
------测试执行备份脚本
run{
execute global script global_inc0;
execute global script global_inc1;
execute global script global_inc1_cu;
}
9、建立RMAN连接Tartget DB和Catalog DB脚本及备份脚本
1、连接 target and catalog db
[oracle@rh6 script]$ cat connect.rcv
connect target sys/oracle@test1;
connect catalog rman/rman@cuug;
2、连接到target and catalog db ，执行备份
[oracle@rh6 script]$ cat inc0.rcv
@@/home/oracle/script/connect.rcv
run{
execute global script global_inc0;
}
[oracle@rh6 script]$ cat inc1.rcv
@@/home/oracle/script/connect.rcv
run{
execute global script global_inc1;
}
[oracle@rh6 script]$ cat inc1_cu.rcv
@@/home/oracle/script/connect.rcv
run{
execute global script global_inc1_cu;
}
[oracle@rh6 script]$
10、shell 备份脚本
[oracle@rh6 script]$ cat inc0.sh
nohup $ORACLE_HOME/bin/rman cmdfile=/home/oracle/script/inc0.rcv log=/home/oracle/script/inc0.log append &
[oracle@rh6 script]$ cat inc1.sh
nohup $ORACLE_HOME/bin/rman cmdfile=/home/oracle/script/inc1.rcv log=/home/oracle/script/inc1.log append &
[oracle@rh6 script]$ cat inc1_cu.sh
nohup $ORACLE_HOME/bin/rman cmdfile=/home/oracle/script/inc1_cu.rcv log=/home/oracle/script/inc1_cu.log append &
11、crontab 备份计划
[oracle@rh6 script]$ crontab -l
0 0 * * 0 sh /home/oracle/script/inc0.sh
0 0 * * 1 sh /home/oracle/script/inc1.sh
0 0 * * 2 sh /home/oracle/script/inc1.sh
0 0 * * 3 sh /home/oracle/script/inc1.sh
0 0 * * 4 sh /home/oracle/script/inc1_cu.sh
0 0 * * 5 sh /home/oracle/script/inc1.sh
0 0 * * 6 sh /home/oracle/script/inc1.sh