Re: LOG_ARCHIVE_DEST (tape drive in UNIX environment)

In article: <37tb5k$j3g_at_lorne.stir.ac.uk> sam_at_cs.stir.ac.uk (Sam Nelson) writes:
>
> In article <37d7ra$jke_at_newsbf01.news.aol.com>, shanet458_at_aol.com (ShaneT458) writes:
> > archiving a log file group. What I don't know is the exact syntax for
> > LOG_ARCHIVE_DEST that will cause this archiving to occur on a tape in a
> > UNIX environment.
> >
> > I would like to set up a system that would place archive on tape.
> >
> Don't. Archive to a different disk than your database files are on. That
> way, if you lose the database disk, you can get the archived log files back
> quickly once you've restored your original offline backup. Plus, if your
> database is ever busy enough for LGWR to switch to a logfile group that hasn't
> been completely archived yet, your database will hang up until archiving
> completes. Not nice, I think. You could also let yourself in for an
> unpleasant experience if you're changing the tape cartridge at precisely
> the wrong moment!
>
> It isn't difficult to set up a scheme to copy archive log files to tape from
> disk every now and again and delete them from the disk...
>
> --
> SAm. -- (Insert bandwidth-wasting disclaimer here)
>
>

I agree. Do not archive directly to tape.Archive to disk and write a script to write them to tape.
Carl Churchman
carl_at_carlc.demon.co.uk Received on Wed Oct 19 1994 - 23:22:41 CET