recovery issue...

From: Volker Hetzer <firstname.lastname_at_ieee.org>
Date: Thu, 02 Nov 2006 15:11:55 +0100
Message-ID: <eicub6$a55$1@nntp.fujitsu-siemens.com>

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

-- 
For email replies, please substitute the obvious.

Received on Thu Nov 02 2006 - 08:11:55 CST