Solve Your Top Oracle Data Management Problems

This article was originally published in NetApp's Tech OnTap Newsletter. To receive the newsletter monthly and enjoy other great benefits, sign up today at www.netapp.com/us/communities/tech-ontap
Solve Your Top Oracle Data
Management Problems
By Tim Rutherford
®An active Oracle environment-like any Enable Self-Service with Tim Rutherford database environment-faces significant Policy-Driven Data ProtectionProduct Manager data-related challenges, including:Storage Management and If your job is to meet the storage needs of Application Integration . Backing up data frequently enough an active Oracle environment, you probably NetApp without affecting production spend a lot of your time addressing the Tim has worked in product . Enhancing recoverability requests of DBAs, developers, and testers. management for over 10 years, . Providing enough copies of a production With SnapManager 3.0 for Oracle, you can drawing on 15 years' experience in database for QA, testing and other delegate the ability to perform common purposes tasks such as backups, restores, and the software industry, where he . Managing data across both primary cloning. This not only frees up your time, has served as a front-line support it makes your DBAs and developers more engineer, worldwide product support and secondary storage efficient as well. Because they can quickly lead, sales engineer, and project ® ®NetApp SnapManager for Oracle (SMO) perform necessary tasks and get on manager. Tim is passionate about data is designed to significantly simplify all these with their work without delay, they are management and protection, always tasks and more. A previous Tech OnTap more productive and more responsive to looking for ways to help customers get article explained the internals of SMO and its business needs.more value from their business data. close integration with Oracle ASM and other Oracle technologies (http://partners.netapp. By integrating with NetApp Protection com/go/techontap/empower-dba.html). Manager (http://partners.netapp.com/go/techontap/matl/backup_mgmt.html) and In this article, I'll examine how you can NetApp Operations Manager (http://partners.deploy SMO to simplify and even automate netapp.com/go/techontap/death_scale.data protection, recovery, and cloning html), SMO gives you the power of both across both primary and secondary tools, including a graphical user interface storage. To begin, I'll describe how you that allows you to fully control and automate:can use SMO self-service data protection Tto delegate the ability to perform these . NetApp Snapshot copies for space-tasks to DBAs or others in your organization efficient backup on primary storageTso that you don't have to be directly involved . NetApp SnapVault for longer-term in every database-related operation on backups on secondary storageNetApp storage.Figure 1) Policy-driven data protection allows a storage administrator to delegate the ability to perform certain storage tasks to users such as DBAs.
®. NetApp SnapMirror for disaster recovery that reduce the total amount of data to organization in the best position to know ®. NetApp FlexClone to create space- be restored in the event of a failure. With when backups are required, so they can efficient clones of Oracle databases the graphical scheduler, you can quickly create the most effective backup schedules create or modify schedules to automatically and/or perform ad hoc backups as needed.Role-based access control (RBAC) provides execute the backups you want. Full the granular security necessary to delegate integration with Oracle RMAN provides Recoverythe ability to perform any or all of these tasks support for block-level restores. With SnapManager for Oracle, you can to other users. You manage groups of users restore very quickly from data stored on by defining roles and assigning users to A key feature of SMO is that it maps the disk, so you can quickly choose the right those roles. Those users are able to perform database contents (data files, archive logs, backup version and get up and running the tasks delegated to them by using the and so on) each time a backup is created. much faster.SMO interface and do not need to have a You no longer have to worry whether you detailed understanding of the underlying have updated your backup script to include New in SMO 3.0, the restore algorithm storage configuration.... [download for more]