#!/bin/bash
SCRIPT_HOME=/u01/app/oracle/scripts
ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
LOCAL_FLASH_AREA=/u01/app/oracle/fast_recovery_area/XE
. $ORACLE_HOME/bin/oracle_env.sh
rm -f $SCRIPT_HOME/oracle_backup.log
$ORACLE_HOME/bin/rman target / cmdfile $SCRIPT_HOME/oracle_backup.rcv log $SCRIPT_HOME/oracle_backup.log
s3cmd --no-progress sync --delete-removed $LOCAL_FLASH_AREA s3://cftc-rman-backup/
s3cmd put $SCRIPT_HOME/oracle_backup.log s3://cftc-rman-backup
$ cat oracle_backup.rcv
list db_unique_name all;
show all;
RUN {
crosscheck backup;
crosscheck copy;
delete noprompt expired archivelog all;
delete noprompt expired backup;
delete noprompt obsolete device type disk;
}
RUN {
sql "alter system archive log current";
RECOVER COPY OF DATABASE WITH TAG 'ORAXE_INC_UPD'
UNTIL TIME 'SYSDATE - 7';
BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG 'ORAXE_INC_UPD'
DATABASE;
sql "alter system switch logfile";
}
exit;
No comments:
Post a Comment