linux下rman备份恢复实例,Linux环境下的一个rman备份的实例脚本

背景：目标数据库192.168.1.172 Redhat Linux AS 3.0 Oracle 9.2.0.6

恢复目录数据库 192.168.1.244 Windows2000 Oracle 9.2.0.1 rman/rman

1、配置catalog恢复目录

create tablespace ts_rman datafile='d:oratestrman.dbf' size=100M;

create user rman identified by rman default tablespace ts_rman;

grant connect ,resource , RECOVERY_CATALOG_OWNER to rman;

连接到目标数据库和CATALOG数据库

rman target / catalog

创建CATALOG用户的表,登记目标数据库

rman> create catalog

rman> register database

配置参数

rman> configure controlfile autobackup on;

rman> configure backup optimization on;

2、rman备份方案

每周日晚做一次零级备份，周一到周六做一次一级备份

************************************************************************

*** rman_bk_L0.sh ***

************************************************************************

#!/bin/sh

source /home/oracle/.bash_profile

cd $ORACLE_HOME/bin

./rman target / catalog msglog=/home/oracle/work/log/rman_bk_L0_`date '+%Y%m%d%H%M%S'`.log <

run {

allocate channel c1 type disk;

backup incremental level 0 filesperset 5 tag 'dbL0' format '/mnt/raid/rman_bk/ora_o_%d_%t%s%p%u' database skip readonly;

sql 'alter system archive log current' ;

backup(archivelog all format '/mnt/raid/rman_bk/ora_a_%d_%t%s%p%u');

release channel c1;

}

list backup;

exit;

EOF

************************************************************************

*** rman_bk_L1.sh ***

************************************************************************

#!/bin/sh

source /home/oracle/.bash_profile

cd $ORACLE_HOME/bin

./rman target / catalog msglog=/home/oracle/work/log/rman_bk_L1_`date '+%Y%m%d%H%M%S'`.log <

run {

allocate channel c1 type disk;

backup incremental level 1 filesperset 5 tag 'dbL1' format '/mnt/raid/rman_bk/ora_o_%d_%t%s%p%u' database skip readonly;

sql 'alter system archive log current' ;

backup(archivelog all format '/mnt/raid/rman_bk/ora_a_%d_%t%s%p%u');

release channel c1;

}

list backup;

exit;

EOF

然后使用crontab命令在linux上安排job如下：

00 02 * * 0 /home/oracle/work/bin/rman_bk_L0.sh

00 02 * * 1,2,3,4,5,6 /home/oracle/work/bin/rman_bk_L1.sh

注意：每周一要将冗余的备份手工清除掉

rman> report obsolete;

rman> delete obsolete;