Hey, Paul:

You're basically correct re: the recovery procedure.  Very generally, you
should:

     1)   Restore the database
     2)   Run DBUTIL:    disable for access, enable for roll-forward
recovery
     3)   Run DBRECOV to recover the data from the log files
     4)   Run DBUTIL:    disable recovery, enable for access and logging
     5)   Back up the database and log files and refresh the log cycle (the
TI manual says this is optional,
              but we have always done this to establish a new recovery
point).

The TurboImage Reference manual has a section dedicated to logging and
recovery procedures, and I'd recommend that you refer to that for the final
word re: this process.

Also, I'm not sure when it changed, but the requirement for having the log
files on the same volume set as the database no longer exists unless
rollback recovery is enabled.  Perhaps, someone else on the list can
confirm this?

Good luck!

Lee Gunter
Regence Blue Cross Blue Shield of Oregon / Regence HMO Oregon

mailto:[log in to unmask]
voice...503-375-4498    fax.....503-375-4401
==========================================================
The opinions expressed, here, are mine and mine alone, and do not
necessarily reflect those of my employer.



From: [log in to unmask] on 10/27/97 08:05 PM

Please respond to [log in to unmask]


To:   [log in to unmask]
cc:    (bcc: Lee Gunter/BCBSO/TBG)
Subject:  IMAGE recovery




We currently have logging enabled on our databases, but do not use
DBBEGIN and DBEND. We store our databases using Orbit/3000 once a week
and store the log files nightly.

We also have not tested our database recovery procedures in years.... :(

We are going to.

If we were to experience a problem that wiped out a database would the
proper procedure be to restore the database from the full backup
containing the databases and then do a DBRECOVER using the log file from
the nightly partial?

Of course this means we lose a days work at most(too bad we store the
log files on the same volume set as the databases.)

I beg pardon for what is essentially an RTFM question, but it has been
years since I've had to do this. Any manual citations would be
appreciated.

*******************************************
Paul Courry
[log in to unmask]
500 442-0261 (ATT lines only)
http://www.ns.net/~courry/
PGP key kept at PGPKEYS.MIT.EDU

*******************************************