RMAN recovery behavior for a single datafile...

> You can recover just one or a set of datafiles with RMAN.

That's what I did just yesterday only I used the recover tablespace syntax. What Lisa is saying is that if you only need to recover one datafile all you have to do is use the recover database syntax and RMAN will "automagically" figure out which datafiles are OK and just recover the datafiles that are missing or need repair. I did a test of this a couple of years ago and the recover database syntax took much longer so I assumed it was replacing perfectly good datafiles with copies on tape and applying the logs.

This is an issue because if RMAN does the "automagic" thing then you can recover without thinking about mean time to recovery. If RMAN isn't so automagic then you still need to determine what needs recovery in advance and come up with the syntax to recover only the necessary datafile(s).

-----Original Message-----
Sent: Thursday, April 04, 2002 9:36 AM
To: Multiple recipients of list ORACLE-L

You can recover just one or a set of datafiles with RMAN. I've had to do that for a recovery before. It will recover just the datafiles you need plus the necessary archive logs.

Jim

"Koivu, Lisa" <lisa.koivu_at_efairfield.com> wrote:

>No, not from what I saw.  I may be wrong, though.
>
>Lisa
>
>> -----Original Message-----
>> From: Orr, Steve [SMTP:sorr_at_rightnow.com]
>> Sent: Thursday, April 04, 2002 10:24 AM
>> To:   Multiple recipients of list ORACLE-L
>> Subject:  RE: Deleting old archive log files.
>>
>> > the most portable and sanest route is to use RMAN
>> Agreed.  Go RMAN... Gorman... Hmmm...  :-)
>>
>> > Being able to issue only two commands (i.e. "RESTORE DATABASE" and
>> "RECOVER
>> > DATABASE") over dialup from home after being roused at 2:30am and
having
>> > RMAN do all the thinking for you is sublime.  
>> If you do a RESTORE/RECOVER DATABASE doesn't RMAN retrieve and restore
ALL
>> datafiles from tape? Wouldn't this unnecessarily increase the mean time
to
>> recovery if you just need to recover one datafile?
>>
>>
>> Orrman for RMAN,
>> Steve Orr
>> Bozeman, MT

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Orr, Steve
  INET: sorr_at_rightnow.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).