Re: Archivelog Mode Recoverability: How Close to Point of Failure?

From: Ron <support_at_dbainfopower.com>
Date: Thu, 12 Feb 2004 16:47:23 -0800
Message-ID: <ioGdnXnB8JyBgLHdRVn-hA@comcast.com>

Hello Guy,

BCS - full recovery

WCS - up to the good backup

Regards,

  Ron
  DBA Infopower
  http://www.dbainfopower.com
  Standard disclaimer:
http://www.dbainfopower.com/dbaip_advice_disclaimer.html

"Skinny Guy" <skinnychineseguy_at_hotmail.com> wrote in message news:f9b5a61d.0402121603.1730933b_at_posting.google.com...
> Hi,
>
> If I have my DB in archivelog mode and a good backup, how close to the
> point of failure can I recover to?
>
> Don't the archive logs get copied only after a log switch and a log
> switch only occurs when a log fills up. So what if there are commits
> that don't cause the log file to fill up so that those commits haven't
> yet made it to the archive log file. Won't you lose those tranactions
> when you tried to recover from the full backup + the archive logs?
Received on Thu Feb 12 2004 - 18:47:23 CST