SQL> select * from v$flash_recovery_area_usage;
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
------------ ------------------ ------------------------- ---------------
ARCHIVELOG 97.43 0 792
rm rm rm ....................................
RMAN> crosscheck archivelog all;
RMAN> delete expired archivelog all;
SQL> select * from v$flash_recovery_area_usage;
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
------------ ------------------ ------------------------- ---------------
ARCHIVELOG 16.68 0 142
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/16348200/viewspace-571400/ ,如需转载,请注明出处,否则将追究法律责任。