当前位置:操作系统 > Unix/Linux >>

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;

 


CopyRight © 2022 站长资源库 编程知识问答 zzzyk.com All Rights Reserved
部分文章来自网络,