If it seems like we have published a lot of articles around the Sun ZFS Storage Appliance, it is because we have. Busy Oracle engineer and frequent contributor Sridhar Ranganathan has handed us another jewel: Oracle Database Cloning Solution Using Oracle Recovery Manager and Sun ZFS Storage Appliance. What a great pair of topics!
Let's forget for a minute that I work for Oracle, the leading database company in the World: that is a relatively new phenomenon. The truth is I've always known that databases dominate the solutions that computer hardware enables. Indeed, I vividly remember the early 1980s, when the emerging personal computer market was propelled largely by two primitive database applications: for balancing checkbooks and saving recipes. When Apple announced their new soft-sectored floppy drive, we had to get onto a waiting list to buy 360 KB of random access disk for our puny databases. The CEO of General Dynamics, where I worked at the time, discovered this power and the company was transformed almost overnight from analog to digital.
There are many important things DBAs do to secure their hefty compensation (had I anticipated that trend, I would have started off as a DBA, rather than as an actuary. Wait! I'm afraid there wasn't even the acronym "DBA" way back then...) One of these activities is that of cloning databases, which is done for a variety of reasons, including development, testing, and training without disrupting the actual database itself. As Sridhar points out, the Sun ZFS Storage Appliance provides an ideal platform for performing database cloning. It comes with a user-friendly interface for ease of management, a full set of data services for business continuity and disaster recovery purposes, multi-protocol support to cater to any infrastructure, analytics for monitoring and resolution purposes, and a hybrid storage pool for faster response time for test, development, and QA activities. With unlimited snapshots and cloning possibilities, many concurrent database instances can be launched for various purposes without impacting the production database.
This paper gives you a good look at the power of the graphical front end, includes examples, recommendations, best practices, and sizing considerations. As I said, this is another jewel, not to be missed.