How to clone an Oracle database in less than 5 minutes

When we were planning for Oracle OpenWorld in San Francisco, we wanted to show the top benefits of Tegile flash arrays in an Oracle environment. As this was not my first rodeo at Oracle OpenWorld, actually my eighth in a row (with the past five as a presenter on flash storage), I had a good idea of what is cool to show and what is not so cool.

The cool stuff with Flash storage
Definitely, a huge number IOPS and lightning-fast latencies are very cool in our Tegile all-flash arrays and very easily demonstrated — but we’ve been showing that off for years. So I asked myself: What else can I demonstrate to show the following benefits?

1. extreme performance of flash

2. extreme ease of use of the Tegile IntelliFlash GUI

3. extreme time-saving techniques for all my fellow DBAs out there

ORACLE-EUREKA-MOMENT

Eureka moment
It came to me! For Oracle OpenWorld, to demonstrate the top benefits of Tegile flash arrays, with a series of clicks, we would clone a production Oracle database from a standalone Linux server to a VM-based Test/Dev environment. We could do it all in less than 5 minutes.

Ready to pull the trigger for our demo at Oracle OpenWorld
So, after prepping a new VM-based OEL environment with the necessary Oracle binaries, creating an ASM instance to house the forthcoming cloned database, and performing a few DBA magic tricks with SRVCTL to create the required services to manipulate, we were ready to pull the trigger.

For this demonstration, my production database was composed of multiple LUNs presented to an ASM instance. All the LUNs for this specific database would reside inside a specific “project” in the Tegile IntelliFlash GUI, which makes the steps of creating snapshots of the LUNs and clones of the snapshots a two-click ordeal, no matter how many LUNs we are dealing with. Nice and easy.

The only thing left for me to do after that was to shut down the database and ASM instance on my test/dev VM, spoof the LUN IDs into the multipath.conf file, and turn everything back on. Could it really be that easy? Test after test from the production database to the test/dev database proved that there was nothing missing. The cloned Oracle database was perfectly in sync every time.

Final nugget: fast cloning to create test environment in under 5 minutes
Thinking this demo was just too easy and fast, I decided to add a final little nugget and included the PDB “cloning” facet in order to create a few more test environments. By simply stating the following: SQL> create pluggable database tegile2 from tegile1; I had myself a fresh up-to-date developer environment that was totally in sync with production, in under 5 minutes.

Watch demo of Tegile flash storage on Oracle
Tegile-Flash-Arrays-Reduce-Response-TimeIf you would like to see this demo or anything else Oracle related, hit our website and request a demo. Our team of flash storage experts are eager to hear your needs — and show what flash arrays can do for your database environment. If you want to see in person, come out and chat with us at Tegile events in 2016.

Running Oracle on Tegile?
Get the Tegile Best Practices Guide for Oracle Database.  Take the headache out of configuring your Oracle database to run on flash.  Take advantage of step-by-step instructions, real-world examples, and a “Quick Start” guide.  Also get pre-validated configs for your Oracle database to run on IntelliFlash.

So, next time you’re looking to clone your Oracle database in under 5 minutes, look to Tegile. Not only can you get the job done fast, but with our Best Practices Guide, you can quickly optimize your Oracle database on flash, and get on with your business.  


Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>