Re: Minimizing backup induced downtime

From: Alexander Skwar <alexander_at_skwar.name>
Date: Fri, 13 Jul 2007 08:20:03 +0200
Message-ID: <3145241.0tL86nlxXL@kn.gn.rtr.message-center.info>

joel garry <joel-garry_at_home.com> wrote:
> On Jul 12, 2:23 pm, Alexander Skwar <use..._at_alexander.skwar.name> > wrote:

>> I am running the databases in archive log mode and I know what it is.
>> But the problem is, that the logs aren't backed up. They are, at best,
>> backed up until 22:45. Then the backup is finished. Everything that's
>> stored on the disks/in the database between 22:46 and 22:59 has not
>> been backed up yet.

[...]
> Note that if you want to, you can be shipping the archived logs > somewhere off the server.

I know. But suppose that this not being done. How can you then restore something, that's not backed up?

Alexander Skwar Received on Fri Jul 13 2007 - 01:20:03 CDT