Hi all
As following queries there is some reclaimable spaces in my recover destination.
query :
SELECT Name, (SPACE_LIMIT/1024/1024/1024) Space_Limit_GB, SPACE_USED/1024/1024/1024 Space_Used_GB, SPACE_RECLAIMABLE, NUMBER_OF_FILES FROM V$RECOVERY_FILE_DEST;
output :
NAME,SPACE_LIMIT_GB ,SPACE_USED_GB ,SPACE_RECLAIMABLE ,NUMBER_OF_FILES
/orafra, 700 ,48.1809592247009 ,3198156800 ,77
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 .05 0 9
BACKUP PIECE 6.39 0 4
IMAGE COPY 0 0 0
FLASHBACK LOG .45 .43 64
FOREIGN ARCHIVED LOG 0 0 0
7 rows selected.
Please advise me how can i do the cleaning process ?