Skip Headers
Oracle® Database Backup and Recovery Advanced User's Guide
10g Release 2 (10.2)

Part Number B14191-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
View PDF

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
REGISTER command, 10.2.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