Home » Server Options » Data Guard » Temporary files
icon5.gif  Temporary files [message #237020] Fri, 11 May 2007 11:25 Go to next message
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
Re: Temporary files [message #237065 is a reply to message #237020] Fri, 11 May 2007 15:03 Go to previous messageGo to next message
Frank Naude
Messages: 4579
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.
Re: Temporary files [message #237458 is a reply to message #237065] Mon, 14 May 2007 09:53 Go to previous message
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.

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


Current Time: Thu Mar 28 06:24:02 CDT 2024