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-92

B

BACKUP command, 2-28

BLOCKRECOVER command, 2-61

C

CATALOG command, 2-66

CHANGE command, 2-70

channels

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

code examples

description of RMAN, 1-6

command line

arguments for RMAN, 2-74

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-61

CATALOG, 2-66

CHANGE, 2-70

completedTimeSpec clause, 2-79

CONFIGURE, 2-81

CONNECT, 2-99

connectStringSpec clause, 2-102

CREATE CATALOG, 2-111

CREATE SCRIPT, 2-113

CROSSCHECK, 2-116

DELETE, 2-121

DELETE SCRIPT, 2-125

deprecated, A-1

DROP CATALOG, 2-129

DROP DATABASE, 2-131

DUPLICATE, 2-133

EXECUTE SCRIPT, 2-143

EXIT, 2-145

fileNameConversionSpec clause, 2-146

FLASHBACK, 2-149

HOST, 2-158

LIST, 2-163

listObjList clause, 2-184

PRINT SCRIPT, 2-194

QUIT, 2-196

recordSpec, 2-197

RECOVER, 2-199

RELEASE CHANNEL, 2-213, 2-215

REPLACE SCRIPT, 2-216

REPORT, 2-219

RESET DATABASE, 2-227

RESTORE, 2-230

RESYNC CATALOG, 2-245

RUN, 2-248

SEND, 2-251

SET, 2-253

SHOW, 2-262

SHUTDOWN, 2-265

SPOOL, 2-268

SQL, 2-270

STARTUP, 2-272

summary, 2-2, 3-2

SWITCH, 2-275

UNREGISTER DATABASE, 2-279

untilClause, 2-281

UPGRADE CATALOG, 2-284

VALIDATE, 2-286

compatibility

recovery catalog, B-2

Recovery Manager, B-2

completedTimeSpec clause, 2-79

CONFIGURE command, 2-81

CONNECT command, 2-99

connectStringSpec clause, 2-102

control files

automatic backups, 2-92

corrupt datafile blocks

maximum acceptable number, 2-258

corruption detection

using SET MAXCORRUPT command, 2-258

CREATE CATALOG command, 2-111

CREATE SCRIPT command, 2-113

CROSSCHECK command, 2-116

D

dates

specifying in RMAN commands, 2-281

DELETE command, 2-121

DELETE SCRIPT command, 2-125

deprecated commands

Recovery Manager, A-1

DROP CATALOG command, 2-129

DROP DATABASE command, 2-131

DUPLICATE command, 2-133

E

environment variables

in RMAN strings, 1-4

EXECUTE SCRIPT command, 2-143

EXIT command, 2-145

F

fileNameConversionSpec clause, 2-146

FLASHBACK command, 2-149

H

HOST command, 2-158

K

keywords

in syntax diagrams, 1-3

L

LIST command, 2-163

listObjList clause, 2-184

M

MAXCORRUPT parameter

SET command, 2-258

MAXSETSIZE parameter

BACKUP command, 2-43

P

parameters

in syntax diagrams, 1-3

PL/SQL stored procedures

executing within RMAN, 2-271

PRINT SCRIPT command, 2-194

Q

QUIT command, 2-196

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-257

RC_DATABASE_BLOCK_CORRUPTION view, 3-27

RC_DATABASE_INCARNATION view, 2-257, 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-197

RECOVER command, 2-199

recovery catalog

views, 3-1

Recovery Manager

backups

control file autobackups, 2-92

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-61

CATALOG, 2-66

CHANGE, 2-70

completedTimeSpec, 2-79

CONFIGURE, 2-81

CONNECT, 2-99

connectStringSpec, 2-102

CREATE CATALOG, 2-111

CREATE SCRIPT, 2-113

CROSSCHECK, 2-116

DELETE, 2-121

DELETE SCRIPT, 2-125

DROP CATALOG, 2-129

DROP DATABASE, 2-131

DUPLICATE, 2-133

EXECUTE SCRIPT, 2-143

EXIT, 2-145

fileNameConversionSpec, 2-146

FLASHBACK, 2-149

HOST, 2-158

LIST, 2-163

listObjList, 2-184

PRINT SCRIPT, 2-194

QUIT, 2-196

recordSpec, 2-197

RECOVER, 2-199

RELEASE CHANNEL, 2-213

REPLACE SCRIPT, 2-216

REPORT, 2-219

RESET DATABASE, 2-227

RESTORE, 2-230

RESYNC, 2-245

RUN, 2-248

SEND, 2-251

SET, 2-253

SHOW, 2-262

SHUTDOWN, 2-265

SPOOL, 2-268

SQL, 2-270

STARTUP, 2-272

SWITCH, 2-275

UNREGISTER DATABASE, 2-279

untilClause, 2-281

UPGRADE CATALOG, 2-284

VALIDATE, 2-286

compatibility, B-2

dates in commands, 2-281

symbolic links for filenames, 2-235

syntax conventions, 1-2

RELEASE CHANNEL command (RMAN), 2-213

releasing a maintenance channel, 2-215

REPLACE SCRIPT command, 2-216

REPORT command, 2-219

RESET DATABASE command, 2-227

RESTORE command, 2-230

RESYNC CATALOG command, 2-245

RUN command, 2-248

S

SEND command, 2-251

SET command, 2-253

shared server

allocating channels, 2-9, 2-13

SHOW command, 2-262

SHUTDOWN command, 2-265

SPOOL command, 2-268

SQL command, 2-270

STARTUP command, 2-272

stored procedures

executing within RMAN, 2-271

SWITCH command, 2-275

symbolic links

and RMAN, 2-235

syntax conventions

Recovery Manager, 1-2

syntax diagrams

explanation of, 1-2

keywords, 1-3

parameters, 1-3

U

UNREGISTER DATABASE command, 2-279

untilClause, 2-281

UPGRADE CATALOG command, 2-284

V

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

V$BACKUP_CORRUPTION view, 2-40

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

V$BACKUP_PIECE view, 2-169, 2-171, 2-174

V$BACKUP_SET view, 2-168, 2-173, 2-174, 2-175, 2-176

V$DATABASE view, 2-257

V$DATABASE_BLOCK_CORRUPTION view, 2-62, 2-63, 2-65, 2-207, 2-237, 2-287

V$DATAFILE view, 2-119

V$DATAFILE_COPY view, 2-119, 2-177, 2-178

V$DATAFILE_HEADER view, 2-119

V$PROXY_DATAFILE view, 2-172

V$SESSION view, 2-256, 2-259

VALIDATE command, 2-286

views

recovery catalog, 3-1