Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: recovery issue...
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.orgReceived on Thu Nov 02 2006 - 11:22:17 CST