Best Practices for Improving Oracle Database Backup and Recovery SLAs

Agenda

• Data Protection Challenges
• Protecting Data with Oracle Recovery Manager and Sun Unified Storage Systems
• Best Practice Architectures & Configurations
• Adding Further Value to the Backup
• Sun Support Services
• Next Steps

Databases are the most widely deployed and most challenging application to backup.Growing amount of data and new data types to support, while the back up window stays the same or shortens due to 24/7 operation.According to ESG 2008, 1 in 7 backups and 1 in 6 restores fail. This is due, largely, to growing volumes of data and backup windows remaining the same or shrinking.

RMAN to the rescue! RMAN is the Oracle-preferred method for efficiently backing up and recovering Oracle databases. Its free with the Oracle Database and it supports incremental backup.

Oracle RMAN has all the knowledge and can control all the functions to create a successful and efficient backup and restore.

RMAN is designed to work intimately with the database and the server, providing block-level corruption detection. RMAN optimizes performance and space consumption with file multiplexing and backup set compression. RMAN takes care of all underlying database procedures, freeing dependency on OS and SQL scripts. It provides a common interface, via command line and Enterprise Manager, for tasks across different host operating systems and offers features not available through user-managed methods, such as parallelization of data streams, retention policies, and detailed histories.

Oracle Recovery Manager keeps track of and simplifies all aspects go the backup and recovery process.

Here’s why the 7000 makes such a great partner to RMAN. Its high performance for fast backups and restores, and is cost effective.

It complements RMAN’s incremental backup functionality with its ZFS compression capabilities. RMAN best practice is to have the target do compression where possible to relieve the Database server CPUs from doing it so as not to degrade Database performance.

In addition, the 7000’s free Replication capability provides for cost effective Disaster Recovery.

Here is a diagram illustrating D2D2T. EMC Networker is the best practice third party product enabling D2D2T in this scenario.
Oracle Secure backup (OSB) can’t be used when a 7000 is an intermediate disk target. OSB can be used to backup directly to tape with no 7000 in the middle.
Remember the whole idea about putting another disk (the 7000) between the primary disk array and tape is to enable faster backups and more importantly, restores.

This customer saved $250,000 by incorporating an S7000 as a target for Oracle RMAN over renewing a 3rd party BU&R application license. By leveraging the powerful insights afforded by Sun’s storage analytics, they were able to maximize their investment in the S7210 by tuning it to increase the workload 300% (3x more concurrent database backup streams).

This customer set up the 7000 themselves. This customer’s experience showcases the intuitiveness and ease of use of Sun Unified Storage’ management and analytic features. In the case where a customer might not be a self-sufficient, Sun recommends and offers implementation and training services.

Here is an extremely popular way of further adding value to the backup process by using the backed up database on the 7000 to do test and development. The database resides on an S7000 and is snapped, cloned, then replicated to another S7000. There, additional copies can be made for Test, Development, QA, Training, Pre-Production, etc. If appropriate and sized properly, these additional copies might be snaps residing in the S7000′s ample cache. There, the lower latency of the S7000 cache helps speed development, training, and more.

Some of the reasons why integrating test and development onto the backup workflow is so important.

There are far more test and development databases at your customer site than OLTP databases. For example, Oracle has 1 OLTP database and 8 test and development databases.

Oracle Advanced Customer Services for storage products help increase security, improve business continuity, decrease data retention and regulatory risks, and improve your ability to compete — all while helping you save time and money.

Accelerate achievement of storage and data management goals
Ensure full product readiness – storage feature enablement, maximum utilization and complete integration
Speed application development and deployment time with access to Oracle storage hardware and software experts
Ensure a more secure environment, better compliance and stronger BCDR policies
Learn data management best practices from Oracle storage experts
Mitigate the risk of downtime, data loss and costly delays as Oracle’s storage experts utilize proven methodologies and global implementation and migration best practices.

© 2010, www.oracledatabase12g.com. 版权所有.文章允许转载,但必须以链接方式注明源地址,否则追究法律责任.

相关文章 | Related posts:

1. Oracle Secure Backup:Secure Your Data, Protect Your Budget
2. How to recover and open the database if the archivelog required for recovery is either missing, lost or corrupted?
3. undo backup optimization does not work on 11.2.0.1?
4. How to Minimise the impact of an Online RMAN Backup on an OLTP system
5. Expert Oracle Practices Oracle Database Administration from the Oak Table PDF
6. RMAN Performance Tuning Using Buffer Memory Parameters
7. Lost Redo Logs And Archive Logs And Need To Apply Media Recovery ** INTERNAL ONLY **
8. Oracle Database 11gr1/10gr2 Automatic Storage Management Overview and Technical Best Practices
9. 11g Release 2 enhanced Tablespace Point In Time Recovery
10. Best Practices for Loading in an Oracle Data Warehouse