RMAN recovery through missing datafile (but all archivelogs)

From: Michael Schmitt <mschmitt_at_uchicago.edu>
Date: Thu, 30 Jul 2009 16:42:08 -0500
Message-ID: <E37E556CF8A6C44381D2DA9FC354D241012D9EE6D66B_at_EVS03.ad.uchicago.edu>

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?


Received on Thu Jul 30 2009 - 16:42:08 CDT

Original text of this message