Home » RDBMS Server » Server Administration » loose my undo datafile (oracle 9i, , windows 2000 professional)
loose my undo datafile [message #344346] Fri, 29 August 2008 08:27 Go to next message
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
Re: loose my undo datafile [message #344411 is a reply to message #344346] Fri, 29 August 2008 13:44 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: loose my undo datafile [message #344549 is a reply to message #344411] Sat, 30 August 2008 08:17 Go to previous messageGo to next message
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.
Re: loose my undo datafile [message #344556 is a reply to message #344549] Sat, 30 August 2008 09:53 Go to previous message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
First, execute the FIRST step, don't start with the second or third one.

Regards
Michel
Previous Topic: Tablespace management
Next Topic: Changing Archive log destination
Goto Forum:
  


Current Time: Mon Dec 05 08:57:42 CST 2016

Total time taken to generate the page: 0.22820 seconds