oracle數(shù)據(jù)庫(kù)增量備份腳本
0備份腳本;#!/bin/bash;# incremental level 0 backup script
source /home/oracle/.bash_profile
current_day=`date +%Y%m%d`;mkdir /home/oracle/RMANBACKUP/$current_day;rman target; / <<EOF;run;{;CONFIGURE CONTROLFILE AUTOBACKUP ON;;CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/RMANBACKUP/$current_day/PID-%F';;allocate channel dev1 type disk;;allocate channel dev2 type disk;;allocate channel dev3 type disk;;backup incremental level 0 tag='db0';format '/home/oracle/RMANBACKUP/$current_day/%n_%T_%U' database;;sql 'alter system archive log current';;backup archivelog all format '/home/oracle/RMANBACKUP/$current_day/arc_%n_%T_%U' delete all input;;release channel dev1;;release channel dev2;;release channel dev3;;};EOF
1級(jí)累積增量腳本;#!/bin/bash;# incremental level 1 backup script
source /home/oracle/.bash_profile
current_day=`date +%Y%m%d`;incr_day=incr$current_day;mkdir /home/oracle/RMANBACKUP/$incr_day;rman target; / <<EOF;run;{;CONFIGURE CONTROLFILE AUTOBACKUP ON;;CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/RMANBACKUP/$incr_day/PID-%F';;allocate channel dev1 type disk;;allocate channel dev2 type disk;;allocate channel dev3 type disk;;backup incremental level 1 cumulative tag='db1';format '/home/oracle/RMANBACKUP/$incr_day/%n_%T_%U' database;;sql 'alter system archive log current';;backup archivelog all format '/home/oracle/RMANBACKUP/$incr_day/arc_%n_%T_%U' delete all input;;release channel dev1;;release channel dev2;;release channel dev3;;};EOF
每天RMAN出來(lái)的backup set集合到一個(gè)文件夾下面;
相關(guān)文章:
1. Oracle 10g(10.1.0.2)中的OPTIMIZER_INDEX_COST_ADJ2. 快速掌握Oracle數(shù)據(jù)庫(kù)游標(biāo)的使用方法3. Oracle10g安裝升級(jí)以及新特性介紹4. Windows環(huán)境下Oracle監(jiān)聽(tīng)服務(wù)啟動(dòng)的問(wèn)題5. Oracle中資源的共享與競(jìng)爭(zhēng)及問(wèn)題定位6. ORACLE常用傻瓜問(wèn)題1000問(wèn)(之十二)7. oracle分區(qū)表創(chuàng)建(自動(dòng)按年、月、日分區(qū))實(shí)戰(zhàn)記錄8. oracle 指定類型和指定位數(shù)創(chuàng)建序列號(hào)的代碼詳解9. 用Oracle的解析函數(shù)發(fā)現(xiàn)序列間隙10. Oracle壓縮表空間的基本步驟
