RMAN备份

备份Spfile、控制文件、数据文件、归档日志文件,并删除冗余备份。可结合rman cmdfile=FILE_PATH msglog=$HOME/backup/log/backup_level0.log和CRONTAB进行周期备份。

run {
allocate channel c1 device type disk;
backup incremental level 0 format '/export/home/oracle/backup/db_full_incre0_%U.bkp'tag '2015-09-15-FULL-0'database plus archivelog DELETE ALL INPUT;
crosscheck backupset;
crosscheck archivelog all;
delete noprompt expired backupset;
delete noprompt expired archivelog all;
delete noprompt obsolete;
release channel c1;
}
backup current controlfile format '/export/home/oracle/backup/control20150914.bak';
backup spfile format '/export/home/oracle/backup/spfile20150914.bak'; 

 

posted on 2015-09-15 22:34  侯志清  阅读(180)  评论(0编辑  收藏  举报

导航