Home » RDBMS Server » Server Administration » UNDO segments needed recovery
UNDO segments needed recovery [message #234973] Thu, 03 May 2007 10:36 Go to next message
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 ?
Re: UNDO segments needed recovery [message #234977 is a reply to message #234973] Thu, 03 May 2007 10:43 Go to previous messageGo to next message
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.

Re: UNDO segments needed recovery [message #234981 is a reply to message #234973] Thu, 03 May 2007 10:57 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
Why UNDOTBS01 ?
why dont he drop UNDOTBS02 and recreate it
Re: UNDO segments needed recovery [message #234992 is a reply to message #234981] Thu, 03 May 2007 12:07 Go to previous messageGo to next message
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.
Re: UNDO segments needed recovery [message #234996 is a reply to message #234973] Thu, 03 May 2007 12:20 Go to previous messageGo to next message
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.
Re: UNDO segments needed recovery [message #234997 is a reply to message #234996] Thu, 03 May 2007 12:33 Go to previous messageGo to next message
harshad.gohil
Messages: 157
Registered: April 2007
Location: USA
Senior Member
Oracle RDBMS require to have one undo atleast. Undo tablespace is mandatory tablespace.
Re: UNDO segments needed recovery [message #234999 is a reply to message #234973] Thu, 03 May 2007 12:37 Go to previous message
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.
Previous Topic: estimate size of tablespace
Next Topic: Insert into MS Access using Oracle Heterogeneous Services inserts null into memo fields
Goto Forum:
  


Current Time: Fri Dec 09 11:50:35 CST 2016

Total time taken to generate the page: 0.13032 seconds