1、数据库每天23点进行level 1的累计增量备份，同时为了与其它的备份产生时间上的隔离，加上了keep until time 'sysdate + 1’的命令后备份不自动删除；

2、备份执行脚本如下：

“----------------------------------------`date`---------------------------------------”

source ~/.bash_profile

export FILE=“mwdbbak_inc”$(date +%Y%m%d%H)

rman target / log /backup/dbincbak/${FILE}-LEVEL1.log<<EOF

run{

allocate channel c1 type disk;

allocate channel c2 type disk;

allocate channel c3 type disk;

allocate channel c4 type disk;

crosscheck archivelog all;

crosscheck backupset;

sql ‘alter system checkpoint’;

sql ‘alter system switch logfile’;

backup as compressed backupset incremental level=1 CUMULATIVE database tag=mwdb_bk_level1 format ‘/backup/dbincbak/mwdbbak_level1C_$(date +%Y%m%d%H)_%d_%s_%p.bak’ FILESPERSET 1000 MAXSETSIZE 500000M keep UNTIL TIME ‘sysdate+1’;

sql ‘alter system archive log current’;

backup as compressed backupset tag=mwdb_bkLOG_level1 not backed up 1 times archivelog all format ‘/backup/dbincbak/mvdbArchLog_%d_%T_%s_%p.bak’ FILESPERSET 1000 MAXSETSIZE 500000M keep UNTIL TIME ‘sysdate+1’;

backup as compressed backupset current controlfile tag=mwdb_controlfile_level1 format ‘/backup/dbincbak/controlfile_$(date +%Y%m%d%H)_%d_control.bak’ keep UNTIL TIME ‘sysdate+1’;

delete noprompt expired backupset;

delete noprompt archivelog all completed before ‘sysdate-1’;

delete noprompt obsolete;

release channel c1;

release channel c2;

release channel c3;

release channel c4;

}

exit;

EOF

3、但是查询备份记录发现每天晚上执行的level 1的备份并没有被标记过期，这样也没有被删除

select * from v$BACKUP_SET

4、rman备份设置如下:
RMAN> show all;
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name EASDB are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO ‘+FRANDREDG/EASDB/AUTOBACKUP/controlfile_%d_%T_%F_%s.bak’;
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM ‘AES128’; # default
CONFIGURE COMPRESSION ALGORITHM ‘BASIC’ AS OF RELEASE ‘DEFAULT’ OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO ‘+FRANDREDG/easdb/controlfile/snapcf_EASDB.f’;

CONFIGURE SNAPSHOT CONTROLFILE NAME TO ‘+FRANDREDG/easdb/controlfile/snapcf_easdb.f’;

4、