您当前的位置： 首页 >  oracle

Oracle增量备份和快速备份（块改变跟踪Block Change Tracking）

发布时间：2017-06-18 11:36:33 ，浏览量：0

Oracle增量备份和快速备份（块改变跟踪Block Change Tracking）

下面小麦苗给出全库备份的脚本：

点击(此处)折叠或打开

  1. [oracle@rhel6lhr ~]$ crontab -l
  2. 2 12 * * 1 /home/oracle/lhr/rman/rman_backup_full.sh
  3. [oracle@rhel6lhr ~]$ more /home/oracle/lhr/rman/rman_backup_full.sh
  4. export ORACLE_SID=orclasm
  5. export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
  6. export PATH=$ORACLE_HOME/bin:$PATH
  7. MYDATE=`date +'%Y%m%d%H%M%S'`
  8. BACKUP_DIR=/u05/oracle/oracle_bk/$ORACLE_SID
  10.  
  11. rman target / log /home/oracle/lhr/rman/log/rman_full_$MYDATE.log append <<EOF
  12. run
  13. {
  14.  allocate channel c1 type disk;
  15.  allocate channel c2 type disk;
  16.  backup database filesperset 4 format '$BACKUP_DIR/full_%n_%T_%t_%s_%p.bak';
  17.  sql 'alter system archive log current';
  18.  backup archivelog all format '$BACKUP_DIR/arch_%d_%T_%s_%p.bak' delete input;
  19.  backup current controlfile format '$BACKUP_DIR/ctl_%d_%T_%s_%p.bak';
  20. }
  21. EOF
  23. rman target / log /home/oracle/lhr/rman/log/rman_delete_$MYDATE.log append <<EOF
  24.  allocate channel for maintenance type disk;
  25.  allocate channel for maintenance type sbt_tape;
  26.  crosscheck copy;
  27.  crosscheck archivelog all;
  28.  crosscheck backup;
  29.  delete noprompt obsolete;
  30.  delete noprompt expired backup;
  31. EOF

下面小麦苗给出增量备份的脚本，备份策略为周日0级全备，周四为1级增量备份，其它为2级增量备份：

点击(此处)折叠或打开

  1. 40 11 * * * /home/oracle/lhr/rman/run_rman_incremental.sh
  3. [oracle@rhel6lhr ~]$ more /home/oracle/lhr/rman/run_rman_incremental.sh
  4. sh /home/oracle/lhr/rman/rman_incremental.sh 2>&1 &
  5. [oracle@rhel6lhr ~]$ more /home/oracle/lhr/rman/rman_incremental.sh
  6. ########################################################################
  7. ## incremental_database_backup.sh ##
  8. ## created by lhr ##
  9. ## 2015-1-23 ##
  10. ## sun:0 Thu:1 others:2 ##
  11. #########################################################################
  12. #!/bin/ksh
  15. export LANG=en_US
  16. MYDATE=`date +'%Y%m%d%H%M%S'`
  17. MYDATE2=`date +'%Y-%m-%d %H:%M:%S'`
  18. CUSER=`id|cut -d "(" -f2|cut -d ")" -f1`
  19. export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
  20. export PATH=$ORACLE_HOME/bin:$PATH
  21. export RMAN=$ORACLE_HOME/bin/rman
  22. export ORACLE_SID=orclasm
  23. export ORACLE_USER=oracle
  24. BACKUP_DIR=/u05/oracle/oracle_bk/$ORACLE_SID
  25. RMAN_LOG_FILE=$BACKUP_DIR/log/rman_incremental_"$ORACLE_SID"_$MYDATE.log
  28. echo "-----------------$MYDATE2-------------------">$RMAN_LOG_FILE
  29. echo "ORACLE_SID: $ORACLE_SID">>$RMAN_LOG_FILE
  30. echo "ORACLE_HOME:$ORACLE_HOME">>$RMAN_LOG_FILE
  31. echo "ORACLE_USER:$ORACLE_USER">>$RMAN_LOG_FILE
  32. echo "==========================================">>$RMAN_LOG_FILE
  33. echo "BACKUP DATABASE BEGIN......">>$RMAN_LOG_FILE
  34. echo " ">>$RMAN_LOG_FILE
  35. chmod 666 $RMAN_LOG_FILE
  36.  
  37. WEEK_DAILY=`date +%a`
  38.  
  39. case "$WEEK_DAILY" in
  40.        "Mon")
  41.             BAK_LEVEL=2
  42.             ;;
  43.        "Tue")
  44.             BAK_LEVEL=2
  45.             ;;
  46.        "Wed")
  47.             BAK_LEVEL=2
  48.             ;;
  49.        "Thu")
  50.             BAK_LEVEL=1
  51.             ;;
  52.        "Fri")
  53.             BAK_LEVEL=2
  54.             ;;
  55.        "Sat")
  56.             BAK_LEVEL=2
  57.             ;;
  58.        "Sun")
  59.             BAK_LEVEL=0
  60.             ;;
  61.        "*")
  62.             BAK_LEVEL=error
  63. esac
  64. export BAK_LEVEL=$BAK_LEVEL
  65. echo "Today is : $WEEK_DAILY incremental level= $BAK_LEVEL">>$RMAN_LOG_FILE
  66.  
  67. RMAN_RUN_STR="
  68.         export BAK_LEVEL=$BAK_LEVEL
  69.         export ORACLE_HOME=$ORACLE_HOME
  70.         export ORACLE_SID=$ORACLE_SID
  71.         export NLS_DATE_FORMAT='YYYY-MM-DD HH24:mi:ss'
  72.         $RMAN nocatalog TARGET sys/lhr log $RMAN_LOG_FILE append <
关注
打赏
1688896170
查看更多评论

暂无认证

  • 0浏览

    0关注

    108697博文

    0收益

  • 0浏览

    0点赞

    0打赏

    0留言

私信
关注
热门博文

[ 申请 ]友情链接：

快连vpn 快连 快连vpn 搜外友链 笔趣阁 爱思助手 ClashX教程 绘画宝宝 配音宝宝
立即登录/注册

微信扫码登录

0.0562s