久久r热视频,国产午夜精品一区二区三区视频,亚洲精品自拍偷拍,欧美日韩精品二区

您的位置:首頁技術文章
文章詳情頁

oracle數據庫增量備份腳本

瀏覽:4日期: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級累積增量腳本;#!/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出來的backup set集合到一個文件夾下面;

標簽: Oracle 數據庫
相關文章:
主站蜘蛛池模板: 慈溪市| 齐齐哈尔市| 泉州市| 连州市| 弥渡县| 丹东市| 澄迈县| 甘洛县| 江陵县| 花垣县| 湖北省| 宁南县| 汤阴县| 依安县| 治多县| 枣阳市| 噶尔县| 岱山县| 闻喜县| 十堰市| 申扎县| 西乌珠穆沁旗| 阳东县| 新疆| 黄山市| 湖南省| 平凉市| 隆安县| 方城县| 长兴县| 靖安县| 婺源县| 黑水县| 思茅市| 临漳县| 澄城县| 蕉岭县| 偃师市| 旌德县| 修武县| 盐池县|