RE: ZFS snapshots

My contention is that ArchiveLog streams allow you PITR to any point in time.

If you take a snapshot you can only do an Instance Recovery to the point of the snapshot -- ie it would be like simulating a server failure and you restarting the database whereby it does a "Crash Recovery" because the datafiles were fuzzy (not in backup mode).

Hemant

At 11:27 PM Tuesday, Donahue, Adam wrote:
>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.

Hemant K Chitale
http://web.singnet.com.sg/~hkchital

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