oracle清除过期备份,RMAN清理过期备份和归档⽇志⾸先要先定位磁盘问题，怀疑到是过期备份导致的。df -h | awk '$5 >= 90||$4>=90 {print}'
Filesystem Size Ud Avail U% Mounted on
1.4T 1.3T 115G 92% /d01_test2
15G 15G 373M 98% /u01_test1
12G 12G 545M 96% /u01_test2
然后切换合适的ORACLE_SID之后，我们开始RMAN操作rman target /
Configure retention policy to redundancy 1;--指保留⼀次备份，其余的都是过期的
香菜根的功效
--Configure retention policy to recovery window of 7 days;--指保留7天内的备份，其余的都是过期的搜狗导航网址
RMAN> report obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is t to redundancy 1
虎鲸杀人
广西玉林必去景点大全Report of obsolete backups and copies
格列齐特缓释片Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set 97 11-MAY-2013 00:25:40
Backup Piece 101 11-MAY-2013 00:25:40 /ora_daily2/xxx_0410********_g3o6oo7o_
Backup Set 97 11-MAY-2013 00:25:39
Backup Piece 99 11-MAY-2013 00:25:39 /ora_daily2/xxx_0410********_g3o6oo7o_
Backup Set 97 11-MAY-2013 00:25:32
Backup Piece 75 11-MAY-2013 00:25:32 /ora_daily2/xxx_0410********_g3o6oo7o_生于安乐死于忧患
Backup Set 98 11-MAY-2013 00:25:41年度安全培训计划
英国属于哪个洲Backup Piece 103 11-MAY-2013 00:25:41 /ora_daily2/xxx_0410********_g4o6oo7q_
Backup Set 98 11-MAY-2013 00:25:40
Backup Piece 100 11-MAY-2013 00:25:40 /ora_daily2/xxx_0410********_g4o6oo7q_
Backup Set 98 11-MAY-2013 00:25:39
Backup Piece 98 11-MAY-2013 00:25:39 /ora_daily2/xxx_0410********_g4o6oo7q_
Backup Set 111 11-MAY-2013 00:25:44
Backup Piece 116 11-MAY-2013 00:25:44 /ora_daily2/xxx_0410********_g9o6pm32_
Backup Set 112 11-MAY-2013 00:25:45
delete obsolete;--就会删除过期备份
下⾯还可以检查下归档⽇志crosscheck archivelog all;--检查过期归档⽇志
delete expired archivelog all;--删除过期归档⽇志
