Home

一个oracle增量备份的实例

环境：Solaris9+oracle9i
part 1
增量备份的脚本ora_incr_bk.sh：
_____________________________________________________________
#!/usr/bin/bash

DATE=`date +%w`
DATE_2=`date +%Y%m%d`
BACKUP_PATH=/oradata/oradata_backup
LEVEL=$@
TARGET_SID=TNT_72
RMAN_SID=TNT_71
BIN=/oracle/app/oracle/product/9.2.0/bin

# Delete the data backed up last time
rm -rf $BACKUP_PATH/data/$DATE/*

if [ $LEVEL = 0 ]; then

$BIN/rman target sys/sys catalog rman/rman@$RMAN_SID log $BACKUP_PATH/log/level.$TARGET_SID.$LEVEL.$DATE_2.log<

resync catalog;
run{
allocate channel c3 type disk;
backup filesperset 6 format '$BACKUP_PATH/data/$DATE/arch.%d.live.%t' (archivelog from time 'sysdate-7' all delete input);
release channel c3;
}

run{
allocate channel c1 type disk;
backup incremental level $LEVEL filesperset 4 format '$BACKUP_PATH/data/$DATE/level.%d.live.$LEVEL.%t' (database include current controlfile);
release channel c1;
}

exit;
EOF

else
$BIN/rman target sys/sys catalog rman/rman@$RMAN_SID log $BACKUP_PATH/log/level.$TARGET_SID.$LEVEL.$DATE_2.log<

resync catalog;
run{
allocate channel c3 type disk;
backup filesperset 6 format '$BACKUP_PATH/data/$DATE/arch.%d.live.%t' (archivelog from time 'sysdate-1' all);
release channel c3;
}

run{
allocate channel c1 type disk;
backup incremental level $LEVEL filesperset 4 format '$BACKUP_PATH/data/$DATE/level.%d.live.$LEVEL.%t' (database include current controlfile);
release channel c1;
}

exit;
EOF
fi
$BIN/exp rman/rman@$RMAN_SID file=$BACKUP_PATH/data/$DATE/live.rman.$DATE_2.dmp log=$BACKUP_PATH/log/$RMAN_SID.rman.$DATE_2.log
____________________________________________________________________________________________________

2、该脚本在Crontab中的定义
——————————————————————————————————————————————————
00 4 * * 0 su - oracle -c "/oradata/oradata_backup/scripts/ora_incr_bk.sh 0"
00 4 * * 3,6 su - oracle -c "/oradata/oradata_backup/scripts/ora_incr_bk.sh 1"
00 4 * * 1,2,4,5 su - oracle -c "/oradata/oradata_backup/scripts/ora_incr_bk.sh 2"
——————————————————————————————————————————————————

3、备份输出

——————————————————————————————————————————————————
bash-2.05# ls -la *
0:
total 4424676
drwxrwxrwx 2 oracle dba 512 Jul 17 04:11 .
drwxrwxrwx 10 oracle dba 512 Jul 7 09:35 ..
-rw-r----- 1 oracle dba 399340544 Jul 17 04:00 arch.TNT.live.563860810
-rw-r----- 1 oracle dba 215586816 Jul 17 04:01 arch.TNT.live.563860856
-rw-r----- 1 oracle dba 383639552 Jul 17 04:02 level.TNT.live.0.563860885
-rw-r----- 1 oracle dba 143507456 Jul 17 04:03 level.TNT.live.0.563860951
-rw-r----- 1 oracle dba 27426816 Jul 17 04:04 level.TNT.live.0.563861006
-rw-r----- 1 oracle dba 40828928 Jul 17 04:05 level.TNT.live.0.563861061
-rw-r----- 1 oracle dba 26894336 Jul 17 04:06 level.TNT.live.0.563861116
-rw-r----- 1 oracle dba 19931136 Jul 17 04:07 level.TNT.live.0.563861172
-rw-r----- 1 oracle dba 61988864 Jul 17 04:08 level.TNT.live.0.563861227
-rw-r----- 1 oracle dba 943898624 Jul 17 04:11 level.TNT.live.0.563861342
-rw-r--r-- 1 oracle dba 1147904 Jul 17 04:11 live.rman.20050717.dmp

1:
total 232068
drwxrwxrwx 2 oracle dba 512 Jul 18 04:08 .
drwxrwxrwx 10 oracle dba 512 Jul 7 09:35 ..
-rw-r----- 1 oracle dba 92839936 Jul 18 04:00 arch.TNT.live.563947209
-rw-r----- 1 oracle dba 3284992 Jul 18 04:01 level.TNT.live.2.563947218
-rw-r----- 1 oracle dba 237568 Jul 18 04:01 level.TNT.live.2.563947274
-rw-r----- 1 oracle dba 385024 Jul 18 04:02 level.TNT.live.2.563947320
-rw-r----- 1 oracle dba 65536 Jul 18 04:03 level.TNT.live.2.563947365
-rw-r----- 1 oracle dba 647168 Jul 18 04:04 level.TNT.live.2.563947420
-rw-r----- 1 oracle dba 65536 Jul 18 04:05 level.TNT.live.2.563947475
-rw-r----- 1 oracle dba 491520 Jul 18 04:07 level.TNT.live.2.563947530
-rw-r----- 1 oracle dba 19513344 Jul 18 04:08 level.TNT.live.2.563947635
-rw-r--r-- 1 oracle dba 1153024 Jul 18 04:09 live.rman.20050718.dmp

2:
total 192356
drwxrwxrwx 2 oracle dba 512 Jul 12 04:09 .
drwxrwxrwx 10 oracle dba 512 Jul 7 09:35 ..
-rw-r----- 1 oracle dba 69335552 Jul 12 04:00 arch.TNT.live.563428807
-rw-r----- 1 oracle dba 3325952 Jul 12 04:01 level.TNT.live.2.563428818
-rw-r----- 1 oracle dba 802816 Jul 12 04:01 level.TNT.live.2.563428875
-rw-r----- 1 oracle dba 1474560 Jul 12 04:02 level.TNT.live.2.563428920
-rw-r----- 1 oracle dba 434176 Jul 12 04:03 level.TNT.live.2.563428965
-rw-r----- 1 oracle dba 2252800 Jul 12 04:04 level.TNT.live.2.563429020
-rw-r----- 1 oracle dba 65536 Jul 12 04:05 level.TNT.live.2.563429075
-rw-r----- 1 oracle dba 2433024 Jul 12 04:07 level.TNT.live.2.563429130
-rw-r----- 1 oracle dba 17104896 Jul 12 04:08 level.TNT.live.2.563429245
-rw-r--r-- 1 oracle dba 1119232 Jul 12 04:09 live.rman.20050712.dmp

3:
total 295188
drwxrwxrwx 2 oracle dba 512 Jul 13 04:08 .
drwxrwxrwx 10 oracle dba 512 Jul 7 09:35 ..
-rw-r----- 1 oracle dba 113268736 Jul 13 04:00 arch.TNT.live.563515206
-rw-r----- 1 oracle dba 3883008 Jul 13 04:01 level.TNT.live.1.563515218
-rw-r----- 1 oracle dba 933888 Jul 13 04:01 level.TNT.live.1.563515263
-rw-r----- 1 oracle dba 2392064 Jul 13 04:02 level.TNT.live.1.563515308
-rw-r----- 1 oracle dba 974848 Jul 13 04:03 level.TNT.live.1.563515353
-rw-r----- 1 oracle dba 3006464 Jul 13 04:04 level.TNT.live.1.563515408
-rw-r----- 1 oracle dba 65536 Jul 13 04:05 level.TNT.live.1.563515463
-rw-r----- 1 oracle dba 2932736 Jul 13 04:07 level.TNT.live.1.563515518
-rw-r----- 1 oracle dba 22396928 Jul 13 04:08 level.TNT.live.1.563515634
-rw-r--r-- 1 oracle dba 1125376 Jul 13 04:09 live.rman.20050713.dmp

4:
total 286932
drwxrwxrwx 2 oracle dba 512 Jul 14 04:08 .
drwxrwxrwx 10 oracle dba 512 Jul 7 09:35 ..
-rw-r----- 1 oracle dba 111883776 Jul 14 04:00 arch.TNT.live.563601606
-rw-r----- 1 oracle dba 3342336 Jul 14 04:01 level.TNT.live.2.563601617
-rw-r----- 1 oracle dba 933888 Jul 14 04:01 level.TNT.live.2.563601663
-rw-r----- 1 oracle dba 2080768 Jul 14 04:02 level.TNT.live.2.563601708
-rw-r----- 1 oracle dba 524288 Jul 14 04:03 level.TNT.live.2.563601753
-rw-r----- 1 oracle dba 2473984 Jul 14 04:04 level.TNT.live.2.563601808
-rw-r----- 1 oracle dba 65536 Jul 14 04:05 level.TNT.live.2.563601863
-rw-r----- 1 oracle dba 2564096 Jul 14 04:07 level.TNT.live.2.563601918
-rw-r----- 1 oracle dba 21749760 Jul 14 04:08 level.TNT.live.2.563602033
-rw-r--r-- 1 oracle dba 1131520 Jul 14 04:09 live.rman.20050714.dmp

4.bak:
total 269988
drwxr-xr-x 2 root other 512 Jul 7 09:35 .
drwxrwxrwx 10 oracle dba 512 Jul 7 09:35 ..
-rw-r----- 1 root other 103349248 Jul 7 09:35 arch.TNT.live.562997370
-rw-r----- 1 root other 2342912 Jul 7 09:35 ctl.TNT.live.562997363
-rw-r----- 1 root other 3358720 Jul 7 09:35 level.TNT.live.2.562996829
-rw-r----- 1 root other 851968 Jul 7 09:35 level.TNT.live.2.562996886
-rw-r----- 1 root other 1531904 Jul 7 09:35 level.TNT.live.2.562996931
-rw-r----- 1 root other 663552 Jul 7 09:35 level.TNT.live.2.562996986
-rw-r----- 1 root other 2605056 Jul 7 09:35 level.TNT.live.2.562997041
-rw-r----- 1 root other 65536 Jul 7 09:35 level.TNT.live.2.562997096
-rw-r----- 1 root other 1777664 Jul 7 09:35 level.TNT.live.2.562997151
-rw-r----- 1 root other 20455424 Jul 7 09:35 level.TNT.live.2.562997266
-rw-r--r-- 1 root other 1067008 Jul 7 09:35 live.rman.20050707.dmp

5:
total 298516
drwxrwxrwx 2 oracle dba 512 Jul 15 04:08 .
drwxrwxrwx 10 oracle dba 512 Jul 7 09:35 ..
-rw-r----- 1 oracle dba 116045312 Jul 15 04:00 arch.TNT.live.563688006
-rw-r----- 1 oracle dba 4268032 Jul 15 04:01 level.TNT.live.2.563688018
-rw-r----- 1 oracle dba 1294336 Jul 15 04:01 level.TNT.live.2.563688063
-rw-r----- 1 oracle dba 1802240 Jul 15 04:02 level.TNT.live.2.563688108
-rw-r----- 1 oracle dba 671744 Jul 15 04:03 level.TNT.live.2.563688153
-rw-r----- 1 oracle dba 2457600 Jul 15 04:04 level.TNT.live.2.563688208
-rw-r----- 1 oracle dba 65536 Jul 15 04:05 level.TNT.live.2.563688263
-rw-r----- 1 oracle dba 2793472 Jul 15 04:07 level.TNT.live.2.563688318
-rw-r----- 1 oracle dba 22151168 Jul 15 04:08 level.TNT.live.2.563688434
-rw-r--r-- 1 oracle dba 1136640 Jul 15 04:09 live.rman.20050715.dmp

6:
total 280324
drwxrwxrwx 2 oracle dba 512 Jul 16 04:08 .
drwxrwxrwx 10 oracle dba 512 Jul 7 09:35 ..
-rw-r----- 1 oracle dba 108475392 Jul 16 04:00 arch.TNT.live.563774406
-rw-r----- 1 oracle dba 3350528 Jul 16 04:01 level.TNT.live.2.563774419
-rw-r----- 1 oracle dba 647168 Jul 16 04:01 level.TNT.live.2.563774464
-rw-r----- 1 oracle dba 2293760 Jul 16 04:02 level.TNT.live.2.563774509
-rw-r----- 1 oracle dba 450560 Jul 16 04:03 level.TNT.live.2.563774554
-rw-r----- 1 oracle dba 2514944 Jul 16 04:04 level.TNT.live.2.563774609
-rw-r----- 1 oracle dba 65536 Jul 16 04:05 level.TNT.live.2.563774665
-rw-r----- 1 oracle dba 2588672 Jul 16 04:07 level.TNT.live.2.563774720
-rw-r----- 1 oracle dba 21839872 Jul 16 04:08 level.TNT.live.2.563774835
-rw-r--r-- 1 oracle dba 1142784 Jul 16 04:09 live.rman.20050716.dmp
——————————————————————————————————————————————————
4、将rman的输出用netbackup备份到磁带
过程：定义0－6，共7个volume pool
定义7条策略，按照以下顺序备份到对应的pool：周日对应0，周一对应1……

mars - Tue, 2007-04-10 19:15