New tool speeds Oracle data recovery process

Article

New tool speeds Oracle data recovery process

3PARdata Inc. on Tuesday announced a new way to get to database backup data faster than tape and cheaper than traditional disk. The company, based in Fremont, Calif., announced the availability of Virtual Copy DBA, a software tool that enables Oracle backups and recoveries using disk-based snapshots.

3PAR focused on recovering applications with this software release.

"Today, trying to recover from tape is far too slow, but trying to recover from disk is too expensive," said David Scott, 3PAR's president and CEO.

Scott said users might believe they have things in hand, but restoring large databases from tape can be a nightmare that takes hours or days. "Lots of companies believe they have a fast recovery program, until they use it," he said.

The process is this: first, snapshots use "copy-on-write" technology, enabling an image of the database to occupy a small amount of disk space. This process makes it economically feasible to store hundreds of snapshots on a limited amount of disk. Second, dual read-write capability enables the immediate mounting of a recovered database image, which speeds the restore process. Finally, Virtual Copy DBA automates and coordinates administrative backup and recovery commands issued at the Oracle database and storage consoles, 3PAR said.

This unique 3PAR capability allows multiple point-in-time snapshots to be taken daily or hourly to create a spectrum of recovery images, thus minimizing the playback of database logs and substantially

    Requires Free Membership to View

    When you register for SearchStorage.com, you’ll also receive targeted emails from my team of award-winning editorial writers. Our goal is to keep you informed on the hottest topics, the latest news and the biggest challenges you face as a storage professional today.

    Rich Castagna, Editorial Director

    By submitting your registration information to SearchStorage.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchStorage.com is governed by our Terms of Use. You may contact us at webmaster@TechTarget.com.

improving recovery time.

Steve Duplessie, president and founder of the Enterprise Storage Group Inc., Milford, Mass., explained that 3PAR's software can take instant snapshots of backup data, store a huge number of copies of the data and make the data writable.

"That means I can snapshot a live database, make a copy for backup and a copy for testing that gets migrated to another server and can be written to or read from," Duplessie said. "Others can do it, but not in those kinds of numbers, and the fact that they can turn a read-only file into a [writable] version means that restoring data can be simply re-pointing the database to the snapshot volume and letting the database take off."

Duplessie said that, normally, you would have to restore the entire read-only snapshot to a new volume that has read/write capability, which takes a lot of time from tape and less time from disk. "Big Oracle shops have to like this," he said.

3PAR said the product has been certified by the Oracle Storage Compatibility Program (OSCP).

Veritas Software Corp. has also given 3PAR's Virtual Copy DBA its seal of approval. The company has qualified 3PAR Utility Storage in an Oracle9i Real Application Cluster environment with Veritas Database Edition/Advanced Cluster for Oracle9i.

Let us know what you think about the story. E-mail Kevin Komiega, News Writer

FOR MORE INFORMATION:

Best storage products of the year

3PAR Utility Storage System

3PAR pushes storage arrays

Comment on this article in the SearchStorage.com Discussion forums