Advertisement
Guest User

Untitled

a guest
Jul 17th, 2018
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.14 KB | None | 0 0
  1. weekly_full.rcv
  2. #Script to run weekly full backup
  3. #Created 2017.12.25
  4. #Author : Daniel Heim
  5. #Version 1.0
  6. run
  7. {
  8. #Database Full Backup
  9. CROSSCHECK BACKUP;
  10. CROSSCHECK ARCHIVELOG ALL;
  11. ALLOCATE CHANNEL ch1 DEVICE TYPE DISK FORMAT = '&1/&2/data/data_%T_%s_%p.bak';
  12. ALLOCATE CHANNEL ch2 DEVICE TYPE DISK FORMAT = '&1/&2/spfile/spfile_%T_%s_%p.bak';
  13. ALLOCATE CHANNEL ch3 DEVICE TYPE DISK FORMAT = '&1/&2/arc/arc_%T_%s_%p.bak';
  14. backup
  15. spfile tag 'spfile backup' channel ch2
  16. database tag 'data backup' channel ch1
  17. archivelog all tag 'archive backup' channel ch3 delete all input;
  18. delete noprompt archivelog until time 'sysdate - 1' backed up 1 times to device type disk;
  19. delete noprompt force obsolete;
  20. DELETE noprompt EXPIRED BACKUP;
  21. backup current controlfile;
  22. release channel ch1;
  23. release channel ch2;
  24. release channel ch3;
  25. }
  26.  
  27. weekly_full.sh
  28. #!/bin/bash
  29.  
  30. #Script to run weekly full backup
  31. #Created 2017.12.25
  32. #Author : Daniel Heim
  33. #Version 1.0
  34.  
  35. #Backup nvdata
  36. . /home/oracle/scripts/setEnv-nvdata.sh
  37. export ORAENV_ASK=NO
  38. . oraenv
  39. export ORAENV_ASK=YES
  40. rman target / @/home/oracle/scripts/weekly_full.rcv using \"$BACKUP_PATH\" $ORACLE_SID
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement