OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » tempfile

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

tempfile [message #159893]

Wed, 22 February 2006 02:26

kinjal
Messages: 124
Registered: June 2001

Senior Member

Hello,

I do not have physical backup of tempfile. And if I need to restore old backup then will it work?
or do I need to drop and recreate tempfile again?

Kinjal

Report message to a moderator

Re: tempfile [message #160259 is a reply to message #159893]

Fri, 24 February 2006 02:17

Frank Naude
Messages: 4596
Registered: April 1998

Senior Member

You don't need to backup your tempfiles - you can create new tempfiles after restoring/recovering the DB.

Best is to do a test restore/recovery to ensure you understand the process. Don't wait for a disaster to strike!

Report message to a moderator

Re: tempfile [message #160385 is a reply to message #160259]

Fri, 24 February 2006 21:52

kinjal
Messages: 124
Registered: June 2001

Senior Member

Thanks for replying.
Actually I read that all *.dbf are required to be there. so I thought if tempfile is not there, there must be some error while opening the database.
Is there any error?

Kinjal

Report message to a moderator

Re: tempfile [message #160690 is a reply to message #159893]

Tue, 28 February 2006 01:42

alexzeng
Messages: 133
Registered: August 2005
Location: alexzeng.wordpress.com

Senior Member

No error will pop-up if you don't have tempfiles. If you run a sql with an order by clause or group by clause which need use temp tablespace, you will get a error immediately.

In my opinion, you'd better backup the tempfiles if it is not a burden for you.

Report message to a moderator

Re: tempfile [message #160691 is a reply to message #160690]

Tue, 28 February 2006 01:44

kinjal
Messages: 124
Registered: June 2001

Senior Member

Thanks a lot.

Report message to a moderator

Previous Topic:	Safemode: How to recover the data when desktop gets in safemode
Next Topic:	Views about lost datafiles

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Sep 27 11:29:15 CDT 2025