Re: FRA size continuously filling up
- From: Lyall personal <lyallbarbour@xxxxxxxxxxxxxxx>
- To: rjoralist3@xxxxxxxxxxxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Tue, 23 Sep 2014 07:39:32 -0400
Also, if you want to delete archive logs after backing them up, check the
syntax in RMAN backup command... DELETE INPUT
Sent from my BlackBerry 10 smartphone.
Original Message
From: Rich Jesse
Sent: Monday, September 22, 2014 4:58 PM
To: oracle-l@xxxxxxxxxxxxx
Reply To: rjoralist3@xxxxxxxxxxxxxxxxxxxxx
Subject: Re: FRA size continuously filling up
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
