Tuesday, March 13, 2018

RMAN Script

ORACLE_SID=BACKLIFE
ORACLE_HOME=/u01/oracle/product/12.2.0/dbhome_1
PATH=$PATH:${ORACLE_HOME}:${ORACLE_HOME}/bin
export ORACLE_SID
export ORACLE_HOME
export LD_LIBRARY_PATH
export PATH

rman target / <<EOF
spool log to /u02/RMAN/BACKLIFE/BACKLIFE_RMAN.log
run {
CROSSCHECK ARCHIVELOG ALL;
delete noprompt expired archivelog all;
CROSSCHECK BACKUP;
delete noprompt expired backup;
BACKUP AS BACKUPSET DATABASE FORMAT '/u02/RMAN/BACKLIFE/%d-%T-%U' PLUS ARCHIVELOG FORMAT '/u02/RMAN/BACKLIFE/%d-%T-%U';
BACKUP CURRENT CONTROLFILE;
delete noprompt archivelog until time 'SYSDATE-7';
delete noprompt backup completed before 'sysdate-14';
delete noprompt obsolete;
delete noprompt expired backup;
}
exit
EOF

No comments:

Post a Comment