RE: Recovery Question

You can use datafile from cold backup and apply archive logs to it.

-----Original Message-----
From: Kirk W. Conrad [mailto:kwconrad_at_mdanderson.org] Posted At: Wednesday, August 01, 2001 3:42 PM Posted To: comp.databases.oracle.server
Conversation: Recovery Question
Subject: Recovery Question

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:57:16 CDT