I have a question regarding use of db_recovery_file_dest_size on Oracle RDBMS 11.2, using ASM, along with DG (w/FSFO).
First, is there way to set the value for db_recovery_file_dest_size to unlimited (or to the maximum size available on the file system)?
I seem to remember being able to do this either by setting this to null (blank), or something similar.
Next, if our db_recovery_file_dest_size fills up to 100% full, does this have any impact on our database?
To understand this question, let me explain that our database is set up in ASM, but the FRA is on the file system.
The archive_log_dest_1 is also on the file system in a different location from our FRA.
Our FRA only contains two directories: one for "flashback", and the other for onlinelog.
Since we are configuring this database as a DG installation with FSFO (DGBroker), we are multiplexing redologs in both ASM and on the file system in the FRA onlinelogs directory.
Since the redo logs are circular in nature, I would not think there would be any problem if our FRA reached its maximum size, (other than not being able to flashback far enough to our flashback_retention_time setting). But I can't see that the database would stop or anything like that. This is my main concern.
For reference:
db_recovery_file_dest_size big integer 30G
db_flashback_retention_target integer 1440
GROUP# TYPE MEMBER
-------- ------- ------------------------------------------------------------
1 ONLINE +DATADG/prod/onlinelog/group_1.297.766622049
ONLINE /oraback/flashback/PROD/onlinelog/o1_mf_1_7ck8skss_.log
2 ONLINE +DATADG/prod/onlinelog/group_2.298.766622051
ONLINE /oraback/flashback/PROD/onlinelog/o1_mf_2_7ck8slg2_.log
3 ONLINE /oraback/flashback/PROD/onlinelog/o1_mf_3_7ck8slw8_.log
ONLINE +DATADG/prod/onlinelog/group_3.270.766622051
4 STANDBY /oraback/flashback/PROD/onlinelog/o1_mf_4_7ck8sm7y_.log
STANDBY +DATADG/prod/onlinelog/group_4.269.766622051
5 STANDBY /oraback/flashback/PROD/onlinelog/o1_mf_5_7ck8smkt_.log
STANDBY +DATADG/prod/onlinelog/group_5.259.766622051
6 STANDBY /oraback/flashback/PROD/onlinelog/o1_mf_6_7ck8smxj_.log
STANDBY +DATADG/prod/onlinelog/group_6.271.766622051
7 STANDBY /oraback/flashback/PROD/onlinelog/o1_mf_7_7ck8snbt_.log
STANDBY +DATADG/prod/onlinelog/group_7.280.766622053
14 rows selected.
Thanks in advance for your help.