Re: temp datafiles not on restore tapes
- From: "Ron Rogers" <RROGERS@xxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>, <cemail_219@xxxxxxxxxxx>
- Date: Fri, 06 Jan 2006 10:20:15 -0500
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" <cemail_219@xxxxxxxxxxx> 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
--
//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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
