I am having a problem with FRA. I have looked at the threads in metalink and tried what they suggested and I still have the problem.
Enterprise Manager says Usable Fast Recovery Area (%)= 100, but I believe it is becuase it can't see the files that are there. Here are some examples.
SQL> show parameter recovery
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /OraFlash/VISITOR/backupset
db_recovery_file_dest_size big integer 5G
recovery_parallelism integer 0
select name, space_limit as Total_size ,space_used as Used,
SPACE_RECLAIMABLE as reclaimable ,NUMBER_OF_FILES as "number"
from V$RECOVERY_FILE_DEST; 2 3
NAME
--------------------------------------------------------------------------------
TOTAL_SIZE USED RECLAIMABLE number
---------- ---------- ----------- ----------
/OraFlash/VISITOR/backupset
5368709120 0 0 0
ls -alt /OraFlash/VISITOR/backupset
total 846188
drwxr-----. 2 oracle dba 4096 Jun 16 11:12 .
-rw-r-----. 1 oracle dba 76345856 Jun 16 08:54 1tq9kdgo_1_1
-rw-r-----. 1 oracle dba 790134784 Jun 16 08:53 1rq9kd86_1_1
drwx------. 4 oracle dba 4096 May 18 15:32 ..
Why isn't oracle seeing the files?