Oracle数据库RMAN的自动备份脚本

来源:Oracle认证    发布时间:2012-11-12    Oracle认证视频    评论

  rm -rf $L0_PATH/$WEEK/*

  $SH_PATH/db_l0_backup.sh $L0_PATH/$WEEK

  cd $L0_PATH/$WEEK

  $SH_PATH/ftp.sh $IP $FTPUSER $FTPPASS $FTPROOT0 $WEEK $WEEK_$LOG_TAG.log

  fi

  fi

  else

  if [ ! -d $L1_PATH ]; then

  mkdir $L1_PATH

  fi

  if [ ! -d $L1_PATH/$WEEK ]; then

  mkdir $L1_PATH/$WEEK

  $SH_PATH/db_l1_backup.sh $L1_PATH/$WEEK

  cd $L1_PATH/$WEEK

  $SH_PATH/ftp.sh $IP $FTPUSER $FTPPASS $FTPROOT1 $WEEK $WEEK_$LOG_TAG.log

  else

  rm -rf $L1_PATH/$WEEK/*

  $SH_PATH/db_l1_backup.sh $L1_PATH/$WEEK

  cd $L1_PATH/$WEEK

  $SH_PATH/ftp.sh $IP $FTPUSER $FTPPASS $FTPROOT1 $WEEK $WEEK_$LOG_TAG.log

  fi

  fi

  db_l0_backup.sh零级备份程序

  #!/bin/bash

  L0_PATH=$1

  DAY_TAG=`date "%Y-%m-%d"`

  rman target / nocatalog msglog $L0_PATH/L0_db_backup_$DAY_TAG.log /dev/null

  run{

  allocate channel c0 type disk;

  backup incremental level 0 database tag 'L0_dbf_bak' format '$L0_PATH/L0_%d_DF_s.%s_p.%p_%T.bak' plus archivelog tag 'L0_arc_bak' format '$L0_PATH/L0_%d_ARC_s.%s_p.%p_%T.bak' delete all input;

  backup tag 'L0_spfile_bak' format '$L0_PATH/L0_%d_SPFILE_s.%s_p.%p_%T.bak' spfile;

  backup tag 'L0_ctl_bak' format '$L0_PATH/L0_%d_CTL_s.%s_p.%p_%T.bak' current controlfile;

  release channel c0;

  }

  #crosscheck backup;

  #delete noprompt expired backup;

  #delete noprompt obsolete;

  EOF

  db_l1_backup.sh一级备份程序

  #!/bin/bash

  L1_PATH=$1

  DAY_TAG=`date "%Y-%m-%d"`

  rman target / nocatalog msglog $L1_PATH/L1_db_backup_$DAY_TAG.log /dev/null

  run{

  allocate channel c1 type disk;

  backup incremental level 1 database tag 'L1_dbf_bak' format '$L1_PATH/L1_%d_DF_s.%s_p.%p_%T.bak' plus archivelog tag 'L1_arc_bak' format '$L1_PATH/L1_%d_ARC_s.%s_p.%p_%T.bak' delete all input;

  backup tag 'L1_spfile_bak' format '$L1_PATH/L1_%d_SPFILE_s.%s_p.%p_%T.bak' spfile;

  backup tag 'L1_ctl_bak' format '$L1_PATH/L1_%d_CTL_s.%s_p.%p_%T.bak' current controlfile;

  release channel c1;

  }

  #crosscheck backup;

  #delete noprompt expired backup;

  #delete noprompt obsolete;

  EOF

  FTP主程序

  #!/bin/bash

  _IP=$1

  _FTPUSER=$2

  _FTPPASS=$3

  _FTPROOT=$4

  _WEEK=$5

  _LOG=$6

  #_FILE=$7

  echo "..................FTP Trans $_IP...................." >>$_LOG

  date "%Y-%m-%d-%T:FTP $_IP Trans Begin..." >> $_LOG 2>>$_LOG

  ftp -d -i -n > $_LOG 2>>$_LOG

  open $_IP

  user $_FTPUSER $_FTPPASS

  cd $_FTPROOT/$_WEEK

  bi

  mdelete *

  mput *

  bye

  FTPIT

  FTP目录维护程序

  #!/bin/bash

  _IP=$1

  _FTPUSER=$2

  _FTPPASS=$3

  _FTPROOT=$4

  _WEEK=$5

  _LOG=$6

  #_FILE=$7

  echo "..................FTP Delete And Trans $_IP...................." >>$_LOG

  date "%Y-%m-%d-%T:FTP $_IP Begin..." >> $_LOG 2>>$_LOG

  ftp -d -i -n > $_LOG 2>>$_LOG

  open $_IP

  user $_FTPUSER $_FTPPASS

  cd /l1/2

  mdelete *

  cd /l1/4

  mdelete *

  cd /l1/5

  mdelete *

  cd /l1/0.bak

  mdelete *

  cd /l1

  rmdir 0.bak

  rename 0 0.bak

  mkdir 0

  cd /

  cd /$_FTPROOT/3

  mdelete *

  cd /$_FTPROOT/6.bak

  mdelete *

  cd /$_FTPROOT

  rmdir 6.bak

  rename 6 6.bak

  mkdir 6

  cd /$_FTPROOT/$_WEEK

  mdelete *

  bi

  mput *

  bye

  FTPIT

上一页12下一页

视频学习

我考网版权与免责声明

① 凡本网注明稿件来源为"原创"的所有文字、图片和音视频稿件,版权均属本网所有。任何媒体、网站或个人转载、链接转贴或以其他方式复制发表时必须注明"稿件来源:我考网",违者本网将依法追究责任;

② 本网部分稿件来源于网络,任何单位或个人认为我考网发布的内容可能涉嫌侵犯其合法权益,应该及时向我考网书面反馈,并提供身份证明、权属证明及详细侵权情况证明,我考网在收到上述法律文件后,将会尽快移除被控侵权内容。

最近更新

社区交流

考试问答