Re: hot backup & direct load - compatible ?

From: John P. Higgins <jh33378_at_deere.com>
Date: Fri, 13 Nov 1998 13:26:43 -0600
Message-ID: <364C87F3.4D19F055@deere.com>

Hot backups are never consistent in and of themselves. You must have the redo logs that were generated durring the backup. Since the direct load avoids logging, you could never recover the records that were inserted durring the backup. In a recovery, you would need a way to re-load the unlogged records.

kstingel@sairgroup.com wrote:

Hi all,

I have a warehouse which has long sqlloader jobs running against it in direct
mode. As it happens my hot backup window of 8hrs also overlaps some of the
direct loader jobs.
Question - Is my database backup consistent?

thanks
Kelvin Stingel
Atraxis

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own

  Received on Fri Nov 13 1998 - 13:26:43 CST