OraFAQ Forum: Server Administration » UNDO segments needed recovery

Home » RDBMS Server » Server Administration » UNDO segments needed recovery

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

UNDO segments needed recovery [message #234973]

Thu, 03 May 2007 10:36

gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen

Senior Member

Reffering to following link .

http://www.my-whiteboard.com/oracle-dba/how-to-drop-and-recreate-oracle-undo-tablespace-and-its-data-files.html

Exact scenario happend to me for my test database and recreated the undo tablespace as mentioned in the link.

Can someone please tell me why Step10 to Step14 are required?Why to create a additionaly undo tablespace ?

Report message to a moderator

Re: UNDO segments needed recovery [message #234977 is a reply to message #234973]

Thu, 03 May 2007 10:43

harshad.gohil
Messages: 157
Registered: April 2007
Location: USA

Senior Member

That's because his database was running previosly on UNDOTBS02 and now after creationg of undo tablespace he wants to make again from UNDOTBS01 to UNDOTBS02.

Report message to a moderator

Re: UNDO segments needed recovery [message #234981 is a reply to message #234973]

Thu, 03 May 2007 10:57

gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen

Senior Member

Why UNDOTBS01 ?
why dont he drop UNDOTBS02 and recreate it

Report message to a moderator

Re: UNDO segments needed recovery [message #234992 is a reply to message #234981]

Thu, 03 May 2007 12:07

harshad.gohil
Messages: 157
Registered: April 2007
Location: USA

Senior Member

One UNDO should be there and they have only one and that is also corrupted, that's why.

Report message to a moderator

Re: UNDO segments needed recovery [message #234996 is a reply to message #234973]

Thu, 03 May 2007 12:20

gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen

Senior Member

>>One UNDO should be there
Why that is required when we are in RESTRICTED mode.

Report message to a moderator

Re: UNDO segments needed recovery [message #234997 is a reply to message #234996]

Thu, 03 May 2007 12:33

harshad.gohil
Messages: 157
Registered: April 2007
Location: USA

Senior Member

Oracle RDBMS require to have one undo atleast. Undo tablespace is mandatory tablespace.

Report message to a moderator

Re: UNDO segments needed recovery [message #234999 is a reply to message #234973]

Thu, 03 May 2007 12:37

gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen

Senior Member

Thts true!
for a time being , can we keep it as SYSTEM and create our required tablespace (UNDOTBS02) .wht role UNDOTBS01 has to play here.
its just a matter of 5 mins and we are in RESTRICTED mode.

Report message to a moderator

Previous Topic:	estimate size of tablespace
Next Topic:	Insert into MS Access using Oracle Heterogeneous Services inserts null into memo fields

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Feb 04 05:54:41 CST 2025