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 92.64
0 229
FILE_TYPE PERCENT_SPACE_USED
------------------------------------------------------------ ------------------
PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
------------------------- ---------------
BACKUP PIECE 7.29
0 2
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.
1.alter system set DB_RECOVERY_FILE_DEST_SIZE=20g;
2.delete in OS, then
crosscheck archivelog all;
delete noprompt expired archivelog all;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10897379/viewspace-1016295/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/10897379/viewspace-1016295/