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

just an untested idea (or in fact 2 of them): maybe it's possible to increase the SCN by methods like 10015 trace name adjust_scn
or
_minimum_giga_scn

I have never played with both of them, so I cannot give any further infos right now (but I guess, it would be worth palying around a little bit)

hth
  Martin

Am 06.08.2009 um 18:24 schrieb Martin Klier:

> Hi list,
>
> I know it's unsecure, unsupported and ugly. But given this situation:
>
> I need a recovery of a tablespace, all archivelogs are there, bu I
> miss
> one from last night. I want to do a "complete" recovery.
>
> The log that's missing is out of a low activity period, and I am ready
> to acceppt slight data corruption, and I will set up the DB as a new
> afterwards, but I need the data from this morning.
>
> What can one desperate DBA do?
>
> To make it clear: I don't have this situation at the moment, but
> someday
> this may change, and I would prefer to test this stress situation in
> peacetime (now).
>
> Any hints, advice, procedures?
>
> Thanks a lot
> Martin Klier
> --
> Usn's IT Blog for Linux, Oracle, Asterisk
> http://www.usn-it.de
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>

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




application/pkcs7-signature attachment: smime.p7s