HP3000-L Archives

February 1996, Week 5

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:
Reply To:
Date:
Wed, 28 Feb 1996 15:02:10 PST
Content-Type:
text/plain
Parts/Attachments:
text/plain (64 lines)
Marvin,
 
The data is as safe as the last logfile available from which to
recover.  We do standalone backups, here, with logging stopped so as to
retrieve all logfiles, and our weekly full system backup refreshes all
log cycles on the system (stores and purges logfiles, resets root file
store dates & "dirty" bits, builds new logfiles, ALTLOGs all log IDs).
 
Recovery methods vary - rollback recovery must be specifically enabled
in the root file (without ILR!!), and fairly fast depending upon the
reason for recovery.  We rarely roll back in the event of a system
abort - we used to do it every time, but no transactions recovered!  I
think XM helps in this regard.
 
Roll forward recovery involves a restore of the database from a
previous backup and posting from logfiles via the DBRECOV utility.
This would be required in the event of a media (disk) failure.
 
Generally, logfiles should be located on media separate from the
databases being logged to protect them from damage should the databases
suffer a hit; however, with your client backing up his logs frequently
during the day, this may not be a problem.
 
Hope this helps.
 
Lee Gunter      503-375-4498        [log in to unmask]
HMO Oregon      503-375-4401  fax
==========================================================
The opinions expressed, here, are mine and mine alone, and do not
necessarily reflect those of my employer.
 
 
 
 
______________________________ Reply Separator _________________________________
Subject: Log files in Turbo Image
Author:  Marvin Barnes <[log in to unmask]> at ~INTERNET
Date:    2/28/96 12:56 PM
 
 
I am at client's site and have found logging turned on all Image data
bases.  The logs are switched twice a day and backups of the old log
files are made upon completion of the switch.  The primary applications
are materials management and production management.
 
Partial backups are done Monday thru Thursday nights and a full with
everyone off the system is done Saturday night.  A noon backup of the old
log files are also performed.
 
I come from the school of either using something like backpack or getting
all the users off the system and then doing full/partial backups.  What
are you opinions of using the log files from image to cover the data
incase of loss due to whatever?  How difficult is it to roll back the log
files into the data bases?
 
Bottomline - is the data safe?
 
TIA...
 
Marvin Barnes                       EMail [log in to unmask]
3240 Addison Avenue East            Telephone: 208.733.7307
P.O. Box U                          FAX: 208.733.7309
Twin Falls, ID 83303-0446

ATOM RSS1 RSS2