OraFAQ Forum: Data Guard » Temporary files

Home » Server Options » Data Guard » Temporary files

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

Temporary files [message #237020]

Fri, 11 May 2007 11:25

mlgoins
Messages: 116
Registered: March 2007
Location: Denver, CO

Senior Member

I found parameters to redirect the Database, Log, and Control Files (so that when a Physical Standby Database is on the same server as the Primary Database the files don't try to overwrite each other). What about Temporary Files? As far as I know, there isn't a way to redirect them with parameters.

select name from v$tempfile; # shows you where the tempfiles are

Mike

Report message to a moderator

Re: Temporary files [message #237065 is a reply to message #237020]

Fri, 11 May 2007 15:03

Frank Naude
Messages: 4596
Registered: April 1998

Senior Member

There is no need for such a parameter. Tempfiles will not be required until after you open the standby database.

Report message to a moderator

Re: Temporary files [message #237458 is a reply to message #237065]

Mon, 14 May 2007 09:53

mlgoins
Messages: 116
Registered: March 2007
Location: Denver, CO

Senior Member

Thanks for the reply! I found (in the documentation) where I create a temporary file for the Standby Database to use in read-only mode. It worked great, even in the same directory as the production temporary files.

Report message to a moderator

Previous Topic:	Standby DB as Read-Only
Next Topic:	Asking primary what last arc applied was...in 8i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Oct 01 08:43:26 CDT 2025