Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: recovery issue...

Re: recovery issue...

From: Volker Hetzer <firstname.lastname_at_ieee.org>
Date: Thu, 02 Nov 2006 21:32:00 +0100
Message-ID: <eidkkc$o61$1@nntp.fujitsu-siemens.com>


DA Morgan schrieb:

> Volker Hetzer wrote:

>> Hi!
>> (10.2.0.1, Linux RH ES 4)
>> We've got a tablespace with some logging and some nologging tables.
>> Now we've got some corruption and I took the tablespace offline for
>> recovery.
>> Turned out, the corruption was in the nologging part, recovery failed
>> and whenever I try to do put the tablespace online I get a message
>> that it needs recovery.
>> I'm perfectly happy with losing the nologging tables but how do I
>> achieve that?
>> I've got incremental backups until monday and archivelogs until today.
>> I've opened a SR but so far oracle hasn't responded.
>>
>> Any ideas?
>>
>> Lots of Greetings and thanks!
>> Volker

>
> Any chance you have flashback logs?
I have that flashback stuff switched on, I'll tell support about it. Thanks for the hint!

Btw, oracle is on the ball with this.

Lots of Greetings!
Volker

-- 
For email replies, please substitute the obvious.
Received on Thu Nov 02 2006 - 14:32:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US