Re: FRA size continuously filling up

From: Saad Khan <saad4u_at_gmail.com>
Date: Tue, 23 Sep 2014 09:46:54 -0400
Message-ID: <CACqGOPKAffSv-0n_DyPzEfOOvaG8tgyGjzmU=_3av+c8io6Cyw_at_mail.gmail.com>

Yes ofcourse, its included already within RMAN syntax command for backups. im thinking to setup hourly job to cleanup archivelogs.

On Tue, Sep 23, 2014 at 7:39 AM, Lyall personal < lyallbarbour_at_sanfranmail.com> wrote:

> 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_at_freelists.org
> Reply To: rjoralist3_at_society.servebeer.com
> 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
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Sep 23 2014 - 15:46:54 CEST