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

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-l