Index

A B C D E F G H I J K L M N O P R S T U V W

A

ABORT option

SHUTDOWN statement, 17-8, 17-9, 17-28, 17-37, 17-38

active online redo log

loss of group, 18-14, 18-15

alert log, 18-18

checking after RESETLOGS, 17-36

useful for RMAN, 15-2

ALLOW ... CORRUPTION clause

RECOVER command, 20-8

ALTER DATABASE statement

BACKUP CONTROLFILE clause, 16-14

TO TRACE option, 16-14

CLEAR LOGFILE clause, 18-13

END BACKUP clause, 16-11

NORESETLOGS option, 17-35

OPEN RESETLOGS clause, 13-9

RECOVER clause, 17-7, 17-19

RESETLOGS option, 17-35, 17-37, 17-39

ALTER SYSTEM statement

KILL SESSION clause, 15-13

RESUME clause, 16-20

SUSPEND clause, 16-19

ALTER TABLESPACE statement

BEGIN BACKUP clause, 16-6, 16-9

END BACKUP option, 16-9

archived redo logs

applying during media recovery, 17-14

automating application, 17-16

backing up, 7-17

cataloging, 13-7

changing default location, 17-18

corrupted, 20-2

deleting after recovery, 17-7

deletion after backup, 2-15, 4-22

deletion after restore, 3-8

errors during recovery, 17-20

incompatible format, 20-3

location during recovery, 17-14

loss of, 18-15

restoring, 17-6

RMAN fails to delete, 15-27

using for recovery

in default location, 17-17

in nondefault location, 17-19

ARCHIVELOG mode

datafile loss in, 18-2

AS SELECT clause

CREATE TABLE statement, 18-6

autobackups

control file, 2-38, 2-40

server parameter file, 2-38

automatic channels, 2-2

allocation, 2-2

configuring, 6-12, 6-16, 7-2

generic

configuring, 2-7, 6-13

definition, 6-13

naming conventions, 2-6

overriding, 6-12

parallelism, 6-12

specific configurations, 2-8

AUTORECOVERY option

SET statement, 17-15

B

BACKUP command, 7-26

BACKUPSET option, 2-22, 7-7

DELETE INPUT option, 4-23

FORMAT parameter, 2-25

KEEP option, 2-47

NOT BACKED UP SINCE clause, 2-54, 7-8

PROXY ONLY option, 2-14

PROXY option, 2-14

SKIP OFFLINE option, 7-12

VALIDATE option, 2-60

BACKUP CONTROLFILE clause

of ALTER DATABASE, 16-2

BACKUP CONTROLFILE TO TRACE clause

of ALTER DATABASE, 16-2, 16-14

BACKUP COPIES parameter

CONFIGURE command, 6-22

backup mode

ending with ALTER DATABASE END BACKUP, 16-11

for online user-managed backups, 16-7

instance failure, 16-10

backup optimization

configuring, 6-21

definition, 2-49, 7-8

disabling, 2-51, 6-21

enabling, 2-51, 6-21

recovery window and, 2-52

redundancy and, 2-53

retention policies and, 2-52

BACKUP OPTIMIZATION option

of CONFIGURE, 7-9

backup retention policy

definition, 2-41

backup sets

backing up, 2-22, 7-7

configuring maximum size, 6-20

crosschecking, 4-8

duplexing, 7-3

errors during creation, 2-57

failover during backups, 2-24

how RMAN generates, 2-30

limiting size, 2-30

multiplexing, 2-16

naming, 2-25

specifying maximum size (in bytes), 2-28

specifying number of, 2-30

Backup Solutions Program (BSP), 1-12

backups

archived redo logs, 7-17

deletion after backing up, 4-22

availability

altering with CHANGE command, 4-24

backup sets, 7-7

backups of, 2-22

closed, 16-4

consistent, 16-4

control file

using for recovery, 8-7

control files, 16-14

binary, 16-14

trace files, 16-14

correlating RMAN channels with, 4-11, 4-12

cumulative incremental, 2-36, 3-7, 3-15, 7-19

datafile

using RMAN, 7-7, 7-8, 7-9, 7-10

DBVERIFY utility, 16-25

deleting, 4-20

determining datafile status, 16-3

duplexing, 6-22, 7-3

excluding tablespaces from backups, 6-24

failed RMAN, 15-27

failover during BACKUP BACKUPSET, 2-24

hung, 15-19

image copies, 2-12

inconsistent, 16-4

incremental, 2-33, 7-19

differential, 2-35

using RMAN, 7-4, 7-5

interrupted, 7-8

keeping, 7-22

keeping records, 16-27

limiting I/O rate, 2-31

listing files needed, 16-2

logical, 16-26

long-term, 2-47

changing status, 4-24

multiple copies, 6-22

NOARCHIVELOG mode, in, 7-20

obsolete

batch deletes, 2-46

offline datafiles, 16-5

offline tablespaces, 16-5

optimizing, 2-49

read-only tablespaces, 16-12

recovering pre-RESETLOGS, 8-4

recovery catalog, 1-9, 13-22

restartable, 2-54, 7-8

restoring user-managed, 17-3

RMAN error handling, 7-26

specifying number of files in a backup set, 2-30

split mirror, 2-13

using RMAN, 7-5

stored scripts, 13-15

tablespace, 16-8

using RMAN, 7-7, 7-8, 7-9, 7-10

tags, 2-26

testing RMAN, 2-60, 7-10

using media manager, 6-10

troubleshooting failed RMAN, 15-17, 15-21, 15-25

types, 2-32

user-managed

restoring, 17-6

validating, 7-10

verifying, 16-25

whole database

preparing for, 16-4

BEGIN BACKUP clause

ALTER TABLESPACE statement, 16-6

block corruptions

stored in V$DATABASE_BLOCK_CORRUPTION, 7-10

block media recovery, 8-21

guidelines, 3-11

overview, 3-10

BLOCKRECOVER command, 3-10, 8-21

BSP. See Backup Solutions Program (BSP)

C

cancel-based media recovery

procedures, 17-25, 17-32

canceling RMAN commands, 15-13

CATALOG command, 13-7

cataloging

archived redo logs, 13-7

datafiles, 13-7

operating system copies, 7-21

catalog.sql script, 13-4

catproc.sql script, 13-4

CHANGE command, 4-7

AVAILABLE option, 4-24

KEEP option, 4-24

change-based media recovery

coordinated in distributed databases, 18-18

channels

allocating manually for backups, 7-2

configuring automatic, 6-12

configuring for backups, 7-2

control options, 2-10

definition, 2-2

difference between manual and automatic, 2-3

generic configurations, 2-7

overriding automatic, 6-12

parallelism for manual channels, 2-9

preconfigured disk, 6-12

Recovery Manager, 2-2

RMAN naming conventions, 2-6

specific configurations, 2-8

circular reuse records, 1-10

CLEAR LOGFILE clause

of ALTER DATABASE, 18-13

clearing RMAN configuration, 2-8, 6-19

clone databases

preparing for TSPITR, 19-10, 19-12

preparing parameter files for, 19-7

cold failover cluster

definition, 16-10

command files

Recovery Manager, 1-4

command interface

RMAN, 1-3

commands, Recovery Manager

BACKUP, 7-26

PROXY ONLY option, 2-14

PROXY option, 2-14

SKIP OFFLINE option, 7-12

batch execution, 1-4

CATALOG, 13-7

CHANGE, 4-7

CONFIGURE, 2-7, 2-8

DELETE, 4-20

DROP CATALOG, 13-34

DUPLICATE, 3-13

EXECUTE SCRIPT, 13-15

how RMAN interprets, 1-3

interactive, 1-4

LIST, 4-2

INCARNATION option, 13-9

piping, 1-6

RECOVER, 3-5

RESET DATABASE

INCARNATION option, 13-9

RESYNC CATALOG, 13-11

FROM CONTROLFILECOPY option, 13-25

SET

MAXCORRUPT option, 7-26

SHOW, 2-5, 4-7

standalone, 1-5

terminating, 15-13

UPGRADE CATALOG, 13-33

commands, SQL

ALTER DATABASE, 17-7, 17-19

commands, SQL*Plus

RECOVER

UNTIL TIME option, 17-32

SET, 17-7, 17-15, 17-19

compatibility

recovery catalog, 1-9

compilation

and execution of RMAN commands, 1-3

complete recovery

procedures, 17-21

CONFIGURE command

BACKUP OPTIMIZATION option, 6-21

CHANNEL option, 2-7

CLEAR option, 2-8, 6-19

DEFAULT DEVICE TYPE clause, 2-5

DEVICE TYPE clause, 2-4

EXCLUDE option, 6-24

RETENTION POLICY clause, 2-41, 2-42

configuring

media manager

installing, 6-5

prerequisites, 6-5

media managers for use with RMAN, 6-7

Recovery Manager

autobackups, 2-38

automatic channels, 6-12, 6-13

backup optimization, 6-21

backup set size, 6-20

clearing, 2-8, 6-19

default device types, 2-5

device types, 2-4

parallelism, 2-4

shared server, 6-29

SHOW command, 4-7

snapshot control file location, 6-26

specific channels, 6-16

tablespace exclusion for backups, 6-24

consistent backups

whole database, 16-4

control file autobackups

after structural changes to database, 2-38

configuring, 2-38

default format, 2-39

restoring, 2-39

control files

automatic backups, 2-40

configuring, 2-38

backing up to trace file, 16-15

backup and recovery, 8-7

backups, 16-2, 16-14

binary, 16-14

recovery using, 8-6

trace files, 16-14

creating, 17-13

duplicate database, 11-5

finding filenames, 16-2

loss of

all copies, 17-12

multiplexed

loss of, 17-8

restoring

to default location, 17-8

to nondefault location, 17-9

using SET DBID, 8-25

snapshot

specifying location of, 6-26

time-based recovery, 17-28

types of records, 1-10

using instead of a recovery catalog, 1-10

CONTROL_FILES initialization parameter, 10-24, 17-9

coordinated time-based recovery

distributed databases, 18-18

COPIES option

of BACKUP, 7-4

corrupt datafile blocks, 2-59

detecting, 2-59

records in control file, 2-58

recovering, 8-23

RMAN and, 2-57

setting maximum for backup, 7-26

corruption detection, 2-59

CREATE DATAFILE clause

of ALTER DATABASE, 18-4

CREATE TABLE statement

AS SELECT clause, 18-6

CREATE TABLESPACE statement, 18-3

creating

test databases, 3-13

crosschecking

definition, 4-7

recovery catalog with the media manager, 4-8

cumulative incremental backups, 2-36, 7-19

D

data blocks

corrupted, 20-3

data dictionary views, 16-5, 16-7, 16-13

Data Pump Export utility, 16-26

backups, 16-26

Data Pump Import utility, 16-26

database connections

Recovery Manager

auxiliary database, 5-4

hiding passwords, 5-5

database incarnation, 17-33

database point-in-time recovery (DBPITR)

definition, 8-2

user-managed, 17-27

databases

listing for backups, 16-2

media recovery procedures, 17-1 to ??

media recovery scenarios, 18-1

recovery

after control file damage, 17-8, 17-9

registering in recovery catalog, 13-5, 13-6

suspending, 16-18

unregistering in recovery catalog, 13-8

datafile recovery

definition, 3-5

datafiles

backing up

offline, 16-5

using Recovery Manager, 7-7, 7-8, 7-9, 7-10

cataloging, 13-7

determining status, 16-3

duplicate database, 11-6

listing

for backup, 16-2

losing, 18-2

in ARCHIVELOG mode, 18-2

in NOARCHIVELOG mode, 18-2

recovery

basic steps, 3-5

determining when necessary, 4-17

without backup, 18-4

re-creating, 18-4

renaming

after recovery, 18-4

restoring, 3-2, 17-6

to default location, 17-6

db identifier

problems registering copied database, 13-7

setting during disaster recovery, 8-9

setting with DBNEWID, 13-8

DB_FILE_NAME_CONVERT initialization parameter, 10-24, 19-9

using with RMAN DUPLICATE command, 11-8

DB_NAME initialization parameter, 10-23

DBA_DATA_FILES view, 16-5, 16-7, 16-13

DBMS_PIPE package, 1-6

using with RMAN, 5-7

DBNEWID utility, 13-8

DBVERIFY utility, 16-25

DELETE command, 4-20

OBSOLETE option, 2-46

deleting

expired backups, 4-21

files after backups, 4-23

obsolete backups, 4-21

using RMAN, 4-19

device types

configuring in RMAN, 6-12

differential incremental backups, 2-35

disk API, 6-7

disk channels

preconfigured, 6-12

distributed databases

change-based recovery, 18-18

coordinated time-based recovery, 18-18

recovery, 18-17

dropping the recovery catalog, 13-34

dummy API, 6-7

duplexing

backup sets, 2-20, 6-22, 7-3

DUPLICATE command, 3-13

duplicate databases

creating, 3-13

on local host, 11-19

on remote host with different file system, 11-14

on remote host with same file system, 11-13

past point-in-time, 11-23

using CONFIGURE AUXNAME, 11-17

using init.ora parameter and LOGFILE, 11-15

using SET NEWNAME, 11-16

datafiles, 11-6

excluding tablespaces, 3-14, 11-4

failed creation, 15-30

generating control files, 11-5

generating filenames, 11-5

how RMAN creates, 11-3

NOFILENAMECHECK option, 11-7

online redo logs, 11-5

preparing for duplication, 11-9

skipping offline normal tablespaces, 11-8

skipping read-only tablespaces, 11-7

duplicating a database, 3-13

troubleshooting, 15-30

E

environment, Recovery Manager

definition, 1-2

error codes

media manager, 15-4

RMAN, 15-2, 15-3

message numbers, 15-4

error messages

Recovery Manager

interpreting, 15-7

error stacks

interpreting, 15-7

errors

during RMAN backups, 7-26

EXCLUDE option

of CONFIGURE, 6-24

expired backups

deleting, 4-21

F

features, new, i-xxxiii to ??

filenames

listing for backup, 16-2

flashback table

using, 9-4, 9-5

FLASHBACK TABLE statement, 9-4, 9-5

flashback transaction query, 9-3

flashback undrop

about, 9-6

querying recycle bin, 9-8

recycle bin, 9-6

renaming tables for recycle bin, 9-7

restoring objects, 9-10

FORCE option

DELETE command, 4-22

fractured blocks

definition, 2-60

detection, 2-60

G

generic channels

definition, 6-13

groups

archived redo log, 18-10, 18-11

online redo log, 18-10, 18-11

H

hot backup mode

for online user-managed backups, 16-8

hot backups

failed, 16-10

ending with ALTER DATABASE END BACKUP, 16-11

I

image copies, 2-12

inactive online redo log

loss of, 18-12

INCARNATION option

of LIST, 13-9

of RESET DATABASE, 13-9

incomplete media recovery, 17-27

in Oracle Real Application Clusters configuration, 17-17

time-based, 17-32

with backup control file, 17-17

incomplete recovery

overview, 3-9

time-based, 8-3

using RMAN, 8-2

with current control file, 8-3

incremental backups, 7-19

differential, 2-35

how RMAN applies, 3-7

using RMAN, 7-4, 7-5

initialization parameter file, 3-5

initialization parameters

CONTROL_FILES, 17-9

DB_FILE_NAME_CONVERT, 10-24

DB_NAME, 10-23

LARGE_POOL_SIZE, 14-10

LOCK_NAME_SPACE, 10-23

LOG_ARCHIVE_DEST_n, 17-18

LOG_ARCHIVE_FORMAT, 17-17

LOG_FILE_NAME_CONVERT, 10-23

RECOVERY_PARALLELISM, 17-40

instance failures

in backup mode, 16-10

integrity checks, 2-58

interpreting RMAN error stacks, 15-7

interrupting media recovery, 17-20

I/O errors

effect on backups, 2-57

ignoring during deletions, 4-22

J

jobs

RMAN

monitoring performance, 4-17

monitoring progress, 4-13

K

KEEP option

of BACKUP, 2-47

of CHANGE, 4-24

L

LARGE_POOL_SIZE initialization parameter, 14-10

level 0 incremental backups, 2-34

LIST command, 4-2

INCARNATION option, 13-9

LOCK_NAME_SPACE initialization parameter, 10-23

log sequence numbers

requested during recovery, 17-14

log switches

recovery catalog records, 13-22

LOG_ARCHIVE_DEST_n initialization parameter, 17-18, 19-9

LOG_ARCHIVE_FORMAT initialization parameter, 17-17, 19-9

LOG_FILE_NAME_CONVERT initialization parameter, 10-23, 19-9

logical backups, 16-26

LOGSOURCE variable

SET statement, 17-7, 17-19

long waits

definition of, 14-12

long-term backups

changing status, 4-24

definition, 2-47

loss of

inactive log group, 18-12

M

managing RMAN metadata, 11-1, 13-1

MAXPIECESIZE parameter

SET command, 6-8

MAXSETSIZE parameter

BACKUP command, 6-20

CONFIGURE command, 6-20

MAXSIZE parameter

RECOVER command, 3-9

mean time to recovery (MTTR)

definition, 3-10

media failures

archived redo log file loss, 18-15

complete recovery, 17-21 to 17-27, 17-27

control file loss, 17-12

datafile loss, 18-2

NOARCHIVELOG mode, 17-37

online redo log group loss, 18-11

online redo log loss, 18-10

online redo log member loss, 18-10

recovery, 17-21 to ??

distributed databases, 18-17

recovery procedures

examples, 18-2

media management

backing up files, 1-11

Backup Solutions Program, 1-12

crosschecking, 4-7

error codes, 15-4

linking to software, 6-6

sbttest program, 15-10

testing the API, 15-10

media managers

configuring for use with RMAN, 6-7

installing, 6-5

linking

testing, 6-7

prerequisites for configuring, 6-5

testing, 6-7

testing backups, 6-10

troubleshooting, 6-10

media recovery, 17-1 to ??

ADD DATAFILE operation, 18-3

after control file damage, 17-8, 17-9

applying archived redo logs, 17-14

cancel-based, 17-25, 17-27, 17-32

change-based, 17-27

complete, 17-21 to 17-27, 17-27

closed database, 17-21

corruption

allowing to occur, 20-7

datafiles

basic steps, 3-5

without backup, 18-4

distributed databases, 18-17

coordinated time-based, 18-18

errors, 17-20, 20-3

incomplete, 17-27

interrupting, 17-20

lost files

lost archived redo log files, 18-15

lost datafiles, 18-2

lost mirrored control files, 17-8

NOARCHIVELOG mode, 17-37

offline tablespaces in open database, 17-24

online redo log files, 18-9

opening database after, 17-33, 17-35

parallel, 17-39

problems, 20-2, 20-3

fixing, 20-5

investigating, 20-4

restarting, 17-20

restoring

archived redo log files, 17-6

whole database backups, 17-37

resuming after interruption, 17-20

roll forward phase, 17-14

scenarios, 18-1

time-based, 17-27

transportable tablespaces, 18-8

trial, 20-9

explanation, 20-9

overview, 20-9

troubleshooting, 20-2

basic methodology, 20-3

types

distributed databases, 18-17

undamaged tablespaces online, 17-24

unsuccessfully applied redo logs, 17-20

using Recovery Manager, 3-5

metadata

managing RMAN, 1-7, 11-1, 13-1

querying RMAN, 4-2

storing in control file, 1-10

mirrored files

online redo log

loss of, 18-10

splitting, 16-18

suspend/resume mode, 16-18

using RMAN, 7-5

mirroring

backups using, 7-5

modes

NOARCHIVELOG

recovery from failure, 17-37

monitoring RMAN, 4-9

MOUNT option

STARTUP statement, 17-29, 17-31

multiplexed files

control files

loss of, 17-8

multiplexing

datafiles with Recovery Manager, 2-16

N

naming backup sets, 2-25

new features, i-xxxiii to ??

NOARCHIVELOG mode

backing up, 7-20

datafile loss in, 18-2

disadvantages, 17-37

recovery, 17-37

noncircular reuse records, 1-10

NOT BACKED UP SINCE clause

BACKUP command, 7-8

O

obsolete backups

deleting, 2-46, 4-21

different from expired backups, 2-42

reporting, 4-4

online redo logs, 18-12

active group, 18-10, 18-11

applying during media recovery, 17-14

archived group, 18-10, 18-11

clearing

failure, 18-13

clearing inactive logs

archived, 18-12

unarchived, 18-13

current group, 18-10, 18-11

determining active logs, 18-11

duplicate database, 11-5

inactive group, 18-10, 18-11

listing log files for backup, 16-2

loss of

active group, 18-14, 18-15

all members, 18-11

group, 18-11

mirrored members, 18-10

recovery, 18-9

multiple group loss, 18-15

replacing damaged member, 18-10

status of members, 18-10, 18-11

OPEN RESETLOGS clause

ALTER DATABASE statement, 13-9

operating system copies

definition, 2-13

operating system utilities

copying files with, 7-21

ORA-01578 error message, 18-6

orphaned backups

reports, 4-5

P

packages

DBMS_PIPE, 1-6, 5-7

parallel block recovery

definition, 17-39

parallel recovery, 17-40

parallelism

backups, 2-18

configuring RMAN, 2-4, 6-12

manually allocated RMAN channels, 2-9

partitioned tables

dropped partitions, 19-19

performing partial TSPITR, 19-16

split partitions, 19-22

password files

connecting to Recovery Manager with, 5-2

passwords

connecting to RMAN, 5-5

pipe interface, 1-6

pipes

using to run RMAN commands, 5-7

point of recoverability

recovery window, 2-43

point-in-time recovery, 17-27

tablespace, 10-1 to ??, 10-4 to ??, 10-5 to ??, 19-1 to 19-16

PROXY ONLY option

of BACKUP, 2-14

PROXY option

of BACKUP, 2-14

R

RATE option

of ALLOCATE CHANNEL, 2-31

of CONFIGURE CHANNEL, 2-31

raw devices

backing up to, 16-20

restoring to, 17-6

UNIX backups, 16-21

Windows backups, 16-23

read-only tablespaces

backing up, 7-12

backups, 16-12

RECOVER clause

of ALTER DATABASE, 17-7, 17-19

RECOVER command, 3-5, 3-9

PARALLEL option, 17-39

unrecoverable objects and standby databases, 18-6

UNTIL TIME option, 17-32

USING BACKUP CONTROLFILE clause, 18-6

recovery

ADD DATAFILE operation, 18-3

automatically applying archived logs, 17-15

cancel-based, 17-25, 17-32

complete, 17-21 to 17-27

closed database, 17-21

offline tablespaces, 17-24

corruption

intentionally allowing, 20-7

data blocks, 3-10, 8-21

guidelines, 3-11

database

in NOARCHIVELOG mode, 8-27

database files

how RMAN applies changes, 3-7

overview, 3-5

datafile without a backup, 8-28

datafiles, 18-2

ARCHIVELOG mode, 18-2

NOARCHIVELOG mode, 18-2

determining files needing recovery, 4-17, 17-4

disaster using RMAN, 8-18

dropped table, 18-17

errors, 20-3

incomplete, 8-2

interrupting, 17-20

media, 17-1, 18-1, 20-1

multiple redo threads, 17-17

of lost or damaged recovery catalog, 13-25

online redo logs, 18-9

losing member, 18-10

loss of group, 18-11

opening database after, 17-33

parallel, 17-39

parallel processes for, 17-40

problems, 20-2

fixing, 20-5

investigating, 20-4

responding to unsuccessful, 17-20

setting number of processes to use, 17-40

stuck, 20-2

time-based, 8-3, 17-32

transportable tablespaces, 18-8

trial, 20-9

explanation, 20-9

overview, 20-9

troubleshooting, 20-2

user errors, 18-16

user-managed, 17-1, 18-1, 20-1

using backup control file, 8-6, 8-7

with recovery catalog, 8-7

without recovery catalog, 8-8

using logs in a nondefault location, 17-18

using logs in default location, 17-17

using logs in nondefault location, 17-19

whole database

using backup control file, 8-7

without a recovery catalog, 1-10

recovery catalog, 1-7

availability, 13-28

backing up, 1-9, 13-22

compatibility, 1-9

contents, 1-8

crosschecking, 4-8

db identifier problems, 13-7

dropping, 13-34

incomplete recovery using, 8-3

log switch record, 13-22

managing size of, 13-21

moving to new database, 13-26

operating with, 1-7

operating without, 1-10

recovery of, 13-25

refreshing, 13-11

registering target databases, 1-8, 13-5, 13-6

resynchronizing, 13-11

snapshot control file, 1-8

space requirements, 13-3

stored scripts

creating, 13-16

synchronization, 1-8

UNKNOWN database name, 15-32

unregistering databases, 13-8

updating

after schema changes, 13-14

upgrading, 13-33

views

querying, 13-29

Recovery Manager

allocating channels, 14-8

allocating disk buffers, 14-2

allocating tape buffers, 14-3

backup sets

backing up, 7-7

backup types

duplexed backup sets, 2-20

backups

backing up, 2-22

batch deletion of obsolete, 2-46

control file autobackups, 2-40

datafile, 7-7, 7-8, 7-9, 7-10

image copy, 2-12

incremental, 7-4, 7-5

long-term, 2-47

optimization, 2-49

restartable, 2-54

tablespace, 7-7, 7-8, 7-9, 7-10

testing, 2-60, 7-10

types, 2-32

using tags, 2-26

validating, 7-10

channels, 2-2

generic configurations, 2-7

naming conventions, 2-6

specific configurations, 2-8

commands

BACKUP, 2-14, 7-26

CATALOG, 13-7

CHANGE, 4-7

EXECUTE SCRIPT, 13-15

interactive use of, 1-4

LIST, 13-9

RESYNC CATALOG, 13-25

standalone commands, 1-5

using command files, 1-4

compilation and execution of commands, 1-3

configuring

default device types, 2-5

device types, 2-4

showing, 4-7

corrupt datafile blocks, 2-59

handling I/O errors and, 2-57

crosschecking recovery catalog, 4-8

database connections

auxiliary database, 5-4

duplicate database, 5-4

hiding passwords, 5-5

with password files, 5-2

DBMS_PIPE package, 5-7

duplicate databases

how created, 11-3

environment

definition, 1-2

error codes

message numbers, 15-4

errors, 15-2, 15-3

interpreting, 15-7

file deletion

overview, 4-19

fractured block detection in, 2-60

hanging backups, 15-19

image copy backups, 2-12

incomplete recovery

with current control file, 8-3

incremental backups

cumulative, 2-36

differential, 2-35

level 0, 2-34

integrity checking, 2-58

interactive use of commands, 1-4

jobs

monitoring progress, 4-13

media management

backing up files, 1-11

Backup Solutions Program (BSP), 1-12

crosschecking, 4-7

media manager, linking with a, 6-6

metadata, 1-7, 11-1, 13-1

storing in control file, 1-10

monitoring, 4-9, 4-17

multiplexing

datafiles, 2-16

overview, 1-3

performance, 14-8

monitoring, 4-9

pipe interface, 1-6

recovery

after total media failure, 8-18

incomplete, 8-2

using backup control file, 8-7

recovery catalog, 1-7

availability, 13-28

backing up, 13-22

compatibility, 1-9

contents, 1-8

crosschecking, 4-8

managing the size of, 13-21

moving to new database, 13-26

operating with, 1-7

operating without, 1-10

recovering, 13-25

registration of target databases, 1-8, 13-6

resynchronizing, 13-11

snapshot control file, 1-8

synchronization, 1-8

updating after schema changes, 13-14

upgrading, 13-33

reports, 4-2

overview, 4-3

restoring

datafiles, 3-2

to new host, 8-11

return codes, 15-10

RPC calls and, 15-20

snapshot control file location, 6-26

standby databases

creating, 3-15

starting, 5-2

stored scripts, 1-5

synchronous and asynchronous I/O, 14-4

tablespace point-in-time recovery, 3-10

tags for backups, 2-26

terminating commands, 15-13

test disk API, 6-7

types of backups, 2-12

using incremental backups, 14-8

using RMAN commands, 1-3

using with a pipe, 5-7

recovery window

point of recoverability, 2-43

recovery windows

backup optimization and, 2-52

definition, 2-43

RECOVERY_PARALLELISM initialization parameter, 17-40

recycle bin

about, 9-6

renamed objects, 9-7

restoring objects from, 9-10

viewing, 9-8

redo logs

incompatible format, 20-3

listing files for backup, 16-2

naming, 17-17

parallel redo, 20-3

redo records

problems when applying, 20-2

REPORT OBSOLETE command, 2-46

reports, 4-2

obsolete backups, 4-4

orphaned backups, 4-5

overview, 4-3

repository

RMAN, 1-7

RESET DATABASE command

INCARNATION option, 13-9

RESETLOGS operation

when necessary, 17-34

RESETLOGS option

of ALTER DATABASE, 17-33, 17-35, 17-37, 17-39

restartable backups

definition, 2-54, 7-8

restarting RMAN backups, 7-8

RESTORE command, 3-2

FORCE option, 3-5

restore optimization, 3-5

restoring

archived redo logs, 17-6

backup control file

using SET DBID, 8-25

control files

to default location, 17-8

to nondefault location, 17-9

database

to default location, 17-37

to new host, 8-11

to new location, 17-38

database files, 3-2

how RMAN chooses, 3-3

mechanics, 3-2

restore optimization, 3-5

datafiles

to default location, 17-6

to raw devices, 17-6

user-managed backups, 17-3

keeping records, 16-27

RESUME clause

ALTER SYSTEM statement, 16-20

resuming recovery after interruption, 17-20

RESYNC CATALOG command, 13-11

FROM CONTROLFILECOPY option, 13-25

resynchronizing the recovery catalog, 13-11

retention policies

affect on backup optimization, 2-52

definition, 2-41

disabling, 2-42

exempt backups, 2-47

recovery window, 2-42

redundancy, 2-42, 2-45

return codes

RMAN, 15-10

RMAN. See Recovery Manager

S

sbtio.log

and RMAN, 15-3

sbttest program, 15-10

scenarios, Recovery Manager

backing up archived redo logs, 7-17

cataloging operating system copies, 7-21

duplexing backup sets, 7-3

handling backup errors, 7-26

incremental backups, 7-19

incremental cumulative backups, 7-19

maintaining backups and copies, 7-22

NOARCHIVELOG backups, 7-20

recovering pre-resetlogs backup, 8-4, 8-27

recovery after total media failure, 8-18

setting size of backup sets, 7-15

schemas

changes

updating recovery catalog, 13-14

SCN (system change number)

use in distributed recovery, 18-19

server parameter files

autobackups, 2-38

configuring autobackups, 2-38

server sessions

Recovery Manager, 1-3

session architecture

Recovery Manager, 1-3

SET command

MAXCORRUPT option, 7-26

SET statement

AUTORECOVERY option, 17-15

LOGSOURCE variable, 17-7, 17-19

shared server

configuring for use with RMAN, 6-29

short waits

definition of, 14-12

SHOW command, 2-5, 4-7

SHUTDOWN statement

ABORT option, 17-8, 17-9, 17-28, 17-37, 17-38

size of backup sets

setting, 2-28

SKIP OFFLINE option

of BACKUP, 7-12

SKIP READONLY option

of BACKUP, 7-12

snapshot control files, 1-8

specifying location, 6-26

split mirrors

using as backups, 7-5

splitting mirrors

suspend/resume mode, 16-18

standalone Recovery Manager commands, 1-5

standby databases

creating using RMAN, 3-15

starting RMAN

without connecting to a database, 5-2

STARTUP statement

MOUNT option, 17-29, 17-31

stored scripts

creating RMAN, 13-16

deleting, 13-19

managing, 13-15

Recovery Manager, 1-5

stuck recovery

definition, 20-2

SUSPEND clause

ALTER SYSTEM statement, 16-19

suspending a database, 16-18

suspend/resume mode, 16-18

system time

changing

effect on recovery, 17-28

T

tables

FLASHBACK TABLE statement, 9-4

flashback transaction query, 9-3

recovery of dropped, 18-17

tablespace backups

using RMAN, 7-7, 7-8, 7-9, 7-10

tablespace point-in-time recovery

clone database, 19-2

introduction, 19-2

methods, 19-3

performing, 19-1 to 19-16

planning for, 19-4

procedures for using transportable tablespace feature, 19-14, 19-15

requirements, 19-5

terminology, 19-2

transportable tablespace method, 19-3

user-managed, 19-3

using RMAN, 3-10

basic steps, 10-4

introduction, 10-1

planning, 10-6

preparing the auxiliary instance, 10-22

restrictions, 10-6

why perform, 10-4

tablespaces

backups, 16-8

offline, 16-5

online, 16-8

excluding from RMAN backups, 6-24

read-only

backing up, 7-12, 16-13

read/write

backing up, 16-7

recovering offline in open database, 17-24

transporting RMAN backups, 8-29

tags, 2-26

terminating RMAN commands, 15-13

test databases, creating, 3-13

test disk API, 6-7

testing RMAN

backups, 2-60, 7-10

with media management API, 15-10

time format

RECOVER DATABASE UNTIL TIME statement, 17-32

time-based recovery, 17-32

coordinated in distributed databases, 18-18

trace files

and RMAN, 15-2

backing up control file, 16-15

control file backups to, 16-14

transportable tablespaces, 8-29

recovery, 18-8

TSPITR and, 19-3

transporting tablespaces between databases, 8-29

trial recovery

explanation, 20-9

overview, 20-9

TSPITR. See tablespace point-in-time recovery

tuning

Recovery Manager

V$ views, 4-9

U

UNAVAILABLE option

of CHANGE, 4-24

unrecoverable objects

and RECOVER operation, 18-6

recovery

unrecoverable objects and, 18-6

unregistering a database from the recovery catalog, 13-8

UNTIL TIME option

RECOVER command, 17-32

upgrading the recovery catalog, 13-33

user errors

recovery from, 18-16

user-managed backups, 16-4

backup mode, 16-10

control files, 16-14

binary, 16-14

trace files, 16-14

determining datafile status, 16-3

hot backups, 16-11

listing files before, 16-2

offline datafiles, 16-5

offline tablespaces, 16-5

read-only tablespaces, 16-12

restoring, 17-6

tablespace, 16-8

verifying, 16-25

whole database, 16-4

user-managed recovery, 17-27

ADD DATAFILE operation, 18-3

applying archived redo logs, 17-14

complete, 17-21

incomplete, 17-27

interrupting, 17-20

opening database after, 17-33

scenarios, 18-1

user-managed restore operations, 17-3

USING BACKUP CONTROLFILE option

RECOVER command, 17-31

utilities

operating system, using to make copies, 7-21

V

V$ARCHIVED_LOG view, 3-8

listing all archived logs, 16-17

V$BACKUP view, 16-3

V$BACKUP_ASYNC_IO, 4-10

V$BACKUP_CORRUPTION view, 2-58

V$BACKUP_SYNC_IO, 4-10

V$COPY_CORRUPTION view, 2-58

V$DATABASE_BLOCK_CORRUPTION view, 7-10, 8-23

V$DATAFILE view, 16-2

listing files for backups, 16-2

V$LOG_HISTORY view

listing all archived logs, 17-7

V$LOGFILE view, 18-10, 18-11

listing files for backups, 16-2

listing online redo logs, 16-2

V$PROCESS view, 4-9

V$RECOVER_FILE view, 4-9, 17-4

V$RECOVERY_LOG view

listing logs needed for recovery, 17-7

V$RMAN_OUTPUT view, 4-9

V$RMAN_STATUS view, 4-9

V$SESSION view, 4-9

V$SESSION_LONGOPS view, 4-9

V$SESSION_WAIT view, 4-10

V$TABLESPACE view, 16-2

validating

backups, 7-10

views

recovery catalog, 13-29

W

whole database backups

ARCHIVELOG mode, 16-4

inconsistent, 16-4

NOARCHIVELOG mode, 16-4

preparing for, 16-4