Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 12136 invoked from network); 12 Dec 2006 09:22:21 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 12 Dec 2006 09:22:16 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6745D5666D8; Tue, 12 Dec 2006 10:20:24 -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 11446-09; Tue, 12 Dec 2006 10:20:24 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 55D215666DD; Tue, 12 Dec 2006 10:20:22 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 12 Dec 2006 10:19:19 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 212275665B9 for ; Tue, 12 Dec 2006 10:19:19 -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 11141-05 for ; Tue, 12 Dec 2006 10:19:19 -0500 (EST) Received: from smtp14.singnet.com.sg (smtp14.singnet.com.sg [165.21.6.24]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7C755566643 for ; Tue, 12 Dec 2006 10:19:05 -0500 (EST) Received: from chitale.singnet.com.sg (bb220-255-237-122.singnet.com.sg [220.255.237.122]) by smtp14.singnet.com.sg (8.13.8/8.13.6) with ESMTP id kBCFJjuo024414; Tue, 12 Dec 2006 23:19:45 +0800 Message-Id: <7.0.1.0.0.20061212231901.01b1d4f0@singnet.com.sg> Date: Tue, 12 Dec 2006 23:19:35 +0800 To: Adam.Donahue@kbcfp.com, From: Hemant K Chitale Subject: RE: ZFS snapshots In-Reply-To: <248A58C2AB63304C82F0706DE62FB345015AA29D@nyc.kbcfp.com> References: <248A58C2AB63304C82F0706DE62FB345015AA29D@nyc.kbcfp.com> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-archive-position: 43035 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: hkchital@singnet.com.sg Precedence: normal Reply-to: hkchital@singnet.com.sg List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at avenirtech.net You would still be recommended to run ALTER TABLESPACE (DATABASE in 10g) BEGIN BACKUP .. before you take the Snapshot and ALTER TABLESPACE (DATABASE) END BACKUP followed by ALTER SYSTEM ARCHIVE LOG CURRENT after the Snapshot. Hemant At 10:58 PM Tuesday, Donahue, Adam wrote: >Well, a ZFS snapshot is atomic - meaning, it's not like copying a >datafile in that it doesn't read things block-by-block, meaning the >file can change underneath you while you copy it. Instead, because >of the way ZFS works, it merely marks an existing "uberblock" to be >preserved, which is a single, atomic state of the filesystem as of a >given time. > >I admit it's not clean - even if it works. But I'm curious if I'm >missing something that would make it not work at all in some cases. > >Adam Hemant K Chitale http://web.singnet.com.sg/~hkchital -- http://www.freelists.org/webpage/oracle-l