Prev: High JS kgl get object wait
Next: 11g upgrade - DBUA0 instance
From: maadhuuranjan.m on 3 Jan 2008 01:40
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 :
log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST
VALID_FOR=(ALL_LOGFILES,A
LL_ROLES)

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
From: DA Morgan on 3 Jan 2008 01:54
maadhuuranjan.m(a)gmail.com 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 :
> log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST
> VALID_FOR=(ALL_LOGFILES,A
> LL_ROLES)
>
> 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
damorgan(a)x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
 | 
Pages: 1
Prev: High JS kgl get object wait
Next: 11g upgrade - DBUA0 instance