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" <Sean.ONeill_at_organon.ie> 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: Sean.ONeill_at_organon.ie
>
> 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: ListGuru_at_fatcity.com (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: wisernet100_at_yahoo.com
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: ListGuru_at_fatcity.com (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).
Received on Fri Jan 11 2002 - 08:21:54 CST
