rman備份指令碼

urgel_babay發表於2016-02-29
指令碼
vi rman_bak.sh

點選(此處)摺疊或開啟

  1. #!/bin/sh
  2. source /home/oracle/.bash_profile
  3. cd $ORACLE_HOME/bin
  4. rman target / nocatalog msglog=/app/oracle/back/log/rman_bk_`date \'+%Y%m%d%H%M%S\'`.log <<EOF
  5. run{
  6. REPORT OBSOLETE;
  7. DELETE force NOPROMPT OBSOLETE;
  8. allocate channel c1 type disk;//定義通道//
  9. allocate channel c2 type disk;//定義通道//
  10. allocate channel c3 type disk;//定義通道//
  11. backup full database tag \'dbfull\' format \'/app/oracle/back/data/dbfull_%u_%s_%p\' ;
  12. backup current controlfile tag \'ctl\' format \'/app/oracle/oadb_backup/data/ctl_%s_%p_%t\';
  13. sql \'alter system archive log current\';
  14. #crosscheck archivelog all;
  15. backup filesperset 3 archivelog all tag \'arch\' format \'/app/oracle/oadb_backup/data/arch_%u_%s_%p\' delete input;
  16. release channel c1;
  17. release channel c2;
  18. release channel c3;
  19. }
  20. exit;
  21. EOF

指令碼實現的是rman 全庫備份，
先刪除掉無用的備份集，開啟三個備份通道。

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/30936525/viewspace-2016729/，如需轉載，請註明出處，否則將追究法律責任。

相關文章