RE: 10g flashback

One gotcha that you need to keep in mind is that the flash recovery area holds much more than just RMAN backups. By default, it also holds the archive logs and flashback logs. In addition, if so configured, it holds Oracle-managed files, multiplexed copies of the online redo logs, and control files. However, only the total size of this area can be defined, and when there is disk pressure on account of rapid generation of archivelogs and adequate disk is not available, RMAN backups will fail with messages such as ORA-19809: limit exceeded for recovery files and ORA-19804: cannot reclaim 52428800 bytes disk space from 2147483648 limit. Be sure to calculate and set an adequate value for the DB_RECOVERY_FILE_DEST_SIZE parameter and sensible values for DB_FLASHBACK_RETENTION_TARGET. Note that this is independent of the actual disk space available in that filesystem or ASM disk group; this value is simply a logical upper limit and exists to prevent some runaway job from filling up the disk space.

The default is 2G and you should increase it depending on the amount of permanent/temporary usage of space (Most of this text used from Ch 9 in my book).

Regards,
John Kanagaraj <><
DB Soft Inc
Phone: 408-970-7002 (W)  

Fear connects you to the Negative, but Faith connects you to the Positive! I Jn 4:18  

• The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers **

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Christo Kutrovsky Sent: Monday, May 15, 2006 1:20 PM
To: Spears, Brian
Cc: oracle-l
Subject: Re: 10g flashback

I think you are confusing the following 2 different technologies: - flash recovery area
- flashback database

Those are different things. One is a way to organize your backup files, the other is something like reverse-redo.

--
Christo Kutrovsky
Senior Database/System Administrator
The Pythian Group - www.pythian.com
I blog at http://www.pythian.com/blogs/


On 5/15/06, Spears, Brian <BSpears_at_limitedbrands.com> wrote:


> Do you use is in-place-of other backups and use the flashback as the

typical


> recovery?

>

> How long a recovery period are you covering?

>

>

> Brian Spears

> Database Services

> Limited Technology Services

> * DC2 Phone:     614-415-1398

> * E-Mail:             bspears_at_Limitedbrands.com

> * Text Page:        866-577-9532_at_SkyTel.com

> Limitedbrands

>

>

> -----Original Message-----

> From: Christo Kutrovsky [mailto:kutrovsky.oracle_at_gmail.com]

> Sent: Monday, May 15, 2006 3:32 PM

> To: Spears, Brian

> Cc: Oracle-L Freelists

> Subject: Re: 10g flashback

>

> I am using it. I am loving it. That is the flashback recovery area.

>

> --

> Christo Kutrovsky

> Senior Database/System Administrator

> The Pythian Group - www.pythian.com

> I blog at http://www.pythian.com/blogs/

>

>

>

> On 5/15/06, Spears, Brian <BSpears_at_limitedbrands.com> wrote:

> >

> >

> > Has anyone converted their Rman backups to disk procedure to just

use the


> > ORACLE flash back procedure for oracle 10g?

> >

> > Anybody have any pointers against this?

> >

> > Thanks!

> >

> > Brian

> >

> > --

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

> >

> >

> >

>

>

> --

> Christo Kutrovsky

> Senior Database/System Administrator

> The Pythian Group - www.pythian.com

> I blog at http://www.pythian.com/blogs/

>

>



-- 
Christo Kutrovsky
Senior Database/System Administrator
The Pythian Group - www.pythian.com
I blog at http://www.pythian.com/blogs/
--
http://www.freelists.org/webpage/oracle-l


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