OraFAQ Forum: Backup & Recovery » undo segment needs recovery

Home » RDBMS Server » Backup & Recovery » undo segment needs recovery (11g, Linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

undo segment needs recovery [message #454815]

Fri, 07 May 2010 11:32

rkl1
Messages: 97
Registered: June 2005

Member

Dear All:

The database crashed and when we restarted, we see constantly the error message in alert.log that SMON need to recover the undo segment. Querying the dba_rollback_segs also shows one of the undo segment needs recovery.

Now we created another undo Tablespace and set the new one as default. But no advantage. We take the old undo TS offline but some of our tables depend on it other wise we get the ORA-00376: file xx cannot be read at this time.

We put the _offline_rollback_segments=_SYSSMUXXX$ in parameter file and do most of stuffs since olf undo tablespace is online, but dba_rollback_segs still prints that recovery needed.

How we know which tables are still depend on the old Undo Tablespace so we could save those tables and then drop them to release the undo recover status.

Any help, advise, suggestion will be highly appreciated.

Report message to a moderator

Re: undo segment needs recovery [message #454827 is a reply to message #454815]

Fri, 07 May 2010 11:56

Michel Cadot
Messages: 68501
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Before using any hidden and unsupported parameter, did you just try to recover as Oracle asked you?

Regards
Michel

[Updated on: Fri, 07 May 2010 12:06]

Report message to a moderator

Re: undo segment needs recovery [message #454839 is a reply to message #454815]

Fri, 07 May 2010 12:36

rkl1
Messages: 97
Registered: June 2005

Member

Yes We did using the RMAN tablespace recovery. There were no error message on the recovery and completed fine. But DBA_Rollback_Segs still indicate the segment recovery.

Thanks.

Report message to a moderator

Re: undo segment needs recovery [message #454842 is a reply to message #454839]

Fri, 07 May 2010 12:54

Michel Cadot
Messages: 68501
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

As you posted no information of what you did the only thing I can say is that if Oracle says something needs recovery then you didn't recover it.

Regards
Michel

Report message to a moderator

Previous Topic:	Restore DB for Service Desk application
Next Topic:	Restore backup to Fresh Database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Sep 24 04:42:02 CDT 2023