FRA size continuously filling up
Date: Mon, 22 Sep 2014 16:24:59 -0400
Message-ID: <CACqGOP+F1V2NTaXtiNnw1EaGRw7NYst2nC=KAF5d1zZDKDDecA_at_mail.gmail.com>
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:
- 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.
- Taking the backup to tape, deleting old archivelogs
- Crosscheck archivelogs, delete expired/obsolete ones
- 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
Received on Mon Sep 22 2014 - 22:24:59 CEST