Re: FRA size continuously filling up

The problem is not that the fast recovery area is filling up, but rather that something is generating files in it at a fast rate. So question is, what kind of files are filling it up. Is it archived redo logs or flashback logs or backup files? Once you know that, you can start investigating why these files are being generated at a much higher rate than normally

Kind regards,

Freek

On ma, 2014-09-22 at 16:24 -0400, Saad Khan wrote:
> This is Oracle 11.2.0.3 on windows platform.
>
>
>
> We started getting following message this morning:
>
>
>
>
> ORA-19815: WARNING: db_recovery_file_dest_size of 13958643712 bytes is
> 100.00% used, and has 0 remaining bytes available.
>
>
>
> For now i've tried following actions but its just not working:
>
>
> 1) Extending the value of db_recovery_file_dest_size as much as 4G to
> 13G --wutever the size i give it just fills within no time.
> 2) Taking the backup to tape, deleting old archivelogs
> 3) Crosscheck archivelogs, delete expired/obsolete ones
> 4) Most important, as per MOS doc ID 293418.1, I took the backup of
> FRA and it did help for some time but now its 100% filled again.
>
>
> Its barely 8GB size database.
>
>
> Do I need to bounce DB at this point?
>
>
> Below is my backup configuration:
>
>
> CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
> CONFIGURE BACKUP OPTIMIZATION OFF; # default
> CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
> CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%
> F'; # defa
> ult
> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F';
> # default
> CONFIGURE DEVICE TYPE SBT_TAPE PARALLELISM 1 BACKUP TYPE TO BACKUPSET;
> # default
>
>
> CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; #
> default
> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; #
> default
> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
> CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; #
> default
> CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; #
> default
> CONFIGURE MAXSETSIZE TO UNLIMITED; # default
> CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
> CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
> CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT'
> OPTIMIZE FOR LOA
> D TRUE ; # default
> CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
> CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'E:\ORACLE\11.2.0\DATABASE
> \SNCFICD10DB.OR
> A'; # default

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