Recovery Question

From: Kirk W. Conrad <kwconrad_at_mdanderson.org>
Date: Wed, 1 Aug 2001 15:42:22 -0500
Message-ID: <9k9pus$5ak$1@oac2.hsc.uth.tmc.edu>

We have a small database in archiving mode. We do a cold backup on Sunday night and hot backups getting all the datafiles and archives all other nights. If at 11 am on Monday morning we lose a datafile, can I restore that datafile from the previous nights cold backup and then recover the morning's transactions with the archived logs generated since then? Or can I not use datafiles backed up cold with archived logs?

Thanks.
Kirk Received on Wed Aug 01 2001 - 15:42:22 CDT