Oracle RMAN Pocket Reference
Published on 11. December 2001
Book
Paperback/Softback
96 pages
978-0-596-00233-6 (ISBN)
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.
More details
Other editions
Additional editions
E-Book
11/2001
1st Edition
O'Reilly
€6.49
Available for download
Persons
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.
Content
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 @