国产成人精品亚洲777人妖,欧美日韩精品一区视频,最新亚洲国产,国产乱码精品一区二区亚洲

您的位置:首頁(yè)技術(shù)文章
文章詳情頁(yè)

oracle數(shù)據(jù)庫(kù)增量備份腳本

瀏覽:2日期:2023-11-11 19:58:08
OS :RHEL AS 4 oracle 10g

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)文章:
主站蜘蛛池模板: 遂平县| 阳山县| 乐东| 武定县| 普宁市| 闵行区| 东方市| 微博| 仲巴县| 晋宁县| 讷河市| 郁南县| 延津县| 闵行区| 尼勒克县| 定远县| 贡觉县| 桂阳县| 宜宾县| 黎川县| 慈利县| 中宁县| 清苑县| 遂川县| 贵溪市| 清镇市| 额敏县| 磴口县| 桦甸市| 女性| 玉环县| 收藏| 滦南县| 德江县| 曲阜市| 兴隆县| 温泉县| 瓦房店市| 德钦县| 安达市| 景洪市|