Best Practices for Oracle ASM on XIV with Tivoli FlashCopy Manager.pdf | Oracle Database | Backup

Please download to get full document.

View again

of 51
All materials on our website are shared by users. If you have any questions about copyright issues, please report us to resolve them. We are always happy to assist you.
Information Report
Category:

Documents

Published:

Views: 15 | Pages: 51

Extension: PDF | Download: 0

Share
Related documents
Description
Best Practices Guide for Oracle Databases with IBM XIV Storage System Snapshots XIV Snapshots for Backup/Restore using Tivoli Storage FlashCopy Manager A Best Practices Paper This document can be found in the IBM Techdocs library Version 1.7 (2010-02-15) Hans-Guenther Hoerhammer (hoerhammer@de.ibm.com) Markus Oscheka (moscheka@de.ibm.com) IBM Systems and Technology Group (STG) IBM System Storage - Advanced Technical Suppo
Tags
Transcript
    Best Practices Guide for Oracle Databases with IBM XIV Storage System Snapshots XIV Snapshots for Backup/Restore using Tivoli Storage FlashCopy Manager This document can be found in the IBM Techdocs library Version 1.7 (2010-02-15) Hans-Guenther Hoerhammer (  hoerhammer@de.ibm.com  ) Markus Oscheka (  moscheka@de.ibm.com  ) IBM Systems and Technology Group (STG) IBM System Storage - Advanced Technical Support (ATS) European Storage Competence Center (ESCC), Mainz, Germany    A Best Practices Paper  Best Practices Guide for Oracle Applications with IBM XIV Storage System Snapshots Page 2 of 51 © COPYRIGHT IBM CORPORATION, 2010 Version: 1.7 (2010-02-15)    Abstract In today's IT world, where application servers are operational 24 hours a day, the data on these servers must be fully protected. With the rapid increase in the amount of data on these servers, their critical business needs, and the shrinking backup windows, traditional backup and restore methods may be reaching their limits in meeting these challenging requirements. Point-in-time copy operations can help minimize the impact caused by backups and provide near instant restore capabilities. Since a point-in-time copy operation typically takes much less time than the time for a tape backup, the window during which the data is being backed up can be reduced. This helps facilitate more frequent backups and increase the flexibility of backup scheduling and administration because the time spent for forward recovery through transaction logs after a restore is minimized. IBM/Tivoli offers a range of products for backup and restore of databases. Products that leverage storage system features like Snapshot help to reduce the backup window and to speed up the restore process. The IBM XIV Storage System provides a volume level point-in-time copy function known as snapshot to help minimize the impact caused by backups and provide near instant restore capabilities These array-based snap-shot technologies provide copies of data that can be used to backup the database without impacting the production environment. IBM Tivoli Storage FlashCopy Manager can help deliver the highest levels of protection for mission critical Oracle databases via integrated application-aware snapshot backup and restore capabilities. This is achieved through the exploitation of advanced IBM XIV Storage System snapshot technology to create a high performance, low impact application data protection solution. This paper covers the integrated solution of FlashCopy Manager for backup and restore of Oracle Databases in the XIV Storage System. It describes the installation and configuration of Tivoli Storage FlashCopy Manager for backup and restore of Oracle databases using XIV Storage System snapshots mechanism.  Best Practices Guide for Oracle Applications with IBM XIV Storage System Snapshots Page 3 of 51 © COPYRIGHT IBM CORPORATION, 2010 Version: 1.7 (2010-02-15)   Table of Contents 1 Introduction...........................................................................................................................4   2 Configuration and Setup.......................................................................................................5   2.1 Hardware Topology.......................................................................................................5   2.2 Oracle Database servers..............................................................................................5   2.3 Configuration by example.............................................................................................5   2.3.1 Configuring the Oracle servers.............................................................................6   3 Installation and Configuration of FlashCopy Manager...........................................................8   3.1 Tivoli Storage FCM Architecture...................................................................................8   3.2 FCM Pre-Installation Tasks...........................................................................................9   3.3 TSM Client and Server................................................................................................10   3.4 FCM Installation..........................................................................................................10   3.5 FCM Configuration for disk-only backup.....................................................................10   3.6 Switching from disk-only to offloaded backup.............................................................12   4 Leveraging XIV Snapshots for Backup/Restore of Oracle databases with FCM.................14   4.1 Disk-only backup........................................................................................................15   4.2 Offload to Tivoli Storage Manager..............................................................................16   4.3 Restore from snapshot................................................................................................17   4.4 Restore from TSM server............................................................................................17   5 Summary............................................................................................................................19   References............................................................................................................................20    Appendix A – XIV Storage configuration and Oracle Software installation.............................21   Oracle Database servers..................................................................................................21   Storage hardware.............................................................................................................21   Configuration by example.................................................................................................21   Configuring the Oracle servers....................................................................................29    Appendix B – Commands and Output....................................................................................33   Trademarks and special notices............................................................................................51    Best Practices Guide for Oracle Applications with IBM XIV Storage System Snapshots Page 4 of 51 © COPYRIGHT IBM CORPORATION, 2010 Version: 1.7 (2010-02-15)   1 Introduction The IBM® XIV® Storage System is a revolutionary, easily manageable, enterprise class open disk system, designed to meet today’s ongoing IT challenges. Its design — a grid of standard Intel®/Linux® components are connected in a any-to-any topology using Gigabit Ethernet — represents the next generation of high-end SAN (Storage Area Networks) systems. This best practices paper focuses on benefits and business value of Backup and Recovery process for Oracle environments with XIV Storage System and Tivoli® Storage FlashCopy® Manager. It describes how to use Tivoli Storage FlashCopy Manager to backup and restore Oracle ASM applications taking advantage of XIV snapshot technology. The key features covered in this paper for deploying IBM XIV Storage Systems are: ã  XIV Snapshots - XIV snapshots produce very little performance impact based on a redirect-on-write concept. The snapshot capabilities within the XIV Storage System utilize a metadata, redirect-on-write design that allows snapshots to occur in the millisecond time range with little performance overhead. Up to 16,000 full or differential copies can be taken. Any of the snapshots can be made writable, and then snapshots can be taken of the newly writable snapshots. These snapshots can also be used for restore. ã  XIV Consistency Groups - A XIV Consistency Group is a group of volumes of which a snapshot can be made at the same point in time, thus helping to ensure a consistent image of all volumes within the group at that time. IBM Tivoli Storage FlashCopy Manager (FCM) uses the copy services capabilities of intelligent storage subsystems to create point-in-time copies. These are application-aware copies (FlashCopy   or snapshot) of the production data. These copies are then retained on disk as backup allowing for a fast restore operation (Flashback). IBM Tivoli Storage FlashCopy Manager also allows mounting the copy on an auxiliary server (backup server) as a logical copy. This copy (instead of the srcinal data on the production server) is made accessible for further processing including disk to tape backup by Tivoli Storage Manager. FCM highlights include: -  No load on production server by the backup process -  Short database backup window -  Supports disk and/or tape media -  Balancing of tape workload -  Snapshot/Flash Restore -  Consistent process and user interface for tape/disk restore When a tape backup is required, for long term archival for example,   Tivoli Storage Manager (TSM),   IBM/Tivoli’s central backup/restore facility should be used. TSM includes very powerful storage management functionality: all data are stored in storage pools, according to policies. Storage pools can be any type of disk, optical, or tape storage. INTENDED AUDIENCE The intended audience of this paper is any Technical Lead, System Administrator, Storage  Administrator, or Oracle DBA in a production environment that wants some guidance on the best practices for performing backups and restores of Oracle Database with IBM Tivoli FlashCopy Manager and IBM XIV Storage System.
Recommended
View more...
We Need Your Support
Thank you for visiting our website and your interest in our free products and services. We are nonprofit website to share and download documents. To the running of this website, we need your help to support us.

Thanks to everyone for your continued support.

No, Thanks