Re: Academic question: How to recover through a gap of archived redol ogs with data loss?
From: Martin Klier <usn_at_usn-it.de>
Date: Thu, 06 Aug 2009 18:32:44 +0200
Message-ID: <4A7B05AC.8070900_at_usn-it.de>
Hi Harel,
Date: Thu, 06 Aug 2009 18:32:44 +0200
Message-ID: <4A7B05AC.8070900_at_usn-it.de>
Hi Harel,
thanks for this approach - deleting constraints and other consistency enforcement may help, I guess. :)
Is there another way to do it outside SQL, on block level like RMAN?
Thanks
Martin
Harel Safra schrieb:
> 1. Do a tablespace point in time recovery using all the archives
> starting from the backup till the last continuous one that you have.
>
> 2. Use logminer to mine the relevant data from the archives after the
> gap. Pray that there aren't too many data consistency issues.
-- Usn's IT Blog for Linux, Oracle, Asterisk http://www.usn-it.de -- http://www.freelists.org/webpage/oracle-lReceived on Thu Aug 06 2009 - 11:32:44 CDT