Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- weekly_full.rcv
- #Script to run weekly full backup
- #Created 2017.12.25
- #Author : Daniel Heim
- #Version 1.0
- run
- {
- #Database Full Backup
- CROSSCHECK BACKUP;
- CROSSCHECK ARCHIVELOG ALL;
- ALLOCATE CHANNEL ch1 DEVICE TYPE DISK FORMAT = '&1/&2/data/data_%T_%s_%p.bak';
- ALLOCATE CHANNEL ch2 DEVICE TYPE DISK FORMAT = '&1/&2/spfile/spfile_%T_%s_%p.bak';
- ALLOCATE CHANNEL ch3 DEVICE TYPE DISK FORMAT = '&1/&2/arc/arc_%T_%s_%p.bak';
- backup
- spfile tag 'spfile backup' channel ch2
- database tag 'data backup' channel ch1
- archivelog all tag 'archive backup' channel ch3 delete all input;
- delete noprompt archivelog until time 'sysdate - 1' backed up 1 times to device type disk;
- delete noprompt force obsolete;
- DELETE noprompt EXPIRED BACKUP;
- backup current controlfile;
- release channel ch1;
- release channel ch2;
- release channel ch3;
- }
- weekly_full.sh
- #!/bin/bash
- #Script to run weekly full backup
- #Created 2017.12.25
- #Author : Daniel Heim
- #Version 1.0
- #Backup nvdata
- . /home/oracle/scripts/setEnv-nvdata.sh
- export ORAENV_ASK=NO
- . oraenv
- export ORAENV_ASK=YES
- rman target / @/home/oracle/scripts/weekly_full.rcv using \"$BACKUP_PATH\" $ORACLE_SID
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement