If you have a standby that has never been opened, you won't have REDO or TEMP. Those do get created as the database is being opened. From what I remember, the TEMP thing isn't just for standbys. If you shut down a "primary" database and delete the temp files, it will recreate them on the way back up, as well. On Wed, Jun 15, 2011 at 12:32 PM, Lange, Kevin G <kevin.lange@xxxxxxxxxx>wrote: > Yea, sorry. Ours are not using Rman. Clone the standby, rebuilt its > control file. Add the temp file using the ALTER TABLESPACE TEMP ADD > TEMPFILE '/u03/ora_data/fred/fred/temp01.dbf'; command. (the command > you get from the Backup Controlfile to Trace command. > > -----Original Message----- > From: Ray Stell [mailto:stellr@xxxxxxxxxx] > Sent: Wednesday, June 15, 2011 1:28 PM > To: Lange, Kevin G > Cc: oracle-l@xxxxxxxxxxxxx > Subject: Re: physical standby and temp datafiles > > On Wed, Jun 15, 2011 at 01:19:02PM -0500, Lange, Kevin G wrote: > > 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. > > > the question is how to go about "building" them. It sounds > like some here are buidling the standby in some way such that standby is > not "temp aware." Using rman, everything is in place except the OS > file. Someone made a private hint that this last step is completed by > data guard, it creates the file as needed. > I'm at the point of testing it. I'll be back. > > > > > > -----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 > > > > 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 > > >