Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: recoving the temp tablespace

Re: recoving the temp tablespace

From: Mladen Gogala <mladen_at_wangtrading.com>
Date: Tue, 23 Mar 2004 16:51:01 -0500
Message-ID: <20040323215101.GE3401@mladen.wangtrading.com>


And if you use the "AS" syntax, you can put it wherever you want. Looks like this:
ALTER DATABASE BACKUP CONTROLFILE TO TRACE AS '/tmp/control.sql';

You need 9i or higher for this candy.

On 03/23/2004 03:41:10 PM, Mary Bahrami wrote:
> Yup; if you backup the current controlfile to trace, you will see the create statement for your current temp tablespace at the end of the .trc file.
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Chris Stephens
> Sent: Tuesday, March 23, 2004 11:35 AM
> To: 'oracle-l_at_freelists.org'
> Subject: RE: recoving the temp tablespace
>
>
>
> CREATE
>
> TEMPORARY TABLESPACE "TEMP" TEMPFILE '/path/TEMP1.dbf' SIZE whatever
>
> EXTENT MANAGEMENT LOCAL UNIFORM SIZE whatever;
>
>
>
> -----Original Message-----
> From: Jeffrey Beckstrom [mailto:JBECKSTROM_at_gcrta.org]
> 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 - 16:55:12 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US