Re: recovery issue...

From: Volker Hetzer <firstname.lastname_at_ieee.org>
Date: Thu, 02 Nov 2006 16:50:28 +0100
Message-ID: <eid43h$ugt$1@nntp.fujitsu-siemens.com>

Volker Hetzer schrieb:
> 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.
Ok, I got to talk to support.
They say the backups are indeed corrupt and it has nothing to do with nologging operations.
What I see from the rman messages is that the monday backup was just fine, the tuesday backup failed because of a corrupt block in the users tablespace and the archivelogs on tuesday are corrupt. Great.

How can such a thing happen?

Lots of Greetings!
Volker

-- 
For email replies, please substitute the obvious.

Received on Thu Nov 02 2006 - 09:50:28 CST