Why are my datafile image copies in the flash recovery area showing 100% reclaimable?
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