oracle数据库中rman备份脚本非常实用
查询字符集
sql> select * from nls_database_parameters;
nls_characterset
al32utf8
备份时字符集很重要，，不然会出乱码
一、0级备份（全备）红色是要修改的，根据个人的存放位置。
[oracle@oracle122 script]$ cat db_bak0.rman
run
{
configure retention policy to recovery window of 8 days;
configure controlfile autobackup on;
configure controlfile autobackup format for device type disk to '/home/oracle/rmanbak/%f';
allocate channel ch1 device type disk format '/home/oracle/rmanbak/inc0_%d_%s_%p_%u_%t';
backup incremental level 0 tag='level 0' database skip inaccessible filesperset 10 plus archivelog filesperset 20;
release channel ch1;
}
allocate channel for maintenance device type disk;
crosscheck backup;
delete noprompt expired backup;
delete noprompt obsolete;
delete noprompt archivelog until time 'sysdate-30';
0级运行脚本
[oracle@oracle122 script]$ cat exec_0_level.sh
oracle_hostname=oracle122; export oracle_hostname
oracle_base=/u01/app; export oracle_base
oracle_home=/u01/app/oracle/product/11.2.0/dbhome_1; export oracle_home
oracle_sid=orcl; export oracle_sid
oracle_term=xterm; export oracle_term
path=/usr/sbin:$path; export path
path=$oracle_home/bin:$path; export path
export date=$(date +%y_%m_%d)
export nls_lang=simplified chinese_china.al32utf8
/u01/app/oracle/product/11.2.0/dbhome_1/bin/rman target sys/sys_admin cmdfile /home/oracle/rmanbak/script/db_bak0.rman log /home/oracle/rmanbak/script/log/rman_$date.log append
二、1级备份（增量）
[oracle@oracle122 script]$ cat db_bak1.rman
run
{
configure retention policy to recovery window of 8 days;
configure controlfile autobackup on;
configure controlfile autobackup format for device type disk to '/home/oracle/rmanbak/%f';
allocate channel ch1 device type disk format '/home/oracle/rmanbak/inc1_%d_%s_%p_%u_%t';
backup incremental level 1 tag='level 1' database skip inaccessible filesperset 10 plus archivelog filesperset 20;
release channel ch1;
}
allocate channel for maintenance device type disk;
crosscheck backup;
delete noprompt expired backup;
delete noprompt obsolete;
delete noprompt archivelog until time 'sysdate-30';
1级运行脚本
[oracle@oracle122 script]$ cat exec_1_level.sh
oracle_hostname=oracle122; export oracle_hostname
oracle_base=/u01/app; export oracle_base
oracle_home=/u01/app/oracle/product/11.2.0/dbhome_1; export oracle_home
oracle_sid=orcl; export oracle_sid
oracle_term=xterm; export oracle_term
path=/usr/sbin:$path; export path
path=$oracle_home/bin:$path; export path
export date=$(date +%y_%m_%d)
export nls_lang=simplified chinese_china.al32utf8
/u01/app/oracle/product/11.2.0/dbhome_1/bin/rman target sys/sys_admin cmdfile /home/oracle/rmanbak/script/db_bak1.rman log /home/oracle/rmanbak/script/log/rman_$date.log append
三、2级备份（从0级追加到现在的备份）
[oracle@oracle122 script]$ cat db_bak2.rman
run
{
configure retention policy to recovery window of 8 days;
configure controlfile autobackup on;
configure controlfile autobackup format for device type disk to '/home/oracle/rmanbak/%f';
allocate channel ch1 device type disk format '/home/oracle/rmanbak/inc2_%d_%s_%p_%u_%t';
backup incremental level 2 tag='level 2' database skip inaccessible filesperset 10 plus archivelog filesperset 20 delete all input;
release channel ch1;
}
allocate channel for maintenance device type disk;
crosscheck backup;
delete noprompt expired backup;
delete noprompt obsolete;
2级运行脚本
[oracle@oracle122 script]$ cat exec_2_level.sh
oracle_hostname=oracle122; export oracle_hostname
oracle_base=/u01/app; export oracle_base
oracle_home=/u01/app/oracle/product/11.2.0/dbhome_1; export oracle_home
oracle_sid=orcl; export oracle_sid
oracle_term=xterm; export oracle_term
path=/usr/sbin:$path; export path
path=$oracle_home/bin:$path; export path
export date=$(date +%y_%m_%d)
export nls_lang=simplified chinese_china.al32utf8
/u01/app/oracle/product/11.2.0/dbhome_1/bin/rman target sys/sys_admin cmdfile /home/oracle/rmanbak/script/db_bak2.rman log /home/oracle/rmanbak/script/log/rman_$date.log append
定时备份星期天为0级全备，星期三为2级备份，星期一，星期二，星期四，星期五，星期六为1级增量备份晚上11点开始备份