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

From: Martin Berger <martin.a.berger@xxxxxxxxx>
To: usn@xxxxxxxxx
Date: Thu, 6 Aug 2009 21:10:26 +0200

Martin,

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 furtherinfos right now (but I guess, it would be worth palying around alittle 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 Imiss

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, butsomeday

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

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

References:
- Academic question: How to recover through a gap of archived redol ogs with data loss?
  - From: Martin Klier

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

Other related posts: