Re: RMAN recovery through missing datafile (but all archivelogs)

From: Roger Xu <wellmetus_at_gmail.com>
Date: Thu, 30 Jul 2009 16:47:58 -0500
Message-ID: <eb64345d0907301447o6de143a0t32079c8fd8344dd4_at_mail.gmail.com>

10g can recover datafiles not backed up but it requires all archived redo to be available since the datafile was created ...

On Thu, Jul 30, 2009 at 4:42 PM, Michael Schmitt <mschmitt_at_uchicago.edu>wrote:

>
>
> Hi All,
>
>
>
> We have a situation where we are trying to a point in time restore a PRD
> database to the test system. Unfortunately the only RMAN full backup we
> have prior to the point in time does not include a datafile that was added
> to the PRD database. For example
>
>
>
> FULL RMAN backup------------(datafile added to DB)------------- Restore to
> this point-------- Most recent restore
>
>
>
> The PRD database is in archivelog mode and we have all of the archivelogs,
> so I am guessing there should be a way to still restore this system to TST
>
>
>
> Does the list have any insight on how best to do this?
>
>
>
> Thanks
>

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jul 30 2009 - 16:47:58 CDT