RMAN reclaimable space
I'm making a RMAN backup to the FRA (on SAN) and later to tape (backup recovery area).
Looking at the space available is see:
SQL> SELECT * FROM V$FLASH_RECOVERY_AREA_USAGE;
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
------------ ------------------ ------------------------- ---------------
CONTROLFILE ,08 0 1
ONLINELOG 0 0 0
ARCHIVELOG 2,58 2,58 12
BACKUPPIECE 93,3 62,03 37
IMAGECOPY 0 0 0
FLASHBACKLOG 0 0 0
6 rijen zijn geselecteerd.
In my opinion there a lot of reclaimable space available.
..
..
When I make a backup of a datafile:
RMAN> backup device type disk tag 'BACKUP_TWINDBT_WEE_011011120003' datafile '+TWINTGRP01/twindbt/datafile/ts_cwzmdb_i.ora';
Starting backup at 14-JAN-11
released channel: ORA_SBT_TAPE_1