RE: Backup and Recovery

From: Kimberly Smith <ksmith2_at_myfirstlink.net>
Date: Mon, 04 Feb 2002 06:46:02 -0800
Message-ID: <F001.00404BCC.20020204064030@fatcity.com>

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 <randywk_at_usa.net> 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: deepakthapliyal_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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kimberly Smith
  INET: ksmith2_at_myfirstlink.net

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 Mon Feb 04 2002 - 08:46:02 CST