[转帖]Nocatalog 下的RMAN 增量备份 shell脚本_MySQL, Oracle及数据库讨论区_Weblogic技术|Tuxedo技术|中间件技术|Oracle论坛|JAVA论坛|Linux/Unix技术|hadoop论坛

总帖数

每页帖数

1/1页

返回列表

发起投票

查看: 3695 | 回复: 0

主题： [转帖]Nocatalog 下的RMAN 增量备份 shell脚本

大红薯

注册用户

等级：少校
经验：1440
发帖：159
精华：0
注册：2011-7-21
状态：离线
发送短消息息给大红薯

加好友发送短消息息给大红薯

发消息

发表于：

2011-8-5 16:05:12 | [全部帖] [楼主帖]

楼主

之前整理了下catalog下全备的脚本，上次在生产库上弄了个nocatalog的脚本，结果没有在本本上保存，这次要用了，重新在整理了一下。

Linux 平台下 RMAN 全备和增量备份 shell 脚本

http://blog.csdn.net/tianlesoftware/archive/2010/07/16/5740630.aspx

在执行脚本之前，先修改几个参数值：

1. DB 参数：

修改控制文件的保存时间，从默认的7天改成14天

SQL> show parameter control
SQL> alter system set control_file_record_keep_time=14 scope=both;

2. RMAN 参数：

开启控制文件的自动备份，开启之后在数据库备份或者数据文件（比如添加数据文件）有修改的时候都会自动备份控制文件和spfile文件。

RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;
RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;

3. 备份策略根据自己的系统决

我这里是周日做0级备份。周四1级备份，其他2级备份。

4. 备份脚本如下：

##################################################################
## rman_incremental_backup.sh ##
## created by Tianlesoftware ##
## 2011-1-25 ##
##################################################################
#!/bin/ksh
export LANG=en_US
BACKUP_DATE=`date +%d`
RMAN_LOG_FILE=${0}.out
TODAY=`date`
USER=`id|cut -d "(" -f2|cut -d ")" -f1`
echo "-----------------$TODAY-------------------">$RMAN_LOG_FILE
ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
export ORACLE_HOME
RMAN=$ORACLE_HOME/bin/rman
export RMAN
ORACLE_SID=orcl
export ORACLE_SID
ORACLE_USER=oracle
export ORACLE_USER
echo "ORACLE_SID: $ORACLE_SID">>$RMAN_LOG_FILE
echo "ORACLE_HOME:$ORACLE_HOME">>$RMAN_LOG_FILE
echo "ORACLE_USER:$ORACLE_USER">>$RMAN_LOG_FILE
echo "==========================================">>$RMAN_LOG_FILE
echo "BACKUP DATABASE BEGIN......">>$RMAN_LOG_FILE
echo " ">>$RMAN_LOG_FILE
chmod 666 $RMAN_LOG_FILE
WEEK_DAILY=`date +%a`
case "$WEEK_DAILY" in
"Mon")
BAK_LEVEL=2
;;
"Tue")
BAK_LEVEL=2
;;
"Wed")
BAK_LEVEL=2
;;
"Thu")
BAK_LEVEL=1
;;
"Fri")
BAK_LEVEL=2
;;
"Sat")
BAK_LEVEL=2
;;
"Sun")
BAK_LEVEL=0
;;
"*")
BAK_LEVEL=error
esac
export BAK_LEVEL=$BAK_LEVEL
echo "Today is : $WEEK_DAILY incremental level= $BAK_LEVEL">>$RMAN_LOG_FILE
RUN_STR="
BAK_LEVEL=$BAK_LEVEL
export BAK_LEVEL
ORACLE_HOME=$ORACLE_HOME
export ORACLE_HOME
ORACLE_SID=$ORACLE_SID
export ORACLE_SID
$RMAN nocatalog TARGET sys/admin msglog $RMAN_LOG_FILE append <<EOF
run
{
      allocate channel c1 type disk;
      allocate channel c2 type disk;
      backup incremental level= $BAK_LEVEL skip inaccessible filesperset 5 Database format='/u01/backup/orcl_lev"$BAK_LEVEL"_%U_%T' tag='orcl_lev"$BAK_LEVEL"' ;
      sql 'alter system archive log current';
      backup archivelog all tag='arc_bak' format='/u01/backup/arch_%U_%T' skip inaccessible filesperset 5 not backed up 1 times delete input;
      backup current controlfile tag='bak_ctlfile' format='/u01/backup/ctl_file_%U_%T';
      backup spfile tag='spfile' format='/u01/backup/ORCL_spfile_%U_%T';
      release channel c2;
      release channel c1;
}
allocate channel for maintenance device type disk;
report obsolete;
delete noprompt obsolete;
crosscheck backup;
delete noprompt expired backup;
list backup summary;
release channel;
EOF
"
# Initiate the command string
if [ "$CUSER" = "root" ]
then
echo "Root Command String: $RUN_STR" >> $RMAN_LOG_FILE
su - $ORACLE_USER -c "$RUN_STR" >> $RMAN_LOG_FILE
RSTAT=$?
else
echo "User Command String: $RUN_STR" >> $RMAN_LOG_FILE
/bin/sh -c "$RUN_STR" >> $RMAN_LOG_FILE
RSTAT=$?
fi
# ---------------------------------------------------------------------------
# Log the completion of this script.
# ---------------------------------------------------------------------------
if [ "$RSTAT" = "0" ]
then
LOGMSG="ended successfully"
else
LOGMSG="ended in error"
fi
echo >> $RMAN_LOG_FILE
echo Script $0 >> $RMAN_LOG_FILE
echo ==== $LOGMSG on `date` ==== >> $RMAN_LOG_FILE
echo >> $RMAN_LOG_FILE
/bin/mailx -s "RMAN Backup SID " tianlesoftware@vip.qq.com < $RMAN_LOG_FILE
exit $RSTAT

5. 备份脚本的log 日志：

connected to target database: DAVE (DBID=801102850)
using target database control file instead of recovery catalog
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12>
allocated channel: c1
channel c1: sid=158 devtype=DISK
allocated channel: c2
channel c2: sid=147 devtype=DISK
Starting backup at 01-FEB-12
channel c1: starting incremental level 2 datafile backupset
channel c1: specifying datafile(s) in backupset
input datafile fno=00001 name=/u01/app/oracle/oradata/orcl/system.256.736598559
input datafile fno=00004 name=/u01/app/oracle/oradata/orcl/users.259.736598641
channel c1: starting piece 1 at 01-FEB-12
channel c2: starting incremental level 2 datafile backupset
channel c2: specifying datafile(s) in backupset
input datafile fno=00003 name=/u01/app/oracle/oradata/orcl/sysaux.257.736598563
input datafile fno=00002 name=/u01/app/oracle/oradata/orcl/undotbs1.258.736598599
channel c2: starting piece 1 at 01-FEB-12
channel c1: finished piece 1 at 01-FEB-12
piece handle=/u02/backup/orcl_lev2_0dn287g3_1_1_20120201 tag=ORCL_LEV2 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:36
channel c2: finished piece 1 at 01-FEB-12
piece handle=/u02/backup/orcl_lev2_0en287g3_1_1_20120201 tag=ORCL_LEV2 comment=NONE
channel c2: backup set complete, elapsed time: 00:00:36
Finished backup at 01-FEB-12
Starting Control File and SPFILE Autobackup at 01-FEB-12
piece handle=/u01/app/oracle/flash_recovery_area/DAVE/autobackup/2012_02_01/o1_mf_s_774118951_7lmfms6s_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 01-FEB-12
sql statement: alter system archive log current
Starting backup at 01-FEB-12
current log archived
channel c1: starting archive log backupset
channel c1: specifying archive log(s) in backup set
input archive log thread=1 sequence=9 recid=9 stamp=774118956
channel c1: starting piece 1 at 01-FEB-12
channel c2: starting archive log backupset
channel c2: specifying archive log(s) in backup set
input archive log thread=1 sequence=10 recid=10 stamp=774118956
channel c2: starting piece 1 at 01-FEB-12
channel c1: finished piece 1 at 01-FEB-12
piece handle=/u02/backup/arch_0hn287hc_1_1_20120201 tag=ARC_BAK comment=NONE
channel c1: backup set complete, elapsed time: 00:00:02
channel c1: deleting archive log(s)
archive log filename=/u01/archivelog/1_9_738254360.arch recid=9 stamp=774118956
channel c2: finished piece 1 at 01-FEB-12
piece handle=/u02/backup/arch_0gn287hc_1_1_20120201 tag=ARC_BAK comment=NONE
channel c2: backup set complete, elapsed time: 00:00:03
channel c2: deleting archive log(s)
archive log filename=/u01/archivelog/1_10_738254360.arch recid=10 stamp=774118956
Finished backup at 01-FEB-12
Starting backup at 01-FEB-12
channel c1: starting full datafile backupset
channel c1: specifying datafile(s) in backupset
including current control file in backupset
channel c1: starting piece 1 at 01-FEB-12
channel c1: finished piece 1 at 01-FEB-12
piece handle=/u02/backup/ctl_file_0in287hg_1_1_20120201 tag=BAK_CTLFILE comment=NONE
channel c1: backup set complete, elapsed time: 00:00:02
Finished backup at 01-FEB-12
Starting backup at 01-FEB-12
channel c1: starting full datafile backupset
channel c1: specifying datafile(s) in backupset
including current SPFILE in backupset
channel c1: starting piece 1 at 01-FEB-12
channel c1: finished piece 1 at 01-FEB-12
piece handle=/u02/backup/ORCL_spfile_0jn287hi_1_1_20120201 tag=SPFILE comment=NONE
channel c1: backup set complete, elapsed time: 00:00:01
Finished backup at 01-FEB-12
Starting Control File and SPFILE Autobackup at 01-FEB-12
piece handle=/u01/app/oracle/flash_recovery_area/DAVE/autobackup/2012_02_01/o1_mf_s_774118963_7lmfn45l_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 01-FEB-12
released channel: c2
released channel: c1
RMAN> RMAN>
allocated channel: ORA_MAINT_DISK_1
channel ORA_MAINT_DISK_1: sid=158 devtype=DISK
RMAN> RMAN>
RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 7 days
no obsolete backups found
RMAN> RMAN>
RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 7 days
no obsolete backups found
RMAN> RMAN>
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/backup/orcl_lev2_06n2877c_1_1_20120201 recid=1 stamp=774118636
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/backup/orcl_lev2_05n2877c_1_1_20120201 recid=2 stamp=774118636
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/flash_recovery_area/DAVE/autobackup/2012_02_01/o1_mf_s_774118723_7lmfdojy_.bkp recid=3 stamp=774118725
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/backup/arch_08n287ab_1_1_20120201 recid=4 stamp=774118732
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/backup/arch_09n287ab_1_1_20120201 recid=5 stamp=774118732
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/backup/ctl_file_0an287al_1_1_20120201 recid=6 stamp=774118742
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/backup/ORCL_spfile_0bn287ao_1_1_20120201 recid=7 stamp=774118744
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/flash_recovery_area/DAVE/autobackup/2012_02_01/o1_mf_s_774118745_7lmffb20_.bkp recid=8 stamp=774118746
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/backup/orcl_lev2_0dn287g3_1_1_20120201 recid=9 stamp=774118915
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/backup/orcl_lev2_0en287g3_1_1_20120201 recid=10 stamp=774118923
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/flash_recovery_area/DAVE/autobackup/2012_02_01/o1_mf_s_774118951_7lmfms6s_.bkp recid=11 stamp=774118953
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/backup/arch_0gn287hc_1_1_20120201 recid=12 stamp=774118957
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/backup/arch_0hn287hc_1_1_20120201 recid=13 stamp=774118957
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/backup/ctl_file_0in287hg_1_1_20120201 recid=14 stamp=774118961
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/backup/ORCL_spfile_0jn287hi_1_1_20120201 recid=15 stamp=774118962
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/flash_recovery_area/DAVE/autobackup/2012_02_01/o1_mf_s_774118963_7lmfn45l_.bkp recid=16 stamp=774118964
Crosschecked 16 objects
RMAN> RMAN>
RMAN> RMAN>
List of Backups
===============
Key     TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
1       B  2  A DISK        01-FEB-12       1       1       NO         ORCL_LEV2
2       B  2  A DISK        01-FEB-12       1       1       NO         ORCL_LEV2
3       B  F  A DISK        01-FEB-12       1       1       NO         TAG20120201T165843
4       B  A  A DISK        01-FEB-12       1       1       NO         ARC_BAK
5       B  A  A DISK        01-FEB-12       1       1       NO         ARC_BAK
6       B  F  A DISK        01-FEB-12       1       1       NO         BAK_CTLFILE
7       B  F  A DISK        01-FEB-12       1       1       NO         SPFILE
8       B  F  A DISK        01-FEB-12       1       1       NO         TAG20120201T165905
9       B  2  A DISK        01-FEB-12       1       1       NO         ORCL_LEV2
10      B  2  A DISK        01-FEB-12       1       1       NO         ORCL_LEV2
11      B  F  A DISK        01-FEB-12       1       1       NO         TAG20120201T170231
12      B  A  A DISK        01-FEB-12       1       1       NO         ARC_BAK
13      B  A  A DISK        01-FEB-12       1       1       NO         ARC_BAK
14      B  F  A DISK        01-FEB-12       1       1       NO         BAK_CTLFILE
15      B  F  A DISK        01-FEB-12       1       1       NO         SPFILE
16      B  F  A DISK        01-FEB-12       1       1       NO         TAG20120201T170243
RMAN> RMAN>
released channel: ORA_MAINT_DISK_1
RMAN> RMAN>
Recovery Manager complete.
Script rman_incremental_backup.sh
==== ended successfully on Wed Feb 1 17:02:50 EST 2012 ====

6. 将备份脚本添加到Crontab

[oracle@singledb u02]$ crontab -l
20 17 * * * /u02/rman_incremental_backup.sh 1>/u02/rman.log 2>&1 &

关于crontab 参考：

Linux Crontab 定时任务命令详解

http://blog.csdn.net/tianlesoftware/archive/2010/02/21/5315039.aspx