Oracle9i RMAN Backup & Recovery

by Robert G. Freeman, Matthew Hart

Overview

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.


From the exclusive publishers of Oracle Press Books, here is the only book available offering complete coverage of RMAN (Recovery Manager), Oracle’s free backup and recovery technology. An indispensable resource for new Oracle users, database administrators, and system administrators.

Product Details

ISBN-13:	9780072226621
Publisher:	McGraw Hill LLC
Publication date:	11/19/2002
Series:	Oracle Press
Edition description:	First Edition
Pages:	608
Product dimensions:	7.30(w) x 9.10(h) x 1.64(d)

About the Author

Robert G. Freeman is an Oracle Database 10g Oracle Certified Professional that has been working with Oracle databases for well over 15 years. He is a Principle Datababase Engineer for the Church of Jesus Christ of Latter-day Saints in Salt Lake City, Ut. He resides near Salt Lake with his wife, three of his five kids and cats, dogs and an airplane.Robert is the author or co-author of several Oracle Press titles including Oracle9i New Features, Oracle Database 10g New Features, Oracle9i RMAN Backup and Recovery and Portable DBA: Oracle.

Matthew Hart (Colorado Springs, CO) has worked exclusively with the Windows Operating System for more than 5 years, the last 3 of which have been with Oracle Corporation, assisting Oracle customer implement the RDBMS on Windows NT and 2000. From 1999 onward, his role has increasingly become focused on Oracle’s high availability solutions, specifically Oracle Recovery Manager and Oracle Advanced Replication. For the past 6 months he has been involved in the beta testing of Oracle9i, and he currently supports beta customers who are rolling out 9i into the enterprise. Matthew became an Oracle Certified Professional in May 1999.

Table of Contents

Part I	Starting Out
1	Oracle9i Backup and Recovery Architecture Tour	1
2	Introduction to the RMAN Architecture	33
Part II	Setup Principles and Practices
3	RMAN Setup and Configuration	65
	RMAN Workshop: Put the Database in ARCHIVELOG Mode	68
	RMAN Workshop: Create the Target Database RMAN Backup Account	74
	RMAN Workshop: Create the Recovery Catalog User Account	88
	RMAN Workshop: Create the Recovery Catalog	89
	RMAN Workshop: Register Your Database in the Recovery Catalog	90
4	Media Management Considerations	93
	RMAN Workshop: Test Tape Channels with the Oracle Default SBT Interface	98
	RMAN Workshop: Setup LSSV on Windows 2000	105
5	Configuring VERITAS NetBackup	111
	RMAN Workshop: Creating an RMAN Script Using the NetBackup for Oracle Wizard	137
6	Configuring Legato Networker Module for Oracle	147
	RMAN Workshop: NMO Installation	150
	RMAN Workshop: Configure Networker for OS-Level Backups	153
	RMAN Workshop: Configuration of the nsrnmo.SID Script	157
7	RMAN and Tivoli Storage Manager	165
8	Configuring HP OmniBack II v4.0	183
	RMAN Workshop: Relinking Oracle9.x OmniBack II on HP-UX 11.00	184
	RMAN Workshop: Backing Out OmniBack Links to Cleanly Apply Oracle9.x Patches	186
	RMAN Workshop: Relinking Oracle8.x OmniBack II on HP-UX 11.00	194
	RMAN Workshop: Backing Out OmniBack Links to Cleanly Apply Oracle8.x Patches	196
Part III	Using RMAN Effectively
9	RMAN Backups	201
	RMAN Workshop: Do an Offline Backup	205
	RMAN Workshop: Do an Online Backup	219
	RMAN Workshop: Do an Incremental Backup	232
	RMAN Workshop: Get Your Database Backed Up!	232
10	RMAN Restore & Recovery	237
	RMAN Workshop: Recover Your Control File	252
	RMAN Workshop: Recover Your NOARCHIVELOG Mode Database	258
	RMAN Workshop: Complete Recovery of Your ARCHIVELOG Mode Database	263
11	Using Oracle9i Enterprise Manager for Backup Implementations	269
	RMAN Workshop: Build the Oracle Management Server	272
	RMAN Workshop: Setting Up Preferred Credentials for EM	280
	RMAN Workshop: Schedule an Insert Job	282
	RMAN Workshop: Set Up E-Mail Notification for Job Failure	286
	RMAN Workshop: Create a Backup Configuration	296
12	RMAN Advanced Recovery Topics	307
13	Maintaining RMAN	331
	RMAN Workshop: Using the crosscheck Command	335
	RMAN Workshop: Using the change Command	341
	RMAN Workshop: Using the delete Command	343
	RMAN Workshop: Using RMAN Stored Scripts	349
14	RMAN Reporting	351
15	Performance Tuning RMAN Backup and Recovery Operations	369
Part IV	RMAN: Beyond Backup and Recovery
16	Duplication: Cloning the Target Database	387
	RMAN Workshop: Building a Password File	403
	RMAN Workshop: Duplication to the Same Server Using Disk Backups	406
	RMAN Workshop: Duplication to a Remote Server Using Disk Backups	409
17	RMAN and the Standby Database	415
	RMAN Workshop: Create a Standby Database Using RMAN	421
18	RMAN and Real Application Clusters	427
	RMAN Workshop: Duplicating a RAC Database to a Single-Node Database	436
	RMAN Workshop: Creating a Single-Node Standby Database from a RAC Database	439
19	RMAN in the Workplace: Case Studies	445
Part V	Appendixes
A	RMAN Syntax Reference Guide	483
B	Exploring the Recovery Catalog	529
C	Oracle8i Syntactical Differences	537
D	Setting Up an RMAN Test Environment	547