RMAN期限切れバックアップとアーカイブログのクリーンアップ


まず、ディスクの問題を特定し、バックアップが期限切れになったことを疑ってください.
df -h | awk '$5 >= 90||$4>=90 {print}'
Filesystem            Size  Used Avail Use% 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 set 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_041013211003_g3o6oo7o_3_1.rmn
Backup Set           97     11-MAY-2013 00:25:39
  Backup Piece       99     11-MAY-2013 00:25:39 /ora_daily2/xxx_041013211003_g3o6oo7o_2_1.rmn
Backup Set           97     11-MAY-2013 00:25:32
  Backup Piece       75     11-MAY-2013 00:25:32 /ora_daily2/xxx_041013211003_g3o6oo7o_1_1.rmn
Backup Set           98     11-MAY-2013 00:25:41
  Backup Piece       103    11-MAY-2013 00:25:41 /ora_daily2/xxx_041013211003_g4o6oo7q_3_1.rmn
Backup Set           98     11-MAY-2013 00:25:40
  Backup Piece       100    11-MAY-2013 00:25:40 /ora_daily2/xxx_041013211003_g4o6oo7q_2_1.rmn
Backup Set           98     11-MAY-2013 00:25:39
  Backup Piece       98     11-MAY-2013 00:25:39 /ora_daily2/xxx_041013211003_g4o6oo7q_1_1.rmn
Backup Set           111    11-MAY-2013 00:25:44
  Backup Piece       116    11-MAY-2013 00:25:44 /ora_daily2/xxx_041013211003_g9o6pm32_1_1.rmn
Backup Set           112    11-MAY-2013 00:25:45
        
delete obsolete;-- 

アーカイブ・ログの確認もできます
crosscheck archivelog all;-- 
delete expired archivelog all;--