Oracle RMAN Pocket Reference

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.

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 @