RE: new database server build - sanity check

From: Chris King <>
Date: Tue, 29 Jan 2013 10:02:30 -0800 (PST)
Message-ID: <>

Sounds like ZFS snapshots could be a good backup or even a DR strategy? Is extra/specific software required to take/use snapshots for live/open Oracle databases? Or does the database have to be closed to do this?


The snapshot capabilities can be a nice feature.  You can snap a live database and restore it back

within moments -- eliminating the time needed for an RMAN restore.

Having said that, I would look into testing some things -- perhaps Google "ZFS evil tuning guide" -- Note however, that there are also websites out there that discount much of what is in the guide, essentially saying to leave the defaults or most of them, hence some testing first.  The foundation you lay will be
the one you will be using.

Joel Patterson
Database Administrator
904 727-2546

Received on Tue Jan 29 2013 - 19:02:30 CET

Original text of this message