HP3000-L Archives

October 1999, Week 1

HP3000-L@RAVEN.UTC.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Steve Dirickson <[log in to unmask]>
Reply To:
Steve Dirickson <[log in to unmask]>
Date:
Fri, 1 Oct 1999 14:53:04 -0500
Content-Type:
text/plain
Parts/Attachments:
text/plain (18 lines)
> Can you log to a private volume?  Thus if the log disk fails, you do a
> fulldump and replace your logging disk drive.  If system
> drive(s) fails,
> restore and recover.  Not very likely that both system drive
> and private
> drive both fail at same time.

Sure; works like a champ. You do, however, give up rollback recovery, so it
may take longer to "undo" a transaction. The way to do it is to make a
backup of the database, then start a new logging sequence on the non-system
volume. If there's a failure on the volume containing the database, you use
the backup copy and roll it forward to the pre-failure state using the log
files. Restart the logging sequence each time you back up the database.


Steve Dirickson    WestWin Consulting
[log in to unmask]    (360) 598-6111

ATOM RSS1 RSS2