Feature

Configuring storage for ERP

Ezine

This article can also be found in the Premium Editorial Download "Storage magazine: The hottest storage technology for 2007."

Download it now to read this article plus other related content.

Using backup applications
The process described earlier typically occurs at least once every 24 hours and sometimes several times a day. The process needs to be fully automated, but that can be difficult. Commands need to be executed at the database level, the storage array level and within a backup application to properly execute an appropriate backup of the database.

Some business environments may not need 24/7 access to the ERP application. In those environments, the backup application can be used to control backups of the tablespaces, executables, log files and archives at a file-system level. In many cases, the database administrator will export the database file system to provide a secondary recoverable copy of the database. This exported tablespace doesn't offer point-in-time-type recoveries and, as the database grows, the export can be time consuming.

In a larger environment where a company may need to "roll" the database forward to a specific time or transaction, additional database integration is required. When direct integration with the database application is required to suspend the database, enterprise backup apps (Symantec's Veritas NetBackup and EMC's NetWorker, for example) integrate with the database technologies (e.g., RMAN) at the ERP application level. Enterprise backup applications can also control the storage array to leverage the array's ability to create a separate clone of the production volumes. Another advantage of leveraging

Requires Free Membership to View

these types of enterprise backup and recovery applications is that recovery can be controlled from this point as well.

This was first published in December 2006

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: