OraFAQ Forum: Server Administration » loose my undo datafile

Home » RDBMS Server » Server Administration » loose my undo datafile (oracle 9i, , windows 2000 professional)

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

loose my undo datafile [message #344346]

Fri, 29 August 2008 08:27

Vivek.k.thakur
Messages: 30
Registered: December 2007
Location: DELHI, INDIA

Member

Hi experts,
I loose my undo datafile, while I hutdown the database. Please suggest wt I do ,. Urgent requirement.

Thanks
Vivek Kumar

Report message to a moderator

Re: loose my undo datafile [message #344411 is a reply to message #344346]

Fri, 29 August 2008 13:44

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Create a new undo tablespace:
- Comment undo_tablespace from init.ora (possibly created from spfile if you use it)
- Startup
- Create a new undo tablespace
- Set this new undo tablespace in undo_tablespace parameter
- Restart

Regards
Michel

Report message to a moderator

Re: loose my undo datafile [message #344549 is a reply to message #344411]

Sat, 30 August 2008 08:17

Vivek.k.thakur
Messages: 30
Registered: December 2007
Location: DELHI, INDIA

Member

Dear michel
Database is at mount stage HOW can I create undo tablespace at mount stage? database is not getting open.

Report message to a moderator

Re: loose my undo datafile [message #344556 is a reply to message #344549]

Sat, 30 August 2008 09:53

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

First, execute the FIRST step, don't start with the second or third one.

Regards
Michel

Report message to a moderator

Previous Topic:	Tablespace management
Next Topic:	Changing Archive log destination

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 19:43:19 CST 2024