Oracle RMAN Pocket Reference: RMAN Syntax and Procedures

by Darl Kuhn, Scott Schulze

Overview

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.

Product Details

ISBN-13:	9780596551995
Publisher:	O'Reilly Media, Incorporated
Publication date:	11/01/2001
Sold by:	Barnes & Noble
Format:	eBook
Pages:	126
Sales rank:	329,919
File size:	1 MB

About the Author

Darl Kuhn is currently a DBA with Sun Microsystems. He has coauthored three books: Linux Recipes for Oracle DBAs, RMAN Recipes for Oracle Database 11g: A Problem-Solution Approach and Oracle RMAN Pocket Reference. He also teaches advanced database courses at Regis University. Darl performs volunteer database administration work for the Rocky Mountain Oracle Users Group. He has a graduate degree from Colorado State University and currently lives near Spanish Peaks, Colorado with his wife Heidi and daughters Lisa and Brandi.

Table of Contents

	Introduction	1
	Acknowledgments	1
	Caveats	2
	Conventions	2
	RMAN Architecture	3
	RMAN Executable	4
	Server Processes	4
	Channels	5
	Target Database	5
	Recovery Catalog Database	6
	Media Management Layer	7
	Backups, Backup Sets, and Backup Pieces	8
	Starting RMAN	9
	Target Prerequisites	10
	Invoking the RMAN Executable	13
	Connecting to a Target with No Catalog	14
	Connecting to Both a Target and a Catalog	16
	Executing Commands	18
	Executing RMAN Commands from the RMAN Prompt	18
	Executing RMAN Commands from a File	20
	Running SQL and O/S Commands from Within RMAN	21
	Running RMAN from Shell Scripts	22
	Implementing a Catalog	25
	What Is the Catalog?	25
	Catalog Backup Strategies	28
	Catalog Issues	30
	Creating a Catalog	33
	Registering a Target Database	35
	Stored Catalog Scripts	35
	Storing a Script	35
	Executing a Stored Script	36
	Viewing a Stored Script	38
	Deleting a Stored Script	39
	Backups	39
	Full Database Offline Backup	40
	Full Database Online Backup	41
	Backing Up a Tablespace	42
	Backing Up a Datafile	42
	Backing Up Control Files	43
	Backing Up Archived Redo Log Files	44
	Incremental Backups	46
	Backup Tips	48
	Restoring Files	51
	Restoring and Recovering All Datafiles	52
	Restoring Specific Tablespaces/Datafiles	53
	Restoring Read-Only Tablespaces	54
	Point-in-Time Recovery	55
	Restoring Control Files	55
	Restoring Archived Redo Log Files	56
	Rman Command Reference	57
	Common Keywords	57
	Common Clauses	59
	Command-Line Syntax	59
	@	61
	@@	62
	Allocate Channel	62
	Allocate Channel for Maintenance	63
	allocOperand	64
	Alter Database	65
	archivelogRecordSpecifier	66
	Backup	67
	Blockrecover (Oracle9i only)	72
	Catalog	73
	Change	74
	completedTimeSpec	75
	Configure (Oracle9i only)	76
	Connect	78
	connectStringSpec	79
	Copy	79
	Create Catalog	80
	Create Script	81
	Crosscheck	82
	datafileSpec	83
	Delete	84
	Delete Script	85
	deviceSpecifier	86
	Drop Catalog	86
	Duplicate	86
	Execute Script	87
	Exit	88
	Host	88
	keepOption (Oracle9i only)	89
	List	89
	listObj	91
	mntQualifer (Oracle9i only)	92
	obsoleteOpersList (Oracle9i only)	92
	Print Script	93
	Quit (Oracle9i only)	93
	RecordSpec (Oracle9i only)	93
	Recover	94
	Register	96
	Release Channel	96
	releaseForMaint	97
	Replace Script	97
	Replicate	99
	Report	99
	Reset Database	101
	Restore	102
	Resync	104
	Run	104
	Send	105
	Set	105
	Show (Oracle9i only)	107
	Shutdown	107
	Spool (Oracle9i only)	107
	Sql	107
	Startup	108
	Switch	108
	untilClause	110
	Upgrade Catalog	110
	Validate	110