Sean,
First of all, datafiles actually belong to a
tablespace - not a schema.
- You could place the tablespace into read-only
mode, take a backup of the tablespaces datafile(s),
then no additional backups are required for those
datafile(s) (and you are assured that no one updates
the data).
- In general, to recover from media failure, you
would have to restore the datafile from some backup,
and apply all the archived redo logs since the backup.
HTH
Rob Pegram
Oracle DBA
- "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: Robert Pegram
INET: pegramrg_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 Thu Jan 10 2002 - 09:14:10 CST
