Oracle RMAN 11g Backup and Recovery

Oracle RMAN 11g Backup and Recovery

by Robert Freeman, Matthew Hart
Released May 2010
Publisher(s): McGraw Hill Computing
ISBN: 9780071628617

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

Master Oracle Recovery Master

Protect your databases from hardware, software, and operator failures using the detailed information in this Oracle Press guide. Oracle RMAN 11g Backup and Recovery explains how to configure databases, generate accurate archives, and carry out system restores. Work from the command line or Oracle Enterprise Manager, automate the backup process, perform Oracle Flashback recoveries, and integrate cloud computing technology. This authoritative resource also shows you how to create reports, optimize performance, and implement third-party administration utilities.

  • Set up, configure, and maintain Oracle Recovery Manager (Oracle RMAN)
  • Manage physical and virtual media with Oracle Secure Backup
  • Work with Oracle RMAN catalogs, packages, and control files
  • Use the Amazon Web Services cloud as an offsite storage solution
  • Create online, offline, and incremental system backups
  • Perform full and partial Oracle RMAN database restores
  • Correct user-induced errors with Oracle Flashback
  • Product clone and standby databases on local or remote servers
  • Use Oracle Real Application Clusters and synch and split technology

For a complete list of Oracle Press titles, visit www.OraclePressBooks.com

Table of contents

  1. Cover Page
  2. Oracle RMAN 11g Backup and Recovery
  3. Copyright Page
  4. Contents
  5. Acknowledgments
  6. Introduction
  7. PART I Getting Started with RMAN in Oracle Database 11g
    1. 1 Oracle Database 11g Backup and Recovery Architecture Tour
      1. Backup and Recovery Essentials
        1. High Availability
        2. Backup and Recovery
      2. A Few Oracle Terms to Know
      3. Controlling the Database Software
      4. Oracle Architecture
        1. The Oracle Processes
      5. Oracle Memory and RMAN
        1. The Oracle Database
      6. More About the Oracle Redo Logs
        1. ARCHIVELOG Mode vs. NOARCHIVELOG Mode
        2. Oracle Logical Structures
      7. The Combined Picture
        1. Startup and Shutdown of the Database
        2. Using the Database and Internals
      8. Oracle Backup and Recovery Primer
        1. Logical Backup and Recovery
        2. Oracle Physical Backup and Recovery
        3. Backing Up Other Oracle Components
      9. Summary
    2. 2 Introduction to the RMAN Architecture
      1. Server-Managed Recovery
      2. The RMAN Utility
        1. RMAN and Database Privileges
      3. The Network Topology of RMAN Backups
        1. Running RMAN Remotely
        2. Running RMAN Locally from the Target Database’s ORACLE_HOME
      4. The Database Control File
        1. Record Reuse in the Control File
        2. The Snapshot Control File
      5. The RMAN Server Processes
        1. RMAN Channel Processes
      6. The SYS Packages Used by RMAN
        1. SYS.DBMS_RCVMAN
        2. SYS.DBMS_BACKUP_RESTORE
      7. Backing Up the Data Block
        1. The Data Block Backup Overview
        2. The Benefits of Block-Level Backups
      8. RMAN in Memory
        1. Input Memory Buffers
        2. RMAN Memory Utilization: PGA vs. SGA
      9. The Recovery Catalog
      10. The Auxiliary Database
      11. Compatibility Issues
        1. The Target and the RMAN Executable
        2. The Catalog Database and Catalog Schema
        3. The Auxiliary Database
      12. The RMAN Process: From Start to Finish
      13. The Flash Recovery Area
      14. Summary
  8. PART II Setup Principles and Practices
    1. 3 RMAN Setup and Configuration
      1. Configuring Your Database to Run in ARCHIVELOG Mode
        1. ARCHIVELOG Destination Directories
        2. The Flash Recovery Area
        3. Should You Use the FRA?
        4. Switching Between ARCHIVELOG Modes
        5. If You Created Your Database with the Oracle Database Configuration Assistant
        6. RMAN Workshop: Put the Database in ARCHIVELOG Mode
      2. The Oracle Database 11g Fault Diagnosability Infrastructure
      3. The RMAN Command Line
        1. Connecting via the RMAN Command Line
        2. RMAN Client Compatibility
        3. Using the RMAN connect Command
        4. Exiting the RMAN Client
      4. Configuring the Database for RMAN Operations
        1. Setting Up the Database User
        2. RMAN Workshop: Create the Target Database RMAN Backup Account
        3. Setting Up Database Security
        4. Setting the CONTROL_FILE_RECORD_KEEP_TIME Parameter
      5. Configuring RMAN Default Settings
        1. Introducing the configure Command
        2. Configuring Various RMAN Default Settings
        3. Examples of Using the configure Command
        4. If You Are Using Shared Servers
      6. Summary of RMAN Configuration Tasks
      7. Other Backup and Recovery Setup and Configuration Considerations
      8. Summary
    2. 4 Media Management Considerations
      1. Tape Backups in a Disk Backup World
      2. RMAN and the Media Manager: An Overview
        1. The Media Manager Catalog
        2. The Media Manager: Other Software Components
        3. Media Management Library
        4. RMAN Workshop: Test Tape Channels with the Oracle Default SBT Interface
        5. Interfacing with the MML
      3. The SBT API
      4. Back Up to Tape: From Start to Finish
      5. Restore from Tape: From Start to Finish
      6. Using sbttest and loadsbt.exe
      7. Media Management Errors
      8. Summary
    3. 5 Oracle Secure Backup
      1. Features of Oracle Secure Backup
        1. Oracle Secure Backup and Recovery Manager
        2. Differences Between OSB and OSB Express
        3. Backup Encryption
        4. Fast Database Backup Compression
        5. Oracle Secure Backup Cloud Module
      2. Oracle Secure Backup Interfaces
      3. Oracle Secure Backup Components
        1. Oracle Secure Backup Daemons
        2. Host Access Modes
        3. Administrative Data
        4. Oracle Secure Backup Users and Classes
        5. Operating System Accounts
        6. NDMP Hosts
        7. Oracle Secure Backup Rights and Classes
      4. Installing and Configuring Oracle Secure Backup
        1. RMAN Workshop: Install and Configure Oracle Secure Backup
      5. Oracle Database and File System Data Backup Using Oracle Secure Backup
        1. RMAN Workshop: Schedule Oracle Database and File System Data Backups
      6. Oracle Database Backup Using Oracle Secure Backup Cloud Module
        1. RMAN Workshop: Installing OSB Cloud Module and Using It for OSB Backups
      7. Summary
    4. 6 Backing Up to Amazon Web Services Using the Oracle Secure Backup Cloud Module
      1. Conventional Backups: Assumptions and Limitations
      2. The Oracle Secure Backup Cloud Module
      3. What Is Cloud Computing?
      4. Oracle and the Amazon Cloud
        1. Elastic Compute Cloud (EC2) and Elastic Block Store (EBS)
        2. Simple Storage Service (S3)—Oracle’s Cloud Backup Solution
        3. RMAN Backup to S3: The Oracle Secure Backup Cloud Module
        4. S3 Backup over the Internet or from Amazon EC2
      5. Oracle Cloud Backup Advantages
        1. RMAN Workshop: Deploying RMAN Backups to Amazon S3
      6. Performing Backups by Using the OSB Cloud Module
        1. Listing RMAN Backups and Backup Sets Stored on S3
        2. Optimizing Backups and Recoveries over the Internet Using the OSB Cloud Module and Amazon S3
      7. Licensing Considerations
      8. Summary
    5. 7 Enhancing RMAN with VERITAS NetBackup
      1. Key Features
      2. Necessary Components
      3. Storage/Media Device Configuration
      4. NetBackup Installation
        1. Pre-Installation Tasks for NetBackup for Oracle Agent
        2. NetBackup for Oracle Agent Installation Steps
      5. How to Link Oracle to NetBackup Media Manager
        1. Automatic Link Method
        2. Manual Link Method
      6. Architecture
      7. Configuring NetBackup Policies
        1. Adding New Policies
        2. Defining Schedules
        3. Defining a Backup Selection
        4. Defining Policy Clients
      8. Managing Expired Backup Images
        1. Delete Expired Backups Using NetBackup Repository
        2. Delete Expired Backups Using RMAN
      9. RMAN Sample Scripts
      10. Troubleshooting
        1. Use NetBackup Logs
        2. Determine Which Library Is in Use
      11. Security Best Practices
      12. Cost Justification
      13. Summary
    6. 8 Configuring HP Data Protector for Oracle
      1. Integration of Oracle and Data Protector
        1. Support Matrix
        2. Integration Components
        3. RMAN Workshop: Integration Configuration
      2. RMAN Backup Configuration on Data Protector
        1. RMAN Workshop: Backup Configuration
        2. Editing the Oracle RMAN Script
      3. RMAN Backup
        1. Backup Methods
        2. Backup Procedure
      4. Restoring Oracle Using the Data Protector GUI
        1. Restoring the Control File
        2. Restoring Oracle Database Objects
      5. Oracle RMAN Metadata and Data Protector Media Management Database Synchronization
      6. Summary
    7. 9 RMAN and Tivoli Storage Manager
      1. Overview of Tivoli Storage Manager
        1. TSM Server System Objects
        2. TSM Client
        3. TSM Administration Center and Web Client
        4. RMAN Workshop: Configuring TDPO for Oracle
      2. Performing an RMAN Backup Using TDPO
      3. Deleting Database Backups
      4. Troubleshooting Common Backup Scenarios
      5. Additional Troubleshooting
      6. Summary
    8. 10 Using the Recovery Catalog
      1. What Is the Recovery Catalog?
        1. Creating the Recovery Catalog
        2. RMAN Workshop: Create the Recovery Catalog User Account
        3. RMAN Workshop: Create the Recovery Catalog
        4. RMAN Workshop: Register Your Database in the Recovery Catalog
        5. Utilizing a Virtual Private Catalog
        6. RMAN Workshop: Create a Virtual Private Catalog
      2. Merging Multiple Recovery Catalogs
        1. RMAN Workshop: Merge Two Recovery Catalogs
      3. Recovery Catalog Maintenance
        1. Unregistering a Database in RMAN
        2. Database Migration/Upgrade Issues
        3. Manually Resetting the Database Incarnation (reset catalog)
        4. Manually Resynchronizing the Recovery Catalog (resync catalog)
        5. Purging Recovery Catalog Records
      4. Backing Up the Recovery Catalog
      5. Recovery Catalog Views
        1. RC_ARCHIVED_LOG (V$ARCHIVED_LOG)
        2. RC_BACKUP_CONTROLFILE (V$BACKUP_DATAFILE)
        3. RC_BACKUP_CORRUPTION (V$BACKUP_CORRUPTION)
        4. RC_BACKUP_DATAFILE (V$BACKUP_DATAFILE)
        5. RC_BACKUP_FILES (V$BACKUP_FILES)
        6. RC_BACKUP_PIECE (V$BACKUP_PIECE)
        7. RC_BACKUP_REDOLOG (V$BACKUP_REDOLOG)
        8. RC_BACKUP_SET (V$BACKUP_SET)
        9. RC_BACKUP_SPFILE (V$BACKUP_SPFILE)
        10. RC_CONTROLFILE_COPY (V$DATAFILE_COPY)
        11. RC_COPY_CORRUPTION (V$COPY_CORRUPTION)
        12. RC_DATABASE (V$DATABASE)
        13. RC_DATABASE_BLOCK_CORRUPTION (V$DATABASE_BLOCK_CORRUPTION)
        14. DATABASE_INCARNATION (V$DATABASE_INCARNATION)
        15. RC_DATAFILE (V$DATAFILE)
        16. RC_DATAFILE_COPY (V$DATAFILE_COPY)
        17. RC_LOG_HISTORY (V$LOG_HISTORY)
        18. RC_OFFLINE_RANGE (V$OFFLINE_RANGE)
        19. RC_REDO_LOG (V$LOG, V$LOGFILE)
        20. RC_REDO_THREAD (V$THREAD)
        21. RC_RESYNC
        22. RC_RMAN_CONFIGURATION (V$RMAN_CONFIGURATION)
        23. RC_TABLESPACE (V$TABLESPACE)
        24. RC_TEMPFILE (V$TEMPFILE)
        25. Catalog Views Intended for Use by Oracle Enterprise Manager
    9. 11 RMAN Backups
      1. Benefits of RMAN Backups vs. Scripted Backups
      2. RMAN Compatibility Issues
      3. Monitoring RMAN Backup Status
      4. Offline RMAN Database Backups
        1. Offline Backups Using Default Settings
        2. RMAN Workshop: Do an Offline Backup
        3. Offline Backups Without Using Configured Defaults
      5. Backup Command Options
        1. Multisection Backups
        2. Compression
        3. Tags and Restore Points
        4. Limiting Backup Impacts
        5. Limiting the Size of a Backup Set
        6. Backing Up to a Specific Device Type
        7. Modifying the Retention Policy for a Backup Set
        8. Archive Log Deletion Policies
        9. Overriding the configure exclude Command
        10. Checking the Database for Errors with the backup Command
        11. Skipping Offline, Inaccessible, or Read-Only Datafiles
        12. Forcing a Backup of Read-Only Datafiles
        13. Backing Up Datafiles Based on Their Last Backup Time
        14. Making Copies of Backups on Your RMAN Copier
        15. Capturing the Elusive Control File
      6. Introducing the set Command
      7. Online RMAN Database Backups
        1. Online Database Backups
        2. RMAN Workshop: Do an Online Backup
        3. Tablespace Backups
        4. Datafile Backups
        5. Archived Redo Log Backups
        6. Control File and Parameter File Backups
        7. Backup Set Backups
        8. Flash Recovery Area Backups
      8. Copies
        1. Introducing Image Copies
        2. Database, Tablespace, and Datafile Image Copies
        3. Control File Copies
        4. ARCHIVELOG Image Copies
      9. Incremental RMAN Backups
        1. The Block Change Tracking File
        2. The Base Backup
        3. Differential vs. Cumulative Incremental Backups
        4. RMAN Workshop: Do an Incremental Backup
      10. Getting Started
        1. RMAN Workshop: Get Your Database Backed Up!
      11. Summary
    10. 12 RMAN Restore and Recovery
      1. RMAN Restore and Recovery Basics
      2. Before You Can Restore the Database
      3. Before RMAN Can Get Going
        1. A Note about Recoveries, the Recovery Catalog, and the MML Layer
        2. Restoring the SPFILE
        3. Restoring the Control File
        4. Recovering the Control File from an Autobackup Using RMAN and the FRA
        5. RMAN Workshop: Recover Your Control File
      4. The restore and recover Commands
        1. The restore Command
        2. The recover Command
      5. Restore and Recover the Database in NOARCHIVELOG Mode
        1. Preparing for the Restore
        2. Restoring to a Different Location
        3. RMAN Workshop: Recover Your NOARCHIVELOG Mode Database
      6. Database Recoveries in ARCHIVELOG Mode
        1. Point-of-Failure Database Recoveries
        2. RMAN Workshop: Complete Recovery of Your ARCHIVELOG Mode Database
        3. Tablespace Recoveries
        4. Datafile Recoveries
        5. What If I Use Incremental Backups?
      7. Recovering from Online Redo Log Loss
        1. Loss of an Inactive Online Redo Log Group Member
        2. Loss of an Inactive Online Redo Log Group
        3. Loss of an Active but Not Current Online Redo Log Group
        4. Loss of the Current Online Redo Log Group
      8. The Data Recovery Advisor
        1. Using the Data Recovery Advisor Through RMAN
      9. Summary
  9. PART III Using RMAN Effectively
    1. 13 Using Oracle Enterprise Manager for Backup and Recovery
      1. Oracle Enterprise Manager: The New Paradigm
      2. Grid Control
        1. The Grid Control Architecture
        2. Installing and Configuring Grid Control
      3. Database Control
        1. The Database Control Architecture
        2. Installing and Configuring Database Control
        3. Using Enterprise Manager Configuration Assistant to Configure Database Control
        4. RMAN Workshop: Configure Database Control Using emca
      4. Configuring Backup Settings in Enterprise Manager
        1. Device Configuration
        2. Backup Set Configuration
        3. Policy Settings
        4. What Is Missing from OEM’s Backup Configuration?
        5. RMAN Workshop: Configure Backup Settings in OEM
      5. Configuring Recovery Settings
        1. Instance Recovery
        2. Media Recovery
        3. Flash Recovery
        4. RMAN Workshop: Configure Recovery Settings in OEM
      6. Configuring Recovery Catalogs in OEM
        1. RMAN Workshop: Register the Recovery Catalog with OEM
        2. Related Links for Recovery Catalog Settings
      7. Database Backups from Enterprise Manager
        1. Oracle-Suggested Backup Strategy
        2. Scheduling a Customized Backup
        3. RMAN Script Job vs. Scheduled Backup Wizard
        4. RMAN Workshop: Create an RMAN Script Job in OEM
      8. Performing Recovery in Enterprise Manager
        1. Data Recovery Advisor and the OEM Checkers
        2. User Directed Recovery
        3. RMAN Workshop: Perform Database Recovery from OEM
      9. Backup Management and Reporting
        1. Managing Current Backups
        2. Managing Restore Points
        3. Creating Backup Reports
      10. Database Cloning from Enterprise Manager
      11. Summary
    2. 14 RMAN Advanced Recovery Topics
      1. Incomplete Recoveries
        1. Using the resetlogs Command
        2. Establishing a Point to Recover To
        3. Time-Based Recovery
        4. SCN-Based Recovery
        5. Log Sequence–Based Recovery
        6. Cancel-Based Recovery
        7. Recovery Using Restore Points
      2. Other RMAN Recovery Topics
        1. Read-Only Tablespace Recovery Considerations
        2. Archived Redo Log Restores
        3. Datafile Copy Restores
        4. Recovering Corrupted Data Blocks
        5. Recovering to a Previous Incarnation
      3. Tablespace Point-In-Time Recovery
        1. Performing Automated TSPITR
        2. Manual TSPITR
        3. TSPITR Restrictions
      4. Verifying Your Backups Are Recoverable
        1. The restore preview Command
        2. Restoring with the validate and check logical Commands
        3. Using the validate backupset Command
      5. Call the Movers! Cross-Platform Database Movement and RMAN
        1. Introduction to Cross-Platform Transportable Tablespaces
        2. Byte Ordering and Datafile Conversion
      6. We Like to Move It! Move It!
      7. Sometimes Things Just Go Wrong
      8. Summary
    3. 15 Surviving User Errors: Flashback Technologies
      1. Prepared for the Inevitable: Flashback Technology
      2. Flashback Query
        1. Flashback and the Undo Segment: A Love Story
        2. Performing Flashback Query
        3. Flashback Versions Query with Oracle Enterprise Manager
        4. RMAN Workshop: Explore Flashback Versions Query
      3. Flashback Table
        1. Performing the Flashback Table Operation from SQL
        2. Flashback Table with Oracle Enterprise Manager
        3. RMAN Workshop: Explore Flashback Table
      4. Flashback Transaction
        1. RMAN Workshop: Utilize Flashback Transaction from Enterprise Manager
      5. Flashback Drop
        1. The Recycle Bin
        2. RMAN Workshop: Explore Flashback Drop and the Recycle Bin
      6. Flashback Database
        1. Flashback Logs
        2. Flashback Retention Target
        3. RMAN Workshop: Configure for Flashback Database
        4. Flashback Database: Tuning and Tweaking
        5. RMAN Workshop: Perform Flashback Database
      7. Flashback Data Archive (Total Recall)
        1. RMAN Workshop: Create a Flashback Data Archive
      8. Summary
    4. 16 Maintaining RMAN
      1. RMAN Maintenance
        1. Cross-Checking RMAN Backups
        2. RMAN Workshop: Using the crosscheck Command
        3. Validation of RMAN Backups
        4. Backup Retention Policies
        5. The change Command
        6. RMAN Workshop: Using the change Command
        7. The delete Command
        8. RMAN Workshop: Using the delete Command
        9. Cataloging Other Backups in RMAN
      2. RMAN Stored Scripts
        1. Creating Stored Scripts
        2. Querying the Recovery Catalog for Stored Script Information
        3. Changing Stored Scripts
        4. Deleting Stored Scripts
        5. Using Stored Scripts
        6. Printing Stored Scripts
        7. RMAN Workshop: Using RMAN Stored Scripts
      3. When You Just Can’t Take It Anymore
      4. Summary
    5. 17 Monitoring and Reporting on RMAN
      1. The RMAN list Command
        1. Listing Incarnations
        2. Listing Backups
        3. Listing Image Copies
      2. The RMAN report Command
        1. Reporting on Datafiles That Have Not Been Backed Up Recently
        2. Reporting on Backup Redundancy or Recovery Window
        3. Reporting on Unrecoverable Operations on Datafiles
        4. Reporting on the Database Schema
        5. Reporting on Obsolete Backups
      3. Data Dictionary Views for Reporting
      4. Summary
    6. 18 Performance Tuning RMAN Backup and Recovery Operations
      1. Before You Tune RMAN
        1. RMAN Performance: What Can Be Achieved?
        2. Have the Right Hardware in Place
        3. Tune the Database
      2. Tuning RMAN
        1. Tuning RMAN Settings
        2. Tune the MML Layer
        3. Identifying Database–Related RMAN Issues
      3. Tracing RMAN Sessions
      4. Summary
  10. PART IV RMAN in the Oracle Ecosystem
    1. 19 Duplication: Cloning the Target Database
      1. RMAN Duplication: A Primer
        1. Why Use RMAN Duplication?
        2. Different Types of RMAN Duplication
        3. The Duplication Architecture
      2. Duplication: Location Considerations
        1. Duplication to the Same Server: An Overview
        2. Duplication to the Same Server, Different ORACLE_HOME
        3. Duplication to a Remote Server: An Overview
        4. Duplication and the Network
        5. RMAN Workshop: Build a Password File
      3. Duplication to the Same Server
        1. RMAN Workshop: Duplication to the Same Server, Using Disk Backups
        2. Using Tape Backups
      4. Duplication to a Remote Server
        1. RMAN Workshop: Duplication to a Remote Server, Using Disk Backups
        2. Using Tape Backups for Remote Server Duplication
      5. Target-Less Duplication in 11g
        1. Incomplete Duplication: Using the DBNEWID Utility
      6. Summary
    2. 20 RMAN and Data Guard
      1. RMAN and the Standby Database
        1. Requirements for Using RMAN for Standby Database Creation
        2. The duplicate ... for standby Command
        3. RMAN Workshop: Create a Standby Database Using RMAN
      2. Taking Backups from the Standby Database
        1. Datafile Backups from the Standby Database
        2. Archive Log Backups from the Standby Database
        3. Using Flashback Database for Standby Database Reinstantiation
      3. Summary
    3. 21 RMAN and Real Application Clusters
      1. Real Application Clusters: Unique Backup Challenges
        1. Datafile Backups
        2. Archive Log Backups
      2. RAC Recovery Challenges
        1. Restore Operations
        2. Media Management Considerations During a Restore
        3. Recovery Considerations After a Restore
      3. Advanced RMAN/RAC Topics
        1. Duplication to a Single-Node System
        2. RMAN Workshop: Duplicating a RAC Database to a Single-Node Database
        3. The Single-Node Standby Database
        4. RMAN Workshop: Creating a Single-Node Standby Database from a RAC Database
        5. Backing Up the Multinode RAC Database
      4. Summary
    4. 22 RMAN in Sync and Split Technology
      1. Sync and Split: Broken Mirror Backups
      2. Oracle Databases on Sync and Split Volumes
        1. Datafiles
        2. Control Files
        3. Redo Log Files
        4. Archive Logs
      3. Benefits of the Split Mirror Backup
        1. Fast Point-In-Time Recovery
        2. Speedy-Looking Backups
        3. Mounting a Split Mirror Volume on Another Server
        4. Taking Backups from the Split Mirror
      4. RMAN and Sync and Split
        1. Registering Split Mirror Copies with RMAN
        2. Taking RMAN Backups from the Split Mirror
        3. RMAN Workshop: Configure RMAN to Back Up from the Split Mirror
        4. Getting Sync and Split Functionality from Oracle Software
        5. Using a Standby Database, Flashback Database, and Incremental Apply for Sync and Split
        6. Benefits of the Oracle Sync and Split Solution
      5. Oracle-Integrated Shadow Copy Services for Windows
      6. Summary
    5. 23 RMAN in the Workplace: Case Studies
      1. Before the Recovery
        1. What Is the Exact Nature of the Failure?
        2. What Recovery Options Are Available?
        3. Might Oracle Support Be Needed?
        4. Who Can Act as a Second Pair of Eyes During Recovery?
      2. Recovery Case Studies
        1. Case #1: Recovering from Complete Database Loss (NOARCHIVELOG Mode) with a Recovery Catalog
        2. Case #2: Recovering from Complete Database Loss (NOARCHIVELOG Mode) Without a Recovery Catalog
        3. Case #3: Recovering from Complete Database Loss (ARCHIVELOG Mode) Without a Recovery Catalog
        4. Case #4: Recovering from Complete Database Loss (ARCHIVELOG Mode) with a Recovery Catalog
        5. Case #5: Recovering from the Loss of the SYSTEM Tablespace
        6. Case #6: Recovering Online from the Loss of a Datafile or Tablespace
        7. Case #7: Recovering from Loss of an Unarchived Online Redo Log
        8. Case #8: Recovering Through resetlogs
        9. Case #9: Completing a Failed Duplication Manually
        10. Case #10: Using RMAN Duplication to Create a Historical Subset of the Target Database
        11. Case #11: Recovering from a Lost Datafile (ARCHIVELOG Mode) Using an Image Copy in the Flash Recovery Area
        12. Case #12: Recovering from Running the Production Datafile Out of the Flash Recovery Area
        13. Case #13: Using Flashback Database and Media Recovery to Pinpoint the Exact Moment to Open the Database with resetlogs
      3. Summary
  11. PART V Appendixes
    1. A RMAN Syntax Reference Guide
      1. RMAN Reserved Words
      2. RMAN Command List
      3. RMAN Specifier and Operands Lists
      4. RMAN Command List Syntax Details
      5. @ Command
      6. @@ Command
      7. advise failure Command
      8. allocate channel Command
      9. allocate channel for maintenance Command
      10. alter database Command
      11. backup Command
      12. catalog Command
      13. change Command
      14. configure Command
      15. connect Command
      16. convert Command
      17. create catalog Command
      18. create script Command
      19. crosscheck Command
      20. delete Command
      21. delete script Command
      22. drop catalog Command
      23. drop database Command
      24. duplicate Command
      25. execute script Command
      26. exit Command
      27. flashback database Command
      28. grant Command
      29. host Command
      30. import catalog Command
      31. list Command
      32. print script Command
      33. quit Command
      34. recover Command
      35. register database Command
      36. release channel Command
      37. repair failure Command
      38. replace script Command
      39. report Command
      40. reset database Command
      41. restore Command
      42. resync catalog Command
      43. revoke Command
      44. run Command
      45. send Command
      46. set Command
      47. show Command
      48. shutdown Command
      49. spool Command
      50. SQL Command
      51. startup Command
      52. switch Command
      53. transport tablespace Command
      54. unregister database Command
      55. upgrade catalog Command
      56. validate Command
      57. RMAN Subclauses Syntax Details
      58. allocOperandList
      59. archivelogRecordSpecifier
      60. completedTimeSpec
      61. connectStringSpec
      62. datafileSpec
      63. deviceSpecifier
      64. fileNameConversionSpec
      65. forDbUniqueNameOption
      66. foreignlogRecordSpecifier
      67. formatSpec
      68. keepOption
      69. listObjList
      70. maintQualifier
      71. maintSpec
      72. obsOperandList
      73. recordSpec
      74. tempfileSpec
      75. toDestSpec
      76. untilClause
    2. B RMAN Scripting Examples
      1. RMAN Scripts for Windows
      2. aCreating a Windows Script to Schedule Backups
      3. Scheduling the Backup
      4. RMAN Scripts for Unix
    3. C Setting Up an RMAN Test Environment
      1. The Test Box
      2. Match Your Production Environment
      3. Go Cheap
      4. The Oracle Configuration
      5. Multiple Homes
      6. Creating Databases
      7. Using Oracle ASM
      8. Oracle Enterprise Manager
      9. Media Management Considerations
      10. The RMAN Configuration
  12. Index

Product information

  • Title: Oracle RMAN 11g Backup and Recovery
  • Author(s): Robert Freeman, Matthew Hart
  • Release date: May 2010
  • Publisher(s): McGraw Hill Computing
  • ISBN: 9780071628617