Re: Academic question: How to recover through a gap of archived redol ogs with data loss?

From: Martin Klier <>
Date: Thu, 06 Aug 2009 18:32:44 +0200
Message-ID: <>

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?


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

Received on Thu Aug 06 2009 - 11:32:44 CDT

Original text of this message