Home » RDBMS Server » Backup & Recovery » undo datafile lost. (Oracle 10.2.0.3)
undo datafile lost. [message #321525] Tue, 20 May 2008 10:27 Go to next message
vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad
Senior Member

Hello ,
Database version is oracle 10.2.0.3
Database is in noarchive log mode.. one of the datafiles of undotablespace is lost .. how do we start the database bypassing the missed file .. ?

Please advice,
-Sai.
Re: undo datafile lost. [message #321528 is a reply to message #321525] Tue, 20 May 2008 10:38 Go to previous messageGo to next message
Michel Cadot
Messages: 59748
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Recovering After the Loss of Datafiles

Regards
Michel
Re: undo datafile lost. [message #324014 is a reply to message #321525] Fri, 30 May 2008 04:58 Go to previous messageGo to next message
Rajabaskar Thangaraj
Messages: 13
Registered: March 2008
Location: CHENNAI
Junior Member
Steps:
1.Db in mount stage.
2.Alter database drop datafile 2 offline immediate;
3.alter database open;
4.Create new undo tablespace.


Best Regards

Raja Baskar.T
Re: undo datafile lost. [message #324016 is a reply to message #324014] Fri, 30 May 2008 05:01 Go to previous messageGo to next message
Michel Cadot
Messages: 59748
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I doubt this will work if you have active transactions in your undo file.

Regards
Michel
Re: undo datafile lost. [message #494407 is a reply to message #324016] Mon, 14 February 2011 05:59 Go to previous messageGo to next message
WillIm
Messages: 13
Registered: June 2008
Location: Kyrgyzstan, Bishkek
Junior Member
Michel Cadot wrote on Fri, 30 May 2008 16:01
I doubt this will work if you have active transactions in your undo file.

Regards
Michel


It will work, but be careful using it on production environment. Check this: http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:5669213349582

[Updated on: Mon, 14 February 2011 06:00]

Report message to a moderator

Re: undo datafile lost. [message #494411 is a reply to message #494407] Mon, 14 February 2011 07:00 Go to previous messageGo to next message
Michel Cadot
Messages: 59748
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This what I said, it can't work if "you have active transactions in your undo file".
In Tom example, the file was moved when the database was down and so there was no active transaction.

Regards
Michel
Re: undo datafile lost. [message #494421 is a reply to message #494411] Mon, 14 February 2011 09:32 Go to previous messageGo to next message
WillIm
Messages: 13
Registered: June 2008
Location: Kyrgyzstan, Bishkek
Junior Member
Agree, it depends on how database was shut down. According to author's description, he has his database been already shut down. What should he do in that way? He would need to bypass it anyway because his file is missed.
Re: undo datafile lost. [message #494425 is a reply to message #494421] Mon, 14 February 2011 10:16 Go to previous messageGo to next message
Michel Cadot
Messages: 59748
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
he has his database been already shut down

He didn't say if the file was lost before or after the shutdown, maybe this one is precisely due to the file lost.

Regards
Michel
Re: undo datafile lost. [message #496174 is a reply to message #494425] Fri, 25 February 2011 01:11 Go to previous message
zodiacsom
Messages: 37
Registered: December 2009
Location: pune
Member
not possible to do offline immediate as your database is in no-archive mode
Previous Topic: control file directory missing
Next Topic: RMAN hot backup script to disk
Goto Forum:
  


Current Time: Sat Nov 22 20:43:32 CST 2014

Total time taken to generate the page: 0.07868 seconds