Oracle RMAN Pocket Reference

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

      Introduction  

                Acknowledgments  

                Caveats  

                Conventions  

      RMAN Architecture  

                RMAN Executable  

                Server Processes  

                Channels  

                Target Database  

                Recovery Catalog Database  

                Media Management Layer  

                Backups, Backup Sets, and Backup Pieces  

      Starting RMAN  

                Target Prerequisites  

                Invoking the RMAN Executable  

                Connecting to a Target with No Catalog  

                Connecting to Both a Target and a Catalog  

      Executing Commands  

                Executing RMAN Commands from the RMAN Prompt  

                Executing RMAN Commands from a File  

                Running SQL and O/S Commands from Within RMAN  

                Running RMAN from Shell Scripts  

      Implementing a Catalog  

                What Is the Catalog?  

                Catalog Backup Strategies  

                Catalog Issues  

                Creating a Catalog  

                Registering a Target Database  

      Stored Catalog Scripts  

                Storing a Script  

                Executing a Stored Script  

                Viewing a Stored Script  

                Deleting a Stored Script  

      Backups  

                Full Database Offline Backup  

                Full Database Online Backup  

                Backing Up a Tablespace  

                Backing Up a Datafile  

                Backing Up Control Files  

                Backing Up Archived Redo Log Files  

                Incremental Backups  

                Backup Tips  

      Restoring Files  

                Restoring and Recovering All Datafiles  

                Restoring Specific Tablespaces/Datafiles  

                Restoring Read-Only Tablespaces  

                Point-in-Time Recovery  

                Restoring Control Files  

                Restoring Archived Redo Log Files  

      RMAN Command Reference  

                Common Keywords  

                Common Clauses  

                Command-Line Syntax  

      @ 

      @@ 

      ALLOCATE CHANNEL 

      ALLOCATE CHANNEL FOR MAINTENANCE 

      allocOperand 

      ALTER DATABASE 

      archivelogRecordSpecifier 

      BACKUP 

      BLOCKRECOVER (Oracle9i only) 

      CATALOG 

      CHANGE 

      completedTimeSpec 

      CONFIGURE (Oracle9i only) 

      CONNECT 

      connectStringSpec 

      COPY 

      CREATE CATALOG 

      CREATE SCRIPT 

      CROSSCHECK 

      datafileSpec 

      DELETE 

      DELETE SCRIPT 

      deviceSpecifier 

      DROP CATALOG 

      DUPLICATE 

      EXECUTE SCRIPT 

      EXIT 

      HOST 

      keepOption (Oracle9i only) 

      LIST 

      listObj 

      mntQualifer (Oracle9i only) 

      obsoleteOpersList (Oracle9i only) 

      PRINT SCRIPT 

      QUIT (Oracle9i only) 

      RecordSpec (Oracle9i only) 

      RECOVER 

      REGISTER 

      RELEASE CHANNEL 

      releaseForMaint 

      REPLACE SCRIPT 

      REPLICATE 

      REPORT 

      RESET DATABASE 

      RESTORE 

      RESYNC 

      RUN 

      SEND 

      SET 

      SHOW (Oracle9i only) 

      SHUTDOWN 

      SPOOL (Oracle9i only) 

      SQL 

      STARTUP 

      SWITCH 

      untilClause 

      UPGRADE CATALOG 

      VALIDATE

《Oracle RMAN Pocket Reference》是一本方便的指南，針對打算使用Oracle Recovery Manager進行數據庫備份和恢復的DBA。由於Recovery Manager（RMAN）是一個相對較新的工具，許多DBA剛開始熟悉它。他們將歡迎一本及時的書籍，清晰而簡潔地解釋如何使用RMAN執行罕見但極其重要的常見備份和恢復任務。

該書的第一部分主要是以任務為導向的。在簡短介紹RMAN架構的部分之後，本書以檢查清單的形式展示了如何執行常見的備份和恢復任務，例如：

- 實施恢復目錄
- 創建和運行RMAN腳本
- 配置輸入/輸出通道
- 進行完整數據庫備份
- 備份表空間和數據文件
- 進行增量備份
- 恢復丟失的數據文件

該書的第二部分是一個方便的語法參考，列出了許多RMAN命令。對於DBA來說，快速查找RMAN命令是一個很大的方便，否則在恢復情況下，他們往往需要翻閱Oracle的在線文檔。

目錄如下：

- 引言
- 致謝
- 注意事項
- 約定
- RMAN架構
- RMAN可執行文件
- 服務器進程
- 通道
- 目標數據庫
- 恢復目錄數據庫
- 媒體管理層
- 備份、備份集和備份片段
- 開始使用RMAN
- 目標先決條件
- 調用RMAN可執行文件
- 連接到無目錄的目標
- 同時連接到目標和目錄
- 執行命令
- 從RMAN提示符執行RMAN命令
- 從文件執行RMAN命令
- 在RMAN中運行SQL和操作系統命令
- 從Shell腳本運行RMAN
- 實施目錄
- 什麼是目錄？
- 目錄備份策略
- 目錄問題
- 創建目錄
- 註冊目標數據庫
- 存儲目錄腳本
- 存儲腳本
- 執行存儲腳本
- 查看存儲腳本
- 刪除存儲腳本
- 備份
- 完整數據庫離線備份
- 完整數據庫在線備份

以上是《Oracle RMAN Pocket Reference》的內容概要。這本書對於打算使用Oracle Recovery Manager進行數據庫備份和恢復的DBA來說是一個實用的指南。