Asm Flashcopy10g

Please download to get full document.

View again

of 37
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: 3 | Pages: 37

Extension: PDF | Download: 0

Share
Related documents
Description
ffgfgfgfgf
Tags
Transcript
  ........   © Copyright IBM Corporation, 2007. All Rights Reserved. All trademarks or registered trademarks mentioned herein are the property of their respective holders   Oracle 10 g   R2 with Automatic Storage Management and IBM System Storage FlashCopy Backup and Recovery Procedures  Pat Blaney  IBM Oracle International Competency Center  Erik Salander  IBM Oracle International Competency Center  May 2007    Oracle 10 g   R2 with ASM and IBM System Storage FlashCopy Backup and Recovery Procedures http://www.ibm.com/support/techdocs © Copyright 2007, IBM Corporation Table of contents Change history............................................................................................................................1   Abstract........................................................................................................................................2   Introduction.................................................................................................................................2    Acknowledgements..................................................................................................................................2   Technologies............................................................................................................................................3   1. Software Installation...............................................................................................................5   2. Database setup........................................................................................................................6   Production Server – Database Creation and Configuration....................................................................7   Backup Server – Preparation of Database and ASM..............................................................................9   3. TSM Configuration................................................................................................................10   Backup-Archive Client Configuration.....................................................................................................10   TSM Server Configuration.....................................................................................................................11   Data Protection for Oracle Configuration...............................................................................................12   4. Initial FlashCopy and Database Backup.............................................................................13   Production Server – Create Base FlashCopy of the Volumes..............................................................13   Backup Server – Perform the Backup...................................................................................................18   5. Ongoing FlashCopy and Database Backup........................................................................21   Production Server – Incremental FlashCopy of the Volumes................................................................21   Backup Server – Perform the Backup...................................................................................................23   6. Database Recovery...............................................................................................................23   Summary....................................................................................................................................25   Appendix 1: Resources............................................................................................................26   Appendix 2: Using the Backup-Archive Client.......................................................................27   Appendix 3: Creating pfiles from spfiles ................................................................................30   Appendix 4: RMAN Stored Scripts ..........................................................................................31   Appendix 5: Swingbench on AIX.............................................................................................32   About the Authors.....................................................................................................................33   Trademarks and special notices..............................................................................................34      Oracle 10 g   R2 with ASM and IBM System Storage FlashCopy Backup and Recovery Procedures http://www.ibm.com/support/techdocs © Copyright 2007, IBM Corporation 1 Change history Version Date Editor   Editing d escription 1. 0   05/10/07  Patrick Moore Original Version    Oracle 10 g   R2 with ASM and IBM System Storage FlashCopy Backup and Recovery Procedures http://www.ibm.com/support/techdocs © Copyright 2007, IBM Corporation 2 Abstract This document describes a procedure using IBM System Storage™ FlashCopy to facilitate backup and recovery of an Oracle 10g R2 database using Automatic Storage Management.   Introduction The purpose of this white paper is to document the procedures necessary for an end-to-end backup and recovery solution of an Oracle 10 g   R2 database according to these criteria: 1. The database implements disk sharing using Automatic Storage Management (ASM). 2. The FlashCopy capability of the IBM System Storage DS6000™ or DS8000™ is utilized to make a point-in-time copy of the production database volumes. 3. The combination of Oracle Recovery Manager (RMAN) and IBM Tivoli® Storage Manager products implement the backup and recovery of the database. a. Full backups will be made to tape without shutting down the Production database. b. The Archive Logs will be backed up as well as the datafiles. c. Backups can be made whenever a new Archive Log is created or as frequent as database activity dictates. 4. The Database point-in-time recovery (DBPITR) will be performed from tape, back to the Production server. NOTE : Some of the configuration details in this document may not be well suited for other scenarios such as point-in-time restore from the FlashCopy. The general outline of this document is as follows: 1. Install the software: AIX®, Oracle Database, IBM Tivoli Storage Manager Server, Data Protection for Oracle, Backup-Archive Clients and the DS6800 command line interface (dscli). 2. Create and Configure the database. 3. Configure TSM. 4. FlashCopy the volumes and backup the database. This step is performed on a regular basis (eg. daily). 5. Recover the database. Steps 1-3 will be summarized, while steps 4 and 5 will be documented in detail. Throughout this document, the IBM Tivoli Storage Manager for Databases: Data Protection for Oracle  product will be referred to as Data Protection for Oracle . The IBM Tivoli Storage Manager Backup- Archive Client for AIX   will be referred to as the BA Client  . Acknowledgements Thanks to the following for their support and assistance on this project: Jaymin Yon of Oracle Solutions,  Advanced Technical Support; Neil Rasmussen of IBM Software Group – Tivoli Data Protection for Oracle; Betty Lee and Kathryn Arrell of the IBM Oracle International Competency Center.
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