ORACLE RMAN POCKET REFERENCE

Le Monde En Tique

Commandez cet ouvrage

Ouvrage 9780596002336 : 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.
Darl Kuhn, an Oracle DBA and software developer with 14 years experience, is a senior DBA with
Sun Microsystems. Before joining Sun, his work as a consultant ranged from database
administration to custom application development. For the past four years, Darl has served as a
volunteer DBA and developer for the Rocky Mountain Oracle Users Group. He also taught Oracle
database administration and software development courses for the graduate department of Computer
Information Systems at Regis University. Darl has an MBA from Colorado State University and
currently lives in Denver, Colorado.
Scott Schulze, a senior DBA for Level(3) Communications, worked with Oracle technologies since
1990 both as a developer and as a database administrator, and served as a consultant in the
telecom and data storage industries. Scott also taught numerous courses, ranging from relational
concepts to PL/SQL development for the graduate department of Computer Information Systems at
Regis University. He has an MBA from New Mexico State University, and currently lives in Littleton,
Colorado
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

Auteur : KUHN
Editeur : O'REILLY
Nombre de pages : 112
Date de publication : 11 2001

Commandez cet ouvrage