Sign in  |  Register
Advanced search
Publication Cover

CITATION

Freeman, Robert and Hart, Matthew. Oracle RMAN 11g Backup and Recovery. US: McGraw-Hill Osborne Media, 2010.

Oracle RMAN 11g Backup and Recovery

Authors: Robert Freeman and Matthew Hart

Published:  April 2010

eISBN: 9780071628617 0071628614 | ISBN: 9780071628600
Open eBook
  • Contents
  • Acknowledgments
  • Introduction
  • Part I: Getting Started with RMAN in Oracle Database 11g
  • 1 Oracle Database 11g Backup and Recovery Architecture Tour
  • Backup and Recovery Essentials
  • A Few Oracle Terms to Know
  • Controlling the Database Software
  • Oracle Architecture
  • Oracle Memory and RMAN
  • More About the Oracle Redo Logs
  • The Combined Picture
  • Oracle Backup and Recovery Primer
  • Summary
  • 2 Introduction to the RMAN Architecture
  • Server-Managed Recovery
  • The RMAN Utility
  • The Network Topology of RMAN Backups
  • The Database Control File
  • The RMAN Server Processes
  • The SYS Packages Used by RMAN
  • Backing Up the Data Block
  • RMAN in Memory
  • The Recovery Catalog
  • The Auxiliary Database
  • Compatibility Issues
  • The RMAN Process: From Start to Finish
  • The Flash Recovery Area
  • Summary
  • Part II: Setup Principles and Practices
  • 3 RMAN Setup and Configuration
  • Configuring Your Database to Run in ARCHIVELOG Mode
  • The Oracle Database 11g Fault Diagnosability Infrastructure
  • The RMAN Command Line
  • Configuring the Database for RMAN Operations
  • Configuring RMAN Default Settings
  • Summary of RMAN Configuration Tasks
  • Other Backup and Recovery Setup and Configuration Considerations
  • Summary
  • 4 Media Management Considerations
  • Tape Backups in a Disk Backup World
  • RMAN and the Media Manager: An Overview
  • The SBT API
  • Back Up to Tape: From Start to Finish
  • Restore from Tape: From Start to Finish
  • Using sbttest and loadsbt.exe
  • Media Management Errors
  • Summary
  • 5 Oracle Secure Backup
  • Features of Oracle Secure Backup
  • Oracle Secure Backup Interfaces
  • Oracle Secure Backup Components
  • Installing and Configuring Oracle Secure Backup
  • Oracle Database and File System Data Backup Using Oracle Secure Backup
  • Oracle Database Backup Using Oracle Secure Backup Cloud Module
  • Summary
  • 6 Backing Up to Amazon Web Services Using the Oracle Secure Backup Cloud Module
  • Conventional Backups: Assumptions and Limitations
  • The Oracle Secure Backup Cloud Module
  • What Is Cloud Computing?
  • Oracle and the Amazon Cloud
  • Oracle Cloud Backup Advantages
  • Performing Backups by Using the OSB Cloud Module
  • Licensing Considerations
  • Summary
  • 7 Enhancing RMAN with VERITAS NetBackup™ for Oracle
  • Key Features
  • Necessary Components
  • Storage/Media Device Configuration
  • NetBackup Installation
  • How to Link Oracle to NetBackup Media Manager
  • Architecture
  • Configuring NetBackup Policies
  • Managing Expired Backup Images
  • RMAN Sample Scripts
  • Troubleshooting
  • Security Best Practices
  • Cost Justification
  • Summary
  • 8 Configuring HP Data Protector for Oracle
  • Integration of Oracle and Data Protector
  • RMAN Backup Configuration on Data Protector
  • RMAN Backup
  • Restoring Oracle Using the Data Protector GUI
  • Oracle RMAN Metadata and Data Protector Media Management Database Synchronization
  • Summary
  • 9 RMAN and Tivoli Storage Manager
  • Overview of Tivoli Storage Manager
  • Performing an RMAN Backup Using TDPO
  • Deleting Database Backups
  • Troubleshooting Common Backup Scenarios
  • Additional Troubleshooting
  • Summary
  • 10 Using the Recovery Catalog
  • What Is the Recovery Catalog?
  • Merging Multiple Recovery Catalogs
  • Recovery Catalog Maintenance
  • Backing Up the Recovery Catalog
  • Recovery Catalog Views
  • 11 RMAN Backups
  • Benefits of RMAN Backups vs. Scripted Backups
  • RMAN Compatibility Issues
  • Monitoring RMAN Backup Status
  • Offline RMAN Database Backups
  • Backup Command Options
  • Introducing the set Command
  • Online RMAN Database Backups
  • Copies
  • Incremental RMAN Backups
  • Getting Started
  • Summary
  • 12 RMAN Restore and Recovery
  • RMAN Restore and Recovery Basics
  • Before You Can Restore the Database
  • Before RMAN Can Get Going
  • The restore and recover Commands
  • Restore and Recover the Database in NOARCHIVELOG Mode
  • Database Recoveries in ARCHIVELOG Mode
  • Recovering from Online Redo Log Loss
  • The Data Recovery Advisor
  • Summary
  • Part III: Using RMAN Effectively
  • 13 Using Oracle Enterprise Manager for Backup and Recovery
  • Oracle Enterprise Manager: The New Paradigm
  • Grid Control
  • Database Control
  • Configuring Backup Settings in Enterprise Manager
  • Configuring Recovery Settings
  • Configuring Recovery Catalogs in OEM
  • Database Backups from Enterprise Manager
  • Performing Recovery in Enterprise Manager
  • Backup Management and Reporting
  • Database Cloning from Enterprise Manager
  • Summary
  • 14 RMAN Advanced Recovery Topics
  • Incomplete Recoveries
  • Other RMAN Recovery Topics
  • Tablespace Point-In-Time Recovery
  • Verifying Your Backups Are Recoverable
  • Call the Movers! Cross-Platform Database Movement and RMAN
  • We Like to Move It! Move It!
  • Sometimes Things Just Go Wrong
  • Summary
  • 15 Surviving User Errors: Flashback Technologies
  • Prepared for the Inevitable: Flashback Technology
  • Flashback Query
  • Flashback Table
  • Flashback Transaction
  • Flashback Drop
  • Flashback Database
  • Flashback Data Archive (Total Recall)
  • Summary
  • 16 Maintaining RMAN
  • RMAN Maintenance
  • RMAN Stored Scripts
  • When You Just Can’t Take It Anymore
  • Summary
  • 17 Monitoring and Reporting on RMAN
  • The RMAN list Command
  • The RMAN report Command
  • Data Dictionary Views for Reporting
  • Summary
  • 18 Performance Tuning RMAN Backup and Recovery Operations
  • Before You Tune RMAN
  • Tuning RMAN
  • Tracing RMAN Sessions
  • Summary
  • Part IV: RMAN in the Oracle Ecosystem
  • 19 Duplication: Cloning the Target Database
  • RMAN Duplication: A Primer
  • Duplication: Location Considerations
  • Duplication to the Same Server
  • Duplication to a Remote Server
  • Target-Less Duplication in 11g
  • Summary
  • 20 RMAN and Data Guard
  • RMAN and the Standby Database
  • Taking Backups from the Standby Database
  • Summary
  • 21 RMAN and Real Application Clusters
  • Real Application Clusters: Unique Backup Challenges
  • RAC Recovery Challenges
  • Advanced RMAN/RAC Topics
  • Summary
  • 22 RMAN in Sync and Split Technology
  • Sync and Split: Broken Mirror Backups
  • Oracle Databases on Sync and Split Volumes
  • Benefits of the Split Mirror Backup
  • RMAN and Sync and Split
  • Oracle-Integrated Shadow Copy Services for Windows
  • Summary
  • 23 RMAN in the Workplace: Case Studies
  • Before the Recovery
  • Recovery Case Studies
  • Summary
  • Part V: Appendixes
  • A: RMAN Syntax Reference Guide
  • RMAN Reserved Words
  • RMAN Command List
  • RMAN Specifier and Operands Lists
  • RMAN Command List Syntax Details
  • RMAN Subclauses Syntax Details
  • B: RMAN Scripting Examples
  • RMAN Scripts for Windows
  • RMAN Scripts for Unix
  • C: Setting Up an RMAN Test Environment
  • The Test Box
  • The Oracle Configuration
  • The RMAN Configuration
  • Index