Oracle9i Recovery Manager Reference -- Index

? symbol

in RMAN quoted strings, 1-4

@ command, 2-6

in RMAN quoted strings, 1-4

@@ command, 2-7

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

autobackups

control file, 2-75

BACKUP command, 2-26

BACKUP_TAPE_IO_SLAVES initialization parameter, 2-30

BLOCKRECOVER command, 2-48

CATALOG command, 2-52

CHANGE command, 2-55

channels

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

code examples

description of RMAN, 1-6

command line

arguments for RMAN, 2-59

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

BACKUP, 2-26

BLOCKRECOVER, 2-48

CATALOG, 2-52

CHANGE, 2-55

completedTimeSpec clause, 2-64

CONFIGURE, 2-66

CONNECT, 2-80

connectStringSpec clause, 2-82

COPY, 2-84

CREATE CATALOG, 2-89

CREATE SCRIPT, 2-91

CROSSCHECK, 2-93

DELETE, 2-98

DELETE SCRIPT, 2-103

deprecated, A-1

DROP CATALOG, 2-105

DUPLICATE, 2-106

EXECUTE SCRIPT, 2-115

EXIT, 2-117

HOST, 2-118

LIST, 2-122

listObjList clause, 2-140

PRINT SCRIPT, 2-146

QUIT, 2-148

recordSpec, 2-149

RECOVER, 2-151

REGISTER, 2-157

RELEASE CHANNEL, 2-159, 2-160

REPLACE SCRIPT, 2-161

REPORT, 2-164

RESET DATABASE, 2-172

RESTORE, 2-175

RESYNC CATALOG, 2-187

RUN, 2-190

SEND, 2-193

SET, 2-195

SHOW, 2-202

SHUTDOWN, 2-205

SPOOL, 2-208

SQL, 2-210

STARTUP, 2-212

summary, 2-2, 3-2

SWITCH, 2-214

untilClause, 2-216

UPGRADE CATALOG, 2-219

VALIDATE, 2-221

compatibility

recovery catalog, B-2

Recovery Manager, B-2

completedTimeSpec clause, 2-64

CONFIGURE command, 2-66

CONNECT command, 2-80

connectStringSpec clause, 2-82

control files

automatic backups, 2-75

COPY command, 2-84

corrupt datafile blocks

maximum acceptable number, 2-198

corruption detection

using SET MAXCORRUPT command, 2-198

CREATE CATALOG command, 2-89

CREATE SCRIPT command, 2-91

CROSSCHECK command, 2-93

dates

specifying in RMAN commands, 2-216

DELETE command, 2-98

DELETE SCRIPT command, 2-103

deprecated commands

Recovery Manager, A-1

DISKRATIO parameter

BACKUP command, 2-40

DROP CATALOG command, 2-105

DUPLICATE command, 2-106

environment variables

in RMAN strings, 1-4

EXECUTE SCRIPT command, 2-115

EXIT command, 2-117

FILESPERSET parameter

BACKUP command, 2-37

HOST command, 2-118

initialization parameters

BACKUP_TAPE_IO_SLAVES, 2-30

keywords

in syntax diagrams, 1-3

LIST command, 2-122

listObjList clause, 2-140

MAXCORRUPT parameter

SET command, 2-198

MAXSETSIZE parameter

BACKUP command, 2-37

normalization

of pre-8.1.6 control file on NT, 2-179

parameters

in syntax diagrams, 1-3

PL/SQL stored procedures

executing within RMAN, 2-211

PRINT SCRIPT command, 2-146

QUIT command, 2-148

quoted strings

environment variables, 1-4

RC_ARCHIVED_LOG view, 2-22, 3-4

RC_BACKUP_CONTROLFILE view, 3-5

RC_BACKUP_CORRUPTION view, 3-7

RC_BACKUP_DATAFILE view, 3-8

RC_BACKUP_PIECE view, 3-10

RC_BACKUP_REDOLOG view, 3-11

RC_BACKUP_SET view, 3-12

RC_BACKUP_SPFILE view, 3-14

RC_CHECKPOINT view, 3-15

RC_CONTROLFILE_COPY view, 3-15

RC_COPY_CORRUPTION view, 3-16

RC_DATABASE recovery catalog view, 3-17

RC_DATABASE view, 2-197

RC_DATABASE_BLOCK_CORRUPTION view, 3-18

RC_DATABASE_INCARNATION view, 2-197, 3-18

RC_DATAFILE view, 3-19

RC_DATAFILE_COPY view, 3-20

RC_LOG_HISTORY view, 3-22

RC_OFFLINE_RANGE view, 3-23

RC_PROXY_CONTROLFILE view, 3-24

RC_PROXY_DATAFILE view, 3-25

RC_REDO_LOG view, 3-27

RC_REDO_THREAD view, 3-27

RC_RESYNC view, 3-28

RC_RMAN_CONFIGURATION view, 3-29

RC_STORED_SCRIPT view, 3-29

RC_STORED_SCRIPT_LINE view, 3-30

RC_TABLESPACE view, 3-30

recordSpec clause, 2-149

RECOVER command, 2-151

recovery catalog

views, 3-1

Recovery Manager

backups

control file autobackups, 2-75

commands

@, 2-6

@@, 2-7

ALLOCATE CHANNEL, 2-8, 2-15

ALLOCATE CHANNEL FOR MAINTENANCE, 2-12

ALTER DATABASE, 2-19

archivelogRecordSpecifier clause, 2-21

BACKUP, 2-26

BLOCKRECOVER, 2-48

CATALOG, 2-52

CHANGE, 2-55

completedTimeSpec, 2-64

CONFIGURE, 2-66

CONNECT, 2-80

connectStringSpec, 2-82

COPY, 2-84

CREATE CATALOG, 2-89

CREATE SCRIPT, 2-91

CROSSCHECK, 2-93

DELETE, 2-98

DELETE SCRIPT, 2-103

DROP CATALOG, 2-105

DUPLICATE, 2-106

EXECUTE SCRIPT, 2-115

EXIT, 2-117

HOST, 2-118

LIST, 2-122

listObjList, 2-140

PRINT SCRIPT, 2-146

QUIT, 2-148

recordSpec, 2-149

RECOVER, 2-151

REGISTER, 2-157

RELEASE CHANNEL, 2-159

REPLACE SCRIPT, 2-161

REPORT, 2-164

RESET DATABASE, 2-172

RESTORE, 2-175

RESYNC, 2-187

RUN, 2-190

SEND, 2-193

SET, 2-195

SHOW, 2-202

SHUTDOWN, 2-205

SPOOL, 2-208

SQL, 2-210

STARTUP, 2-212

SWITCH, 2-214

untilClause, 2-216

UPGRADE CATALOG, 2-219

VALIDATE, 2-221

compatibility, B-2

dates in commands, 2-216

symbolic links for filenames, 2-178

syntax conventions, 1-2

REGISTER command, 2-157

RELEASE CHANNEL command (RMAN), 2-159

releasing a maintenance channel, 2-160

REPLACE SCRIPT command, 2-161

REPORT command, 2-164

RESET DATABASE command, 2-172

RESTORE command, 2-175

RESYNC CATALOG command, 2-187

RUN command, 2-190

SEND command, 2-193

SET command, 2-195

shared server

allocating channels, 2-9, 2-13

SHOW command, 2-202

SHUTDOWN command, 2-205

SPOOL command, 2-208

SQL command, 2-210

STARTUP command, 2-212

stored procedures

executing within RMAN, 2-211

SWITCH command, 2-214

symbolic links

and RMAN, 2-178

syntax conventions

Recovery Manager, 1-2

syntax diagrams

explanation of, 1-2

keywords, 1-3

parameters, 1-3

untilClause, 2-216

UPGRADE CATALOG command, 2-219

V$ARCHIVED_LOG view, 2-22, 2-23, 2-24, 2-136

V$BACKUP_CORRUPTION view, 2-42

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

V$BACKUP_PIECE view, 2-127, 2-129, 2-131

V$BACKUP_SET view, 2-126, 2-130, 2-131, 2-132, 2-133

V$DATABASE view, 2-197

V$DATABASE_BLOCK_CORRUPTION view, 2-49, 2-50, 2-51, 2-86, 2-155, 2-183, 2-222

V$DATAFILE view, 2-96

V$DATAFILE_COPY view, 2-96, 2-134, 2-135

V$DATAFILE_HEADER view, 2-96

V$PROXY_DATAFILE view, 2-129

V$SESSION view, 2-200

VALIDATE command, 2-221

views

recovery catalog, 3-1

Index

Symbols

A

B

C

D

E

F

H

I

K

L

M

N

P

Q

R

S

U

V