SQL> select * from V$FLASH_RECOVERY_AREA_USAGE;
FILE_TYPE PERCENT_SPACE_USED------------------------------------------------------------ ------------------PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES------------------------- ---------------CONTROL FILE 0 0 0
REDO LOG 0 0 0
ARCHIVED LOG 95.08 0 16

FILE_TYPE PERCENT_SPACE_USED------------------------------------------------------------ ------------------PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES------------------------- ---------------BACKUP PIECE 0 0 0
IMAGE COPY 0 0 0
FLASHBACK LOG 0 0 0

FILE_TYPE PERCENT_SPACE_USED------------------------------------------------------------ ------------------PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES------------------------- ---------------FOREIGN ARCHIVED LOG 0 0 0

7 rows selected.SQL> show parameter db_recovery_file_dest;
NAME TYPE------------------------------------ ---------------------------------VALUE------------------------------db_recovery_file_dest string/picclife/app/oracle/fast_recovery_areadb_recovery_file_dest_size big integer4182MSQL> select sum(percent_space_used)*3/100 from v$flash_recovery_area_usage;
SUM(PERCENT_SPACE_USED)*3/100----------------------------- 2.8524
9. 检查一些无用的archivelogRMAN> crosscheck archivelog all;10. 删除过期的归档RMAN> delete expired archivelog all;
RMAN> DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-7';再次查看SQL> select * from V$FLASH_RECOVERY_AREA_USAGE;
FILE_TYPE PERCENT_SPACE_USED------------------------------------------------------------ ------------------PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES------------------------- ---------------CONTROL FILE 0 0 0
REDO LOG 0 0 0
ARCHIVED LOG 25.82 0 5

FILE_TYPE PERCENT_SPACE_USED------------------------------------------------------------ ------------------PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES------------------------- ---------------BACKUP PIECE 0 0 0
IMAGE COPY 0 0 0
FLASHBACK LOG 0 0 0

FILE_TYPE PERCENT_SPACE_USED------------------------------------------------------------ ------------------PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES------------------------- ---------------FOREIGN ARCHIVED LOG 0 0 0

7 rows selected.