RE: recoving the temp tablespace

  • From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 23 Mar 2004 15:00:21 -0500

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@xxxxxxxxx]
Sent: Tuesday, March 23, 2004 1:54 PM
To: oracle-l@xxxxxxxxxxxxx; ORACLE-L@xxxxxxxxxxxxx; oracledba@xxxxxxxxxxx; 
oracle-databases@xxxxxxxxxxxxxxx; oracle-rdbms@xxxxxxxxxxxxxxx
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?
 

Other related posts: