Oracle DBAs Rejoice! Automating Oracle Copies for Non-Production Environments

Posted by Neil Salamack | Author Info

Mar 24, 2014 9:00:00 AM

Administrators of the mighty enterprise application and database known as Oracle… this blog post is for you! It’s refreshing to be able to talk to an audience that is tasked with managing the lifeblood of your company. But did you know that there are tools besides Oracle native tools like DataGuard that can help you streamline workflows to make your job easier and save you time? This is precisely what I want to discuss with you today.

A Tale of Two Databases
In my role at EMC, I get to meet and work with many customers who have large scale deployments of Oracle. They tell me that one of the tedious aspects of the job is the need to keep production running without interruption, while also maintaining a non-production environment for testing and development. The fact of the matter is that DBAs are Oracle experts, but not experts on creating copies on the SAN. Often times in large companies, the Oracle DBA has to submit requests in queue to receive copies of a particular database. This “queue” is often managed by the Storage Administrator. This is an inefficient workflow for a number of reasons including:
  • The Oracle DBA has to wait to receive the copy. The longer the wait, the more outdated the non-production environment becomes.
  • The Storage Administrator frequently has higher priority work than creating copies for the DBA.
  • Using native tools, automating the copy job can create inflexibility. Even if the Storage Administrator automates the Oracle copy job, the DBA will need them to intervene to make changes when additional DB’s or other changes are made
Read More

Topics: Oracle