RE: Recover Logical Logs (the hard way)
Thank you for your reply, but I may have left out some information.
We don't have a backup of the logical logs since Friday. We have 70 or
so logical logs that get backed up periodically as they begin to fill.
Since they were backed up before the Friday backup, and we only had one
day of activity (Monday), there was no reason to backup the logs before
I left last night (at least no reason that I could have foreseen). It
is not possible (according to Informix tech support) to restore from the
disk drive, you can only restore from a log backup. Somehow I must
backup the logs to tape before I can use them to roll forward. The
scheme at this time is to re-install, and trick the engine into thinking
it's logs are those that are out there on the drive. Then do an ontape
backup.
-----Original Message-----
From: Woodall Con [SMTP:cwoodall@vth.colostate.edu]
Sent: Tuesday, December 15, 1998 9:36 AM
To: Scott Black
Cc: 'Informix-List (E-mail)
Subject: Re: Recover Logical Logs (the hard way)
Assuming your logical log backup is in place and covers the
period
from your last Friday's backup, the restore process should
normally
prompt you to apply the logical logs. Also, that process should
prompt you to salvage logical logs that are still on your
logical
log drive. If they span that period you can have two sets of
the log data to apply to last Friday's backup. I'm assuming
you use ontape.
Good luck
Con Woodall
Colorado State University Veterinary Teaching Hospital
cwoodall@vth.colostate.edu
970-491-1244
On Tue, 15 Dec 1998, Scott Black wrote:
> I'm running HP-UX 10.20
> Online 7.3
>
> We had a vandal come in and physically smash some of our
server's disk
> drives (before the nightly backup). The root dbspace drive is
toast.
> However the logical log drive is in good working order.
Here's the
> question:
>
> How can I save the logical log information so that when we get
back up
> and running, and restore from Friday's backup, we will be able
to roll
> forward the logs?
>
> Any hair brained scheme will be appreciated. Thanks in
advance.
>
>
>