Skip Headers
Oracle® Database Backup and Recovery User's Guide
11g Release 2 (11.2)

Part Number E10642-03
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  Q  R  S  T  U  V  W 

Symbols

% substitution variable
BACKUP FORMAT, 2.4.3
%b substitution variable
SET NEWNAME, 25.1.1.1
%d substitution variable
BACKUP FORMAT, 2.4.3
%f substitution variable
SET NEWNAME, 25.1.1.1
%I substitution variable
SET NEWNAME, 25.1.1.1
%N substitution variable
SET NEWNAME, 25.1.1.1
%p substitution variable
BACKUP FORMAT, 2.4.3
%t substitution variable
BACKUP FORMAT, 2.4.3
%U substitution variable, 9.2.3.1
BACKUP FORMAT, 2.4.3
SET NEWNAME, 25.1.1.1

A

ABORT option
SHUTDOWN statement, 30.1.1, 30.1.2
ABORT option, SHUTDOWN statement, 29.5
active database duplication, 4.5.4, 24.1.2.1.1
Advanced Security Option, 6.2.6.1, 8.3.5
ADVISE FAILURE command, 15.1.2.4, 15.4
alert log, 12.2.2, 23.1.1
ALLOCATE CHANNEL command, 6.1.1, 9.2.3.1
MAXPIECESIZE option, 6.2.2
ALLOCATE command, 5.1.4.1
ALLOW ... CORRUPTION clause, RECOVER command, 29.6.5
ALTER DATABASE statement
CLEAR LOGFILE clause, 30.7.2.1.3
END BACKUP clause, 28.3.2.3.1
OPEN RESETLOGS clause, 13.8.5
RECOVER clause, 29.2.4.2, 29.3.1, 29.3.2
RESETLOGS option, 29.5
ALTER SYSTEM statement
KILL SESSION clause, 23.4.1
RESUME clause, 28.6.2
SUSPEND clause, 28.6.2, 28.6.2
ALTER TABLESPACE statement
BEGIN BACKUP clause, 28.3.2.1, 28.3.2.2.2
END BACKUP option, 28.3.2.2.2
application errors, 1.1.1.3
archival backups, 1.1.2, 9.6.1, 9.6.1, 12.4.2.2
archived redo log deletion policies, 5.6.1, 5.6.2, 9.4.3
archived redo log files
applying during media recovery, 29.2.1, 29.2.3, 29.2.4.2
backing up, 9.4.2
using RMAN, 9.4
with other backups, 9.4.1.2
cataloging, 12.4.3
changing default location, 29.2.4.1
corrupted, 29.6.1
deleting, 14.3.1, 29.3.1
deletion after backup, 9.4.1
failover, 9.4.1.1
incompatible format, 29.6.1
location during recovery, 29.2.1
loss of, 29.4
restoring using RMAN, 17.2.5
ARCHIVELOG mode
backups in, 2.4.1
AS SELECT clause
CREATE TABLE statement, 30.5
authentication, RMAN, 2.2
autobackups, control file, 8.6, 8.6, 9.3.3, 9.6.2
configuring, 5.1.5
format, 5.1.5.1
automated repairs
Data Recovery Advisor, 1.4
automatic channel allocation, 6.1.1
automatic channels, 3.3, 3.3.2
configuring, 6.1.2
naming conventions, 3.3.2
overriding, 6.1
Automatic Diagnostic Repository (ADR), 5.2.4.1, 8.6.2, 12.2.1, 15.1.2.2, 16.1.2.2, 16.1.2.4, 23.1.1
Automatic Storage Management (ASM)
backups to, 9.2.3
Automatic Workload Repository (AWR), 7.5.4
AUTORECOVERY option
SET statement, 29.2.2
auxiliary channels, 24.1.2.3
auxiliary instance parameter file
with TRANSPORT TABLESPACE, 26.2
availability
of RMAN backups, 12.4.2.1
AVAILABLE option
of CHANGE command, 12.4.2.1

B

backup and recovery
definition, 1.1
introduction, 1
solutions, 1.2
strategy, 1.1.1
user-managed, 1.2
BACKUP command, 2.4, 2.4.1, 2.4.2, 3.3.2, 3.7.2.3, 5.3.5, 5.5.1, 6.1.1, 6.2.1, 6.2.4, 8.1, 8.1, 8.3, 9.1.2, 9.4.3
ARCHIVELOG option, 9.4.1.2, 9.4.2
AS COMPRESSION BACKUPSET option, 9.2.5
AS COPY option, 2.4, 8.4.1, 8.4.1
BACKUPSET option, 6.2.6.1, 6.2.6.1, 8.5, 8.5.2.1, 8.5.2.1, 8.5.2.1, 9.7.1, 9.7.1, 9.7.2
CHANNEL option, 5.1.4.3
COMPRESSED BACKUPSET option, 9.2.5
COPIES parameter, 8.5, 8.5.1
COPY OF option, 8.5, 8.5.2.2, 9.7.1, 9.7.3
CURRENT CONTROLFILE option, 9.3.3, 9.3.3.1
DATABASE option, 9.3.1
DATAFILE option, 9.3.2
DB_FILE_NAME_CONVERT parameter, 8.4.1, 8.4.1
DELETE INPUT option, 9.4.4, 9.4.4, 12.5.1.1
DELETE option, 9.4.1
DEVICE TYPE clause, 5.1.2, 5.5.1, 9.2.1, 9.2.1, 9.3.3.1
DURATION parameter, 10.8.2
FILESPERSET parameter, 8.3.9
FOR RECOVER OF COPY option, 9.5.4.1
FORMAT parameter, 2.4.3, 5.2.3, 5.2.5.1, 8.3.6, 8.5.1, 9.2.3
INCREMENTAL option, 2.4.4, 2.4.4, 2.4.4.1, 9.5, 9.5.3, 9.5.3.1
KEEP option, 9.6.1, 9.6.3.1, 9.6.3.1, 9.6.4
MAXSETSIZE parameter, 10.1
NOT BACKED UP clause, 9.4.3
PLUS ARCHIVELOG option, 9.4.1.2, 9.4.1.2
PROXY ONLY option, 8.3.10, 8.3.10
PROXY option, 8.3.10
RECOVERY AREA option, 9.7.1
SECTION SIZE parameter, 8.3.1, 10.1.3
SPFILE option, 9.3.4
TABLESPACE option, 9.3.2
TAG parameter, 2.4.3, 9.2.4.1, 9.2.4.1
VALIDATE option, 2.4.5, 15.1.2.2, 15.3, 16.2
BACKUP CONTROLFILE clause
ALTER DATABASE statement, 28.1.1, 28.1.1
BACKUP COPIES parameter
CONFIGURE command, 6.2.3
backup encryption, 6.2.6.1, 8.3.5, 14.2.1
decrypting backups, 17.3.1.2
default algorithm, 6.2.6
dual-mode, 6.2.6.1.3, 10.6.4
overview, 10.6
password, 6.2.6.1.2, 10.6.3
transparent, 6.2.6.1.1, 6.2.6.1.1, 10.6.2
backup mode, 8.4.2
ending with ALTER DATABASE END BACKUP, 28.3.2.3.1
for online user-managed backups, 8.2, 28.3.2.1
instance failure, 28.3.2.3
backup optimization, 9.4.3
configuring, 5.5, 10.2
definition, 5.5.1, 9.4.3
disabling, 5.5.1, 5.5.3
enabling, 5.5.1, 5.5.3
redundancy and, 5.5.2.2
retention policies and, 5.5.2
backup pieces, 8.3.1
definition, 2.4
maximum size, 6.2.2
names, 8.3.6
names on tape, 5.2.5.1
backup retention policies, 1.1.2, 3.6, 5.3.1
affect on backup optimization, 5.5.2
configuring, 5.4, 5.4
configuring for redundancy, 5.4.1
definition, 8.8
disabling, 5.4.3
exempt backups, 9.6.1, 12.4.2.2
recovery window, 8.8
recovery windows, 5.4.2
redundancy, 8.8, 8.8.2
backup sets, 2.4, 8.1
backing up, 8.5.2.1, 8.5.2.1, 9.7.1
compressed, 5.1.3, 6.2.5, 9.2.5
configuring as default, 5.1.3
configuring maximum size, 6.2.1
crosschecking, 12.4.1.1
duplexing, 10.4
how RMAN generates, 8.3.8
limiting size, 8.3.8
maximum size, 6.2.1, 10.1
multiplexed, 2.4, 6.2.1, 8.3.9, 9.2.4.2, 22.2.1.1
naming, 8.3.6
overview, 8.3
specifying maximum size, 8.3.7
specifying number, 8.3.8
testing restore of, 17.2.4
Backup Solutions Program (BSP), 3.5.3
backup strategy
fast recovery area, 5.3
backup tags, RMAN, 9.2.4
backup techniques, comparison, 1.2
backup windows, 10.8.1
backup-based duplication, 24.1.2.1.1
backups
archival, 1.1.2, 9.6.1
archived redo logs
using RMAN, 9.4
availability, 12.4.2.1
backup sets, 9.7.1
backups of, 8.5.2.1
closed, 28.2
consistent, 28.2, 28.2
making using RMAN, 8.1.1
control file, 9.3.3, 28.4
control files, 28.4
binary, 28.4.1
correlating RMAN channels with, 23.2.2.2.1, 23.2.2.2.2
crosschecking, 12.4.1, 12.4.1
cumulative incremental, 8.7.1.2
datafile
using RMAN, 9.7.2, 9.7.3
DBVERIFY utility, 28.9
default type for RMAN, 5.1.3
determining datafile status, 28.1.2
duplexing, 6.2.3, 6.2.3, 10.4
excluding tablespaces from backups, 6.2.4
exempt from retention policy, 12.4.2.2
expired, deleting, 12.5.4
generating reports for, 11.1.2, 11.3.1
image copies, 8.4
inconsistent, 28.2
making using RMAN, 8.1.1
incremental, 8.7.1.1, 9.5, 10.4.1, 10.4.2
incrementally updated, 9.5.4
listing files needed, 28.1
logical, 1.1.1
long-term, 1.1.2
managing, 12.1.1
multisection, 3.3.2, 8.3.1, 16.2
NOARCHIVELOG mode, 9.3.5
obsolete, 8.8.3, 12.5.5
offline, 28.3.1, 28.3.1, 28.3.1
offsite, 17.2.3.1
optimizing, 5.5.1, 9.4.3
orphaned, 14.3.2.3
physical, 1.1.1
previewing, 17.2.3
read-only tablespaces, 28.3.2.4
recovering pre-RESETLOGS, 18.6.3
recovery catalog, 13.6.1, 13.6.1
Recovery Manager, 9.1.2
reporting objects needing backups, 11.3.2
restartable, 10.7.1
restoring user-managed, 29.2.1
server parameter files, 9.3.4
skipping files during, 10.3
split mirror, 8.4.2
using RMAN, 10.5
stored scripts, 13.1.2.4, 13.7.1
tablespace, 28.3.2.2
using RMAN, 9.3.2, 9.7.2, 9.7.3
testing RMAN, 16.1.2.4, 16.2, 16.2, 16.3, 16.3
using media manager, 5.2.4.2
user-managed, 28
validating, 16.2, 16.2, 16.3, 16.3
verifying, 28.9
whole database, 9.3.1, 9.3.1, 28.2
BEGIN BACKUP clause
ALTER TABLESPACE statement, 28.3.2.1
binary compression for backups, 9.2.5
block change tracking, 1.2, 8.7.2, 9.5.5, 9.5.5
disk space used for, 9.5.5.1.3
enabling and disabling, 9.5.5.2, 9.5.5.2, 9.5.5.3, 9.5.5.3
moving the change tracking file, 9.5.5.5
block corruptions, 1.1.1.3
stored in V$DATABASE_BLOCK_CORRUPTION, 16.2
block media recovery, 1.1.1.3, 16.1.2.4
automatic, 19.1.2
BSP. See Backup Solutions Program (BSP)

C

cancel-based media recovery, 29.4.2
canceling RMAN commands, 23.4
CATALOG command, 12.4.3, 12.4.3
START WITH parameter, 13.4
CHANGE command
AVAILABLE option, 12.4.2.1
DB_UNIQUE_NAME parameter, 13.8.3
RESET DB_UNIQUE_NAME option, 3.7.2.2
UNCATALOG option, 12.4.4.1
CHANGE FAILURE command, 15.6
channels, RMAN, 3.3, 3.3
auxiliary, 24.1.2.3
configuring, 5.1.4
configuring advanced options, 6.1
definition, 2.3, 3.3
generic, 5.1.4.1
naming conventions, 3.3.2
Oracle RAC environment, 6.1.2
parallel, 5.1.4.3
character sets
setting for use with RMAN, 4.3
circular reuse records, 12.2.1
CLEAR LOGFILE clause
of ALTER DATABASE, 30.7.2.1.3
client, RMAN, 2.1, 2.1, 3.1, 3.5
cold failover cluster
definition, 28.3.2.3
command files, RMAN, 2.4.6
command interface
RMAN, 3.2
commands, Recovery Manager
ADVISE FAILURE, 15.1.2.4, 15.4
ALLOCATE CHANNEL, 5.1.4.1, 6.1.1, 6.2.2, 9.2.3.1
BACKUP, 2.4, 2.4, 2.4.1, 2.4.2, 2.4.3, 2.4.4, 2.4.4, 2.4.4.1, 2.4.5, 3.3.2, 3.7.2.3, 5.1.2, 5.1.4.3, 5.2.3, 5.2.5.1, 5.3.5, 5.3.5, 5.5.1, 5.5.1, 6.1.1, 6.2.1, 6.2.4, 6.2.6.1, 8.1, 8.3, 8.3.1, 8.3.9, 8.3.10, 8.3.10, 8.4.1, 8.4.1, 8.5, 8.5, 8.5.1, 8.5.1, 8.5.2.1, 8.5.2.2, 9.1.2, 9.2.1, 9.2.4.1, 9.2.5, 9.3.1, 9.3.2, 9.3.2, 9.3.3, 9.3.3.1, 9.3.4, 9.4.1, 9.4.1.2, 9.4.1.2, 9.4.3, 9.4.3, 9.4.4, 9.5, 9.5.3, 9.5.3.1, 9.5.4.1, 9.6.1, 9.6.3.1, 9.6.4, 9.7.1, 9.7.1, 9.7.1, 9.7.2, 9.7.3
PROXY ONLY option, 8.3.10
PROXY option, 8.3.10
BACKUP CURRENT CONTROLFILE, 9.3.3.1
canceling, 23.4
CATALOG, 12.4.3, 12.4.3, 12.4.3
CHANGE, 3.7.2.2, 12.4.1, 12.4.1
CHANGE FAILURE, 15.6
CONFIGURE, 3.7.1, 5.1.4.1, 5.4, 5.7, 6.1.1, 6.2.2, 6.2.6.2, 6.3
CREATE CATALOG, 13.2.3, 13.5.3
CREATE SCRIPT, 13.7.2
CROSSCHECK, 12.4.1, 12.4.1
DELETE, 12.4.1.1, 12.4.3.1, 12.4.3.1, 12.5
DROP CATALOG, 13.9
DROP DATABASE, 12.6
DUPLICATE, 24
EXECUTE SCRIPT, 13.7.1, 13.7.4
EXIT, 2.2
FLASHBACK DATABASE, 7.1.1, 13.8.5
GRANT, 13.5.2
how RMAN interprets, 3.2
IMPORT CATALOG, 13.8.7
LIST, 2.5.1, 2.5.1, 11.1.2, 11.2, 11.2, 11.2.1, 13.8.5, 15.2
INCARNATION option, 11.2.4, 13.8.5
MAXSETSIZE, 6.2.1
piping, 4.6
PRINT SCRIPT, 13.7.6
RECOVER, 14.3
REPAIR FAILURE, 15.5.1, 15.6
REPLACE SCRIPT, 13.7.3
REPORT, 2.5.2, 11.3.1, 11.3.2
NEED BACKUP option, 11.3.2
RESET DATABASE
INCARNATION option, 13.8.5
RESTORE, 17.2.1.2, 17.2.1.2
RESYNC CATALOG, 13.6.2, 13.8.2, 13.8.2.3
FROM CONTROLFILECOPY option, 13.6.2
REVOKE, 13.5.4
SET, 6.2.6.1.2
SHOW, 2.3, 5.1.1
SPOOL, 15.5.1
SWITCH, 17.3.4
terminating, 23.4, 23.4
UNREGISTER DATABASE, 13.8.4
UPGRADE CATALOG, 13.8.6.1
VALIDATE, 15.1.2.2, 15.3, 16.2
commands, SQL*Plus
RECOVER
UNTIL TIME option, 29.4.2
SET, 29.2.2, 29.2.4.2, 29.3.1, 29.3.2
comments in RMAN syntax, 4.4.3
COMPATIBLE initialization parameter, 6.2.6.1
complete recovery
overview, 17.1
procedures, 29.3
compressed backups, 5.1.3, 9.2.5
algorithms, 6.2.5
CONFIGURE command
AUXNAME option, 6.3
BACKUP OPTIMIZATION option, 5.5.3
CHANNEL option, 5.1.4.1, 6.1.1
CONTROLFILE AUTOBACKUP option, 8.6.1, 9.6.2
DB_UNIQUE_NAME option, 5.7
ENCRYPTION option, 6.2.6.2
EXCLUDE option, 6.2.4
FOR DB_UNIQUE_NAME option, 3.7.1
MAXPIECESIZE option, 6.2.2
MAXSETSIZE option, 6.2.1
RETENTION POLICY clause, 8.8
RETENTION POLICY option, 5.4
configuring media managers, 5.2.3
installing, 5.2.1
prerequisites, 5.2.1
configuring Recovery Manager
autobackups, 5.1.5, 5.1.5.1, 8.6
backup optimization, 5.5
backup retention policies, 5.4
backup set size, 6.2.1
default backup type, 5.1.3
default devices, 5.1.2
overview, 5.1
shared server, 6.5
snapshot control file location, 6.4
specific channels, 6.1.2
tablespace exclusion for backups, 6.2.4
consistent backups, 8.1.1
using RMAN, 8.1.1
whole database, 28.2
control file autobackups, 12.2.3
after structural changes to database, 8.6
configuring, 5.1.5, 5.1.5, 5.1.5, 5.1.5.1, 5.1.5.1, 8.6, 8.6
default format, 8.6.2
format, 5.1.5.1
control files
backups, 28.1.1, 28.4
binary, 28.4.1
including within database backup, 9.3.3.1
recovery using, 20.3.1
using RMAN, 9.3.3
circular reuse records, 12.2.1
configuring location, 5.3.4
creating after loss of all copies, 30.3
finding filenames, 28.1.1
multiplexed, 5.3.1, 5.3.4, 12.2.3, 17.2.1.1, 28.1.1, 29.2.1, 30.1.1
loss of, 30.1
multiplexing, 12.2.3
recreated, 30.3
restoring, 20.3.1.1, 30.1.1, 30.1.2
snapshot, 13.8.2.1
specifying location of, 6.4
user-managed restore after loss of all copies, 30.3
CONTROL_FILE_RECORD_KEEP_TIME initialization parameter, 12.2.1, 12.2.2, 13.8.2.2.4
CONTROL_FILES initialization parameter, 5.3.4.2, 20.3.1.1, 21.6.1.2, 30.1.2
CONVERT command
with tablespaces and datafiles, 27
COPIES option
BACKUP command, 10.4.2
corrupt blocks, 14.1.1.2, 16.1.2.1, 29.6.1
recovering, 19.1.2.1, 19.1.2.1
RMAN and, 10.7.1
CREATE CATALOG command, 13.2.3, 13.5.3
CREATE DATAFILE clause, ALTER DATABASE statement, 30.4
CREATE SCRIPT command, 13.7.2
CREATE TABLE statement
AS SELECT clause, 30.5
CREATE TABLESPACE statement, 30.2.3
CROSSCHECK command, 12.4.1, 12.4.1
crosschecking, RMAN, 2.6, 12.1.2.2.1, 12.4.1, 12.4.1
definition, 12.4.1.1
recovery catalog with the media manager, 12.4.1.1
cross-platform transportable tablespace, 27
cumulative incremental backups, 2.4.4, 2.4.4.1, 8.7.1, 8.7.1.2

D

data blocks, corrupted, 1.1.1.3, 1.2, 2.7.1, 2.9.4, 14.1.1.2, 15.3, 15.6, 16.2, 19.1.1, 29.6.1, 29.6.1
data dictionary views, 28.3.1, 28.3.2.1, 28.3.2.4
Data Guard environment, 3.7.2.3
archived log deletion policies, 5.6.1.2
changing a DB_UNIQUE_NAME, 13.8.3
configuring RMAN, 5.7
reporting in a, 11.1.2.1
RMAN backups, 9.1.2
RMAN backups, accessibility of, 3.7.2.3
RMAN backups, association of, 3.7.2.2
RMAN backups, interchangeability of, 3.7.2.1, 9.3.3
RMAN usage, 3.7
data integrity checks, 1.4, 15.1.2.2, 15.3
data preservation, definition of, 1.1.2
data protection
definition, 1.1.1
Data Recovery Advisor, 2.7, 11.2.1, 14.1.2
automated repairs, 1.4
data integrity checks, 15.1.2.2, 15.3
failure consolidation, 15.1.2.3.3
failure priority, 15.1.2.3.2
failures, 15.1.2.1, 15.1.2.3
feasibility checks, 15.1.2.4
overview, 1.4
purpose, 15.1.1
repair options, 15.4
repairing failures, 15.5.1
repairs, 15.1.2.1, 15.1.2.4, 15.1.2.4.1
supported configurations, 15.1.2.5
user interfaces, 15.1.2.1
data repair
overview, 14.1.1
techniques, 14.1.2
data transfer, RMAN, 1.1.3
database connections
Recovery Manager
auxiliary database, 4.5.4
hiding passwords, 4.5.5
without a catalog, 4.5
SYSDBA required for RMAN, 4.5.1.1
types in RMAN, 4.5.1
database point-in-time recovery, 18.5
definition, 18.1.2.1
Flashback Database and, 7.1.1, 18.1
prerequisites, 18.5.1
user-managed, 29.4
databases
listing for backups, 28.1
media recovery procedures, user-managed, 29
media recovery scenarios, 30
recovery
after control file damage, 30.1.1, 30.1.2
registering in recovery catalog, 13.3.2, 13.3.2
reporting on schemas, 11.3.5
suspending, 28.6.1
unregistering from recovery catalog, 13.8.4
datafiles
backing up, 9.3.2, 9.7.2, 9.7.3, 28.3.1
determining status, 28.1.2
listing, 28.1
losing, 29.2.1
recovery
without backup, 30.4
re-creating, 30.4
renaming
after recovery, 30.2.3
restoring, 14.2
DB_BLOCK_CHECKSUM initialization parameter, 16.1.2.1
DB_CREATE_FILE_DEST initialization parameter, 5.3.4.1, 9.5.5.2, 17.3.2
DB_FILE_NAME_CONVERT initialization parameter, 21.6.1.2
DB_FLASHBACK_RETENTION_TARGET initialization parameter, 5.3.2, 5.3.2.1, 5.3.2.3
DB_LOST_WRITE_PROTECT initialization parameter, 6.6
DB_NAME initialization parameter, 21.6.1.2
DB_RECOVERY_FILE_DEST initialization parameter, 2.1, 5.3.2, 5.3.4.1
DB_RECOVERY_FILE_DEST_SIZE initialization parameter, 2.1, 5.3.2
DB_UNIQUE_NAME initialization parameter, 3.7, 3.7.2.2, 5.7, 11.1.2.1
DBA_DATA_FILES view, 28.3.1, 28.3.2.1, 28.3.2.4
DBID
determining, 17.2.2
problems registering copied database, 13.1.2.1
setting with DBNEWID, 13.3.1
DBMS_PIPE package, 4.6, 4.6
DBNEWID utility, 13.3.1, 24.1.1
DBPITR. See database point-in-time recovery
DBVERIFY utility, 28.9
DELETE command, 12.4.3.1, 12.5, 12.5.3
EXPIRED option, 12.4.1.1, 12.5.4
OBSOLETE option, 8.8.3, 8.8.3, 12.5.5
deleting backups, 2.6.2, 12.5, 12.5, 12.5.1.1, 12.5.3
deletion policies, archived redo log, 5.6.1
enabling, 5.6.2
devices, configuring default, 5.1.2
differential incremental backups, 2.4.4, 8.7.1, 8.7.1.1
direct ancestral path, 14.3.2.2, 18.4.2, 18.6.2
disaster recovery, 1.1.2
definition, 1.1.1.1
disconnecting
from Recovery Manager, 2.2
disk API, 5.2.4
disk failures, 1.1.1.1
disk usage
monitoring, 12.3.2
DROP DATABASE command, 12.6
dropped tables, retrieving, 18.3.1
dropping a database, 12.6
dropping the recovery catalog, 13.9
dual mode backup encryption, 6.2.6.1.3, 6.2.6.1.3
dual-mode backup encryption, 10.6.4
dummy API, 5.2.4
duplexing backup sets, 6.2.3, 6.2.3, 8.5.1, 10.4
DUPLICATE command, 24
duplicate databases, 3.1
active database duplication, 4.5.4, 24.1.2.1.1
backup-based duplication, 24.1.2.1.2
no target connection, 24.1.2.1.2
no target/recovery connection, 24.1.2.1.2
target connection, 24.1.2.1.2
generating filenames, 24.2.2
how RMAN creates, 24.1.2.3
restarting after failed DUPLICATE, 24.7
skipping offline normal tablespaces, 25.5.2
skipping read-only tablespaces, 25.5
DURATION parameter, BACKUP command, 10.8.2

E

encrypted backups, 10.6, 14.2.1
decrypting, 17.3.1.2
environment variables
NLS_DATE_FORMAT, 4.3
NLS_LANG, 4.3
error codes
media manager, 23.1.3.2
RMAN, 23.1, 23.1.3, 23.1.3.1
error messages, RMAN
interpreting, 23.1.4
error stacks, RMAN
interpreting, 23.1.4
EXECUTE SCRIPT command, 13.7.4
EXIT command, 2.2
exiting RMAN, 2.2
expired backups, 8.8, 12.4.1.1
deleting, 12.5.4
EXPIRED option
DELETE command, 12.5.4

F

failover, when restoring files, 14.2.2
failures
definition, 1.1.1
media, 1.1.1.1
See also recovery
failures, Data Recovery Advisor, 15.1.2.1, 15.1.2.3
consolidation, 15.1.2.3.3
priority, 15.1.2.3.2
fast recovery area, 3.1, 3.6, 18.1.2.2.1
autobackups, 5.1.5.1
changing locations, 12.3.5
configuring, 5.3
definition, 2.1
disabling, 12.3.6
effect of retention policy, 8.8.4
enabling, 5.3.2
flashback database window, 7.1.2
maintaining, 12.3
monitoring disk usage, 12.3.2
monitoring usage, 12.3.2
Oracle Managed Files, 5.3.1.1
permanent and impermanent files, 5.3.1
RMAN files in, 5.3.5
setting location, 5.3.2.2
setting size, 5.3.2.1
snapshot control files, 6.4
space management, 5.3.1.2
feasibility checks, Data Recovery Advisor, 15.1.2.4
file sections, 8.3.7, 8.3.9, 10.1.3, 16.2
filenames, listing for backup, 28.1
flashback data archive
definition, 1.3.1
Flashback Database, 2.8, 14.1.2
determining the flashback database window, 18.4.2
flashback logs, 1.3.2, 7.2.1
limitations, 7.1.3
monitoring, 7.5.4
overview, 1.3.2
prerequisites, 18.4.1
purpose, 18.1.1
requirements, 7.3
space management, 12.3.3
estimating disk space requirement, 5.3.2.3
tuning performance, 7.5.3
FLASHBACK DATABASE command, 7.1.1, 18.4.2
flashback database window, 7.1.2
Flashback Drop, 18.1.2.2.2, 18.3.1
flashback logs, 1.3.2, 2.8, 7.1.1, 12.3.3, 18.1.2.2.1
guaranteed restore points and, 7.1.5
flashback retention target, 7.1.1
Flashback Table, 18.1.2.2.2
using, 18.2.1, 18.2.2
FLASHBACK TABLE statement, 18.2.1, 18.2.1, 18.2.2
Flashback Technology, 18.1.2
logical features, 18.1.2.2.2
overview, 1.3
flashback undrop
restoring objects, 18.3.3
formats, for RMAN backups, 9.2.3
fractured blocks, 8.2
detection, 8.2
full backups, 8.7
incremental backups and, 2.4.4

G

generic channels
definition, 5.1.4.1
GRANT command, 13.5.2
groups, redo log, 30.7.1, 30.7.1, 30.7.2, 30.7.2
guaranteed restore points, 1.3.2, 5.3.2.1
alternative to storage snapshots, 7.1.5.1
compared to storage snapshots, 7.1.5.1
creating, 7.4.1
flashback logs and, 7.1.5
requirements, 7.3
space usage in flash recovery area, 7.4.2

H

Health Monitor, 15.1.2.2
hot backup mode
failed backups, 28.3.2.3, 28.3.2.3.1
for online user-managed backups, 28.3.2.1

I

image copies, 2.4, 8.1, 8.4
definition, 8.4
testing restore of, 17.2.4
IMPORT CATALOG command, 13.8.7
INCARNATION option
LIST command, 11.2.4, 13.8.5
RESET DATABASE command, 13.8.5, 13.8.5
incarnations, database, 11.2.4, 14.3.2, 18.4.2, 18.6.2
INCLUDE CURRENT CONTROLFILE option
BACKUP command, 9.3.3.1
incomplete media recovery, 29.4
incomplete recovery
defined, 18.5
in Oracle Real Application Clusters configuration, 29.2.2.2
overview, 14.3
time-based, 29.4.2
with backup control file, 29.2.2.2
inconsistent backups, 8.1.2
using RMAN, 2.4.1, 8.1.1
incremental backups, 2.4.4, 9.5
block change tracking, 9.5.5
differential, 8.7.1.1
how RMAN applies, 14.3.1
making, 9.5
using RMAN, 10.4.1, 10.4.2
initialization parameter file, 14.3
initialization parameters
CONTROL_FILES, 20.3.1.1, 30.1.2
DB_FILE_NAME_CONVERT, 21.6.1.2
DB_NAME, 21.6.1.2
LARGE_POOL_SIZE, 22.4.3
LOCK_NAME_SPACE, 21.6.1.2
LOG_ARCHIVE_DEST_n, 29.2.3
LOG_ARCHIVE_FORMAT, 29.2.3
LOG_FILE_NAME_CONVERT, 21.6.1.2
instance failures
backup mode and, 28.3.2.3
integrity checks, 16.1.2
interpreting RMAN error stacks, 23.1.4
interrupting media recovery, 29.2.5
I/O errors
effect on backups, 10.7.1

J

jobs, RMAN
monitoring progress, 22.3.1
querying details about, 11.4.1

K

KEEP option
BACKUP command, 12.4.2.2

L

level 0 incremental backups, 2.4.4, 8.7.1, 8.7.1, 8.7.2
level 1 incremental backups, 8.7.1.1, 8.7.1.2
LIST command, 2.5.1, 11.1.2, 11.2, 11.2.1
FAILURE option, 15.2
INCARNATION option, 13.8.5
LOCK_NAME_SPACE initialization parameter, 21.6.1.2
log sequence numbers, 29.2.1
LOG_ARCHIVE_DEST_n initialization parameter, 5.3.4.3, 5.3.5, 17.2.5, 29.2.2, 29.2.3, 29.2.3, 29.3.1, 29.4.1, 29.4.2
LOG_ARCHIVE_FORMAT initialization parameter, 29.2.3
LOG_FILE_NAME_CONVERT initialization parameter, 21.6.1.2
logical backups, 1.1.1
logical block corruption, 16.1.2.2
LOGSOURCE variable
SET statement, 29.2.4.2, 29.3.1, 29.3.2
long waits, 22.3.2.2
loss of
inactive log group, 30.7.2.1
lost writes, detecting, 6.6

M

maintenance commands, RMAN, 2.6, 3.3.2, 12.1.2
Data Guard environment, 12.1.2.2
managing RMAN metadata, 11, 12, 12
MAXPIECESIZE parameter
SET command, 5.2.5.1
MAXSETSIZE parameter
BACKUP command, 6.2.1, 10.1
CONFIGURE command, 6.2.1
media failures, 1.1.1
archived redo log file loss, 29.4
complete recovery, 29.3
complete recovery, user-managed, 29.3
control file loss, 30.3
datafile loss, 29.2.1
definition, 1.1.1.1
NOARCHIVELOG mode, 29.5
online redo log group loss, 30.7.2
online redo log loss, 30.7.1
online redo log member loss, 30.7.1
recovery, 29.3
recovery procedures
examples, 29.2.1
Media Management Layer (MML) API, 3.5, 6.2.2
media managers, 3.1, 3.3.1, 3.5, 3.5.2
backing up files, 3.5.1
backup piece names, 5.2.5.1
Backup Solutions Program, 3.5.3
catalog, 3.1
configuring for use with RMAN, 5.2.3
crosschecking, 12.4.1.1
definition, 2.1
error codes, 23.1.3.2
file restrictions, 5.2.5.1
installing, 5.2.1
library location, 5.2.2
linking
testing, 5.2.4
linking to software, 3.5.2, 5.2.2
multiplexing backups, 8.3.9
prerequisites for configuring, 5.2.1
sbttest program, 23.3.1
testing, 5.2.4
testing backups, 5.2.4.2
testing the API, 23.3
third-party, 5.2
troubleshooting, 5.2.4.2
media recovery, 8.7.4
ADD DATAFILE operation, 30.2.3
after control file damage, 30.1.1, 30.1.2
applying archived redo logs, 29.2.1
cancel-based, 29.4, 29.4.2
complete, 29.3
closed database, 29.3.1
complete, user-managed, 29.3
corruption
allowing to occur, 29.6.4
datafiles
without backup, 30.4
errors, 29.6.1
incomplete, 29.4
interrupting, 29.2.5
lost files
lost archived redo log files, 29.4
lost datafiles, 29.2.1
lost mirrored control files, 30.1
NOARCHIVELOG mode, 29.5, 29.5
offline tablespaces in open database, 29.3.2
online redo log files, 30.7
parallel, 29.2.6
problems, 29.6.1, 29.6.1, 29.6.2, 29.6.3
restarting, 29.2.5
restoring
whole database backups, 29.5
resuming after interruption, 29.2.5
roll forward phase, 29.2.1
scenarios, 30
time-based, 29.4
transportable tablespaces, 30.6
trial, 29.6.6, 29.6.6, 29.6.6.1
troubleshooting, 29.6.1, 29.6.1
undamaged tablespaces online, 29.3.2
user-managed, 29
using Recovery Manager, 14.3
metadata, RMAN, 3.4, 11, 12, 13
mirrored files
backups using, 10.5
online redo log
loss of, 30.7.1
splitting, 28.6.1
suspend/resume mode, 28.6.1
using RMAN, 10.5
monitoring fast recovery area usage, 12.3.2
monitoring RMAN, 23.2
MTTR, 15.1.1
multiplexed backup sets, 6.2.1, 8.3.9, 9.2.4.2, 22.2.1.1
multiplexed control files, 5.3.1, 5.3.4, 12.2.3, 12.2.3, 17.2.1.1, 28.1.1, 29.2.1, 30.1.1
multisection backups, 3.3.2, 8.3.1, 8.3.7, 8.3.9, 10.1.3, 16.2

N

naming backup sets, 8.3.6
NLS_DATE_FORMAT environment variable, 4.3
NLS_LANG environment variable, 4.3
NOARCHIVELOG mode
backing up, 9.3.5
disadvantages, 29.5
recovery, 29.5

O

obsolete backups, 8.8
definition, 8.8
deleting, 2.6.2, 8.8.3, 12.5.5
off-site backups, 17.2.3.1
online redo logs, 30.7.2.1
active group, 30.7.1, 30.7.2
applying during media recovery, 29.2.1
archived group, 30.7.1, 30.7.2
clearing
failure, 30.7.2.1.3
clearing inactive logs
archived, 30.7.2.1.1
unarchived, 30.7.2.1.2
configuring location, 5.3.4
current group, 30.7.1, 30.7.2
determining active logs, 30.7.2
inactive group, 30.7.1, 30.7.2
loss of, 30.7.2.1
active group, 30.7.2.2.1, 30.7.2.2.1
all members, 30.7.2
group, 30.7.2
mirrored members, 30.7.1
recovery, 30.7
loss of group, 30.7.2.2.1, 30.7.2.2.1
multiple group loss, 30.7.2.3
replacing damaged member, 30.7.1
status of members, 30.7.1, 30.7.2
OPEN RESETLOGS clause
ALTER DATABASE statement, 13.8.5, 14.3.2.1, 18.4.2, 18.6.1
ORA-01578 error message, 30.5
Oracle Backup Solutions Program (BSP), 3.5.3
Oracle Data Pump, 1.1.1, 18.4.2
Oracle Encryption Wallet
and backups, 6.2.6.1.1
Oracle Flashback Database. See Flashback Database
Oracle Flashback Drop, 1.3.1
Oracle Flashback Query, 1.3.1
Oracle Flashback Table, 1.3.1
Oracle Flashback Transaction, 1.3.1
Oracle Flashback Transaction Query, 1.3.1
Oracle Flashback Version Query, 1.3.1
Oracle Managed Files
fast recovery, 5.3.1.1
Oracle Real Application Clusters (Oracle RAC)
RMAN channels and, 6.1.2
Oracle Secure Backup, 3.5.2, 5.2
Oracle VSS writer, 5.3.1
Oracle wallet, 6.2.6.1.1
orphaned backups, 14.3.2.3
OSB Cloud Module
See Also Oracle Database Backup and Restore Reference, Preface

P

packages
DBMS_PIPE, 4.6, 4.6
password backup encryption, 6.2.6.1.2, 6.2.6.1.2
password-mode encryption, 10.6.3
passwords
connecting to RMAN, 4.5.5
performance tuning
short waits
definition of, 22.3.2.2
performance tuning, RMAN
backup performance, 22.4
LARGE_POOL_SIZE initialization parameter, 22.4.3
long waits, 22.3.2.2
physical backups, 1.1.1
physical block corruption, 16.1.2.2
pipe interface, RMAN, 4.6
point of recoverability
recovery window, 8.8.1
point-in-time recovery, 29.4
performing
with current control file, 18.5.2
tablespace, 18.1.2
PREVIEW option, RESTORE command, 11.1.2
previewing backups, 17.2.3
PRINT SCRIPT command, 13.7.6
proxy copies, 3.5.1, 8.3.10
PROXY option
BACKUP command, 8.3.10, 8.3.10

Q

QUIT command, 2.2
quitting RMAN, 2.2

R

raw devices
backing up to, 28.7
UNIX backups, 28.7.1
Windows backups, 28.7.2
RC_ARCHIVED_LOG view, 11.5.1.1
RC_BACKUP_FILES view, 11.5.3
RC_BACKUP_PIECE view, 11.5.1
RC_BACKUP_SET view, 12.5.1
read-only tablespaces
backups, 28.3.2.4
RECOVER clause
ALTER DATABASE statement, 29.2.4.2, 29.3.1, 29.3.2
RECOVER command, 14.3
COPY option, 9.5.4
PARALLEL and NOPARALLEL options, 29.2.6
TEST option, 16.4
unrecoverable objects and standby databases, 30.5
UNTIL TIME option, 29.4.2
USING BACKUP CONTROLFILE clause, 30.2.4
recovery
ADD DATAFILE operation, 30.2.3
automatically applying archived logs, 29.2.2
cancel-based, 29.4.2
complete, 17.1, 29.3
closed database, 29.3.1
offline tablespaces, 29.3.2
corruption
intentionally allowing, 29.6.4
database
in NOARCHIVELOG mode, 20.1
database files
how RMAN applies changes, 14.3.1
overview, 14.3
database point-in-time, 18.5
datafiles, 29.2.1
disaster using RMAN, 20.4
dropped table, 30.8
errors, 29.6.1
failures requiring, 1.1.1
interrupting, 29.2.5
media, 29, 29.6, 30
multiple redo threads, 29.2.2.2
of lost or damaged recovery catalog, 13.6.2
online redo logs, 30.7
losing member, 30.7.1
loss of group, 30.7.2
parallel, 29.2.6
preparing for, 17.2.1.2
problems, 29.6.1
fixing, 29.6.3
investigating, 29.6.2
stuck, 29.6.1
time-based, 29.4.2
transportable tablespaces, 30.6
trial, 29.6.6
explanation, 29.6.6.1
overview, 29.6.6
troubleshooting, 29.6.1
user errors, 30.8
user-managed, 29, 29.6, 30
using backup control file, 20.3.1
without recovery catalog, 20.3.2
using logs in a nondefault location, 29.2.4.1
using logs in default location, 29.2.3
using logs in nondefault location, 29.2.4.2
without a recovery catalog, 12.2.3
recovery catalog, 3.4, 13.1
backing up, 13.6.1, 13.6.1
cataloging backups, 12.4.3, 13.4
centralization of metadata, 13.1.2.2
creating, 13.2
crosschecking, 12.4.1.1
DBID problems, 13.1.2.1
definition, 2.1, 3.1
deleting backups, 12.5
deleting records, 12.5.3
dropping, 13.9
log switch record, 12.4.3
managing size of, 13.8.2.2.4
operating with, 3.4
purpose of, 13.1.1
recovery of, 13.6.2
refreshing, 13.8.2
registering databases, 13.1.2.1, 13.3.1, 13.3.2, 13.3.2
resynchronizing, 13.8.2, 13.8.2.1
space requirements, 13.2.1.2
stored scripts, 13.7.1
creating, 13.7.2
synchronization, 13.8.2.1
unregistering databases, 13.8.4
updating
after operating system deletions, 12.4.4.2
upgrading, 13.8.6, 13.8.6.1
views, querying, 11.5
virtual private catalogs, 3.4
recovery catalogs
backing up, 13.6.1
dropping, 13.9
importing, 13.8.7
moving, 13.8.7.4
Recovery Manager
allocating tape buffers, 22.2.3.1.1
archived redo logs
backups, 9.4
authentication, 2.2
backups, 9.1.2
archived redo logs, 9.4
backing up, 8.5.2.1, 9.7.1
batch deletion of obsolete, 8.8.3
control files, 9.3.3
datafile, 9.3.2, 9.7.2, 9.7.3
duplexed, 8.5.1
image copy, 8.4
incremental, 9.5, 10.4.1, 10.4.2
optimization, 5.5.1, 9.4.3
tablespace, 9.7.2, 9.7.3
testing, 16.1.2.4, 16.2, 16.2, 16.3, 16.3
validating, 16.2, 16.2, 16.3, 16.3
whole database, 9.3.1, 9.3.1
channels, 3.3, 3.3
naming conventions, 3.3.2
client, 2.1
connecting to databases, 2.2
corrupt datafile blocks
handling I/O errors and, 10.7.1
crosschecking recovery catalog, 12.4.1.1
database character set, 4.3
database connections, 4.5.1
auxiliary database, 4.5.4
duplicate database, 4.5.4
hiding passwords, 4.5.5
SYSDBA required for target, 4.5.1.1
without a catalog, 4.5
DBMS_PIPE package, 4.6
definition, 2.1
disconnecting from, 2.2
duplicate databases, overview of, 24.1.2.3
error codes
message numbers, 23.1.3.1
errors, 23.1, 23.1.3
interpreting, 23.1.4
file deletion, 12.5.1.1
fractured block detection in, 8.2
image copy backups, 8.4
incremental backups
cumulative, 8.7.1.2
differential, 8.7.1.1
level 0, 8.7.1
integrity checking, 16.1.2
jobs, monitoring progress, 22.3.1
jobs, querying details of, 11.4.1
lists, 11.2
maintenance commands, 2.6
media management
backing up files, 3.5.1
Backup Solutions Program (BSP), 3.5.3
crosschecking, 12.4.1.1
media manager, linking with a, 5.2.2
metadata, 3.4, 11, 12, 13
monitoring, 23.2
overview, 2.1, 3.2
performance
monitoring, 23.2
pipe interface, 4.6
proxy copy, 3.5.1
recovery
after total media failure, 20.4
recovery catalog, 13.1
backing up, 13.6.1
crosschecking, 12.4.1.1
managing the size of, 13.8.2.2.4
operating with, 3.4
recovering, 13.6.2
registration of target databases, 13.1.2.1, 13.3.1, 13.3.2
resynchronizing, 13.8.2
synchronization, 13.8.2.1
upgrading, 13.8.6.1
reports, 11.3.1
database schema, 11.3.5
objects needing a backup, 11.3.2
obsolete backups, 11.3.4
repository, 3.4
restoring
archived redo logs, 17.2.5
datafiles, 14.2
retention policies
configuring, 5.4
return codes, 23.1.5
setting time parameters, 4.3
snapshot control file location, 6.4
starting, 2.2
synchronous and asynchronous I/O, 22.2.1.2, 22.2.1.3, 22.2.3.1.3
terminating commands, 23.4
test disk API, 5.2.4
types of backups, 8.4
using RMAN commands, 3.2
recovery window, 5.4
point of recoverability, 8.8.1
RECOVERY WINDOW parameter
CONFIGURE command, 5.4.2
recovery windows
configuring for retention policy, 5.4.2
definition, 8.8.1
RECOVERY_CATALOG_OWNER role, 13.5.2
recycle bin, 18.1.2.2.2, 18.3.2
restoring objects from, 18.3.3
redo logs
incompatible format, 29.6.1
naming, 29.2.3
parallel redo, 29.6.1
redo records
problems when applying, 29.6.1
REGISTER command, 13.3.2
REPAIR FAILURE command, 15.5.1, 15.6
repair options, Data Recovery Advisor, 15.4
repairs, Data Recovery Advisor, 15.1.2.1
consolidation of, 15.1.2.4.1
manual and automatic, 15.1.2.4
REPLACE SCRIPT command, 13.7.3
REPORT command, 2.5.2, 11.1.2, 11.3.1
NEED BACKUP option, 11.3.2, 11.3.2
OBSOLETE option, 8.8.3, 8.8.3
reports, RMAN, 2.5, 11.1.2, 11.3.1, 11.3.1
backup jobs, 11.4.1
database schema, 11.3.5
files needing backups, 11.3.2
obsolete backups, 11.3.4
unrecoverable backups, 11.3.4
repository, RMAN, 3.4, 3.4
RESET DATABASE command
INCARNATION option, 13.8.5
RESETLOGS operation
when necessary, 14.3.2.1
RESETLOGS option
of ALTER DATABASE, 29.5
restartable backups, 10.7.1
RESTORE command, 14.2, 17.2.1.2
FORCE option, 14.2.3
PREVIEW option, 11.1.2, 17.2.3
VALIDATE HEADER option, 11.1.2, 17.2.3
restore optimization, 14.2.3
restore points, 1.3.2, 2.8
creating, 7.4.1
flashing back to, 18.6.2
guaranteed, 1.3.2, 7.1.5
compared to storage snapshots, 7.1.5.1
listing, 7.4.2
requirements, 7.3
restore validation, 17.2.4
restoring
control files, 20.3.1.1
to default location, 30.1.1
to nondefault location, 30.1.2
database
to default location, 29.5
database files, 14.2, 14.2.1, 14.2.3
server parameter files, 20.2, 20.2
testing, 16.4, 17.2.4
user-managed backups, 29.2.1
RESUME clause
ALTER SYSTEM statement, 28.6.2
resuming recovery after interruption, 29.2.5
RESYNC CATALOG command, 13.8.2, 13.8.2.3
FROM CONTROLFILECOPY option, 13.6.2
resynchronizing the recovery catalog, 3.7.1, 13.8.2, 13.8.2.3
retention policies. See backup retention policies
return codes
RMAN, 23.1.5
REVOKE command, 13.5.4
RMAN repository, 1.2, 2.1
RMAN. See Recovery Manager
RMAN sessions, 2.7.2, 3.3

S

SBT, 3.3.1, 5.2.5.2
sbtio.log
and RMAN, 23.1.1
sbttest program, 23.3.1
scenarios, Recovery Manager
NOARCHIVELOG backups, 9.3.5
recovering pre-resetlogs backup, 18.6.3, 20.1
recovery after total media failure, 20.4
scripts, RMAN, 2.4.6
substitution variables in, 9.6.3
server parameter files
autobackups, 8.6
backups, 9.3.4
configuring autobackups, 5.1.5, 5.1.5.1, 8.6
restoring, 20.2, 20.2
server sessions, Recovery Manager, 3.3
session architecture, Recovery Manager, 3.3
SET command
DBID option, 3.7.1
ENCRYPTION option, 6.2.6.1.2
MAXCORRUPT option, 16.1.2.3
NEWNAME option, 25.1.1.1
SET statement
AUTORECOVERY option, 29.2.2
LOGSOURCE variable, 29.2.4.2, 29.3.1, 29.3.2
shadow copies, 9.5.3.1
shared server
configuring for use with RMAN, 6.5
configuring RMAN, 6.5
short waits
definition, 22.3.2.2
SHOW command, 2.3, 2.3, 5.1.1
SHUTDOWN statement
ABORT option, 29.5, 30.1.1, 30.1.2
size of backup sets, setting, 8.3.7
skipping files in RMAN backups, 10.3
snapshot control files, 6.4, 13.8.2.1
specifying location, 6.4
split mirrors
suspend/resume mode, 28.6.1
using as backups, 10.5
SPOOL command, 15.5.1
standby databases, 3.1
creating with DUPLICATE, 24.1.1
statements, SQL
ALTER DATABASE, 29.2.4.2, 29.3.1, 29.3.2
storage snapshots, 7.1.5.1
stored scripts, 3.4, 9.6.3, 13.1.2.4, 13.7.1, 13.7.1, 13.8.7.1
creating RMAN, 13.7.2
deleting, 13.7.8, 13.7.8
dynamic, 13.7.5
executing, 13.7.9
listing names of, 13.7.7
managing, 13.7.1
printing, 13.7.6
substitution variables in, 13.7.5
stuck recovery, 29.6.1
substitution variables, FORMAT parameter, 5.2.5.1, 8.3.6, 8.4.1
substitution variables, stored scripts, 13.7.5
SUSPEND clause
ALTER SYSTEM statement, 28.6.2, 28.6.2
suspending a database, 28.6.1
suspend/resume mode, 28.6.1
SWITCH command, 17.3.4
SYSDBA privileges, 2.2
system backup to tape. See SBT
system time
changing
effect on recovery, 29.4.2

T

tables, recovery of dropped, 30.8
tablespace point-in-time recovery, 18.1.2
configuring datafile names, 6.3
performing on dropped tablespaces, 21.1.1
planning, 21.3
preparing the auxiliary instance, 21.6.1
restrictions, 21.2.2
why perform, 21.1.1
tablespaces
backups, 9.7.2, 9.7.3, 28.3.2.2
offline, 28.3.1
online, 28.3.2.2
backups using RMAN, 9.3.2
excluding from backups, 6.2.4
excluding from RMAN backups, 6.2.4
read-only
backing up, 28.3.2.4
read/write
backing up, 28.3.2.1
recovering accessible
when database is open, 17.3.3
recovering offline in open database, 29.3.2
transporting with RMAN, 26
tape devices, 3.5.2
target database
connecting to, 2.2
definition, 2.1, 3.1
terminating RMAN commands, 23.4
test disk API, 5.2.4
testing RMAN
backups, 16.1.2.4, 16.2, 16.2, 16.3, 16.3
with media management API, 23.3
time format
RECOVER DATABASE UNTIL TIME statement, 29.4.2
time parameters
setting for Recovery Manager use, 4.3
time-based recovery, 29.4.2
trace files, RMAN, 23.1.1
transparent backup encryption, 6.2.6.1.1, 6.2.6.1.1
transparent-mode backup encryption, 10.6.2
transportable tablespaces
creating with RMAN, 26.1.1
and Data Pump Export, 26.5.2
and past points in time, 26.5.1
auxiliary destination, 26.1.2
auxiliary instance parameter file, 26.2, 26.2.2
file locations, 26.5.3
initialization parameters, 26.2.1
cross-platform, 27
recovery, 30.6
transporting tablespaces, 26
trial recovery, 16.4, 29.6.6, 29.6.6.1
tuning Recovery Manager
V$ views, 23.2

U

UNAVAILABLE option
of CHANGE, 12.4.2.1
UNCATALOG option
CHANGE command, 12.4.4.1
deleting repository records, 12.4.4.1
undo optimization, backup, 5.5.1, 8.3.4
unrecoverable objects
recovery, 30.5, 30.5
UNREGISTER DATABASE command, 13.8.4
unregistering databases, 13.8.4
UNTIL TIME option
RECOVER command, 29.4.2
upgrading the recovery catalog, 13.8.6.1
user errors
definition, 1.1.1.2
recovery from, 30.8
user-managed backups, 28, 28.2
backup mode, 28.3.2.1, 28.3.2.3
control files, 28.4, 28.4
definition, 8.4.2
determining datafile status, 28.1.2
hot backups, 8.2, 28.3.2.3.1
listing files before, 28.1
offline tablespaces, 28.3.1, 28.3.1
read-only tablespaces, 28.3.2.4
tablespace, 28.3.2.2
verifying, 28.9
whole database, 28.2
user-managed recovery, 29.4
ADD DATAFILE operation, 30.2.3
complete, 29.3
incomplete, 29.4
interrupting, 29.2.5
scenarios, 30
user-managed restore operations, 29.2.1

V

V$ARCHIVED_LOG view, 5.3.2.3, 11.5.1.1, 18.5.2
listing all archived logs, 28.5
V$BACKUP view, 28.1.2
V$BACKUP_ASYNC_IO view, 22.3.2
V$BACKUP_DATAFILE view, 9.5.2, 12.4.3.3
V$BACKUP_FILES view, 5.4.2, 12.4.1.1, 12.4.3.2
V$BACKUP_PIECE view, 11.5.1, 12.4.3.3
V$BACKUP_REDOLOG view, 12.4.3.3
V$BACKUP_SET view, 12.4.3.3, 12.5.1
V$BACKUP_SPFILE view, 12.4.3.3
V$BACKUP_SYNC_IO view, 22.3.2
V$BLOCK_CHANGE_TRACKING view, 9.5.5.4
V$CONTROLFILE view, 9.3.3
V$DATABASE view, 11.5.2, 18.2.2, 18.6.1
V$DATABASE_BLOCK_CORRUPTION view, 1.2, 2.9.4, 16.1.2.4, 16.2, 16.2, 19, 19.1.2.1, 19.1.2.1, 19.3, 19.4
V$DATABASE_INCARNATION view, 13.8.5
V$DATAFILE view, 17.2.1.2.2, 21.6.1.2, 28.1.1
listing files for backups, 28.1
V$DATAFILE_HEADER view, 11.1.2, 17.2.1.2.2, 17.2.1.2.2
V$DIAG_INFO view, 2.9.4, 19.3
V$EVENT_NAME view, 23.2.1
V$FLASHBACK_DATABASE_LOG view, 5.3.2.3, 18.4.2, 18.6.1
V$FLASHBACK_DATABASE_STAT view, 7.5.4
V$INSTANCE view, 17.2.1.2.2
V$LOG_HISTORY view
listing all archived logs, 29.3.1
V$LOGFILE view, 21.6.1.2, 30.7.1, 30.7.2
V$PARAMETER view, 18.2.2
V$PROCESS view, 11.1.2, 23.2, 23.2.2
V$PROXY_ARCHIVEDLOG view, 8.3.10
V$PROXY_DATAFILE view, 8.3.10
V$RECOVER_FILE view, 17.2.1.2.2, 29.3.1
V$RECOVERY_AREA_USAGE view, 12.3.2, 12.3.2
V$RECOVERY_FILE_DEST, 12.3.2
V$RECOVERY_FILE_DEST view, 12.3.2, 12.3.2
V$RECOVERY_LOG view
listing logs needed for recovery, 29.3.1
V$RESTORE_POINT view, 18.2.2
V$RMAN_BACKUP_JOB_DETAILS view, 11.4.1
V$RMAN_BACKUP_SUBJOB_DETAILS view, 11.4.1
V$RMAN_ENCRYPTION_ALGORITHMS view, 6.2.6.1, 6.2.6.1, 6.2.6.3, 22.2.2
V$RMAN_OUTPUT view, 11.5.2
V$RMAN_STATUS view, 23.1.1
V$SESSION view, 6.5, 11.1.2, 23.2, 23.2.2
V$SESSION_LONGOPS view, 22.3.1
V$SESSION_WAIT view, 23.2, 23.2.1
V$SGASTAT view, 22.4.3
V$SYSSTAT view, 7.5.4
V$TABLESPACE view, 17.2.1.2.2, 28.1.1
VALIDATE command, 15.1.2.2, 15.3, 16.2, 17.2.1.2.1
SECTION SIZE parameter, 16.2
VALIDATE HEADER option, RESTORE command, 11.1.2
validation, RMAN, 15.3
backups, 2.4.5, 16.2, 16.2, 16.2, 16.2, 16.3, 16.3, 16.3, 16.3
database files, 2.4.5, 16.2
restore operations, 17.2.4
views, recovery catalog, 11.1.2, 11.5
virtual private catalogs, 3.4
dropping, 13.5.5
Volume Shadow Copy Service (VSS), 5.3.1, 9.5.3.1

W

wallet, 6.2.6.1.1
whole database backups
ARCHIVELOG mode, 28.2
inconsistent, 28.2
NOARCHIVELOG mode, 28.2
preparing for, 28.2
using RMAN, 9.3.1, 9.3.1