OraFAQ Forum: Backup & Recovery » undo datafile lost.

Home » RDBMS Server » Backup & Recovery » undo datafile lost. (Oracle 10.2.0.3)

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

undo datafile lost. [message #321525]

Tue, 20 May 2008 10:27

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.

Report message to a moderator

Re: undo datafile lost. [message #321528 is a reply to message #321525]

Tue, 20 May 2008 10:38

Michel Cadot
Messages: 68637
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Recovering After the Loss of Datafiles

Regards
Michel

Report message to a moderator

Re: undo datafile lost. [message #324014 is a reply to message #321525]

Fri, 30 May 2008 04:58

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

Report message to a moderator

Re: undo datafile lost. [message #324016 is a reply to message #324014]

Fri, 30 May 2008 05:01

Michel Cadot
Messages: 68637
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

Report message to a moderator

Re: undo datafile lost. [message #494407 is a reply to message #324016]

Mon, 14 February 2011 05:59

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

Michel Cadot
Messages: 68637
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

Report message to a moderator

Re: undo datafile lost. [message #494421 is a reply to message #494411]

Mon, 14 February 2011 09:32

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.

Report message to a moderator