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: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 02 Nov 2006 09:22:17 -0800
Message-ID: <1162488135.537649@bubbleator.drizzle.com>


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?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Thu Nov 02 2006 - 11:22:17 CST

Original text of this message

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