RE: ZFS snapshots

From within that particular clone, yes.

To me this just seems like a way to have extra overhead on the copy process. If your intention is to use a sparse clone as if it all existed from the Oracle viewpoint, then you've got the same old problem of synchonization of OS level blocks with Oracle blocks.

mwf

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Donahue, Adam
Sent: Tuesday, December 12, 2006 10:28 AM To: Hemant K Chitale; oracle-l_at_freelists.org Subject: RE: ZFS snapshots

I replied privately, but I don't think this step is strictly necessary - nor desired, as we'd then lose our ability to perform PITR to any SCN within the backup window, no?

Adam

-----Original Message-----
From: Hemant K Chitale [mailto:hkchital_at_singnet.com.sg] Sent: Tuesday, December 12, 2006 10:20 AM To: Donahue, Adam; oracle-l_at_freelists.org Subject: RE: ZFS snapshots

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

--
This message may contain confidential, proprietary, or legally privileged
information. No confidentiality or privilege is waived by any transmission
to an unintended recipient. If you are not an intended recipient, please
notify the sender and delete this message immediately. Any views expressed
in this message are those of the sender, not those of any entity within the
KBC Financial Products group of companies (together referred to as "KBC
FP").

This message does not create any obligation, contractual or otherwise, on
the part of KBC FP. It is not an offer (or solicitation of an offer) of, or
a recommendation to buy or sell, any financial product. Any prices or other
values included in this message are indicative only, and do not necessarily
represent current market prices, prices at which KBC FP would enter into a
transaction, or prices at which similar transactions may be carried on KBC
FP's own books. The information contained in this message is provided "as
is", without representations or warranties, express or implied, of any kind.
Past performance is not indicative of future returns.

--
http://www.freelists.org/webpage/oracle-l



--
http://www.freelists.org/webpage/oracle-l