手工清理归档日志

1、确认Flash区空间已满。如：

SQL> select * from v$flash_recovery_area_usage;

FILE_TYPE    PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES

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

CONTROLFILE                   0                                 0                                         0

ONLINELOG                     0                                  0                                          0

ARCHIVELOG                100.00                           0                                        240

BACKUPPIECE                   0                                 0                                          0

IMAGECOPY                     0                                  0                                          0

FLASHBACKLOG               0                                  0                                           0

 

6 rows selected.

2、删除无用的归档日志：

第一步，使用OS命令删除无用的归档日志。如：

# rm –rf /oracle/flash_recovery_area/archivelog/ 2013_04_01

第二步，使用RMAN命令检查无效的归档日志。如：

RMAN> crosscheck archivelog all;

第三步，使用RMAN命令删除无效的归档日志。如：

RMAN> delete expired archivelog all;