Sean, If they are not being backed up, you won't be able to open the database with them in it if you have to recover. You would have to mount the database, alter the datafiles offline drop (this tells Oracle you don't care what was in them anyway, so ignore errors on them) and then after finishing the recovery and opening the database, you'd have to drop the tablespaces.
Now, if there WERE updates to data in those datafiles, the updates would be lost (and the offline during recovery would let recovery go through). If updates to that data were done in the same transaction as updates to data in tables that WERE backed up, the update to the backed up data would be effectively rolled back. You might want to turn on auditing for update/delete on those tables for a short time, to confirm that nothing is being changed. If you trap changes, you can then go to them with proof and tell them to reconsider what the backup policy is. Rachel --- "O'Neill, Sean" <[EMAIL PROTECTED]> wrote: > We perform disk-to-disk offline backups on a nighlty basis. Database > is > running in archived log mode. Due to space contraints (don't ask > =:-[ ) we > are currently forced to backup only some of the data files. The data > files > excluded belong to specific schema owners and are not being updated, > or so > I'm informed =:-0. I'm trying to get my head around what the > recovery > implications are if some of the data files not backed up have being > updated > and a recovery is required?. I expect it depends on what the > recovery > scenario is. So whats worst case scenario and what would my options, > if any > be?. > > > Oracle 7.3.3, 8.0.5, 8.1.7 > NT4, W2K > ------------------------- > Seán O' Neill > Organon (Ireland) Ltd. > [subscribed: digest mode] > > > > -------------------------------------------------------------------- > This message, including attached files, may contain confidential > information and is intended only for the use by the individual > and/or the entity to which it is addressed. Any unauthorized use, > dissemination of, or copying of the information contained herein is > not allowed and may lead to irreparable harm and damage for which > you may be held liable. If you receive this message in error or if > it is intended for someone else please notify the sender by > returning this e-mail immediately and delete the message. > -------------------------------------------------------------------- > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: O'Neill, Sean > 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). __________________________________________________ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- 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).
