I have forgotten that step before when building a database from a standby. You get notified when they do not exist. Then, after building them , it all works fine. -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Ray Stell Sent: Wednesday, June 15, 2011 12:30 PM To: fmhabash Cc: oracle-l@xxxxxxxxxxxxx Subject: Re: physical standby and temp datafiles On Wed, Jun 15, 2011 at 01:00:10PM -0400, fmhabash wrote: > > - 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' No, I doubt that command would work, like I said, the standby "ha record" of the temp datafile, but the OS file does not exist: SQL> select name, bytes from v$tempfile; NAME BYTES ------------------------ ---------- /usr/database/db01/orada 0 ta/db/temp01.dbf I suppose this makes sense since rman does not back these up and the standby was build from that backup: SQL> host ls -l /usr/database/db01/oradata/db/temp01.dbf ls: /usr/database/db01/oradata/db/temp01.dbf: No such file or directory It seems like data guard should/could make these files during the role change. -- //www.freelists.org/webpage/oracle-l This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- //www.freelists.org/webpage/oracle-l