Database Backup and Recovery (MOSC)

MOSC Banner

Why are my datafile image copies in the flash recovery area showing 100% reclaimable?

edited Jun 4, 2014 3:21PM in Database Backup and Recovery (MOSC) 29 commentsAnswered ✓

Why are my datafile image copies in the flash recovery area all showing up as being reclaimable? How can I make them not be reclaimable?


Thanks, Mike


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                        ,99                        ,6              40        

BACKUP PIECE                       1,31                      1,31               5        

IMAGE COPY                        76,69                     76,69             292        

FLASHBACK LOG                         0                         0               0        

FOREIGN ARCHIVED LOG                  0                         0               0        

7 rows selected.


========


Recovery Manager: Release 11.2.0.3.0 - Production on Tue May 27 12:37:18 2014

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: xxxxx (DBID=xxxxxxxx)

RMAN>

using target database control file instead of recovery catalog

Tagged:

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