RE: recoving the temp tablespace
- From: "Guang Mei" <gmei@xxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 23 Mar 2004 14:33:34 -0500
Maybe you could add
copy the temp tablespace's datafiles to the new server
before "start the database"?
Guang
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Jeffrey Beckstrom
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:
