Backing Up Oracle Using Tivoli Storage Management

Book description

This IBM Redbooks publication is designed to assist Oracle Database administrators and system/storage administrators with Oracle backup solutions using Tivoli Storage Manager V4.1. The primary tool we used for backup and recovery is Tivoli Data Protection (TDP) for Oracle V1.1, and the book covers setup and configuration of TDP as well as day-to-day management examples. Operating environments covered by the project are AIX, Sun Solaris, and Microsoft Windows 2000. We provide an overview of relational database management systems and how to plan for protecting them.

This book will help you install, tailor, and configure Tivoli Storage Manager and Tivoli Data Protection for Oracle on UNIX and Microsoft Windows 2000 platforms in order to accomplish backup and restore of Oracle8i databases. RMAN commands and setup are covered in detail, and emphasis is placed on practical recovery scenarios.

Also featured are new solutions utilizing Tivoli's hardware integration features for IBM's ESS intelligent storage subsystem, as well as an update on using TDP for Oracle V2.2 new features.

Note: This book replaces relevant sections of the earlier book, Using ADSM to Back Up Databases, SG24-4335-03, by updating and re-branding the content of that book.

Table of contents

  1. Figures
  2. Tables
  3. Preface
    1. The team that wrote this redbook
    2. Comments welcome
  4. Part 1: Tivoli Storage Manager and database primer
    1. Chapter 1: Tivoli Storage Manager for database administrators
      1. Introducing Tivoli Storage Management
        1. Tivoli Storage Manager backup/archive client
        2. Tivoli Data Protection for Oracle
    2. Chapter 2: Overview of relational databases and the Oracle product
      1. Fundamentals of Relational Database Management Systems
        1. Databases
        2. Tables
        3. Indexes
        4. Tablespaces
        5. Partitioning options
        6. Log Files
        7. Control files
        8. Configuration parameters
      2. Oracle8i overview
        1. Instances
        2. Databases
        3. Tablespaces
        4. Datafiles
        5. Redo log
        6. Control files
        7. Initialization parameter files
        8. Password file
        9. Partitioning option
        10. Parallel server option
    3. Chapter 3: Planning considerations
      1. Backup requirements
        1. Types of events
        2. Speed of recovery
        3. Backup windows
        4. Recovery points
        5. Units of recovery
      2. Backup techniques (1/2)
      3. Backup techniques (2/2)
        1. Disk mirroring
        2. Offline backup
        3. Online backup
        4. Database export
        5. Full database backup
        6. Partial database backup
        7. Incremental backup
        8. Log file backup (simulated incremental)
        9. LAN-free backup
        10. Backup using split mirror features
        11. Backup of RDBMS supporting files
    4. Chapter 4: TSM server considerations
      1. Initial requirements
      2. Tivoli Storage Manager terminology
      3. Similarities between TSM and database software
      4. TSM server base functionality explained
        1. Registering a node with the TSM server
        2. Installing the TSM client
        3. Configuring the TSM client
      5. Managing data objects (1/2)
      6. Managing data objects (2/2)
        1. Archive or data object
        2. Description of data object
        3. Management class to bind object to
        4. Life cycle of TSM data objects
      7. TSM server considerations for Oracle backups
        1. How TDP for Oracle stores data objects
      8. Policy management considerations
        1. Domain considerations
        2. TSM management class considerations
        3. TSM client include-exclude option
      9. Node considerations
        1. Choosing a nodename
        2. Choosing a password
        3. Setting the BACKDELETE option
        4. Specifying the domain
        5. Setting the MAXNUMMP
      10. Storage pool considerations
      11. Our TSM server setup
  5. Part 2: TDP for Oracle on the UNIX platforms
    1. Chapter 5: Configuration and setup of TDP for Oracle on UNIX
      1. TDP for Oracle
        1. Install TDP for Oracle
        2. Define environment variables
        3. Edit the client options files
        4. Registering with the TSM server
        5. Initialize the password
        6. Setting up RMAN
    2. Chapter 6: Oracle backup considerations on UNIX
      1. RMAN: Oracle’s Recovery Manager
        1. RMAN system components
      2. Creating a database for the RMAN catalog
        1. Creating the RMAN catalog
        2. Registering the target database
      3. Back up the database using TDP for Oracle and RMAN
        1. Full backup
        2. Whole database backup
        3. Incremental backup
        4. Image copies
      4. Backup examples (1/2)
      5. Backup examples (2/2)
        1. Consistent whole database backup
        2. Archived redo log backup
        3. Incremental level 0 backup
    3. Chapter 7: Day-to-day monitoring of Oracle backups on UNIX
      1. Automating database tasks
        1. Starting SQL*Net and RDBMS services at system reboot
        2. Automating RMAN backups
      2. RMAN report, list, and crosscheck utilities (1/2)
      3. RMAN report, list, and crosscheck utilities (2/2)
        1. Report utility
        2. List utility
        3. Crosscheck utility
      4. Automatic deletion of old backups
      5. List objects in the TSM database
    4. Chapter 8: Recovering Oracle Databases on UNIX
      1. Restore operations
        1. Consistent database recovery
        2. Inconsistent database recovery
      2. Recovery Operation
      3. Recovery examples (1/2)
      4. Recovery examples (2/2)
        1. Datafile recovery
        2. Complete recovery
        3. Incomplete recovery
        4. Duplicate database
  6. Part 3: TDP for Oracle on Windows 2000
    1. Chapter 9: Installation of TSM software on Windows 2000
      1. Registering a node on the TSM Server for TDP for Oracle backups
      2. Stopping Oracle services
      3. Installing TDP for Oracle for Windows (1/2)
      4. Installing TDP for Oracle for Windows (2/2)
      5. Configuring the TDP for Oracle client options file
      6. Generating the encrypted password
      7. Verify a TDP for Oracle for Windows RMAN backup (1/2)
      8. Verify a TDP for Oracle for Windows RMAN backup (2/2)
        1. Starting RMAN from a command prompt
        2. Viewing the orcagent.log
        3. Listing the backup piece from RMAN
        4. Where the backup is stored on the TSM server
        5. Viewing the backup object in greater detail
        6. Deleting the backup piece from RMAN
      9. Installing the TSM backup-archive client (1/3)
      10. Installing the TSM backup-archive client (2/3)
      11. Installing the TSM backup-archive client (3/3)
        1. Registering a node with the TSM server
        2. Installing the TSM backup-archive client
        3. Configuring the backup-archive client options file (dsm.opt)
    2. Chapter 10: Oracle backup considerations on Windows 2000
      1. RMAN: Oracle Recovery Manager
        1. RMAN system components
        2. Create the RMAN catalog
        3. Registering the target database
      2. Back up the database using TDP for Oracle and RMAN
        1. Full backup
        2. Whole database backup
        3. Incremental backup
        4. Image copies
      3. Backup examples
        1. Consistent whole database backup
        2. Archived redo log backup
        3. Incremental level 0 backup
      4. File level backup using TSM
    3. Chapter 11: Day-to-day monitoring on Windows 2000
      1. Automating database tasks
        1. Starting SQL*Net and RDBMS services at system reboot
      2. Automating RMAN backups
        1. Scheduling TDP for Oracle backups
      3. RMAN report, list, and crosscheck utilities (1/2)
      4. RMAN report, list, and crosscheck utilities (2/2)
        1. Report utility
        2. List utility
        3. Crosscheck utility
      5. Automatic deletion of old backups
        1. Command files to automate backup deletion
        2. Using tags to help with deletion
    4. Chapter 12: Recovering Oracle databases on Windows 2000
      1. Restore operations
        1. Consistent database recovery
        2. Inconsistent database recovery
      2. Recovery Operation
      3. Recovery examples (1/2)
      4. Recovery examples (2/2)
        1. Data file recovery
        2. Complete recovery
        3. Incomplete / partial disaster recovery
        4. Duplicate database
  7. Appendix A: Quick-start checklist for configuration
  8. Appendix B: Troubleshooting
    1. B.1: “Gotchas”
      1. RC 406 options file not found
      2. Checking the library files
      3. Running a TSM CONFIG trace
      4. RC 137 authentication failure, incorrect password
    2. B.2: Things to check on the TSM server
      1. Specifying commtimeout in the dsmserv.opt
      2. Administrative client queries
    3. B.3: Isolating the problem
    4. B.4: List of logfiles
    5. B.5: Inconsistencies between Oracle RMAN and TSM
      1. RMAN references a non-existent TSM object
      2. TSM object exists without a corresponding RMAN reference
      3. Renaming / deleting the TSM filespace
  9. Appendix C: TDP for Oracle Version 2.2
    1. C.1: New features
      1. TDPO.OPT file
      2. Duplex copy (Oracle 8.1.x only)
      3. Configuration utility (TDPOCONF)
      4. Synchronization utility (TDPOSYNC)
      5. Multi-buffering of data transfers
      6. LAN-free data movement
      7. Migration and coexistence
    2. C.2: Configuration and setup on UNIX
      1. Installing TDP for Oracle
      2. Edit the TDP for Oracle options file
      3. Registering with TSM server
      4. Initializing the password
      5. Validating the setup
    3. C.3: Using the new features
      1. Multi-buffering
      2. Duplex copy function
      3. TDPOSync
  10. Appendix D: Performance
    1. D.1: Generic performance issues
      1. TSM and TDP generic performance issues
      2. RMAN performance options
    2. D.2: TDP for Oracle Version 2.1.10
      1. TDP for Oracle Version 2.2.0
  11. Appendix E: TDP for IBM ESS for Oracle databases
    1. E.1: IBM ESS FlashCopy
    2. E.2: Overview of TDP for ESS
    3. E.3: Our lab setup and experiences
      1. Setup and configuration
      2. Backing up the database using TDP for ESS
      3. TDP for ESS testing
      4. Summary
  12. Appendix F: TDP for Oracle using TSM LAN-free setup
    1. F.1: TSM configuration for LAN-free setup
      1. Define new management class for LAN-free backups
      2. Download and install TSM Storage Agent
      3. Modify dsmsta.opt
      4. Check adsmscsi
      5. Define drive mappings
      6. Define server for storage agent on TSM server
      7. Run dsmsta setstorageserver on storage agent
      8. install storage agent as service
      9. Specify enablelanfree in client options file (dsm.opt)
    2. F.2: Running a backup and verifying that LAN-free setup is working
    3. F.3: Additional considerations
  13. Appendix G: Using the additional material
    1. G.1: Locating the additional material on the Internet
    2. G.2: Using the Web material
      1. System requirements for downloading the Web material
      2. How to use the Web material
  14. Appendix H: Special notices
  15. Appendix I: Related publications
    1. I.1: IBM Redbooks
    2. I.2: IBM Redbooks collections
    3. I.3: Other resources
    4. I.4: Referenced Web sites
  16. How to get IBM Redbooks
    1. IBM Redbooks fax order form
  17. Abbreviations and acronyms
  18. Index
  19. IBM Redbooks review (1/2)
  20. IBM Redbooks review (2/2)

Product information

  • Title: Backing Up Oracle Using Tivoli Storage Management
  • Author(s): Deirdre Hewgill, Art Balingit, Martin Bruegger, Wolfgang Postl, James Thompson
  • Release date: October 2001
  • Publisher(s): IBM Redbooks
  • ISBN: 9780738421858