Return-Path: <oracle-l-bounce@freelists.org>
Delivered-To: 2-oracle-l@orafaq.com
Received: (qmail 28425 invoked from network); 17 Dec 2007 08:33:50 -0600
Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180)
  by static-ip-69-64-49-119.inaddr.intergenia.de with SMTP; 17 Dec 2007 08:33:50 -0600
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1E77F7DA043;
 Mon, 17 Dec 2007 09:33:50 -0500 (EST)
Received: from turing.freelists.org ([127.0.0.1])
 by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id 11519-10; Mon, 17 Dec 2007 09:33:50 -0500 (EST)
Received: from turing (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E34097DA159;
 Mon, 17 Dec 2007 09:33:48 -0500 (EST)
Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 17 Dec 2007 08:46:24 -0500 (EST)
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D09107D926D
 for <oracle-l@freelists.org>; Mon, 17 Dec 2007 08:46:23 -0500 (EST)
Received: from turing.freelists.org ([127.0.0.1])
 by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id 02610-09 for <oracle-l@freelists.org>;
 Mon, 17 Dec 2007 08:46:23 -0500 (EST)
Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.180])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A57C97D9221
 for <oracle-l@freelists.org>; Mon, 17 Dec 2007 08:46:23 -0500 (EST)
Received: by py-out-1112.google.com with SMTP id u77so3773246pyb.3
        for <oracle-l@freelists.org>; Mon, 17 Dec 2007 05:46:23 -0800 (PST)
Received: by 10.65.242.7 with SMTP id u7mr14886430qbr.34.1197899181495;
        Mon, 17 Dec 2007 05:46:21 -0800 (PST)
Received: by 10.64.112.6 with HTTP; Mon, 17 Dec 2007 05:46:21 -0800 (PST)
Message-ID: <611ad3510712170546g11e4003cxb54f400ba7a6c9d8@mail.gmail.com>
Date: Mon, 17 Dec 2007 07:46:21 -0600
From: "Jeremy Schneider" <jeremy.schneider@ardentperf.com>
To: "Alex Gorbachev" <ag@oracloid.com>
Subject: Re: superblock backups, ASM vs OCFS2
Cc: Oracle-L <oracle-l@freelists.org>
In-Reply-To: <c2213f680712160653t50926d67wfe637be46538c8a1@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Disposition: inline
References: <611ad3510712130850j4575aea3k4d43481b27699908@mail.gmail.com>
	 <c2213f680712160653t50926d67wfe637be46538c8a1@mail.gmail.com>
X-archive-position: 3968
X-ecartis-version: Ecartis v1.0.0
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
X-original-sender: jeremy.schneider@ardentperf.com
Precedence: normal
Reply-to: jeremy.schneider@ardentperf.com
List-help: <mailto:ecartis@freelists.org?Subject=help>
List-unsubscribe: <oracle-l-request@freelists.org?Subject=unsubscribe>
List-software: Ecartis version 1.0.0
List-Id: oracle-l <oracle-l.freelists.org>
X-List-ID: oracle-l <oracle-l.freelists.org>
List-subscribe: <oracle-l-request@freelists.org?Subject=subscribe>
List-owner: <mailto:steve.adams@ixora.com.au>
List-post: <mailto:oracle-l@freelists.org>
List-archive: <http://www.freelists.org/archives/oracle-l>
X-list: oracle-l
X-Virus-Scanned: Debian amavisd-new at localhost.localdomain

I totally agree about always using partitions in Linux.

However in this particular case the ASMLIB labels were created on top
of entire disks - and I don't think that ASMLIB never issued any
warnings about not using partitions.  (I don't remember ever seeing
any warnings - is this a new feature in 11g?)  FYI, this was a rushed
setup of a test environment for some basic load testing...  I always
create partitions for production setups and somehow this particular
case was the exception.  (I don't remember; they may have had ASM
setup for this machine before I arrived onsite.  The entire setup and
load testing of five different platforms was done in 4 days, according
to their requirements.)

An SA apparently went in later and created partition tables and LVM
labels on the partitions.  I'm pretty sure that partition tables are
written at the *end* of the first block - which is why the ASMLIB
labels were fine (at the top of the block).  And the LVM labels were
in the partition - corrupting the ASM disk headers but leaving the
ASMLIB labels untouched again.

It was actually a pretty tricky situation to figure out at first -
they called back several months after I'd come onsite to do the
testing and wanted help figuring out why they couldn't mount the ASM
disks.  And I assumed that I'd made the partitions at first and
couldn't figure out why the ASM disk headers didn't point to the
partitions.  Took a little detective work.  :)

Jeremy


On 12/16/07, Alex Gorbachev <ag@oracloid.com> wrote:
> Jeremy,
>
> Oracle normally skips the first block of datafiles on raw devices to
> avoid intervention with LVM headers. I wish they do that for ASM but
> in ASM that space if used by ASM itself for similar purpose as in LVM.
>
> On the other hand, ASM disks should be created on top of partitions
> (in Linux terminology) but not the whole disks themselves. In fact,
> ASMLib (if you happen to use it) requires that - it won't mark ASM
> disk unless it's a partition. This would save your disk in case when
> the header of the LUN/physical disk is corrupted. Though, partition
> table may be hosed but that's recoverable and you can easilly back it
> up with "dd" - it's static.
>
> Cheers,
> Alex
>

-- 
Jeremy Schneider
Chicago, IL
http://www.ardentperf.com/category/technical
--
http://www.freelists.org/webpage/oracle-l


