RE: physical standby and temp datafiles

From: Jorgensen, Finn <>
Date: Wed, 15 Jun 2011 13:13:10 -0400
Message-ID: <9CE162BC5ED2C643956B526A7EDE46FF02693F38DDDE_at_EXM-OMF-04.Ceg.Corp.Net>

Yep. Start the database in read only mode and add the tempfile.


-----Original Message-----
From: [] On Behalf Of fmhabash Sent: Wednesday, June 15, 2011 1:00 PM
Subject: Re: physical standby and temp datafiles

  • every file in v$tempfile must physically exist on disk
  • If they are not, add them ... ALTER TABLESPACE TEMP ADD TEMPFILE '/u03/ora_data/fred/fred/temp01.dbf'

>>> This e-mail and any attachments are confidential, may contain legal,
professional or other privileged information, and are intended solely for the addressee. If you are not the intended recipient, do not use the information in this e-mail in any way, delete this e-mail and notify the sender. CEG-IP2 --
Received on Wed Jun 15 2011 - 12:13:10 CDT

Original text of this message