From oracle-l-bounce@freelists.org Tue Mar 23 14:41:23 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i2NKfNw16407 for ; Tue, 23 Mar 2004 14:41:23 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i2NKfLo16394 for ; Tue, 23 Mar 2004 14:41:21 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 66C9C393A44; Tue, 23 Mar 2004 15:10:01 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 18299-28; Tue, 23 Mar 2004 15:10:01 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 62173393B7D; Tue, 23 Mar 2004 14:52:33 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 23 Mar 2004 14:51:22 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 272BA393C31 for ; Tue, 23 Mar 2004 14:45:07 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 12431-75 for ; Tue, 23 Mar 2004 14:45:06 -0500 (EST) Received: from hero.affina.net (mailout.affina.com [12.20.72.25]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CC3B5390CA2 for ; Tue, 23 Mar 2004 14:28:26 -0500 (EST) Received: by hero.affina.net with Internet Mail Service (5.5.2653.19) id ; Tue, 23 Mar 2004 13:35:28 -0600 Message-ID: <4A82CFCF30FDD211A7960008C7B1917023696947@hero.affina.net> From: Chris Stephens To: "'oracle-l@freelists.org'" Subject: RE: recoving the temp tablespace Date: Tue, 23 Mar 2004 13:35:27 -0600 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C4110D.FE3B6950" X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 1584 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: ChrisStephens@affina.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org ------_=_NextPart_001_01C4110D.FE3B6950 Content-Type: text/plain CREATE TEMPORARY TABLESPACE "TEMP" TEMPFILE '/path/TEMP1.dbf' SIZE whatever EXTENT MANAGEMENT LOCAL UNIFORM SIZE whatever; -----Original Message----- From: Jeffrey Beckstrom [mailto:JBECKSTROM@gcrta.org] Sent: Tuesday, March 23, 2004 12:54 PM To: oracle-l@freelists.org; ORACLE-L@IC.SUNYSB.EDU; oracledba@lazydba.com; oracle-databases@yahoogroups.com; oracle-rdbms@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? ------_=_NextPart_001_01C4110D.FE3B6950 Content-Type: text/html Content-Transfer-Encoding: quoted-printable

CREATE =

&nbs= p; TEMPORARY TABLESPACE "TEMP" TEMPFILE '/path/TEMP1.dbf' SIZE = whatever

&nbs= p; EXTENT MANAGEMENT LOCAL UNIFORM SIZE whatever;

-----Original = Message-----
From: Jeffrey Beckstrom [mailto:JBECKSTROM@gcrta.org]
Sent: = Tuesday, March 23, 2004 12:54 = PM
To: = oracle-l@freelists.org; ORACLE-L@IC.SUNYSB.EDU; oracledba@lazydba.com; oracle-databases@yahoogroups.com; oracle-rdbms@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?

------_=_NextPart_001_01C4110D.FE3B6950-- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@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 -----------------------------------------------------------------