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

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

oracle數據庫增量備份腳本

瀏覽:7日期: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 數據庫
相關文章:
主站蜘蛛池模板: 深水埗区| 山西省| 屯昌县| 渑池县| 邵武市| 岚皋县| 清新县| 固镇县| 宁国市| 高唐县| 句容市| 龙岩市| 视频| 百色市| 闵行区| 岳普湖县| 八宿县| 阜南县| 丽水市| 革吉县| 阜康市| 荣昌县| 河源市| 鄂托克旗| 永济市| 左贡县| 丘北县| 长岭县| 黄陵县| 永州市| 荥阳市| 黄平县| 中阳县| 集安市| 佳木斯市| 东乌| 靖州| 德格县| 万荣县| 中西区| 西华县|