RE: recoving the temp tablespace

From: Freeman, Donald <dofreeman_at_state.pa.us>
Date: Tue, 23 Mar 2004 16:19:50 -0500
Message-ID: <AFF54B073FF15849B53E32E67EE860763A9334@ENHBGPRI11.PA.LCL>

Your database is going to be looking for the 'old' temp file. Create a new, different one. Drop the old one, recreate the old one, drop the new one. Is that too many 'olds' and 'news?' :-)

CREATE TEMPORARY TABLESPACE TEMP1
TEMPFILE 'F:\ORACLE\ORADATA\NEDSSARP\TEMP99.DBF' SIZE 2097152K AUTOEXTEND OFF EXTENT MANAGEMENT LOCAL UNIFORM SIZE 4096K SEGMENT SPACE MANAGEMENT MANUAL
/
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP1 /

DROP TABLESPACE TEMP INCLUDING CONTENTS AND DATAFILES /

CREATE TEMPORARY TABLESPACE TEMP
TEMPFILE 'F:\ORACLE\ORADATA\NEDSSARP\TEMP01.DBF' SIZE 2097152K AUTOEXTEND OFF EXTENT MANAGEMENT LOCAL UNIFORM SIZE 4096K SEGMENT SPACE MANAGEMENT MANUAL
/
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP /
DROP TABLESPACE TEMP1 INCLUDING CONTENTS AND DATAFILES /

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Jeffrey Beckstrom Sent: Tuesday, March 23, 2004 12:54 PM
To: oracle-l_at_freelists.org; ORACLE-L_at_IC.SUNYSB.EDU; oracledba_at_lazydba.com; oracle-databases_at_yahoogroups.com; oracle-rdbms_at_yahoogroups.com Subject: recoving the temp tablespace

With 9i, we have implemented the temp tablespace. This tablespace does not get backed up. Shortly, we are going to move this database to a new server. We will

backup the database (hot backup)
shutdown the database
restore it to the new server.
copy the control file to the new server
copy the log files to the new server
start the database
do recovery so that it will apply the log files since the backup until the shutdown.

Question is in regards to the temp tablespace. Since it was not backed up, how do we recreate it?

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Tue Mar 23 2004 - 17:07:37 CST