From oracle-l-bounce@freelists.org Fri Apr 22 17:44:19 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j3MMiJaK014336 for ; Fri, 22 Apr 2005 17:44:19 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j3MMiJ4Z014332 for ; Fri, 22 Apr 2005 17:44:19 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C0F681862AD; Fri, 22 Apr 2005 16:41:57 -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 29529-08; Fri, 22 Apr 2005 16:41:57 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 22DC8186256; Fri, 22 Apr 2005 16:41:57 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=ETycE+huCK3lJcq6zF1eQe3u5HwKG6RTPA/MSv+TmGaxa/4UhAhw2WCdhExoKd7thITjO4YVk7plPEsKoU05EaxExu1wH2h99mYVPpICOM7bScblnKSdSyHHtOaZ2G5GmvXTroYA1WPJFSyeslUITmlQNbYg8bQFYdTyAik4ftY= Message-ID: <6d45e2105042214406eddb829@mail.gmail.com> Date: Fri, 22 Apr 2005 14:40:09 -0700 From: Stephen Andert To: oracle-l@freelists.org Subject: RAC & RAW Question In-Reply-To: <42695CD9.6020801@centrexcc.com> Mime-Version: 1.0 Content-type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit Content-Disposition: inline References: <42695CD9.6020801@centrexcc.com> X-archive-position: 18888 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: andert@gmail.com Precedence: normal Reply-To: andert@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=0.0 required=5.0 tests=none autolearn=ham version=2.63 Hi all,=20 I am working on getting RAC set up. It is sr mgmt's idea and I'm not sure that it will provide what they think it will. I have a question about growing with RAW. I read in a book that RAW partitions cannot be extended. After discussing this with my friendly neighborhood SysAdmin team, they have told me that growing a RAW partition/device is not a problem. They don't even think I need to bring down the database. My questions are: Q1. Is it possible that the author was speaking in general terms and that in my environment, we have an OS, etc that allows this (AIX, EMC)? Q2. Is it that the OS can do it, but the database cannot recognize it? (I thought a alter database datafile ... RESIZE would work) Q3. Can anyone point me towards a best practices with RAW white paper? Q4. Does anyone have any pointers towards converting a cooked database to RAW? It is large enough that export/import will take more time that I think we will get approved for. We are theorizing that if we "reshape" the database to tablespaces with single files that match the sizes of the RAW devices we will be getting, that an RMAN alternate node restore with file rename will work. Thoughts or comments on this? Thanks Stephen -- http://www.freelists.org/webpage/oracle-l