Re: Oracle 10g - db_recovery_file_dest and db_recovery_file_dest_size

From: DA Morgan <>
Date: Wed, 02 Jan 2008 22:54:40 -0800
Message-ID: <> wrote:
> Hello all,
> I am trying to set up Oracle for Dataguard in 10g for a Physical
> standby and its working correctly. Now I have the following doubt :
> When we create a database using dbca, the Flash database window allows
> you to enter the place where you want this to happen and there is a
> default size of 2048 MB . Now when I see the spfile, I see that the
> following 2 parameters are set db_recovery_file_dest and
> db_recovery_file_dest_size which is again fine. Now, when I try to
> set up Archive log for these, by default it does :
> and now I am very apprehensive about this space (2048MB) being
> completely used up so quickly that no more archivals will take place.
> I was also reading about this online and it says that :
> The size of the flash recovery area at any one time is a function of:
> * Copies of all datafiles
> * Incremental backups
> * Online redo logs
> * Archived redo logs
> * Flashback logs
> * Current Controlfile
> * Controlfile autobackups and SPFILEs
> What do you think I should be doing ? Should I use separate locations
> for archived redo logs, online redo logs and backups using RMAN or do
> you think I should just try to increase the size from 2048MB to around
> 30 GB ?
> thanks,
> Madhu M

2GB is a ridiculously small size for any serious database: Resize according to your needs.

For one part of the puzzle this may help: SELECT estimated_flashback_size
FROM gv$flashback_database_log;

Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Thu Jan 03 2008 - 00:54:40 CST

Original text of this message