RE: new database server build - sanity check
From: Chris King <ckaj111_at_yahoo.ca>
Date: Tue, 29 Jan 2013 10:02:30 -0800 (PST)
Message-ID: <1359482550.13040.YahooMailNeo_at_web141405.mail.bf1.yahoo.com>
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?
Date: Tue, 29 Jan 2013 10:02:30 -0800 (PST)
Message-ID: <1359482550.13040.YahooMailNeo_at_web141405.mail.bf1.yahoo.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jan 29 2013 - 19:02:30 CET