From oracle-l-bounce@freelists.org Tue Mar 23 14:42:36 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i2NKgZu16683 for ; Tue, 23 Mar 2004 14:42:35 -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 i2NKgZo16672 for ; Tue, 23 Mar 2004 14:42:35 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6F75B39201C; Tue, 23 Mar 2004 15:27:26 -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 21553-29; Tue, 23 Mar 2004 15:27:26 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5BE8A394E9C; Tue, 23 Mar 2004 15:17:40 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 23 Mar 2004 15:15:49 -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 A15B5394CC1 for ; Tue, 23 Mar 2004 15:03:34 -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 17543-06 for ; Tue, 23 Mar 2004 15:03:34 -0500 (EST) Received: from tera.umi.com (tera.umi.com [192.195.245.144]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 122E7390F58 for ; Tue, 23 Mar 2004 14:53:24 -0500 (EST) Received: from bosmail02.bos.il.pqe (bosmail02.bos.il.pqe [172.24.3.66]) by tera.umi.com (8.11.6/8.11.6) with ESMTP id i2NK0J908939 for ; Tue, 23 Mar 2004 15:00:19 -0500 Received: from bosmail00.bos.il.pqe ([172.24.3.64]) by bosmail02.bos.il.pqe with Microsoft SMTPSVC(5.0.2195.6713); Tue, 23 Mar 2004 15:00:21 -0500 X-MimeOLE: Produced By Microsoft Exchange V6.0.6249.0 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C41111.78B33C28" Subject: RE: recoving the temp tablespace Date: Tue, 23 Mar 2004 15:00:21 -0500 Message-ID: <4C9B6FDA0B06FE4DAF5918BBF0AD82CFECFC55@bosmail00.bos.il.pqe> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: recoving the temp tablespace Thread-Index: AcQRD0C7LiMz+0fQQSy5gwmdktkEugAAVwoA From: "Bobak, Mark" To: X-OriginalArrivalTime: 23 Mar 2004 20:00:21.0268 (UTC) FILETIME=[78D6DD40:01C41111] X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 1594 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Mark.Bobak@il.proquest.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org ------_=_NextPart_001_01C41111.78B33C28 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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. =20 -Mark -----Original Message----- From: Jeffrey Beckstrom [mailto:JBECKSTROM@gcrta.org] Sent: Tuesday, March 23, 2004 1: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=20 =20 - 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. =20 Question is in regards to the temp tablespace. Since it was not backed = up, how do we recreate it? =20 ------_=_NextPart_001_01C41111.78B33C28 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
All you need to do is 'alter = tablespace temp=20 add tempfile 'asasdsad';
for each tempfile.  In fact, = if you do=20 a 'alter database backup controlfile to trace;' right now, it will = contain the=20 exact commands you'll need to run.
 
-Mark
-----Original = Message-----
From: Jeffrey Beckstrom=20 [mailto:JBECKSTROM@gcrta.org]
Sent: Tuesday, March 23, 2004 = 1:54=20 PM
To: oracle-l@freelists.org; ORACLE-L@IC.SUNYSB.EDU;=20 oracledba@lazydba.com; oracle-databases@yahoogroups.com;=20 oracle-rdbms@yahoogroups.com
Subject: recoving the temp=20 tablespace

With 9i, we have implemented the temp tablespace.  This = tablespace=20 does not get backed up.  Shortly, we are going to move this = database to a=20 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=20 the shutdown.
 
Question is in regards to the temp tablespace.  Since it was = not=20 backed up, how do we recreate it?
 
------_=_NextPart_001_01C41111.78B33C28-- ---------------------------------------------------------------- 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 -----------------------------------------------------------------