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, 18.5.1.1, 18.5.1.2, 18.8.1, 18.10.1, 18.10.2

active online redo log

loss of group, 19.8.2.2, 19.8.2.2

alert log, 19.11.1

checking after RESETLOGS, 18.9.3

useful for RMAN, 12.1.1

ALLOW ... CORRUPTION clause

RECOVER command, 21.5

ALTER DATABASE statement

BACKUP CONTROLFILE clause, 17.5.2

TO, 17.5.2

CLEAR LOGFILE clause, 19.8.2.1.3

END BACKUP clause, 17.4.3.1

NORESETLOGS option, 18.9.2

OPEN RESETLOGS clause, 10.2.3

RECOVER clause, 18.4.2, 18.6.6

RESETLOGS option, 18.9.2, 18.9.2, 18.10.1, 18.10.2

ALTER SYSTEM statement

KILL SESSION clause, 12.3.1

RESUME clause, 17.7.2

SUSPEND clause, 17.7.2, 17.7.2

ALTER TABLESPACE statement

BEGIN BACKUP clause, 17.4.1, 17.4.2.2

END BACKUP option, 17.4.2.2

archived redo logs

applying during media recovery, 18.6

automating application, 18.6.2.1, 18.6.2.2

backing up, 6.9.6

cataloging, 10.2.1.2

changing default location, 18.6.5

corrupted, 21.1

deleting after recovery, 18.4.2

deletion after backup, 2.2.4.1, 9.3.2.4

deletion after restore, 3.2.2.1

errors during recovery, 18.6.7

incompatible format, 21.1

location during recovery, 18.6

loss of, 19.9

restoring, 18.4.2

RMAN fails to delete, 12.4.6

using for recovery

in default location, 18.6.3

in nondefault location, 18.6.6

ARCHIVELOG mode

datafile loss in, 19.1.2, 19.1.2

AS SELECT clause

CREATE TABLE statement, 19.5

autobackups

control file, 2.6, 2.6.2.1

server parameter file, 2.6

automatic channels, 2.1

allocation, 2.1

configuring, 5.3, 5.3.1, 5.3.4, 6.1

generic

configuring, 2.1.5, 5.3.2

definition, 5.3.2

naming conventions, 2.1.4

overriding, 5.3

parallelism, 5.3.1

specific configurations, 2.1.6, 2.1.6

AUTORECOVERY option

SET statement, 18.6.2

auxiliary instance parameter file

with TRANSPORT TABLESPACE, 14.3.4

B

BACKUP

and corrupt datafile blocks and MAXCORRUPT, 2.11.2

AS COPY

and DB_FILE_NAME_CONVERT, 2.4.2

and output filenames, 2.4.2

FORMAT, 2.4.2

image copy

and output filenames, 2.4.2

INCREMENTAL

FROM SCN, 13.8

INCREMENTAL FROM SCN, 13.8.1

output filenames

image copies, 2.4.2

BACKUP command, 6.9.13

BACKUPSET option, 2.3.2, 6.4

DELETE INPUT option, 9.3.3

FORMAT parameter, 2.4.1

KEEP option, 2.7.4

NOT BACKED UP SINCE clause, 2.9, 6.7

PROXY ONLY option, 2.2.2

PROXY option, 2.2.2

SKIP OFFLINE option, 6.9.1, 6.9.1

VALIDATE option, 2.12.4

BACKUP CONTROLFILE clause

of ALTER DATABASE, 17.1.1

BACKUP CONTROLFILE TO TRACE clause

of ALTER DATABASE, 17.1.1

BACKUP COPIES parameter

CONFIGURE command, 5.6

backup encryption, 6.6.1

dual-mode, 6.6.1.3

overview, 6.6

password, 6.6.1.2

transparent, 6.6.1.1

backup mode

ending with ALTER DATABASE END BACKUP, 17.4.3.1

for online user-managed backups, 17.4.1

instance failure, 17.4.3

backup optimization

configuring, 5.5

definition, 2.8, 6.7

disabling, 2.8.3, 5.5

enabling, 2.8.3, 5.5

recovery window and, 2.8.5.1

redundancy and, 2.8.5.2

retention policies and, 2.8.5

BACKUP OPTIMIZATION option

of CONFIGURE, 6.7

backup retention policy

definition, 2.7

backup sets

backing up, 2.3.2, 6.4

configuring maximum size, 5.4

crosschecking, 9.2

duplexing, 6.2

errors during creation, 2.11

failover during backups, 2.3.2.3

how RMAN generates, 2.4.5

limiting size, 2.4.5

multiplexing, 2.2.5

naming, 2.4.1

specifying maximum size (in bytes), 2.4.4

specifying number of, 2.4.5

Backup Solutions Program (BSP), 1.4.2

backups

archived redo logs, 6.9.6

deletion after backing up, 9.3.2.4

availability

altering with CHANGE command, 9.4

backup sets, 6.4

backups of, 2.3.2

closed, 17.2.1

consistent, 17.2

control files, 17.5, 17.5

binary, 17.5.1

trace files, 17.5.2

correlating RMAN channels with, 9.6.1.2.1, 9.6.1.2.2

cumulative incremental, 2.5.1.4, 3.4

datafile

using RMAN, 6.4, 6.7.1, 6.7.2

DBVERIFY utility, 17.9

deleting, 9.3.2

determining datafile status, 17.1.2

duplexing, 5.6, 6.2

excluding tablespaces from backups, 5.7

failed RMAN, 12.4.7

failover during BACKUP BACKUPSET, 2.3.2.3

hung, 12.4.2

image copies, 2.2.1

inconsistent, 17.2

incremental, 2.5.1

differential, 2.5.1.3

using RMAN, 6.2.1, 6.2.2

interrupted, 6.7

keeping, 6.9.11

keeping records, 17.12

limiting I/O rate, 2.4.6

listing files needed, 17.1

logical, 17.10

long-term, 2.7.4, 2.7.4

changing status, 9.5

multiple copies, 5.6

NOARCHIVELOG mode, in, 6.9.10

obsolete

batch deletes, 2.7.3

offline datafiles, 17.3

offline tablespaces, 17.3, 17.3

optimizing, 2.8

read-only tablespaces, 17.4.4

recovery catalog, 1.3.2.4, 10.6.1

restartable, 2.9, 6.7

restoring user-managed, 18.2

RMAN error handling, 6.9.13

specifying number of files in a backup set, 2.4.5.1

split mirror, 2.2.1.2

using RMAN, 6.3

stored scripts, 10.5

tablespace, 17.4.2

using RMAN, 6.4, 6.7.1, 6.7.2

tags, 2.4.3

testing RMAN, 2.12.4, 6.8

using media manager, 5.2.3.4

troubleshooting failed RMAN, 12.4.1, 12.4.4, 12.4.5

types, 2.5

Updating standby databases with incrementals, 13.8.1

user-managed, 17

restoring, 18.4.1

validating, 6.8

verifying, 17.9

whole database

preparing for, 17.2.1

BEGIN BACKUP clause

ALTER TABLESPACE statement, 17.4.1

block corruptions

stored in V$DATABASE_BLOCK_CORRUPTION, 6.8

block media recovery, 7.5

guidelines, 3.3.1

overview, 3.3

BLOCKRECOVER command, 3.3, 7.5

BSP. See Backup Solutions Program (BSP)

C

cancel-based media recovery

procedures, 18.7.2, 18.8.4

canceling RMAN commands, 12.3

CATALOG command, 10.2.1.2

cataloging

archived redo logs, 10.2.1.2

datafiles, 10.2.1.2

catalog.sql script, 10.1.2

catproc.sql script, 10.1.2

CHANGE command, 9.2

AVAILABLE option, 9.4

KEEP option, 9.5

change-based media recovery

coordinated in dis, 19.11.1

channels

allocating manually for backups, 6.1

configuring automatic, 5.3

configuring for backups, 6.1

control options, 2.1.9

definition, 2.1

difference between manual and automatic, 2.1.1

generic configurations, 2.1.5

overriding automatic, 5.3

parallelism for manual channels, 2.1.8

preconfigured disk, 5.3

Recovery Manager, 2.1

RMAN naming conventions, 2.1.4

specific configurations, 2.1.6

circular reuse records, 1.3.1.1

CLEAR LOGFILE clause

of ALTER DATABASE, 19.8.2.1.3

clearing RMAN configuration, 2.1.7, 5.3.5

clone databases

preparing for TSPITR, 20.3.1, 20.3.2

cold failover cluster

definition, 17.4.3

command files

Recovery Manager, 1.2.2.2

command interface

RMAN, 1.2

commands, Recovery Manager

BACKUP, 6.9.13

PROXY ONLY option, 2.2.2

PROXY option, 2.2.2

SKIP OFFLINE option, 6.9.1

batch execution, 1.2.2.2

CATALOG, 10.2.1.2

CHANGE, 9.2

CONFIGURE, 2.1.5, 2.1.7

DELETE, 9.3.2

DROP CATALOG, 10.12

DUPLICATE, 3.4

EXECUTE SCRIPT, 10.5

how RMAN interprets, 1.2

interactive, 1.2.2.1

LIST, 9.1.1

INCARNATION option, 10.2.3

piping, 4.7

RECOVER, 3.2

RESET DATABASE

INCARNATION option, 10.2.3

RESYNC CATALOG, 10.3

FROM CONTROLFILECOPY option, 10.6.3

SET

MAXCORRUPT option, 6.9.13

SHOW, 2.1.2

standalone, 1.2.2.5

terminating, 12.3, 12.3

UPGRADE CATALOG, 10.11

commands, SQL

ALTER DATABASE, 18.4.2, 18.6.6

commands, SQL*Plus

RECOVER

UNTIL TIME option, 18.8.4

SET, 18.4.2, 18.6.2, 18.6.6

compatibility

recovery catalog, 1.3.2.5

compilation

and execution of RMAN commands, 1.2.1

complete recovery

procedures, 18.7

CONFIGURE command

BACKUP OPTIMIZATION option, 5.5

CHANNEL option, 2.1.5

CLEAR option, 2.1.7, 5.3.5

DEFAULT DEVICE TYPE clause, 2.1.3

DEVICE TYPE clause, 2.1.2

EXCLUDE option, 5.7

RETENTION POLICY clause, 2.7, 2.7

configuring

media manager

installing, 5.2.1

prerequisites, 5.2.1

media managers for use with RMAN, 5.2.3.1

Recovery Manager

autobackups, 2.6

automatic channels, 5.3, 5.3.2

backup optimization, 5.5

backup set size, 5.4

clearing, 2.1.7, 5.3.5

default device types, 2.1.3

device types, 2.1.2

parallelism, 2.1.2

shared server, 5.10

snapshot control file location, 5.9

specific channels, 5.3.4

tablespace exclusion for backups, 5.7

consistent backups

whole database, 17.2

control file autobackups

after structural changes to database, 2.6

configuring, 2.6

default format, 2.6.1

restoring, 2.6

control files

automatic backups, 2.6.2.1

configuring, 2.6

backing up to trace file, 17.5.2.1

backups, 17.1.1, 17.5

binary, 17.5.1

recovery using, 7.3

trace files, 17.5.2

creating after loss of all copies, 18.5.3

duplicate database, 13.2.1

finding filenames, 17.1.1

multiplexed

loss of, 18.5.1

recreated, 18.5.3

restoring

to default location, 18.5.1.1

to nondefault location, 18.5.1.2

using SET DBID, 7.6.2

snapshot

specifying location of, 5.9

time-based recovery, 18.8.2

types of records, 1.3.1.1

user-managed restore after loss of all copies, 18.5.3

using instead of a recovery catalog, 1.3.1

CONTROL_FILES initialization parameter, 8.5.1.2, 18.5.1.2

CONVERT command

and DB_FILE_NAME_CONVERT, 15.1.1

moving data to/from ASM, 15.4

with databases, 15.2

with tablespaces and datafiles, 15

CONVERT DATABASE, 15.2

CONVERT DATAFILE

moving to/from ASM, 15.4

CONVERT DATAFILE or TABLESPACE, 15.1

CONVERT TABLESPACE

moving to/from ASM, 15.4

coordinated time-based recovery

distributed databases, 19.11.1

COPIES option

of BACKUP, 6.2.2

corrupt datafile blocks, 2.12.1

detecting, 2.12.1, 2.12.2

records in control file, 2.11.2

recovering, 7.5.3

RMAN and, 2.11.1

setting maximum for backup, 6.9.13

corrupt datafile blocks during backup, 2.11.2

corruption detection, 2.12.2

CREATE DATAFILE clause

of ALTER DATABASE, 19.3

CREATE TABLE statement

AS SELECT clause, 19.5

CREATE TABLESPACE statement, 19.2

creating

test databases, 3.4

crosschecking

definition, 9.2

recovery catalog with the media manager, 9.2

cross-platform transportable database, 15.2

transport script, 15.3.2.1

cross-platform transportable tablespace, 15

cumulative incremental backups, 2.5.1.4

D

data blocks

corrupted, 21.1

data dictionary views, 17.3, 17.4.1, 17.4.4

Data Pump Export utility, 17.10

backups, 17.10

Data Pump Import utility, 17.10

database connections

Recovery Manager

auxiliary database, 4.3

hiding passwords, 4.5

database incarnation, 18.9

database point-in-time recovery (DBPITR)

user-managed, 18.8

databases

listing for backups, 17.1

media recovery procedures, user-managed, 18

media recovery scenarios, 19

recovery

after control file damage, 18.5.1.1, 18.5.1.2

registering in recovery catalog, 10.2.1, 10.2.1

suspending, 17.7.1

unregistering in recovery catalog, 10.2.2

datafile recovery

definition, 3.2

datafiles

backing up

offline, 17.3

using Recovery Manager, 6.4, 6.7.1, 6.7.2

cataloging, 10.2.1.2

determining status, 17.1.2

duplicate database, 13.2.3

listing

for backup, 17.1

losing, 19.1

in ARCHIVELOG mode, 19.1.2

in NOARCHIVELOG mode, 19.1.1

recovery

basic steps, 3.2.1

without backup, 19.3

re-creating, 19.3

renaming

after recovery, 19.2

restoring, 3.1, 18.4.1

to default location, 18.4.1

db identifier

problems registering copied database, 10.2.1.2

setting during disaster recovery, 7.3.1

setting with DBNEWID, 10.2.1.2

DB_FILE_NAME_CONVERT

and CONVERT command, 15.1.1

DB_FILE_NAME_CONVERT initialization parameter, 8.5.1.2, 20.2.6

using with RMAN DUPLICATE command, 13.2.3, 13.2.4, 13.2.4

DB_NAME initialization parameter, 8.5.1.2

DBA_DATA_FILES view, 17.3, 17.4.1, 17.4.4

DBMS_PIPE package, 4.7

using with RMAN, 4.7

DBNEWID utility, 10.2.1.2

DBVERIFY utility, 17.9

DELETE command, 9.3.2

OBSOLETE option, 2.7.3

deleting

expired backups, 9.3.2.3

files after backups, 9.3.3

obsolete backups, 9.3.2.2

using RMAN, 9.3.1

device types

configuring in RMAN, 5.3.1

differential incremental backups, 2.5.1.3

disk API, 5.2.3

disk channels

preconfigured, 5.3

distributed databases

change-based recovery, 19.11.1

coordinated time-based recovery, 19.11.1

recovery, 19.11, 19.11

dropping the recovery catalog, 10.12

dual mode backup encryption, 6.6.1.3

dummy API, 5.2.3

duplexing

backup sets, 2.3.1, 5.6, 6.2

DUPLICATE command, 3.4

duplicate database

synchronizing

using DUPLICATE DATABASE, 13.7

using incremental backups, 13.8

duplicate databases

creating, 3.4

on local host, 13.5.3

on remote host with different file system, 13.5.2

on remote host with same file system, 13.5.1

past point-in-time, 13.6.4

using CONFIGURE AUXNAME, 13.5.2.4

using init.ora parameter and LOGFILE, 13.5.2.2

using SET NEWNAME, 13.5.2.3

datafiles, 13.2.3

excluding tablespaces, 3.4, 13.1.2

failed creation, 12.4.10

generating control files, 13.2.1

generating filenames, 13.2

how RMAN creates, 13.1.1

NOFILENAMECHECK option, 13.2.3.1

preparing for duplication, 13.4

skipping offline normal tablespaces, 13.3.2

skipping read-only tablespaces, 13.3.1

duplicating a database, 3.4

troubleshooting, 12.4.10

E

endian formats

and CONVERT DATAFILE/TABLESPACE, 15.1

environment, Recovery Manager

definition, 1.1

error codes

media manager, 12.1.3.2

RMAN, 12.1, 12.1.3

message numbers, 12.1.3.1

error messages

Recovery Manager

interpreting, 12.1.4

error stacks

interpreting, 12.1.4

errors

during RMAN backups, 6.9.13

EXCLUDE option

of CONFIGURE, 5.7

expired backups

deleting, 9.3.2.3

F

FAST_START_MTTR_TARGET

and tuning instance recovery, 11.4.4

Fast-Start checkpointing architecture, 11.4.3

Fast-Start Fault Recovery, 11.4, 11.4.3

features, new, Preface

fileNameConversionSpec

and CONVERT command, 15.1.1

filenames

listing for backup, 17.1

FORCE option

DELETE command, 9.3.5

fractured blocks

definition, 2.12.3

detection, 2.12.3

G

generic channels

definition, 5.3.2

groups

archived redo log, 19.8.1, 19.8.2

online redo log, 19.8.1, 19.8.2

H

hot backup mode

for online user-managed backups, 17.4.1

hot backups

failed, 17.4.3

ending with ALTER DATABASE END BACKUP, 17.4.3.1

I

image copies, 2.2.1

and SWITCH commands, 2.2.1.1

inactive online redo log

loss of, 19.8.2.1

INCARNATION option

of LIST, 10.2.3

of RESET DATABASE, 10.2.3

incomplete media recovery, 18.8

in Oracle Real Application Clusters configuration, 18.6.2.2

time-based, 18.8.4

with backup control file, 18.6.2.2

incomplete recovery

overview, 3.2.3

incremental backups

differential, 2.5.1.3

how RMAN applies, 3.2.2

using RMAN, 6.2.1, 6.2.2

Incremental Roll Forward of Database Copy, 13.8

initialization parameter file, 3.2

initialization parameters

CONTROL_FILES, 18.5.1.2

DB_FILE_NAME_CONVERT, 8.5.1.2

DB_NAME, 8.5.1.2

LARGE_POOL_SIZE, 11.3.3

LOCK_NAME_SPACE, 8.5.1.2

LOG_ARCHIVE_DEST_n, 18.6.3

LOG_ARCHIVE_FORMAT, 18.6.3

LOG_FILE_NAME_CONVERT, 8.5.1.2

RECOVERY_PARALLELISM, 18.11

instance failures

in backup mode, 17.4.3

instance recovery

Fast-Start Fault Recovery, 11.4.3

performance tuning, 11.4

integrity checks, 2.12

interpreting RMAN error stacks, 12.1.4

interrupting media recovery, 18.6.8

I/O errors

effect on backups, 2.11.1

ignoring during deletions, 9.3.5

J

jobs

RMAN

monitoring performance, 9.6.4

monitoring progress, 9.6.2

K

KEEP option

of BACKUP, 2.7.4

of CHANGE, 9.5

L

level 0 incremental backups, 2.5.1.2

LIST command, 9.1.1

INCARNATION option, 10.2.3

LOCK_NAME_SPACE initialization parameter, 8.5.1.2

log sequence numbers

requested durin, 18.6

LOG_ARCHIVE_DEST_n initialization parameter, 18.6.3, 20.2.6

LOG_ARCHIVE_FORMAT initialization parameter, 18.6.3, 20.2.6

LOG_FILE_NAME_CONVERT initialization parameter, 8.5.1.2, 20.2.6

logical backups, 17.10

LOGSOURCE variable

SET statement, 18.4.2, 18.6.6

long waits

defined, 11.3.5.2

long-term backups

changing status, 9.5

definition, 2.7.4, 2.7.4

loss of

inactive log group, 19.8.2.1

M

managing RMAN metadata, 10, 13

MAXCORRUPT setting, 2.11.2

MAXPIECESIZE parameter

SET command, 5.2.3.2.2

MAXSETSIZE parameter

BACKUP command, 5.4

CONFIGURE command, 5.4

MAXSIZE parameter

RECOVER command, 3.2.2.1

mean time to recovery (MTTR)

definition, 3.3

media failures

archived redo log file loss, 19.9

complete recovery, 18.7

complete recovery, user-managed, 18.7

control file loss, 18.5.3

datafile loss, 19.1

NOARCHIVELOG mode, 18.10

online redo log group loss, 19.8.2

online redo log loss, 19.8.1

online redo log member loss, 19.8.1

recovery, 18.7

distributed databases, 19.11

recovery procedures

examples, 19.1

media management

backing up files, 1.4.1

Backup Solutions Program, 1.4.2

crosschecking, 9.2

error codes, 12.1.3.2

linking to software, 5.2.2

sbttest program, 12.2.1

testing the API, 12.2

media managers

configuring for use with RMAN, 5.2.3.1

installing, 5.2.1

linking

testing, 5.2.3

prerequisites for configuring, 5.2.1

testing, 5.2.3

testing backups, 5.2.3.4

troubleshooting, 5.2.3.4

media recovery

ADD DATAFILE operation, 19.2

after control file damage, 18.5.1.1, 18.5.1.2

applying archived redo logs, 18.6

cancel-based, 18.7.2, 18.8, 18.8.4

ch, 18.8

complete, 18.7

closed database, 18.7.1

complete, user-managed, 18.7

corruption

allowing to occur, 21.4

datafiles

basic steps, 3.2.1

without backup, 19.3

distributed databases, 19.11

errors, 18.6.7, 18.6.7, 21.1

incomplete, 18.8

interrupting, 18.6.8

lost files

lost archived redo log files, 19.9

lost datafiles, 19.1

lost mirrored control files, 18.5.1

NOARCHIVELOG mode, 18.10, 18.10

offline tablespaces in open database, 18.7.2

online redo log files, 19.8

opening database after, 18.9, 18.9.2

parallel, 18.11

problems, 21.1, 21.1

fixing, 21.3

investigating, 21.2

restarting, 18.6.8

restoring

archived redo log files, 18.4.2

whole database backups, 18.10

resuming after interruption, 18.6.8

roll forward phase, 18.6

scenarios, 19

time-based, 18.8

transportable tablespaces, 19.7

trial, 21.6

explanation, 21.6.1

overview, 21.6

troubleshooting, 21.1

basic methodology, 21.1

types

distributed databases, 19.11

undamaged tablespaces online, 18.7.2

unsuccessfully applied redo logs, 18.6.7

using Recovery Manager, 3.2

media recovery, user-managed, 18

metadata

managing RMAN, 1.3, 10, 13

querying RMAN, 9.1

storing in control file, 1.3.1

mirrored files

online redo log

loss of, 19.8.1

splitting, 17.7.1

suspend/resume mode, 17.7.1

using RMAN, 6.3

mirroring

backups using, 6.3

modes

NOARCHIVELOG

recovery from failure, 18.10

monitoring RMAN, 9.6

MOUNT option

STARTUP statement, 18.8.2, 18.8.3

multiplexed files

control files

loss of, 18.5.1

multiplexing

datafiles with Recovery Manager, 2.2.5

N

naming backup sets, 2.4.1

new features, Preface

NOARCHIVELOG mode

backing up, 6.9.10

datafile loss in, 19.1.1

disadvantages, 18.10

recovery, 18.10

noncircular reuse records, 1.3.1.1

NOT BACKED UP SINCE clause

BACKUP command, 6.7

not feasible to test 1 oct 04 nocheck, 5.2.3.1

O

obsolete backups

deleting, 2.7.3, 9.3.2.2

different from expired backups, 2.7

reporting, 9.1.2.1

online redo logs, 19.8.2.1

active group, 19.8.1, 19.8.2

applying during media recovery, 18.6

archived group, 19.8.1, 19.8.2

clearing

failure, 19.8.2.1.3

clearing inactive logs

archived, 19.8.2.1.1

unarchived, 19.8.2.1.2

current group, 19.8.1, 19.8.2

determining active logs, 19.8.2

inactive group, 19.8.1, 19.8.2

listing log files for backup, 17.1.1

loss of

active group, 19.8.2.2, 19.8.2.2

all members, 19.8.2

group, 19.8.2

mirrored members, 19.8.1

recovery, 19.8

multiple group loss, 19.8.2.3

replacing damaged member, 19.8.1

status of members, 19.8.1, 19.8.2

online tablespace transport, 14

OPEN RESETLOGS clause

ALTER DATABASE statement, 10.2.3

operating system copies

definition, 2.2.1.2

ORA-01578 error message, 19.5

Oracle Encryption Wallet

and backups, 6.6.1.1

P

packages

DBMS_PIPE, 4.7, 4.7

parallel recovery, 18.11

parallelism

backups, 2.2.7

configuring RMAN, 2.1.2, 5.3.1

manually allocated RMAN channels, 2.1.8

partitioned tables

dropped partitions, 20.6

performing partial TSPITR, 20.5

split partitions, 20.7

password backup encryption, 6.6.1.2

password files

connecting to Recovery Manager with, 4.2

passwords

connecting to RMAN, 4.5

performance tuning

backup performance, 11.3

disk bandwidth and RATE channel parameter, 11.2.1

Fast-Start Fault Recovery, 11.4

instance recovery, 11.4

FAST_START_MTTR_TARGET, 11.4.3

setting FAST_START_MTTR_TARGET, 11.4.4

using V$INSTANCE_RECOVERY, 11.4.3.3

LARGE_POOL_SIZE initialization parameter, 11.3.3

long waits

defined, 11.3.5.2

short waits

definition of, 11.3.5.2

pipe interface, 4.7

point of recoverability

recovery window, 2.7.1

point-in-time recovery, 18.8

tablespace, 8, 8.1.2, 8.1.2.1, 20.4.2

user-managed, 20

PROXY ONLY option

of BACKUP, 2.2.2

PROXY option

of BACKUP, 2.2.2

R

RATE option

of ALLOCATE CHANNEL, 2.4.6

of CONFIGURE CHANNEL, 2.4.6

raw devices

backing up to, 17.8

restoring to, 18.4.1

UNIX backups, 17.8.1

Windows backups, 17.8.2

read-only tablespaces

backing up, 6.9.1

backups, 17.4.4

Recov, 10.2.3

RECOVER clause

of ALTER DATABASE, 18.4.2, 18.6.6

RECOVER command, 3.2, 3.2.2.1

unrecoverable objects and standby databases, 19.5

UNTIL TIME option, 18.8.4

USING BACKUP CONTROLFILE clause, 19.6

RECOVER SQL*Plus statement

PARALLEL and NOPARALLEL options, 18.11

recovery

ADD DATAFILE operation, 19.2

automatically applying archived logs, 18.6.2

cancel-based, 18.7.2, 18.8.4

complete, 18.7

closed database, 18.7.1

offline tablespaces, 18.7.2

corruption

intentionally allowing, 21.4

data blocks, 3.3, 7.5

guidelines, 3.3.1

database

in NOARCHIVELOG mode, 7.1.1

database files

how RMAN applies changes, 3.2.2

overview, 3.2

datafile without a backup, 7.6.3

datafiles, 19.1

ARCHIVELOG mode, 19.1.2

NOARCHIVELOG mode, 19.1.1

determining files needing recovery, 18.3

disaster using RMAN, 7.4

dropped table, 19.10

errors, 21.1

interrupting, 18.6.8

media, 18, 19, 21

multiple redo threads, 18.6.2.2

of lost or damaged recovery catalog, 10.6.3

online redo logs, 19.8

losing member, 19.8.1

loss of group, 19.8.2

opening database after, 18.9

parallel, 18.11

parallel processes for, 18.11

problems, 21.1

fixing, 21.3

investigating, 21.2

responding to unsuccessful, 18.6.7

setting number of processes to use, 18.11

stuck, 21.1

time-based, 18.8.4

transportable tablespaces, 19.7

trial, 21.6

explanation, 21.6.1

overview, 21.6

troubleshooting, 21.1

user errors, 19.10

user-managed, 18, 19, 21

using backup control file, 7.3

without recovery catalog, 7.3.1

using logs in a nondefault location, 18.6.5

using logs in default location, 18.6.3

using logs in nondefault location, 18.6.6

without a recovery catalog, 1.3.1.2

recovery catalog, 1.3.2

availability, 10.8

backing up, 1.3.2.4, 10.6.1

compatibility, 1.3.2.5

contents, 1.3.2.2

crosschecking, 9.2

db identifier problems, 10.2.1.2

dropping, 10.12

managing size of, 10.4

moving to new database, 10.7

operating with, 1.3

operating without, 1.3.1

recovery of, 10.6.3

refreshing, 10.3

registering target databases, 1.3.2.1, 10.2.1, 10.2.1

resynchronizing, 10.3

snapshot control file, 1.3.2.3.1

space requirements, 10.1.1.2

stored scripts

creating, 10.5.1

synchronization, 1.3.2.3

UNKNOWN database name, 12.4.12

unregistering databases, 10.2.2

updating

after schema changes, 10.3.3.3

upgrading, 10.11

views

querying, 10.9

Recovery Manager

allocating disk buffers, 11.1.1

allocating tape buffers, 11.1.1.2

backup sets

backing up, 6.4

backup types

duplexed backup sets, 2.3.1

backups

backing up, 2.3.2

batch deletion of obsolete, 2.7.3

control file autobackups, 2.6.2.1

datafile, 6.4, 6.7.1, 6.7.2

image copy, 2.2.1

incremental, 6.2.1, 6.2.2

long-term, 2.7.4

optimization, 2.8

restartable, 2.9

tablespace, 6.4, 6.7.1, 6.7.2

testing, 2.12.4, 6.8

types, 2.5

using tags, 2.4.3

validating, 6.8

channels, 2.1

generic configurations, 2.1.5

naming conventions, 2.1.4

specific configurations, 2.1.6

commands

BACKUP, 2.2.2, 6.9.13

CATALOG, 10.2.1.2

CHANGE, 9.2

EXECUTE SCRIPT, 10.5

interactive use of, 1.2.2.1

RESYNC CATALOG, 10.6.3

standalone commands, 1.2.2.5

using command files, 1.2.2.2

compilation and execution of commands, 1.2.1

configuring

default device types, 2.1.3

device types, 2.1.2

corrupt datafile blocks, 2.12.1, 2.12.2

handling I/O errors and, 2.11.1

crosschecking recovery catalog, 9.2

database connections

auxiliary database, 4.3

duplicate database, 4.3

hiding passwords, 4.5

with password files, 4.2

DBMS_PIPE package, 4.7

duplicate databases

how created, 13.1.1

environment

definition, 1.1

error codes

message numbers, 12.1.3.1

errors, 12.1, 12.1.3

interpreting, 12.1.4

file deletion

overview, 9.3.1

fractured block detection in, 2.12.3

hanging backups, 12.4.2

image copy backups, 2.2.1

incremental backups

cumulative, 2.5.1.4

differential, 2.5.1.3

level 0, 2.5.1.2

integrity checking, 2.12

interactive use of commands, 1.2.2.1

jobs

monitoring progress, 9.6.2

media management

backing up files, 1.4.1

Backup Solutions Program (BSP), 1.4.2

crosschecking, 9.2

media manager, linking with a, 5.2.2

metadata, 1.3, 10, 13

storing in control file, 1.3.1

monitoring, 9.6, 9.6.4

multiplexing

datafiles, 2.2.5

overview, 1.2

performance

monitoring, 9.6

pipe interface, 4.7

recovery

after total media failure, 7.4

recovery catalog, 1.3.2

availability, 10.8

backing up, 10.6.1

compatibility, 1.3.2.5

contents, 1.3.2.2

crosschecking, 9.2

managing the size of, 10.4

moving to new database, 10.7

operating with, 1.3

operating without, 1.3.1

recovering, 10.6.3

registration of target databases, 1.3.2.1, 10.2.1

resynchronizing, 10.3

snapshot control file, 1.3.2.3.1

synchronization, 1.3.2.3

updating after schema changes, 10.3.3.3

upgrading, 10.11

reports, 9.1

overview, 9.1.2

restoring

datafiles, 3.1

to new host, 7.2

return codes, 12.1.5

RPC calls and, 12.4.3

snapshot control file location, 5.9

standby databases

creating, 3.5

starting, 4.1

stored scripts, 1.2.2.3

synchronous and asynchronous I/O, 11.1.2

tablespace point-in-time recovery, 3.2.4

tags for backups, 2.4.3

terminating commands, 12.3

test disk API, 5.2.3

types of backups, 2.2.1

using RMAN commands, 1.2

recovery window

point of recoverability, 2.7.1

recovery windows

backup optimization and, 2.8.5.1

definition, 2.7.1

RECOVERY_PARALLELISM initialization parameter, 18.11

redo logs

incompatible format, 21.1

listing files for backup, 17.1.1

naming, 18.6.3

parallel redo, 21.1

redo records

problems when applying, 21.1

REPORT OBSOLETE command, 2.7.3

reports, 9.1

obsolete backups, 9.1.2.1

overview, 9.1.2

repository

RMAN, 1.3

RESET DATABASE command

INCARNATION option, 10.2.3

RESETLOGS operation

when necessary, 18.9.1

RESETLOGS option

of ALTER DATABASE, 18.9, 18.9.2, 18.9.2, 18.10.1, 18.10.2

restartable backups

definition, 2.9, 6.7

restarting RMAN backups, 6.7

RESTORE command, 3.1

FORCE option, 3.1.4

restore optimization, 3.1.4

restoring

archived redo logs, 18.4.2

backup control file

using SET DBID, 7.6.2

control files

to default location, 18.5.1.1

to nondefault location, 18.5.1.2

database

to default location, 18.10.1

to new host, 7.2

to new location, 18.10.2

database files, 3.1

how RMAN chooses, 3.1.2

mechanics, 3.1.1

restore optimization, 3.1.4

datafiles

to default location, 18.4.1

to raw devices, 18.4.1

user-managed backups, 18.2

keeping records, 17.12

RESUME clause

ALTER SYSTEM statement, 17.7.2

resuming recovery after interruption, 18.6.8

RESYNC CATALOG command, 10.3

FROM CONTROLFILECOPY option, 10.6.3

resynchronizing the recovery catalog, 10.3

retention policies

affect on backup optimization, 2.8.5

definition, 2.7

disabling, 2.7

exempt backups, 2.7.4

recovery window, 2.7

redundancy, 2.7, 2.7.2

return codes

RMAN, 12.1.5

RMAN. See Recovery Manager

S

sbtio.log

and RMAN, 12.1.1

sbttest program, 12.2.1

scenarios, Recovery Manager

backing up archived redo logs, 6.9.6

duplexing backup sets, 6.2

handling backup errors, 6.9.13

maintaining backups and copies, 6.9.11

NOARCHIVELOG backups, 6.9.10

recovering pre-resetlogs backup, 7.1.1

recovery after total media failure, 7.4

setting size of backup sets, 6.9.4

schemas

changes

updating recovery catalog, 10.3.3.3

SCN (system change number)

use in distributed recovery, 19.11.1

server parameter files

autobackups, 2.6

configuring autobackups, 2.6

server sessions

Recovery Manager, 1.1.1

session architecture

Recovery Manager, 1.1.1

SET command

MAXCORRUPT option, 6.9.13

SET statement

AUTORECOVERY option, 18.6.2

LOGSOURCE variable, 18.4.2, 18.6.6

shared server

configuring for use with RMAN, 5.10

short waits

definition of, 11.3.5.2

SHOW command, 2.1.2

SHUTDOWN statement

ABORT option, 18.5.1.1, 18.5.1.2, 18.8.1, 18.10.1, 18.10.2

size of backup sets

setting, 2.4.4

SKIP OFFLINE option

of BACKUP, 6.9.1

SKIP READONLY option

of BACKUP, 6.9.1

snapshot control files, 1.3.2.3.1

specifying location, 5.9

split mirrors

using as backups, 6.3

splitting mirrors

suspend/resume mode, 17.7.1

standalone Recovery Manager commands, 1.2.2.5

standby databases

creating using RMAN, 3.5

updating with incrementals, 13.8.1

starting RMAN

without connecting to a database, 4.1

STARTUP statement

MOUNT option, 18.8.2, 18.8.3

stored scripts

creating RMAN, 10.5.1

deleting, 10.5.6, 10.5.6, 10.5.6

managing, 10.5

Recovery Manager, 1.2.2.3

stuck recovery

definition, 21.1

SUSPEND clause

ALTER SYSTEM statement, 17.7.2, 17.7.2

suspending a database, 17.7.1

suspend/resume mode, 17.7.1

SWITCH command, 2.2.1.1

synchronizing duplicate database

uising DUPLICATE DATABASE, 13.7

uising incremental backups, 13.8

system time

changing

effect on recovery, 18.8

T

tables

recovery of dropped, 19.10

tablespace backups

using RMAN, 6.4, 6.7.1, 6.7.2

tablespace point-in-time recovery, 8.1.2

clone database, 20.1.1

introduction, 20.1

methods, 20.1.2

performing

user-managed, 20

planning for, 20.2

procedures for using transportable tablespace feature, 20.4.1, 20.4.2

requirements, 20.2.1

terminology, 20.1.1

transportable tablespace method, 20.1.2

user-managed, 20.1.2

using RMAN, 3.2.4

basic steps, 8.1.2

introduction, 8.1

planning, 8.2

preparing the auxiliary instance, 8.5.1

restrictions, 8.1.2.1.1

why perform, 8.1.2

tablespace transport

online, 14

tablespaces

backups, 17.4.2

offline, 17.3

online, 17.4.2

excluding from RMAN backups, 5.7

read-only

backing up, 6.9.1, 17.4.4

read/write

backing up, 17.4.1

recovering offline in open database, 18.7.2

tags, 2.4.3

terminating RMAN commands, 12.3

test databases, creating, 3.4

test disk API, 5.2.3

testing RMAN

backups, 2.12.4, 6.8

with media management API, 12.2

time format

RECOVER DATABASE UNTIL TIME statement, 18.8.4

time-based recovery, 18.8.4

coordinated in distributed databases, 19.11.1

trace files

and RMAN, 12.1.1

backing up control file, 17.5.2.1

control file backups to, 17.5.2

transparent backup encryption, 6.6.1.1

transportable tablespace

cross-platform, 15

online, 14

transportable tablespaces

and CONVERT DATAFILE/TABLESPACE, 15.1

creating with RMAN, 14.1

and Data Pump Export, 14.3.3

and past points in time, 14.3.2

auxiliary destination, 14.2.2, 14.3.1

auxiliary instance parameter file, 14.3.4, 14.3.4.2

Concepts, 14.2

file locations, 14.3.7

initialization parameters, 14.3.4.1

limitations, 14.2.3

Shared Pool Size, 14.3.5, 14.4.1

when to use, 14.2.1

cross-platform, 15.1

recovery, 19.7

TSPITR and, 20.1.2

transporting databases across platforms, 15.2

trial recovery

explanation, 21.6.1

overview, 21.6

TSPITR, 8.1.2

TSPITR. See tablespace point-in-time recovery

tuning

Recovery Manager

V$ views, 9.6

U

UNAVAILABLE option

of CHANGE, 9.4

unrecoverable objects

and RECOVER operation, 19.5

recovery

unrecoverable objects and, 19.5

unregistering a database from the recovery catalog, 10.2.2

UNTIL TIME option

RECOVER command, 18.8.4

upgrading the recovery catalog, 10.11

user errors

recovery from, 19.10

user-managed backups, 17, 17.2

backup mode, 17.4.3

control files, 17.5, 17.5

binary, 17.5.1

trace files, 17.5.2

determining datafile status, 17.1.2

hot backups, 17.4.3.1

listing files before, 17.1

offline dataf, 17.3

offline tablespaces, 17.3, 17.3

read-only tablespaces, 17.4.4

restoring, 18.4.1, 18.4.1

tablespace, 17.4.2

verifying, 17.9

whole database, 17.2.1

user-managed recovery, 18.8

ADD DATAFILE operation, 19.2

complete, 18.7

incomplete, 18.8

interrupting, 18.6.8

opening database after, 18.9

scenarios, 19

user-managed restore operations, 18.2

USING BACKUP CONTROLFILE option

RECOVER command, 18.8.3

V

V$ARCHIVED_LOG view, 3.2.2.1

listing all archived logs, 17.6

V$BACKUP view, 17.1.2

V$BACKUP_ASYNC_IO, 9.6

V$BACKUP_CORRUPTION view, 2.11.2

V$BACKUP_SYNC_IO, 9.6

V$COPY_CORRUPTION view, 2.11.2

V$DATABASE_BLOCK_CORRUPTION view, 6.8, 7.5.3

V$DATAFILE view, 17.1.1

listing files for backups, 17.1

V$LOG_HISTORY view

listing all archived logs, 18.4.2

V$LOGFILE view, 19.8.1, 19.8.2

listing files for backups, 17.1.1

listing online redo logs, 17.1.1

V$PROCESS view, 9.6

V$RECOVER_FILE view, 18.3

V$RECOVERY_LOG view

listing logs needed for recovery, 18.4.2

V$SESSION view, 9.6

V$SESSION_LONGOPS view, 9.6

V$SESSION_WAIT view, 9.6

V$TABLESPACE view, 17.1.1

validating

backups, 6.8

views

recovery catalog, 10.9

W

wallet, 6.6.1.1

whole database backups

ARCHIVELOG mode, 17.2

inconsistent, 17.2

NOARCHIVELOG mode, 17.2

preparing for, 17.2.1