1.rman 配置库

RMAN> show all;
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 14 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/oracle/backdump/rmbackup/cf_%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   '/oracle/backdump/rmbackup/df_%s_%d';
CONFIGURE MAXSETSIZE TO 4096 M; 
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/ora9/product/9.2/dbs/snapcf_CTMESP1.f'; # default

2.OEM中rman 备份脚本 (ctmesp1_rmbk)

RUN { BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
      DELETE FORCE NOPROMPT OBSOLETE DEVICE TYPE DISK; }
---
run { 
allocate channel Channel1 type disk format '/oradata/maintain/rman_bk/bk_%d_%s';
backup  
   ( database  include current controlfile );
backup  ( archivelog all  delete input );
}
allocate channel for maintenance device type disk;
delete obsolete device type disk;

3.OEM中写磁带脚本
---(dbph_totape)
prompt backup file(/oradata/backup/) to Tape ..
prompt Start Time ..
select to_char(sysdate,'DD-MON-YY HH24:MI') from dual;
host tar -cvf /dev/rmt0 /oradata/backup
prompt
prompt Ending backup file to Tape
select to_char(sysdate,'DD-MON-YY HH24:MI') from dual;
prompt list tape content ..
host tar -tvf /dev/rmt0
host find /oradata/backup/ -mtime +3|xargs rm -f
exit;
;
---(csmesp1_totape)
PROMPT backup file(/oradata/backdump/rmbackup) to Tape ..
PROMPT Start Time ..
select to_char(sysdate,'DD-MON-YY HH24:MI') from dual;
host tar -cvf /dev/rmt0 /oradata/backdump/rmbackup
PROMPT 
PROMPT Ending backup file to Tape ..
select to_char(sysdate,'DD-MON-YY HH24:MI') from dual;
PROMPT listing tape content ..
host tar -tvf /dev/rmt0
host rm -f /oradata/backdump/rmbackup/*
exit;
;

---(ctmesp1_totape)

set pagesize 200
set linesize 140
select file#,status, to_char(time,'DD-MM-YYYY HH24:Mi') TIME from v$backup;
PROMPT Begin backup file to Tape ..
PROMPT Start Time ..
select to_char(sysdate,'DD-MM-YYYY HH24:Mi') from dual;
host tar -cvf /dev/rmt0 /oracle/backdump/rmbackup
PROMPT
PROMPT Ending backup file to Tape ..
select to_char(sysdate,'DD-MM-YYYY HH24:Mi') from dual;
PROMPT listing tape content ..
host tar -tvf /dev/rmt0
host rm -f /oracle/backdump/rmbackup/*;
PROMPT Change Tape slot ...
host sh /oracle/maintain/rman/tape_cg.sh;

4.磁带库交换磁带脚本(tape_cg.sh)
$ cat tape_cg.sh
#!/bin/sh
idate=`date +%w`
pre=`expr $idate - 1 `
tapeutil -f /dev/rmt0 unmount $pre&&tapeutil -f /dev/rmt0 mount $idate$

注：
下面的写法可以避免星期天 date +%w = 0 时出错!
(原来的写法 tapeutil -f /dev/rmt0 unmount 0&&tapeutil -f /dev/rmt0 mount 1;; )
#!/bin/sh
idate= date +%w
case $idate in
1)tapeutil -f /dev/rmt0 unmount ; tapeutil -f /dev/rmt0 mount 1;;
2)tapeutil -f /dev/rmt0 unmount ; tapeutil -f /dev/rmt0 mount 2;;
3)tapeutil -f /dev/rmt0 unmount ; tapeutil -f /dev/rmt0 mount 3;;
4)tapeutil -f /dev/rmt0 unmount ; tapeutil -f /dev/rmt0 mount 4;;
5)tapeutil -f /dev/rmt0 unmount ; tapeutil -f /dev/rmt0 mount 5;;
6)tapeutil -f /dev/rmt0 unmount ; tapeutil -f /dev/rmt0 mount 6;;
0)tapeutil -f /dev/rmt0 unmount ; tapeutil -f /dev/rmt0 mount 7;;
esac