From oracle-l-bounce@freelists.org Tue Mar 23 13:11:12 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i2NJB8o24837 for ; Tue, 23 Mar 2004 13:11:08 -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 i2NJB7o24828 for ; Tue, 23 Mar 2004 13:11:07 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 41425390856; Tue, 23 Mar 2004 14:05:41 -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 06277-55; Tue, 23 Mar 2004 14:05:41 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A509239384B; Tue, 23 Mar 2004 14:04:09 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 23 Mar 2004 14:02:34 -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 6D13F391464 for ; Tue, 23 Mar 2004 13:55:58 -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 04032-34 for ; Tue, 23 Mar 2004 13:55:58 -0500 (EST) Received: from gcrta.org (clevelandrta.org [209.49.247.27]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 49361391316 for ; Tue, 23 Mar 2004 13:47:09 -0500 (EST) Received: from GWIA_DOM-MTA by gcrta.org with Novell_GroupWise; Tue, 23 Mar 2004 13:54:04 -0500 Message-Id: X-Mailer: Novell GroupWise Internet Agent 6.5.0 Date: Tue, 23 Mar 2004 13:53:41 -0500 From: "Jeffrey Beckstrom" To: , , , , Subject: recoving the temp tablespace Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="=_13323EDC.66076BA2" X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 1575 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: JBECKSTROM@gcrta.org Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org --=_13323EDC.66076BA2 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit 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? --=_13323EDC.66076BA2 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit Content-Description: HTML

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?

--=_13323EDC.66076BA2-- ---------------------------------------------------------------- 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 -----------------------------------------------------------------