Legerity is a leading provider of analog/mixed-signal integrated circuits (ICs) for wireline voice and data networks. More than 20 years of industry experience, a veteran management team and the engineering innovation of a technology "start-up" give Legerity the energy and resources to meet the specialized needs of communications equipment manufacturers. Currently, more than one-third of all voice or data calls worldwide pass through Legerity ICs.

Equipment manufacturers around the world ­ from blue-chip firms to new and growing companies in rapidly evolving markets ­ rely on Legerity to help them stay competitive by reducing system costs, increasing board density, lowering power dissipation and enhancing overall system performance.

When I came on board at Legerity during the initial phase of an Oracle Applications rollout, I was faced with the typical learning curve that comes with any new job, or so I thought. The sense of urgency was multiplied dramatically as the consultants that were to bring me up to speed were leaving in one month. I was forced to absorb as much as possible within this short window of time while ensuring that all aspects of the company's IT infrastructure were in place. I immediately began to think of areas in which I could quickly implement a solution that I could trust to take care of itself ­ there was no time for unforeseen errors. Because Legerity is an Oracle shop and having had experience with the complexities associated with the Oracle recovery method, I knew backup and recovery was the area I needed to address first ­ not to mention that backup and recovery is an essential piece of any company's IT infrastructure. Because I had worked with BMC Software's SQL- BackTrack at a previous job, I was very familiar with it. I knew it was a product I could rely on, one that I could quickly implement and then not worry about again.

SQL-BackTrack takes the guesswork out of backup and recovery. With other products, DBAs must write the syntax to run the backup and recovery process; with SQL-BackTrack, the guided recovery piece of the tool does it for you, thus shielding the DBA from the syntax which eliminates mistakes. It allows me to focus my time and energy on other more strategic IT areas. The tool also maintains a detailed report when backup is complete, giving me the data I need to manage the backup and recovery process. We have had two serious crashes, and the tool quickly recovered just the way it should have.

The guided recovery feature allows me to set a recovery strategy, and then the tool automates recovery. This function prevents manual errors and false starts, essentially saving time. SQL-BackTrack can also recover from a given point in time, recover a selected data file or tablespace, or even recover a single object from a physical backup without taking the production instance offline. Like the guided recovery, this feature is a time saver not only of my time, but also of production time because it reduces the total time of outage.

SQL-BackTrack also maintains a file-system-based backup and recovery catalog, which is a very nice and very important feature of the tool. DBAs have to ensure that archive logs are monitored. If they fill up a disk, Oracle shuts down. SQL-BackTrack monitors and backs up archive logs automatically. Backing up this catalog is crucial to recoveries, and it is always easier to back up static file systems.

The only area in which we have had issues integrating SQL-BackTrack are with HP's Omniback software. There aren't any built-in drivers in the tool for this software (presumably because the software is not that prevalent), so we had to develop our own integration solution. Overall, SQL-BackTrack has produced the results I was looking for ­ it is a very reliable backup and recovery solution that saves time and money for Legerity. It also saves dependence on scripts and facilitates quick cross-training between DBA resources.

BMC Software's SQL-BackTrack for Oracle is a comprehensive, flexible backup and recovery management tool that simplifies and automates many database administration tasks associated with Oracle database backup and recovery. Highlights of the product include: complete archive log management, automation of common backup and recovery tasks, table extraction from physical backups while hiding the complexity of a recovery, and data compression of data during backups resulting in relieved network resources.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access