Oracle RMAN Pocket Reference
暫譯: Oracle RMAN 口袋參考手冊

Darl Kuhn, Scott Schulze

  • 出版商: O'Reilly
  • 出版日期: 2001-12-11
  • 售價: $650
  • 貴賓價: 9.5$618
  • 語言: 英文
  • 頁數: 96
  • 裝訂: Paperback
  • ISBN: 0596002335
  • ISBN-13: 9780596002336
  • 相關分類: Oracle
  • 海外代購書籍(需單獨結帳)

買這商品的人也買了...

相關主題

商品描述

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 口袋參考手冊》是一本方便的指南,適合打算使用 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
- 實施目錄
- 什麼是目錄?
- 目錄備份策略
- 目錄問題
- 創建目錄
- 註冊目標資料庫
- 存儲的目錄腳本
- 存儲腳本
- 執行存儲的腳本
- 查看存儲的腳本
- 刪除存儲的腳本
- 備份
- 完整資料庫離線備份
- 完整資料庫在線備份
- 備份表空間
- 備份數據文件
- 備份控制文件
- 備份已歸檔的重做日誌文件
- 增量備份
- 備份提示
- 恢復文件
- 恢復和恢復所有數據文件
- 恢復特定的表空間/數據文件
- 恢復只讀表空間
- 時間點恢復
- 恢復控制文件
- 恢復已歸檔的重做日誌文件
- RMAN 命令參考
- 常見關鍵字
- 常見子句
- 命令行語法
- @
- @@
- 分配通道
- 分配維護通道
- allocOperand
- ALTER DATABASE
- archivelogRecordSpecifier
- BACKUP
- BLOCKRECOVER(僅限 Oracle9i)
- CATALOG
- CHANGE
- completedTimeSpec
- CONFIGURE(僅限 Oracle9i)
- CONNECT
- connectStringSpec
- COPY
- CREATE CATALOG
- CREATE SCRIPT
- CROSSCHECK
- datafileSpec
- DELETE
- DELETE SCRIPT
- deviceSpecifier
- DROP CATALOG
- DUPLICATE
- EXECUTE SCRIPT
- EXIT
- HOST
- keepOption(僅限 Oracle9i)
- LIST
- listObj
- mntQualifer(僅限 Oracle9i)
- obsoleteOpersList(僅限 Oracle9i)
- PRINT SCRIPT
- QUIT(僅限 Oracle9i)
- RecordSpec(僅限 Oracle9i)
- RECOVER
- REGISTER
- RELEASE CHANNEL
- releaseForMaint
- REPLACE SCRIPT
- REPLICATE
- REPORT
- RESET DATABASE
- RESTORE
- RESYNC
- RUN
- SEND
- SET
- SHOW(僅限 Oracle9i)
- SHUTDOWN
- SPOOL(僅限 Oracle9i)
- SQL
- STARTUP
- SWITCH
- untilClause
- UPGRADE CATALOG
- VALIDATE