Hum, he says nope and I say yup. Yet I believe we are giving the same answer. So I will explain mine more fully.
One of the advantages of a database running in archive log mode is the ability to restore just one data file. -----Original Message----- Thapliyal Sent: Sunday, February 03, 2002 11:00 PM To: Multiple recipients of list ORACLE-L nope .. this should just work fine:) --- Randy Kirkpatrick <[EMAIL PROTECTED]> wrote: > Listmembers, > > Are there any "gotchas" with restoring just one > datafile from a hot backup > and applying the archive logs? Will applying the > archive logs only affect > the restored datafile? For instance, if I have a hot > backup from Monday and > all the archive logs to the current date and a disk > crashes which contains > the datafile, can I restore just the datafile and > apply all the archive logs > from Monday forward? Are changes only applied to the > restored datafile? > > Randy Kirkpatrick > home: (303) 772-7467 > cell: (303) 885-2102 > __________________________________________________ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
