Oracle一周備份策略及備份腳本
周日:做0級的增量備份(是增量備份的基礎(chǔ)備份),腳本如下:
仲巴網(wǎng)站建設(shè)公司創(chuàng)新互聯(lián),仲巴網(wǎng)站設(shè)計制作,有大型網(wǎng)站制作公司豐富經(jīng)驗。已為仲巴1000多家提供企業(yè)網(wǎng)站建設(shè)服務(wù)。企業(yè)網(wǎng)站搭建\外貿(mào)網(wǎng)站建設(shè)要多少錢,請找那個售后服務(wù)好的仲巴做網(wǎng)站的公司定做!
文本如下:
#!/bin/bash
#Author:wangergui Date:2017-02-13 Email:291131893@qq.com
#Function Sunday Increment level 0 backup script
Current_day=$(date +%Y-%m-%d)
[[ ${USER} == "oracle" ]] || exit 2
[[ -d /u01/app/oracle/myrman ]] || mkdir -p /u01/app/oracle/myrman
rman target / <
run {
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F';
allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;
allocate channel c4 type disk;
backup incremental level 0 database format '/u01/app/oracle/myrman/%d_%T_%s.bak' plus archivelog delete all input;
delete noprompt obsolete;
release channel c1;
release channel c2;
release channel c3;
release channel c4;
}
EOF
本文標(biāo)題:Oracle一周備份策略及備份腳本
文章源于:http://www.xueling.net.cn/article/gpjsos.html