免费视频淫片aa毛片_日韩高清在线亚洲专区vr_日韩大片免费观看视频播放_亚洲欧美国产精品完整版

#!/bin/bash

back_path="/10g/backup";

back_log="/10g/backup/log";

rman_name=“cisco”;

rman_pw="rman";

rman_log_name="rman";

rman_log_pass="cisco";

rman_sid=“zsh1”;

rman_bin=/opt/oracle/product/9.2.0.4/bin

date_w=`date +%w`;

 

case $date_w in

 

5) #指的是周五執(zhí)行

$rman_bin log $back_log/level0_`date +%Y-%m-%d`.log <<EOF

connect target $rman_name/$rman_pw

run {

allocate channel d1 type disk;

allocate channel d2 type disk;

backup full database format '$back_path/`date +%Y%m%d`_full_%d_%s_%p_%u.bak' tag='full' include current controlfile;

sql 'alter system archive log current';

backup archivelog all format '$back_path/`date +%Y%m%d`_archivelog_%d_%s_%p_%u.bak' delete all input;

release channel d2;

release channel d1;

}

crosscheck backup;

delete noprompt expired backup;

delete noprompt obsolete;

exit

EOF

;;

#以上是完全備份

 

7)  #指的是周日?qǐng)?zhí)行

$rman_bin log $back_log/level0_`date +%Y-%m-%d`.log <<EOF

connect catalog $rman_log_name/$rman_log_pass

connect target $rman_name/$rman_pw

run {

allocate channel d1 type disk;

allocate channel d2 type disk;

backup incremental level 0 database format '$back_path/`date +%Y%m%d`_level0_%d_%s_%p_%u.bak' tag='level 0' include current controlfile;

sql 'alter system archive log current';

backup archivelog all format '$back_path/`date +%Y%m%d`_archivelog_%d_%s_%p_%u.bak' delete all input;

release channel d2;

release channel d1;

}

crosscheck backup;

delete noprompt expired backup;

delete noprompt obsolete;

resync catalog;

exit

EOF

;;

#以上是0級(jí)備份

 

3) #指的是周三執(zhí)行

$rman_bin log $back_log/level1_`date +%Y-%m-%d`.log <<EOF

connect catalog $rman_log_name/$rman_log_pass

connect target $rman_name/$rman_pw

run {

allocate channel d1 type disk;

backup incremental level 1 format '$back_path/`date +%Y%m%d`_level1_%d_%s_%p_%u.bak' tag = 'level 1' database;

sql 'alter system archive log current';

backup archivelog all format '$back_path/`date +%Y%m%d`_archivelog_%d_%s_%p_%u.bak' delete all input;

release channel d1;

}

crosscheck backup;

delete noprompt expired backup;

delete noprompt obsolete;

resync catalog;

exit;

EOF

;;

#以上是1級(jí)備份

1|2|4|5|6)   #指的是周一，二，四，五，六執(zhí)行

$rman_bin log $back_log/level2_`date +%Y-%m-%d`.log <<EOF

connect catalog $rman_log_name/$rman_log_pass

connect target $rman_name/$rman_pw

 

本站僅提供存儲(chǔ)服務(wù)，所有內(nèi)容均由用戶發(fā)布，如發(fā)現(xiàn)有害或侵權(quán)內(nèi)容，請(qǐng)點(diǎn)擊舉報(bào)。