Re: Backup flashback logs to tape

On Jul 2, 12:49 pm, "Vladimir M. Zakharychev" <vladimir.zakharyc..._at_gmail.com> wrote:
> On Jul 2, 6:43 pm, zigzag..._at_yahoo.com wrote:
>
>
>
>
>
> > On Jul 2, 10: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
>
> > You can alwys use OS command to backup flashback logs to taoe. As
> > along you do not delete logs you will be fine.
>
> Always? Really? Even if FRA is configured on an ASM volume? Which OS
> command does that and of which OS? And assuming FRA is on a
> conventional file system, what will you get on tape when Oracle writes
> flashback logs while you tar them? And why would you want to backup
> flashback logs to tape in the first place? What's their worth being
> there?
>
> Regards,
> Vladimir M. Zakharychev
> N-Networks, makers of Dynamic PSP(tm)
> http://www.dynamicpsp.com- Hide quoted text -
>
> - Show quoted text -

I work with UNIX. You can always use dd to backup anything. Never tried ASM.
It has been pointed by Oracle that there is no need to backup flashback logs, but OP is not asking that. OP's question was how to back them up and not why to back them up.

I thnk there is something wrong in Oracle's design. What hapens if disk crashes and flashbac logs get deleted or become corrupted. Then you cannot flashback database or flashabck db only to some point in time. You may hvave to turn flashback feature off and then turn the feature on. I recently had a stuation where somehow flashback logs were corrupted, it brought Oracle Database down. Then I had to turn flashback off and then on. Oracle said it is a bug in Oracle 10.1.0.4 and is fixed in 10.2.0.x. Received on Mon Jul 02 2007 - 12:11:51 CDT