script:RMAN全备脚本
script:RMAN全备脚本
************************************
* RMAN 全备数据文件加控制文件,归档日志文件,备份文件保存到 /../.. 下,
* 并在完成归档日志文件备份后,自动删除已备份的归档日志。
*
* 备份保留14天,过期自动删除。
***********************************
db_full_backup.rman RUN{ configure retenion policy to recovery window of 14 days; configure controlfile autobackup on; configure controlfile autobackup format for device type disk to '/../..%F'; allocate channel c1 device type disk format '/../..BAK_%U'; backup database skip inaccessible/offline/readonly plus archivelog filesperset 20 delete all input; release channel c1; } allocate channel for maintenance device type disk ; crosscheck backupset; delete noprompt obsolete;