Re: LOG_ARCHIVE_DEST (tape drive in UNIX environment)
Date: 17 Oct 1994 08:04:04 GMT
Message-ID: <37tb5k$j3g_at_lorne.stir.ac.uk>
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)Received on Mon Oct 17 1994 - 09:04:04 CET