Re: FRA size continuously filling up
Date: Mon, 22 Sep 2014 15:56:12 -0500 (CDT)
Message-ID: <38999decb3338d308190a39bbf3c3ea5.squirrel_at_society.servebeer.com>
Saad writes:
> Here is the output as I see it for these queries:
>
> SQL> select file_type, percent_space_used||'%' per_used,
> percent_space_reclaimab
> le||'%' per_recl, number_of_files num_file from v$flash_recovery_area_usage;
>
> FILE_TYPE PER_USED PER_RECL NUM_FILE
> ------------------------------ -------- -------- --------
> CONTROL FILE 0% 0% 0
> REDO LOG 0% 0% 0
> ARCHIVED LOG 95.13% 62.9% 280
[snip]
>>> CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
Perhaps this configuration item could help, as I don't think we see anywhere that the archive logs are removed after being backed up (unless this is an external process not shown here).
My $.02,
Rich
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Sep 22 2014 - 22:56:12 CEST