RMAN 保留策略将应用于该命令
将 RMAN 保留策略设置为冗余 1
使用通道 ORA_DISK_1
删除以下已废弃的备份和副本
每次全备份后都会删除之前的所有备份
主要时rman备份策略默认是1。
DG中的备库执行configure retention policy to redundancy 60;
报错:RMAN-05021:this configuration cannot be changed for a BACKUP or STANDBY control file
主库可以更改
备库的自动备份脚本如下:
run {
allocate channel cha1 type disk maxpiecesize=10240m;
backup database format 'H:\DATA_BAK\sbdc_full_%T_%t_%U.bak';
backup archivelog all not backed up 1 times format 'H:\DATA_BAK\sbdc_arch_%T_%t_%U.bak';
delete noprompt archivelog all completed before 'sysdate-7';
delete noprompt backup completed before 'sysdate - 3';
backup current controlfile format 'H:\DATA_BAK\ctl_%T_%t.bak';
release channel cha1;
crosscheck backup;
delete noprompt obsolete recovery window of 7 days; -----------脚本中设置备份保留策略
}