Index

A B C D E F H K L M P Q R S U V

Symbols

? symbol

in RMAN quoted strings, 1-4

@ command, 2-6

in RMAN quoted strings, 1-4

@@ command, 2-7

A

ALLOCATE CHANNEL command, 2-8, 2-15

and shared server, 2-9, 2-13

FOR MAINTENANCE option, 2-12

ALTER DATABASE command, 2-19

archivelogRecordSpecifier clause, 2-22

autobackups

control file, 2-93

B

BACKUP command, 2-28

BLOCKRECOVER command, 2-62

C

CATALOG command, 2-67

CHANGE command, 2-71

channels

allocating to shared server sessions, 2-9, 2-13

code examples

description of RMAN, 1-6

command line

arguments for RMAN, 2-75

commands, Recovery Manager

@, 2-6

@@, 2-7

ALLOCATE CHANNEL, 2-8, 2-15

ALLOCATE CHANNEL FOR MAINTENANCE, 2-12

ALTER DATABASE, 2-19

archivelogRecordSpecifier clause, 2-22

BACKUP, 2-28

BLOCKRECOVER, 2-62

CATALOG, 2-67

CHANGE, 2-71

completedTimeSpec clause, 2-80

CONFIGURE, 2-82

CONNECT, 2-100

connectStringSpec clause, 2-103

CREATE CATALOG, 2-113

CREATE SCRIPT, 2-115

CROSSCHECK, 2-118

DELETE, 2-123

DELETE SCRIPT, 2-127

deprecated, A-1

DROP CATALOG, 2-131

DROP DATABASE, 2-133

DUPLICATE, 2-135

EXECUTE SCRIPT, 2-145

EXIT, 2-147

fileNameConversionSpec clause, 2-148

FLASHBACK, 2-151

HOST, 2-160

LIST, 2-164

listObjList clause, 2-185

PRINT SCRIPT, 2-195

QUIT, 2-197

recordSpec, 2-198

RECOVER, 2-200

RELEASE CHANNEL, 2-214, 2-216

REPLACE SCRIPT, 2-217

REPORT, 2-220

RESET DATABASE, 2-228

RESTORE, 2-231

RESYNC CATALOG, 2-246

RUN, 2-249

SEND, 2-252

SET, 2-254

SHOW, 2-263

SHUTDOWN, 2-266

SPOOL, 2-269

SQL, 2-271

STARTUP, 2-273

summary, 2-2, 3-2

SWITCH, 2-276

UNREGISTER DATABASE, 2-280

untilClause, 2-282

UPGRADE CATALOG, 2-285

VALIDATE, 2-287

compatibility

recovery catalog, B-2

Recovery Manager, B-2

completedTimeSpec clause, 2-80

CONFIGURE command, 2-82

CONNECT command, 2-100

connectStringSpec clause, 2-103

control files

automatic backups, 2-93

corrupt datafile blocks

maximum acceptable number, 2-259

corruption detection

using SET MAXCORRUPT command, 2-259

CREATE CATALOG command, 2-113

CREATE SCRIPT command, 2-115

CROSSCHECK command, 2-118

D

dates

specifying in RMAN commands, 2-282

DELETE command, 2-123

DELETE SCRIPT command, 2-127

deprecated commands

Recovery Manager, A-1

DROP CATALOG command, 2-131

DROP DATABASE command, 2-133

DUPLICATE command, 2-135

E

environment variables

in RMAN strings, 1-4

EXECUTE SCRIPT command, 2-145

EXIT command, 2-147

F

fileNameConversionSpec clause, 2-148

FLASHBACK command, 2-151

H

HOST command, 2-160

K

keywords

in syntax diagrams, 1-3

L

LIST command, 2-164

listObjList clause, 2-185

M

MAXCORRUPT parameter

SET command, 2-259

MAXSETSIZE parameter

BACKUP command, 2-44

P

parameters

in syntax diagrams, 1-3

PL/SQL stored procedures

executing within RMAN, 2-272

PRINT SCRIPT command, 2-195

Q

QUIT command, 2-197

quoted strings

environment variables, 1-4

R

RC_ARCHIVED_LOG view, 2-23, 3-4

RC_BACKUP_CONTROLFILE view, 3-6

RC_BACKUP_CORRUPTION view, 3-8

RC_BACKUP_DATAFILE view, 3-10

RC_BACKUP_PIECE view, 3-15

RC_BACKUP_REDOLOG view, 3-17

RC_BACKUP_SET view, 3-19

RC_BACKUP_SPFILE view, 3-21

RC_CHECKPOINT view, 3-22

RC_CONTROLFILE_COPY view, 3-23

RC_COPY_CORRUPTION view, 3-25

RC_DATABASE recovery catalog view, 3-26

RC_DATABASE view, 2-258

RC_DATABASE_BLOCK_CORRUPTION view, 3-27

RC_DATABASE_INCARNATION view, 2-258, 3-28

RC_DATAFILE view, 3-29

RC_DATAFILE_COPY view, 3-31

RC_LOG_HISTORY view, 3-33

RC_OFFLINE_RANGE view, 3-34

RC_PROXY_CONTROLFILE view, 3-37

RC_PROXY_DATAFILE view, 3-39

RC_REDO_LOG view, 3-41, 3-45

RC_REDO_THREAD view, 3-42

RC_RESYNC view, 3-43

RC_RMAN_CONFIGURATION view, 3-44

RC_STORED_SCRIPT view, 3-47

RC_STORED_SCRIPT_LINE view, 3-48

RC_TABLESPACE view, 3-49

recordSpec clause, 2-198

RECOVER command, 2-200

recovery catalog

views, 3-1

Recovery Manager

backups

control file autobackups, 2-93

commands

@, 2-6

@@, 2-7

ALLOCATE CHANNEL, 2-8, 2-15

ALLOCATE CHANNEL FOR MAINTENANCE, 2-12

ALTER DATABASE, 2-19

archivelogRecordSpecifier clause, 2-22

BACKUP, 2-28

BLOCKRECOVER, 2-62

CATALOG, 2-67

CHANGE, 2-71

completedTimeSpec, 2-80

CONFIGURE, 2-82

CONNECT, 2-100

connectStringSpec, 2-103

CREATE CATALOG, 2-113

CREATE SCRIPT, 2-115

CROSSCHECK, 2-118

DELETE, 2-123

DELETE SCRIPT, 2-127

DROP CATALOG, 2-131

DROP DATABASE, 2-133

DUPLICATE, 2-135

EXECUTE SCRIPT, 2-145

EXIT, 2-147

fileNameConversionSpec, 2-148

FLASHBACK, 2-151

HOST, 2-160

LIST, 2-164

listObjList, 2-185

PRINT SCRIPT, 2-195

QUIT, 2-197

recordSpec, 2-198

RECOVER, 2-200

RELEASE CHANNEL, 2-214

REPLACE SCRIPT, 2-217

REPORT, 2-220

RESET DATABASE, 2-228

RESTORE, 2-231

RESYNC, 2-246

RUN, 2-249

SEND, 2-252

SET, 2-254

SHOW, 2-263

SHUTDOWN, 2-266

SPOOL, 2-269

SQL, 2-271

STARTUP, 2-273

SWITCH, 2-276

UNREGISTER DATABASE, 2-280

untilClause, 2-282

UPGRADE CATALOG, 2-285

VALIDATE, 2-287

compatibility, B-2

dates in commands, 2-282

symbolic links for filenames, 2-236

syntax conventions, 1-2

RELEASE CHANNEL command (RMAN), 2-214

releasing a maintenance channel, 2-216

REPLACE SCRIPT command, 2-217

REPORT command, 2-220

RESET DATABASE command, 2-228

RESTORE command, 2-231

RESYNC CATALOG command, 2-246

RUN command, 2-249

S

SEND command, 2-252

SET command, 2-254

shared server

allocating channels, 2-9, 2-13

SHOW command, 2-263

SHUTDOWN command, 2-266

SPOOL command, 2-269

SQL command, 2-271

STARTUP command, 2-273

stored procedures

executing within RMAN, 2-272

SWITCH command, 2-276

symbolic links

and RMAN, 2-236

syntax conventions

Recovery Manager, 1-2

syntax diagrams

explanation of, 1-2

keywords, 1-3

parameters, 1-3

U

UNREGISTER DATABASE command, 2-280

untilClause, 2-282

UPGRADE CATALOG command, 2-285

V

V$ARCHIVED_LOG view, 2-23, 2-25, 2-26, 2-180

V$BACKUP_CORRUPTION view, 2-40

V$BACKUP_DEVICE view, 2-10, 2-13

V$BACKUP_PIECE view, 2-170, 2-172, 2-175

V$BACKUP_SET view, 2-169, 2-174, 2-175, 2-176, 2-177

V$DATABASE view, 2-258

V$DATABASE_BLOCK_CORRUPTION view, 2-63, 2-64, 2-66, 2-208, 2-238, 2-288

V$DATAFILE view, 2-121

V$DATAFILE_COPY view, 2-121, 2-178, 2-179

V$DATAFILE_HEADER view, 2-121

V$PROXY_DATAFILE view, 2-173

V$SESSION view, 2-257, 2-260

VALIDATE command, 2-287

views

recovery catalog, 3-1