You are previewing Oracle RMAN Pocket Reference.
O'Reilly logo
Oracle RMAN Pocket Reference

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.

Table of Contents

  1. Oracle RMAN Pocket Reference
    1. SPECIAL OFFER: Upgrade this ebook with O’Reilly
    2. 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
            1. @
            2. @@
            3. ALLOCATE CHANNEL
            4. ALLOCATE CHANNEL FOR MAINTENANCE
            5. allocOperand
            6. ALTER DATABASE
            7. archivelogRecordSpecifier
            8. BACKUP
            9. BLOCKRECOVER (Oracle9i only)
            10. CATALOG
            11. CHANGE
            12. completedTimeSpec
            13. CONFIGURE (Oracle9i only)
            14. CONNECT
            15. connectStringSpec
            16. COPY
            17. CREATE CATALOG
            18. CREATE SCRIPT
            19. CROSSCHECK
            20. datafileSpec
            21. DELETE
            22. DELETE SCRIPT
            23. deviceSpecifier
            24. DROP CATALOG
            25. DUPLICATE
            26. EXECUTE SCRIPT
            27. EXIT
            28. HOST
            29. keepOption (Oracle9i only)
            30. LIST
            31. listObj
            32. mntQualifer (Oracle9i only)
            33. obsoleteOpersList (Oracle9i only)
            34. PRINT SCRIPT
            35. QUIT (Oracle9i only)
            36. RecordSpec (Oracle9i only)
            37. RECOVER
            38. REGISTER
            39. RELEASE CHANNEL
            40. releaseForMaint
            41. REPLACE SCRIPT
            42. REPLICATE
            43. REPORT
            44. RESET DATABASE
            45. RESTORE
            46. RESYNC
            47. RUN
            48. SEND
            49. SET
            50. SHOW (Oracle9i only)
            51. SHUTDOWN
            52. SPOOL (Oracle9i only)
            53. SQL
            54. STARTUP
            55. SWITCH
            56. untilClause
            57. UPGRADE CATALOG
            58. VALIDATE
    3. About the Authors
    4. SPECIAL OFFER: Upgrade this ebook with O’Reilly