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 concise...
| Main Author: | |
|---|---|
| Other Authors: | |
| Format: | eBook |
| Language: | English |
| Published: |
Sebastopol, CA
O'Reilly
2002
|
| Edition: | 1st ed |
| Subjects: | |
| Online Access: | |
| Collection: | O'Reilly - Collection details see MPG.ReNa |
Table of Contents:
- Restoring Archived Redo Log FilesRMAN Command Reference; Common Keywords; Common Clauses; Command-Line Syntax; Oracle9i syntax; Oracle8i syntax; Keywords; @; @@; 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
- Storing a ScriptExecuting 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; Validating backups; Configuring channels; Parallelism of backups; Tagging a backup; Restoring Files; Restoring and Recovering All Datafiles; Restoring Specific Tablespaces/Datafiles; Restoring Read-Only Tablespaces; Point-in-Time Recovery; Restoring Control Files
- Executing RMAN Commands from a FileRunning SQL and O/S Commands from Within RMAN; Running RMAN from Shell Scripts; Shell basics; Passing parameters to RMAN; Implementing a Catalog; What Is the Catalog?; Catalog advantages; Catalog disadvantages; Using RMAN without a catalog; Catalog Backup Strategies; Full export; Cold backup; Hot backup; RMAN backup; Hot standby; Recreating a catalog; Catalog Issues; Physical location of the catalog; Version of catalog; Sizing the catalog; Managing multiple target databases; Creating a Catalog; Registering a Target Database; Stored Catalog Scripts
- Oracle RMAN Pocket Reference; 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; O/S authentication; Password file authentication; Hiding the password; Connecting to Both a Target and a Catalog; O/S authentication; Password authentication; Executing Commands; Executing RMAN Commands from the RMAN Prompt
- 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.