Oracle RMAN Pocket Reference

Oracle RMAN Pocket Reference

by Darl Kuhn, Scott Schulze
Released November 2001
Publisher(s): O'Reilly Media, Inc.
ISBN: 9780596002336

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.

Buy on Amazon Buy on ebooks.com
Start your free trial

Book description

Oracle RMAN Pocket Reference is a handy guide for DBAs who intend to use Oracle Recovery Manager for database backup and recovery. Because Recovery Manager (RMAN) is a relatively new tool, many DBAs are just becoming familiar with it. They will welcome a timely book that explains clearly and concisely how to use RMAN for common backup and recovery tasks that are infrequent, yet extremely vital.

The first portion of the book is primarily task-oriented. After a short section on RMAN architecture, the book shows (in checklist style) how to perform common backup and recovery tasks such as:

  • Implementing a recovery catalog
  • Creating and running RMAN scripts
  • Configuring input/output channels
  • Taking a full database backup
  • Backing up tablespaces and datafiles
  • Taking incremental backups
  • Recovering lost datafiles


The second portion of the book consists of a handy syntax reference to the many RMAN commands. Having a quick reference to RMAN commands is a great convenience to DBAs who otherwise, often under the pressure of a recovery situation, would have to wade through Oracle's online documentation.

Publisher resources

View/Submit Errata

Table of contents

  1. 1. Oracle RMANPocket Reference
    1. 1.1. Introduction
      1. 1.1.1. Acknowledgments
      2. 1.1.2. Caveats
      3. 1.1.3. Conventions
    2. 1.2. RMAN Architecture
      1. 1.2.1. RMAN Executable
      2. 1.2.2. Server Processes
      3. 1.2.3. Channels
      4. 1.2.4. Target Database
      5. 1.2.5. Recovery Catalog Database
      6. 1.2.6. Media Management Layer
      7. 1.2.7. Backups, Backup Sets, and Backup Pieces
    3. 1.3. Starting RMAN
      1. 1.3.1. Target Prerequisites
      2. 1.3.2. Invoking the RMAN Executable
      3. 1.3.3. Connecting to a Target with No Catalog
        1. 1.3.3.1. O/S authentication
        2. 1.3.3.2. Password file authentication
        3. 1.3.3.3. Hiding the password
      4. 1.3.4. Connecting to Both a Target and a Catalog
        1. 1.3.4.1. O/S authentication
        2. 1.3.4.2. Password authentication
    4. 1.4. Executing Commands
      1. 1.4.1. Executing RMAN Commandsfrom the RMAN Prompt
      2. 1.4.2. Executing RMAN Commands from a File
      3. 1.4.3. Running SQL and O/S Commandsfrom Within RMAN
      4. 1.4.4. Running RMAN from Shell Scripts
        1. 1.4.4.1. Shell basics
        2. 1.4.4.2. Passing parameters to RMAN
    5. 1.5. Implementing a Catalog
      1. 1.5.1. What Is the Catalog?
        1. 1.5.1.1. Catalog advantages
        2. 1.5.1.2. Catalog disadvantages
        3. 1.5.1.3. Using RMAN without a catalog
      2. 1.5.2. Catalog Backup Strategies
        1. 1.5.2.1. Full export
        2. 1.5.2.2. Cold backup
        3. 1.5.2.3. Hot backup
        4. 1.5.2.4. RMAN backup
        5. 1.5.2.5. Hot standby
        6. 1.5.2.6. Recreating a catalog
      3. 1.5.3. Catalog Issues
        1. 1.5.3.1. Physical location of the catalog
        2. 1.5.3.2. Version of catalog
        3. 1.5.3.3. Sizing the catalog
        4. 1.5.3.4. Managing multiple target databases
      4. 1.5.4. Creating a Catalog
      5. 1.5.5. Registering a Target Database
    6. 1.6. Stored Catalog Scripts
      1. 1.6.1. Storing a Script
      2. 1.6.2. Executing a Stored Script
      3. 1.6.3. Viewing a Stored Script
      4. 1.6.4. Deleting a Stored Script
    7. 1.7. Backups
      1. 1.7.1. Full Database Offline Backup
      2. 1.7.2. Full Database Online Backup
      3. 1.7.3. Backing Up a Tablespace
      4. 1.7.4. Backing Up a Datafile
      5. 1.7.5. Backing Up Control Files
      6. 1.7.6. Backing Up Archived Redo Log Files
      7. 1.7.7. Incremental Backups
      8. 1.7.8. Backup Tips
        1. 1.7.8.1. Validating backups
        2. 1.7.8.2. Configuring channels
        3. 1.7.8.3. Parallelism of backups
        4. 1.7.8.4. Tagging a backup
    8. 1.8. Restoring Files
      1. 1.8.1. Restoring and Recovering All Datafiles
      2. 1.8.2. Restoring Specific Tablespaces/Datafiles
      3. 1.8.3. Restoring Read-Only Tablespaces
      4. 1.8.4. Point-in-Time Recovery
      5. 1.8.5. Restoring Control Files
      6. 1.8.6. Restoring Archived Redo Log Files
    9. 1.9. RMAN Command Reference
      1. 1.9.1. Common Keywords
      2. 1.9.2. Common Clauses
      3. 1.9.3. Command-Line Syntax
        1. 1.9.3.1. Oracle9i syntax
        2. 1.9.3.2. Oracle8i syntax
        3. 1.9.3.3. Keywords
  2. About the Authors
  3. Copyright

Product information

  • Title: Oracle RMAN Pocket Reference
  • Author(s): Darl Kuhn, Scott Schulze
  • Release date: November 2001
  • Publisher(s): O'Reilly Media, Inc.
  • ISBN: 9780596002336