RMAN备份脚本

来源：互联网发布：手机淘宝店铺号怎么看编辑：程序博客网时间：2024/05/16 06:10

环境：数据库 ORACLE 10.2.0.4.0 系统： linux enterprise 4

=================备份脚本===================

开始准备了两份备份脚本如下:

backup_full0.rcv.rman -------全库备份及控制文件

[oracle@qht111 rman_script]$ cat backup_full0.rcv
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u01/RMAN/%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO COMPRESSED BACKUPSET;
run {
crosscheck archivelog all;
delete expired archivelog all;
crosscheck backup;
delete expired backup;
allocate channel c1 type disk;
backup incremental level 0 database format '/u01/RMAN/db0%u_%s_%p.bak' include current controlfile;
sql 'alter system archive log current';
backup filesperset 1 format '/u01/RMAN/arch%u_%s_%p.bak'
archivelog all delete input;
release channel c1;
}
exit;

backup_inc1.rcv -------增量备份

[oracle@qht111 rman_script]$ cat backup_inc1.rcv
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u01/RMAN/%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO COMPRESSED BACKUPSET;
run {
crosscheck archivelog all;
delete expired archivelog all;
crosscheck backup;
delete expired backup;
allocate channel c1 type disk;
backup incremental level 1 database format '/u01/RMAN/db0%u_%s_%p.bak' include current controlfile;
sql 'alter system archive log current';
backup filesperset 1 format '/u01/RMAN/arch%u_%s_%p.bak'
archivelog all delete input;
release channel c1;
}
exit;

==================创建SH脚本=====================

在创建连个sh脚本执行上面两个备份脚本

-------------------------------------------------------------------------------------------------------------------------------------

auto_opt_bak0.sh 执行脚本database_bak0.rman

#!/bin/sh
source /home/orcl/.bash_profile

rman target / log=/u02/oradata/script/backup_full0.log cmdfile=/u02/oradata/script/backup_full0.rcv

auto_opt_bak1.sh 执行脚本 database_bak1.rman

#!/bin/sh
source /home/orcl/.bash_profile
rman target / log=/u02/oradata/script/backup_inc1.log cmdfile=/u02/oradata/script/backup_inc1.rcv