RE: 10g flashback
- From: "John Kanagaraj" <john.kanagaraj@xxxxxxx>
- To: <kutrovsky.oracle@xxxxxxxxx>, "Spears, Brian" <BSpears@xxxxxxxxxxxxxxxxx>
- Date: Tue, 16 May 2006 13:36:32 -0700
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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@xxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxx
> * Text Page: 866-577-9532@xxxxxxxxxx
> Limitedbrands
>
>
> -----Original Message-----
> From: Christo Kutrovsky [mailto:kutrovsky.oracle@xxxxxxxxx]
> 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@xxxxxxxxxxxxxxxxx> 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
> >
> > --
> > //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/
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
