Re: temp datafiles not on restore tapes

From: Ron Rogers <RROGERS_at_galottery.org>
Date: 2006-01-06 19:36:34
Message-id: 20060106183634.GI16857@iris.uqtr.ca

J,
On the source database...backup the controlfile to trace. If you look at the controlfile created in the dump destination that was created with the \ "ALTER DATABASE BACKUP CONTROLFILE TO TRACE;" command you will see that the TEMP files \ are created independant of the other datafiles.

Commands to add tempfiles to temporary tablespaces.
Online tempfiles have complete space information.
Other tempfiles may require adjustment. ALTER TABLESPACE TEMP ADD TEMPFILE '/u01/datafiles/temp01.dbf' SIZE 883949568 REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M;
End of tempfile additions.

Ron

>>> "J. Dex" 01/06/06 10:06 AM >>>

I am trying to stand up a database from a tape restore and rename it. The restore did not include any of the temp datafiles but I think I know what the temp tablespace had been called. How should this be addressed? In the create controlfile script, should I have an alter tablespace petemp add datafile.... or will I have to create a new temp tablespace? Can the temp tablespace be created after the database is opened?

Is your PC infected? Get a FREE online computer virus scan from McAfee® Security. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963

--
http://www.freelists.org/webpage/oracle-l 




The information transmitted is intended solely for the individual or entity to which it is \ 
addressed and may contain confidential and/or privileged material. Any review, \ 
retransmission, dissemination or other use of or taking action in reliance upon this \ 
information by persons or entities other than the intended recipient is prohibited. If you \ 
have received this email in error please contact the sender and delete the material from \ 
any computer.

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l

Received on Fri Jan 06 2006 - 19:36:34 CST