使用rman 备份 脚本如下
RMAN> run
2> {
3> allocate channel c1 device type disk;
4> allocate channel c2 device type disk;
5> allocate channel c3 device type disk;
6> allocate channel c4 device type disk;
7> backup filesperset = 5 as compressed backupset database format ‘C:\rmanbackup%U’;
8> sql ‘alter system archive log current’;
9> backup current controlfile format ‘C:\controlfilebackup\control_%U_%d_%T’;
10> backup spfile format ‘C:\controlfilebackup\spfile_%U_%d_%T’;
11> delete noprompt expired backup;
12> delete noprompt obsolete;
13> delete noprompt archivelog all completed before ‘sysdate -7’;
14> release channel c1;
15> release channel c2;
16> release channel c3;
17> release channel c4;
18> }

设置保留策略为
CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
备份完同时会删除控制文件与 spfile

日志如下
RMAN 保留策略将应用于该命令
将 RMAN 保留策略设置为冗余 1
删除以下已废弃的备份和副本:
类型 关键字 完成时间 文件名/句柄

备份集 10 30-4月 -20
备份片段 10 30-4月 -20 C:\APP\ADMINISTRATOR\FAST_RECOVERY_AREA\ORCL\AUTOBACKUP\2020_04_30\O1_MF_S_1039070044_HBN06Z8M_.BKP
备份集 11 30-4月 -20
备份片段 11 30-4月 -20 C:\CONTROLFILEBACKUP\CONTROL_0BUUTSR7_1_1_ORCL_20200430
备份集 12 30-4月 -20
备份片段 12 30-4月 -20 C:\CONTROLFILEBACKUP\SPFILE_0CUUTSRE_1_1_ORCL_20200430
已删除备份片段
备份片段句柄=C:\APP\ADMINISTRATOR\FAST_RECOVERY_AREA\ORCL\AUTOBACKUP\2020_04_30\O1_MF_S_1039070044_HBN06Z8M_.BKP RECID=10 STAMP=1039070047
已删除备份片段
备份片段句柄=C:\CONTROLFILEBACKUP\CONTROL_0BUUTSR7_1_1_ORCL_20200430 RECID=11 STAMP=1039070059
已删除备份片段
备份片段句柄=C:\CONTROLFILEBACKUP\SPFILE_0CUUTSRE_1_1_ORCL_20200430 RECID=12 STAMP=1039070062
3 对象已删除

保留策略为1 为啥不保留这份控制文件和spfile呢？