首先设置rman的参数
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS ---窗口时间为7天
CONFIGURE CONTROLFILE AUTOBACKUP ON ---控制文件自动备
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/control_file_backup/sales_%F' --设置为自动备份的控制文件的路径
CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET --设置分配几个通道进行备份
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT '/home/oracle/rman/backup_p%p_s%s_t%t_%T.bak'
CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT '/home/oracle/rman2/backup_p%p_s%s_t%t_%T.bak'
CONFIGURE BACKUP OPTIMIZATION ON --不会备份已经备份过的日志
configure exclude for tablespace sflog; -- 备份时不备份这个表空间
然后开始备份脚步
rman target / << EOF
spool log to '/home/oracle/fullbackup.log' append;
run {
sql'alter system archive log current';
backup
filesperset 3
incremental level=0
(database include current controlfile);
}
crosscheck backup of database;
crosscheck archivelog all;
delete noprompt expired archivelog all;
delete noprompt expired backup of database;
delete noprompt obsolete;
exit
EOF
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/7668955/viewspace-1007960/ ，如需转载，请注明出处，否则将追究法律责任。
