[ORACLE] RMAN Script example

1. Full backup script

Full backup example

rman target / cmdfile=/home/oracle/rman_backup/rman.rcv log=/home/oracle/rman_backup/dump/rman_$(date +"%y_%m_%d").log append

find /home/oracle/rman_backup/dump -name "dbf_*" -mtime +2 -exec rm {} \;
find /home/oracle/rman_backup/dump -name "arc_*" -mtime +2 -exec rm {} \;
find /home/oracle/rman_backup/dump -name "*.log" -mtime +2 -exec rm {} \;



아래 내용 rcv 파일에 생성


RMAN> run {
 crosscheck archivelog all;
 crosscheck backupset;

 backup as compressed backupset archivelog all
 format '/home/oracle/rman_backup/arc_%U_%T';

 backup as compressed backupset database
 format '/home/oracle/rman_backup/dbf_%U_%T';

  delete noprompt archivelog until time "sysdate-7";
  delete noprompt obsolete;
}

* 위 명령어로 인해 지워지는 파일
이전 backupset ->  delete obsolete는 redundancy 설정에 영향을 받습니다.
현재까지 archive되었던 archivelog파일