Storage Management (ASM ACFS DNFS ODM) (MOSC)

MOSC Banner

How to reclaim space from flash recovery area

edited Jun 16, 2010 7:58AM in Storage Management (ASM ACFS DNFS ODM) (MOSC) 3 commentsAnswered
 Hi,
I'm looking at claiming some space back from the 'FLASHBACK' area:

4) Filetype Summary

TYPE               FILES       BLOCKS      USED_MiB     SPACE_MiB
---------------- ------- ------------ ------------- -------------
ARCHIVELOG         2,526   27,951,061      13,648.0      14,748.6
BACKUPSET          1,175    4,603,621       2,247.9       3,021.0
CONTROLFILE            3        7,107         111.0         120.9
DATAFILE              57    3,035,747      23,716.8      23,791.8
FLASHBACK          3,448    5,159,198      40,306.2      53,150.1
ONLINELOG             14      942,094         460.0         543.5
PARAMETERFILE          8           64            .0           8.0
TEMPFILE               3       43,523         340.0         345.7
                                      ------------- -------------
Total :                                    80,830.0      95,729.5

8 rows selected.

On querying the database for v$flash_recovery_area_usage, it shows there's ~ 34% space that's reclaimable. How can I achieve this? I've verified that there are obsolete archive logs by 'rman crosscheck'. Are there any other ways I can reclaim this space?

SQL> select PERCENT_SPACE_USED,PERCENT_SPACE_RECLAIMABLE, NUMBER_OF_FILES from v$flash_recovery_area_usage where FILE_TYPE like 'FLASHBACK LOG';

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center