short answer: no gotchas, it will work for you longer answer: yes, because that's the way recovery is designed to work. In the header of every datafile is an SCN. If that SCN matches the one n the controlfile, the datafile is presumed to be up-to-date and no recovery is done on it.
--- 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: Rachel Carmichael 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).
