Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Backup flashback logs to tape

Re: Backup flashback logs to tape

From: <zigzagdna_at_yahoo.com>
Date: Mon, 02 Jul 2007 18:06:06 -0700
Message-ID: <1183424766.319267.118760@g4g2000hsf.googlegroups.com>


On Jul 2, 8:57 pm, zigzag..._at_yahoo.com wrote:
> On Jul 2, 8:12 pm, joel garry <joel-ga..._at_home.com> wrote:
>
>
>
>
>
> > On Jul 2, 7:20 am, Ganesh <ganesh.tam..._at_gmail.com> wrote:
>
> > > I would like to know if there is any way I can backup my flashback
> > > logs to tape.
>
> > > I want to do this to provide additional level of backup and I have a
> > > business need where I need to preserve older copies of Flashback logs.
>
> > > According to all the documents I have referred, there is no RMAN
> > > command available that would do this for me.
>
> > > Kindly let me know if anyone has tried this sort of operation.
>
> > > Thanks & Regards,
> > > Ganesh
>
> > I think what you and zigzag are missing here is that flashback is just
> > a shortcut to recovery, at the expense of potentially a lot of disk
> > space. If you just use RMAN commands to do the regular recovery to a
> > point in time you get what you want. Right?
>
> > jg
> > --
> > @home.com is bogus.
> > 'I'm reminded of the "Mr. Bill" character that was once featured on
> > "Saturday Night Live."' - Dear Abby
>
> It is a short cut but not robust.- Hide quoted text -
>
> - Show quoted text -

It sure will be nice if falshbak logs could also be backed up using rman or some other means and one can quickly recover them and do flashback database point in time recovery instead of doing traditional rman based recovery which will take much longer time depending on size of database. Received on Mon Jul 02 2007 - 20:06:06 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US