激情五月天婷婷,亚洲愉拍一区二区三区,日韩视频一区,a√天堂中文官网8

<ul id="buwfs"><strike id="buwfs"><strong id="buwfs"></strong></strike></ul>
    <output id="buwfs"></output>
  • <dfn id="buwfs"><source id="buwfs"></source></dfn>
      <dfn id="buwfs"><td id="buwfs"></td></dfn>
      <div id="buwfs"><small id="buwfs"></small></div>
      <dfn id="buwfs"><source id="buwfs"></source></dfn>
      1. <dfn id="buwfs"><td id="buwfs"></td></dfn>
        始創(chuàng)于2000年 股票代碼:831685
        咨詢熱線:0371-60135900 注冊(cè)有禮 登錄
        • 掛牌上市企業(yè)
        • 60秒人工響應(yīng)
        • 99.99%連通率
        • 7*24h人工
        • 故障100倍補(bǔ)償
        全部產(chǎn)品
        您的位置: 網(wǎng)站首頁(yè) > 幫助中心>文章內(nèi)容

        RMAN自動(dòng)備份和磁帶機(jī)備份SHELL腳本

        發(fā)布時(shí)間:  2012/8/26 16:15:17

        (1)遠(yuǎn)程TELNET備份數(shù)據(jù)到磁帶機(jī)的SHLL腳本

        lgmfis:/u01/Oracle/CIC/BACKUP ] cat TAPE_BACKUP.sh
        : ${OK=0} ${FAIL=1} ${CANCEL=3}
        : ${MM=`date +%m`}
        : ${DD=`date +%d`}
        : ${YY=`date +%Y`}
        : ${DEVFILn='/dev/rmt/0cn'}
        -
         

        : ${FLOG=/u01/Oracle/CIC/LOG/TAPE_bk_${MM}${DD}.log}
        : ${FLST=/u01/Oracle/CIC/LOG/TAPE_bk_${MM}${DD}.lst}
        : ${HOST=`uname -n`}
        . /u01/Oracle/CIC/BACKUP/common.sh
        START_YMD=`date +%Y%m%d`
        START_HMS=`date +%H%M%S`
        echo "  $HOST TAPE Backup start at $START_YMD $START_HMS    "     >> $FLOG
        #chkdate=`get_before_date ${YY}${MM}${DD}`
        #tmpdate=`expr substr $chkdate 5 5`
        /usr/bin/mt -f ${DEVFILn} rewind

        if [ $? -eq 0 ]
        then
           echo "## Tape Check : Success/n"                          >> $FLOG
           echo "## Tape Check : Success/n"
        else
           echo "## Tape Check : Error(Insert tape into Device)/n"   >> $FLOG
           echo "## Tape Check : Error(Insert tape into Device)/n"

           exit ${FAIL}
        fi

        echo "## Step 1 : FULL Backup                 ###"        >> $FLOG

        cd /

        find fz02/RMANBK/lgmfis/*${MM}${DD}* -print|sort -rn +1|head -9| cpio -ocv -H od

        c -C 30720 -O $DEVFILn | tee -a $FLST

        find u08/EXP_BK/FZLFMES/*${MM}${DD}.* -print | cpio -ocv -H odc -C 30720 -O $DEV

        FILn | tee -a $FLST


        mt -f $DEVFILn offline
        echo "## Step 1 : FULL Backup    End             ###"        >> $FLOG

        echo "please insert the secound tape"
        Getyn "Was the secound tape insert? (y/n)"

        echo "## Step 2 : lgmfis db file & EXP Backup                 ###"        >> $FL

        OG

        /usr/bin/mt -f ${DEVFILn} rewind
        cd /

        find fz02/RMANBK/lgmfis/*${YY}${MM}${DD}* -print|sort -n +1|head -7| cpio -ocv -

        H odc -C 30720 -O $DEVFILn | tee -a $FLST
        #find u08/EXP_BK/lgmfis/*${MM}${DD}.* -print | cpio -ocv -H odc -C 30720 -O $DEV

        FILn | tee -a $FLST

        echo "## Step 2 : lgmfis db file & EXP Backup    END             ###"        >>

        $FLOG

        mt -f $DEVFILn offline
        echo "please insert the third tape"
        Getyn "Was the third tape insert? (y/n)"

        /usr/bin/mt -f ${DEVFILn} rewind
        cd /

        echo "## Step 3 : lgmfis arch & FZLFMES DATAFILE & ARCH & export Backup

                ###"        >> $FLOG
        find fz01/RMANBK/FZLFMES/*${MM}${DD}* -print | cpio -ocv -H odc -C 30720 -O $DEV

        FILn | tee -a $FLST
        find fz02/RMANBK/lgmfis/*${MM}${DD}* -print|sort -rn +1|sed -n '10,11p;11q'| cpi

        o -ocv -H odc -C 30720 -O $DEVFILn | tee -a $FLST
        echo "## Step 3 : lgmfis arch & FZLFMES DATAFILE & ARCH & export Backup   End

         ###"   >> $FLOG

        mt -f $DEVFILn offline

        echo "please insert the fourth tape"
        Getyn "Was the fourth tape insert? (y/n)"

        /usr/bin/mt -f ${DEVFILn} rewind
        cd /

        echo "## Step 4 : lgmfis arch & FZLFMES DATAFILE & ARCH & export Backup

                ###"        >> $FLOG
        find u08/EXP_BK/lgmfis/*${MM}${DD}.* -print | cpio -ocv -H odc -C 30720 -O $DEVF

        ILn | tee -a $FLST
        find u08/RMANBK/lgmfis/*${MM}${DD}* -print | cpio -ocv -H odc -C 30720 -O $DEVFI

        Ln | tee -a $FLST
        echo "## Step 4 : lgmfis arch & FZLFMES DATAFILE & ARCH & export Backup   End

         ###"   >> $FLOG

        cd /


        (2)自動(dòng)RMAN腳本:

        [lgmfisu:root] /u01/Oracle/CIC/BACKUP> cat DB_FULL_lgmfis.sh
        MM=`date +%m`
        DD=`date +%d`
        YY=`date +%y`

        RMAN_LOG_FILE=/u01/Oracle/CIC/LOG/FULL_HOT_lgmfis_${YY}${MM}${DD}.log

        Oracle_HOME=/u01/app/oracle/product/9.2.0
        export Oracle_HOME

        Oracle_SID=lgmfis
        export Oracle_SID
        Oracle_HOME=$ORACLE_HOME
        export Oracle_HOME
        Oracle_SID=$ORACLE_SID
        export Oracle_SID
        #find /fz02/RMANBK/lgmfis -mtime +0 -exec rm {} /;
        find /u08/RMANBK/lgmfis -mtime +0 -exec rm {} /;
        rm -f /fz02/RMANBK/lgmfis/db_full*

        /u01/app/Oracle/product/9.2.0/bin/rman target / nocatalog msglog $RMAN_LOG_FILE
        append << EOF
        RUN {
        BACKUP FULL
            FILESPERSET 4
            FORMAT '/fz02/RMANBK/lgmfis/db_full_%T_%s_%p'
            DATABASE;
        sql 'alter system archive log current';
        BACKUP
           filesperset 20
           FORMAT '/u08/RMANBK/lgmfis/al_%T_%s_%p'
           ARCHIVELOG ALL DELETE INPUT;
        BACKUP
            FORMAT '/fz02/RMANBK/lgmfis/cntrl_%T_%s_%p'
            CURRENT CONTROLFILE;
        }
        EOF

        #find /fz02/RMANBK/lgmfis -mtime +0 -exec rm {} /;
        #find /u08/RMANBK/lgmfis -mtime +0 -exec rm {} /;
        you have mail in /var/mail/root
        [lgmfisu:root] /u01/Oracle/CIC/BACKUP>

        mt -f $DEVFILn offline
        END_YMD=`date +%Y%m%d`
        END_HMS=`date +%H%M%S`

        echo "  $HOST  TAPE Backup Successfully Ended At $END_YMD $END_HMS    "     >> $

        FLOG

         

        另外個(gè)文件:COMMON.SH

        [lgmfisu:root] /u01/Oracle/CIC/BACKUP> cat common.sh
        get_before_date()
        {
         Y=`expr substr $1 1 4`
         M=`expr substr $1 5 2`
         D=`expr substr $1 7 2`
         YY=`expr $Y - 1`
         MM=`expr $M - 1`
         DD=`expr $D - 1`
         MM=`printf "%02d" $MM`
         DD=`printf "%02d" $DD`
         dd=$Y$MM
         dad=`get_mon_days $dd`
         be_date=$Y$M$DD
         if [ $D -eq 01 ]
         then
         if [ $M -ne 01 ]
         then
         be_date=$Y$MM$dad
         fi
         if [ $M -eq 01 ]
                        then
                                be_date=$YY"1231"
                        fi
           fi
                echo $be_date

        }


        Getyn() {
               while echo "/n$* (y/n)? /c"
                       do read yn
                                case "$yn" in
                                        [Yy] )  return $OK      ;;
                                        [Nn] )  ConfirmYn "cancel The Job ?" ;;
                                          *  ) echo "Please enter y or n"  ;;
                                esac
                        done
         }

        ConfirmYn() {
               while echo "/n$* (y/n)? /c"
                       do read yn
                                case "$yn" in
                                        [Nn] ) return $OK       ;;
                                        [Yy] ) echo "/n The Job is canceled."
                                               sleep 3
                                               exit $CANCEL     ;;
                                          *  ) echo "Please enter y or n"  ;;
                                esac
                        done
        }


        本文出自:億恩科技【mszdt.com】

        服務(wù)器租用/服務(wù)器托管中國(guó)五強(qiáng)!虛擬主機(jī)域名注冊(cè)頂級(jí)提供商!15年品質(zhì)保障!--億恩科技[ENKJ.COM]

      2. 您可能在找
      3. 億恩北京公司:
      4. 經(jīng)營(yíng)性ICP/ISP證:京B2-20150015
      5. 億恩鄭州公司:
      6. 經(jīng)營(yíng)性ICP/ISP/IDC證:豫B1.B2-20060070
      7. 億恩南昌公司:
      8. 經(jīng)營(yíng)性ICP/ISP證:贛B2-20080012
      9. 服務(wù)器/云主機(jī) 24小時(shí)售后服務(wù)電話:0371-60135900
      10. 虛擬主機(jī)/智能建站 24小時(shí)售后服務(wù)電話:0371-60135900
      11. 專注服務(wù)器托管17年
        掃掃關(guān)注-微信公眾號(hào)
        0371-60135900
        Copyright© 1999-2019 ENKJ All Rights Reserved 億恩科技 版權(quán)所有  地址:鄭州市高新區(qū)翠竹街1號(hào)總部企業(yè)基地億恩大廈  法律顧問(wèn):河南亞太人律師事務(wù)所郝建鋒、杜慧月律師   京公網(wǎng)安備41019702002023號(hào)
          0
         
         
         
         

        0371-60135900
        7*24小時(shí)客服服務(wù)熱線