Oracle RMAN Pocket Referenceis 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 datafilesThe 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.

Introduction

1

(1)

Acknowledgments

1

(1)

Caveats

2

(1)

Conventions

2

(1)

Rman Architecture

3

(6)

Rman Executable

4

(1)

Server Processes

4

(1)

Channels

5

(1)

Target Database

5

(1)

Recovery Catalog Database

6

(1)

Media Management Layer

7

(1)

Backups, Backup Sets, and Backup Pieces

8

(1)

Starting Rman

9

(9)

Target Prerequisites

10

(3)

Invoking the Raman Executable

13

(1)

Connecting to a Target with No Catalog

14

(2)

Connecting to Both a Target and a Catalog

16

(2)

Executing commands

18

(7)

Executing Rman Commands from the Rman Prompt

18

(2)

Executing Rman Commands from a File

20

(1)

Running SQL and O/S Commands from Within Rman

21

(1)

Running Rman from Shell Scripts

22

(3)

Implementing a Catalog

25

(10)

What is the Catalog?

25

(3)

Catalog Backup Strategies

28

(2)

Catalog Issues

30

(3)

Creating a Catalog

33

(2)

Registering a Target Database

35

(1)

Stored Catalog Scripts

35

(4)

Storing a Scripts

35

(1)

Executing a Stored Script

36

(2)

Viewing a Stored Script

38

(1)

Deleting a Stored Script

39

(1)

Backups

39

(12)

Full Database Offline Backup

40

(1)

Full Database Online Backup

41

(1)

Backing Up a Tablespace

42

(1)

Backing Up a Datafile

42

(1)

Backing Up Control Files

43

(1)

Backing Up Archived Redo Log Files

44

(2)

Incremental Backups

46

(2)

Backup Tips

48

(3)

Restoring Files

51

(6)

Restoring and Recovering All Datafiles

52

(1)

Restoring Specific Tablespaces/Datafiles

53

(1)

Restoring Read-Only Tablespaces

54

(1)

Point-in-Time Recovery

55

(1)

Restoring Control Files

55

(1)

Restoring Archived Redo Log Files

56

(1)

RMAN Command Reference

57

(53)

Common Keywords

57

(2)

Common Clauses

59

(1)

Command-Line Syntax

59

(2)

@

61

(1)

@@

62

(1)

Allocate Channel

62

(1)

Allocate Channel for Maintenance

63

(1)

allocOperand

64

(1)

Alter Database

65

(1)

archivelogRecordSpecifier

66

(1)

Backup

67

(5)

Blockrecover (Oracle9i only)

72

(1)

Catalog

73

(1)

Change

74

(1)

completedTimeSpec

75

(1)

Configure (Oracle9i only)

76

(2)

Connect

78

(1)

connectStringSpec

79

(1)

Copy

79

(1)

Create Catalog

80

(1)

Create Script

81

(1)

Crosscheck

82

(1)

datafileSpec

83

(1)

Delete

84

(1)

Delete Script

85

(1)

deviceSpecifier

86

(1)

Drop Catalog

86

(1)

Duplicate

86

(1)

Execute Script

87

(1)

Exit

88

(1)

Host

88

(1)

keepOption (Oracle9i only)

89

(1)

List

89

(2)

listObj

91

(1)

mntQualifer (Oracle9i only)

92

(1)

obsoleteOpersList (Oracle9i only)

92

(1)

Print Script

93

(1)

Quit (Oracle9i only)

93

(1)

RecordSpec (Oracle9i only)

93

(1)

Recover

94

(2)

Register

96

(1)

Release Channel

96

(1)

releaseForMaint

97

(1)

Replace Script

97

(2)

Replicate

99

(1)

Report

99

(2)

Reset Database

101

(1)

Restore

102

(2)

Resync

104

(1)

Run

104

(1)

Send

105

(1)

Set

105

(2)

Show (Oracle9i only)

107

(1)

Shutdown

107

(1)

Spool (Oracle9i only)

107

(1)

SQL

107

(1)

Startup

108

(1)

Switch

108

(2)

untilClause

110

(1)

Upgrade Catalog

110

(1)

Validate

110

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.