【若泽大数据】Rman归档删除策略的配置_rman 备份归档并删除4小时之前-优快云博客

本文介绍了如何在Oracle 11g R2中配置RMAN的归档删除策略，包括查看当前配置、启用归档删除策略、以及不同删除策略的测试，展示了如何通过RMAN命令进行归档备份并删除归档日志。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

 
 从11gR2开始，RMAN引入了归档删除策略的配置，下面我们通过简单的例子来讨论这个功能： 

 
 数据库版本： 

 
 SQL> select * from v$version; 

 
 BANNER 

 
 -------------------------------------------------------------------------------- 

 
 Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production 

 
 PL/SQL Release 11.2.0.2.0 - Production 

 
 CORE    11.2.0.2.0      Production 

 
 TNS for Linux: Version 11.2.0.2.0 - Production 

 
 NLSRTL Version 11.2.0.2.0 - Production 

 
 1.查看RMAN配置： 

 
 RMAN> show all; 

 
 RMAN configuration parameters for database with db_unique_name RACTEST are: 

 
 CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS; 

 
 CONFIGURE BACKUP OPTIMIZATION OFF; # default 

 
 CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default 

 
 CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default 

 
 CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default 

 
 CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default 

 
 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 '/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_ractest.f'; # default 

 
 默认归档删除策略没有启用。 

 
 2.启用归档删除策略： 

 
 RMAN>  
 CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO DISK; 