Return-Path: <oracle-l-bounce@freelists.org>
Delivered-To: 2-oracle-l@orafaq.com
Received: (qmail 17221 invoked from network); 16 Dec 2007 09:41:09 -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; 16 Dec 2007 09:41:09 -0600
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DCD577D9612;
 Sun, 16 Dec 2007 10:41:09 -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 04933-07; Sun, 16 Dec 2007 10:41:09 -0500 (EST)
Received: from turing (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 573DC7D95DA;
 Sun, 16 Dec 2007 10:41:09 -0500 (EST)
Received: with ECARTIS (v1.0.0; list oracle-l); Sun, 16 Dec 2007 09:53:44 -0500 (EST)
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 599BC7D8B23
 for <oracle-l@freelists.org>; Sun, 16 Dec 2007 09:53:44 -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 28636-09 for <oracle-l@freelists.org>;
 Sun, 16 Dec 2007 09:53:44 -0500 (EST)
Received: from rv-out-0910.google.com (rv-out-0910.google.com [209.85.198.188])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E95917D8A3A
 for <oracle-l@freelists.org>; Sun, 16 Dec 2007 09:53:43 -0500 (EST)
Received: by rv-out-0910.google.com with SMTP id b22so1458801rvf.46
        for <oracle-l@freelists.org>; Sun, 16 Dec 2007 06:53:42 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=gamma;
        h=domainkey-signature:received:received:message-id:date:from:sender:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references:x-google-sender-auth;
        bh=PEJf85H9TJwA2AE2J8AB7FLmtYuqimZVTCKSNgc9Xdo=;
        b=kjs+JRzwMdgZx6L2+9r1mKX1rYvOc4GiXRCji2XFvL6l1B3pZCG6X0uz3jRwp9Pg9hDXrZaT81R0u/FSZiZIBtVuztU17TlPAUeIy85ALktoyFXeTiMUhgIKS2CvMvmMa20sRj1iAgm0rXM4hlQv/lVu1Q7WwGkZxk+LFTP8BxE=
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:sender:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references:x-google-sender-auth;
        b=RaoK2iiJxBxXD8uVqkYj2zDIk0nA8GDUhj08OWrSL6fwiE7MUqAGjO4ZPOlaTLmzjrGziaaOjyJW8qDRw/RwKf+QvQVX0ENsZ8PrMo9EyyTPLWgMYItI66TMR8QxePxD9gkuk+vB5wnLurocjHdnNMCerGGvQdnvVe1DBIfzmAI=
Received: by 10.141.180.5 with SMTP id h5mr3234041rvp.128.1197816822223;
        Sun, 16 Dec 2007 06:53:42 -0800 (PST)
Received: by 10.140.161.9 with HTTP; Sun, 16 Dec 2007 06:53:42 -0800 (PST)
Message-ID: <c2213f680712160653t50926d67wfe637be46538c8a1@mail.gmail.com>
Date: Sun, 16 Dec 2007 09:53:42 -0500
From: "Alex Gorbachev" <ag@oracloid.com>
To: jeremy.schneider@ardentperf.com
Subject: Re: superblock backups, ASM vs OCFS2
Cc: Oracle-L <oracle-l@freelists.org>
In-Reply-To: <611ad3510712130850j4575aea3k4d43481b27699908@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Disposition: inline
References: <611ad3510712130850j4575aea3k4d43481b27699908@mail.gmail.com>
X-Google-Sender-Auth: 7592605ab787d178
X-archive-position: 3955
X-ecartis-version: Ecartis v1.0.0
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
X-original-sender: ag@oracloid.com
Precedence: normal
Reply-to: ag@oracloid.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

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


On Dec 13, 2007 11:50 AM, Jeremy Schneider
<jeremy.schneider@ardentperf.com> wrote:
> Just wondering, does anyone know much about "superblock" backups in ASM vs
> OCFS2?
>
> I ran into an interesting case a month or so back where someone had
> accidentally tried to initialize their ASM disks with linux LVM...  and
> written the LVM headers to the disk.  It was just a few bytes at the very
> top of the disk - but it was enough to totally hose ASM.  Which started me
> thinking, "if this was a filesystem then I'd have a backup superblock that I
> could recover".  Who knows - maybe ASM has a backup of its header block -
> but it's all proprietary and if there's a tool that will recover an ASM
> header then it's probably buried at Oracle support somewhere.
>
> Looks like OCFS2 includes superblock backups since this patchset:
> http://lkml.org/lkml/2007/1/22/148
>
> Not sure if ckfs will recover them but since it's open source it'd be
> trivial to put together a utility that would recover a superblock.
>
> This seems to me to be a great reason to choose OCFS2 over ASM.  Recovering
> a backup superblock is MUCH faster than recreating the entire volume and
> restoring data from backup!!!  I don't even know if you could use dd to try
> to backup your ASM disk headers - since it's proprietary I don't know what's
> in those blocks.
>
> Anyone have any thoughts on this?  Is there something I'm missing here?
>
> Jeremy
>
>
> --
> Jeremy Schneider
> Chicago, IL
> http://www.ardentperf.com/category/technical
>



-- 
Alex Gorbachev, Oracle DBA Brewer, The Pythian Group
http://www.pythian.com/blogs/author/alex http://www.oracloid.com
BAAG party - www.BattleAgainstAnyGuess.com
--
http://www.freelists.org/webpage/oracle-l


