As long as the database being logged is not enabled for rollback recovery, you
may even place the log files on a different volume set from the database;
otherwise, I agree with Mark in that log files should reside on a different
device from the database if at all possible. Also, the entire log file set
should be backed up at least nightly.
----
Lee Gunter The Regence Group
Supervisor, TRG HP/MPE Systems 503.375.4498
----
Opinions expressed are solely mine.
From: [log in to unmask] on 11/08/99 07:44 AM
Please respond to [log in to unmask]
To: [log in to unmask]
cc: (bcc: Lee Gunter/BCBSO/TBG)
Subject: Re: [HP3000-L] Image log files
Gary Nolan sez:
>Logging to disc is great as long as you don't lose ldev 1 (as we
>found out the hard way).
Why limit your log file to LDEV 1? If you limit the log file to
a spindle that does not contain your databases, you should be
protected in the event a disk fails - either you lose the
database, or you lose the log file, but not both.