RE: recoving the temp tablespace

From: Freeman, Donald <dofreeman_at_state.pa.us>
Date: Wed, 24 Mar 2004 09:35:23 -0500
Message-ID: <AFF54B073FF15849B53E32E67EE860763A9337@ENHBGPRI11.PA.LCL>

I'm looking at my trace file and it does add a datafile to the temp tablespace. But, it has a new filename. Is the old file still registered in the data dictionary? Do I have to remove it?

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Bobak, Mark Sent: Tuesday, March 23, 2004 3:00 PM
To: oracle-l_at_freelists.org
Subject: RE: recoving the temp tablespace

All you need to do is 'alter tablespace temp add tempfile 'asasdsad'; for each tempfile. In fact, if you do a 'alter database backup controlfile to trace;' right now, it will contain the exact commands you'll need to run.

-Mark

-----Original Message-----

From: Jeffrey Beckstrom [mailto:JBECKSTROM_at_gcrta.org] Sent: Tuesday, March 23, 2004 1: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 Wed Mar 24 2004 - 08:33:41 CST