Skip Headers
Oracle® Database Backup and Recovery Reference
11g Release 2 (11.2)

Part Number E10643-01
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  X 

Symbols

%U format, 4
? symbol in quoted strings, 1.2.2
@ command, 2
@ parameter, RMAN command, 3
@ symbol in quoted strings, 1.2.2
@@ command, 2

A

ABORT parameter, SHUTDOWN command, 3
ACTIVE DATABASE parameter, DUPLICATE command, 2
Advanced Compression option, 2
Advanced Security option, 2
ADVISE FAILURE command, 2
ADVISE OPTION parameter, REPAIR FAILURE command, 3
AFTER parameter, completedTimeSpec subclause, 4
AL16UTF16 character set, CLOB storage, 2
ALGORITHM parameter, SET command, 3
ALL parameter
BACKUP command, 2
SHOW command, 3
ALL parameter, archivelogRecordSpecifier subclause, 4
ALL PRIVILEGES parameter, REVOKE command, 3
ALL SCRIPT NAMES parameter, LIST command, 2
ALLOCATE CHANNEL command, 2
allocOperandList subclause, 4
ALLOCATE CHANNEL FOR MAINTENANCE command, 2
shared server, 2
allocOperandList subclause
parameter descriptions, 4
syntax diagram, 4
ALLOW CORRUPTION parameter, RECOVER command, 3
ALTER DATABASE BACKUP command (SQL), 2
ALTER DATABASE command, 2
analyzing RMAN repositories, 3
APPEND parameter, RMAN command, 3
archived log backups, 2
archived log copies, 2
archived log failover, 2
archived logs
in backup sets, 2
validation report, 3
archived redo files, optimization algorithms, 2
archived redo logs, 4
adding to repository, 2
backing up, 2, 2, 4
backing up n times, 2
cataloging in RMAN repository, 2
days for recovery, 3
deleting, 2, 2, 2, 3
deletion policies, 2
displaying information, 2
excluding from backup, 2, 2
excluding from validation, 3
foreign (LogMiner), 4
image copies, 2
limiting number of backups, 2
missing or inaccessible, 3
number of backups, 3
obsolete, 3
previewing, 3
recovering, 3
report output, 3
restoring, 3
restoring a range, 3
setting the destination, 3
specifying a range, 4
using for recovery (example), 3
validating, 3, 3
ARCHIVELOG BACKUP COPIES parameter
CONFIGURE command, 2
SHOW command, 3
ARCHIVELOG DELETION POLICY parameter
CONFIGURE command, 2
SHOW command, 3
ARCHIVELOG DESTINATION parameter, SET command, 3
ARCHIVELOG mode, 2, 2, 2
ARCHIVELOG parameter
CATALOG command, 2
VALIDATE command, 3
recordSpec subclause, 4
ARCHIVELOG TAG parameter, RECOVER command, 3
archivelogRecordSpecifier subclause, 4, 4
parameter descriptions, 4
syntax diagram, 4
archiving redo logs, 2, 2
archlogRange subclause
parameter descriptions, 4
syntax diagram, 4, 4
arguments to stored scripts, 2
AS BACKUPSET parameter, BACKUP command, 2
AS COPY parameter, BACKUP command, 2
ASM
See Automatic Storage Management (ASM)
AT SCN parameter, REPORT command, 3
AT SEQUENCE parameter, REPORT command, 3
at sign command (@), 2
at sign parameter, RMAN command, 3
AT TIME parameter, REPORT command, 3
atClause subclause
parameter descriptions, 3
syntax diagram, 3
AUTOBACKUP parameter, RESTORE command, 3
autoBackupOptList subclause
parameter descriptions, 3
syntax diagram, 3
autobackups, control file, 2
Automated Diagnostic Repository, logging failures, 3
automated repair, 3
automatic diagnostic repository
changing failure status, 2
changing logged failures, 2
See diagnostic repository
Automatic Storage Management (ASM)
channel allocation, 2
converting format to, 2
converting format to (example), 2
converting formats, 2
disk groups, 3
duplicating databases, 2
specifying disk groups, 2
AUXILIARY CHANNEL parameter
CONFIGURE command, 2
SHOW command, 3
auxiliary databases
connecting to, 2, 4
initialization files, 2
AUXILIARY DESTINATION parameter
RECOVER command, 3
TRANSPORT TABLESPACE command, 3
auxiliary filename settings, 2
AUXILIARY FORMAT parameter
allocOperandList subclause, 4
BACKUP command, 2
AUXILIARY INSTANCE PARAMETER FILE TO parameter, SET command, 3
auxiliary instances, specifying channels, 2
AUXILIARY parameter
ALLOCATE CHANNEL command, 2
CONNECT command, 2
RMAN command, 3
AUXNAME parameter
CONFIGURE command, 2
SHOW command, 3
availability, changing status for backup or copy, 2, 2
AVAILABLE parameter, CHANGE command, 2
AVAILABLE status
definition, 2
effect of DELETE command, 2

B

BACKED UP parameter, maintQualifier subclause, 4
backing up, excluded files, 2
backup clause
parameter descriptions, 2
syntax diagram, 2
BACKUP command, 2
backup clause, 2, 2
backupOperand subclause, 2, 2
backupSpec subclause, 2, 2, 2
backupSpecOperand subclause, 2, 2
backupTypeSpec subclause, 2, 2
copyOfSpec subclause, 2, 2
datafileCopySpec subclause, 2, 2
duration subclause, 2, 2
fileNameConversionSpec parameter, 4
forRecoveryOfSpec subclause, 2, 2
limiting processing time, 2
notBackedUpSpec subclause, 2, 2
sizeSpec subclause, 2, 2
skipSpec subclause, 2, 2
backup commands, 3
BACKUP COPIES parameter
SET command, 3
SHOW command, 3
backup levels, 2
backup media, 2
BACKUP OPTIMIZATION parameter
SHOW command, 3
BACKUP OPTIMIZATION parameter, CONFIGURE command, 2
BACKUP parameter
LIST command, 2
maintSpec subclause, 4
backup pieces
adding to repository, 2, 2
available information, 2, 2
crosschecking or deleting, 2
definition, 2
displaying information, 2
format, 4, 4
maximum size, 4
obsolete, 3
overriding default copies, 3
restoring, 3
validating, 3
backup retention policies, 2
backup sections, sizing, 2
backup set failover, 2
backup sets
about archived logs, 2
available information, 2
backing up, 2
backing up encrypted, 2
backup pieces, available information, 2
binary compression, 2, 2
cataloging in RMAN repository, 2
date ranges, 2
deleting, 2, 2
displaying information, 2
encryption, 2, 3
information about copies, 2
information about datafiles, 2
maximum size, 2
maximum size per channel, 2
obsolete
report output, 3
optimization algorithms, 2
recovering, 3
restoring only from, 3
retention policies, 2
status, 2
summary information, 2
tag names, 2
unused block compression, 2, 2
validating, 3, 3
BACKUP_TAPE_IO_SLAVES initialization parameter, 2, 2
backupCommands subclause, syntax diagram, 3
backupConf subclause
parameter descriptions, 2
syntax diagram, 2
backupOperand subclause
parameter descriptions, 2
syntax diagram, 2
BACKUPPIECE parameter
CATALOG command, 2
recordSpec subclause, 4
backups
applying incremental, 3
binary compression, 2, 2
changing availability, 2, 2
configuration, 2
corruption tolerance (example), 2
creating multiple copies, 2
creating transportable tablespaces, 3
criteria for obsolescence, 4
cumulative, 2
datafiles, 2, 2
datafiles requiring new, 3
deleting, 2
deleting obsolete, 2
duplexing example, 2
duplicate copies, 2
duplicating, 2
failures, 2
inconsistent, 2
incremental, 2, 2, 3
limiting duration, 2
listing, 2, 3
minimum required, 3
multisection, 2
obsolete, 3
overriding defaults in restore, 3
overwriting, 2
partial, 2
previewing, 3
redundant, 3
removing from recovery catalog, 3
restarting, 2
retaining multiple full (level 0), 2
retention policies, 2
summary list, 2
using incremental (example), 3
using incremental updates (example), 3
validating files, 3
validating in repository, 2
BACKUPS parameter, UNREGISTER command, 3
BACKUPSET parameter
BACKUP command, 2, 2
RECOVER command, 3
RESTORE command, 3
VALIDATE command, 3
recordSpec subclause, 4
backupSpec subclause
parameter descriptions, 2, 2
syntax diagram, 2
backupSpecOperand subclause
parameter descriptions, 2
syntax diagram, 2
backupTypeSpec subclause
parameter descriptions, 2
syntax diagram, 2
Backus Naur Form syntax diagrams, 1.2
base recovery catalog
See recovery catalog
batch files
See command files
BEFORE parameter, completedTimeSpec subclause, 4
BEFORE RESETLOGS parameter, FLASHBACK DATABASE command, 2
BEFORE SCN parameter, FLASHBACK DATABASE command, 2
BEFORE SEQUENCE parameter, FLASHBACK DATABASE command, 2
BEFORE TIME parameter, FLASHBACK DATABASE command, 2
BETWEEN parameter, completedTimeSpec subclause, 4
BFILE data type, excluded from backup, 2
binary compression, 2, 2
block change tracking files
excluded from backup, 2
improving performance, 2
block checksums, 2
block corruptions
checking for, 3
flashback, 2
block media recovery, 3
block sizes of backup media, 2
blockObject subclause
parameter descriptions, 3
syntax diagram, 3, 3
blocks
corrupt, 3
creating, 3
See also data blocks
BNF syntax diagrams, 1.2
braces {}, 3
BY FILE parameter, LIST command, 2

C

CATALOG command, 2
CATALOG FOR DATABASE parameter
GRANT command, 2
REVOKE command, 3
CATALOG parameter
CONNECT command, 2
RMAN command, 3
CATALOG privilege, 2
catalogs
importing, 2
virtual private, 2
CDs as backup media, 2
cfauConf subclause
parameter descriptions, 2
syntax diagram, 2
CHANGE command, 2
changeFailure subclause, 2, 2
forDbUniqueNameOption subclause, 2
maintSpec subclause, 2, 4
recordSpec subclause, 4
resetDbUniqueNameOption subclause, 2, 2
changeFailure subclause
parameter descriptions, 2
syntax diagram, 2
changes, reversing, 2
channel names, 2
CHANNEL parameter
ALLOCATE CHANNEL command, 2
BACKUP command, 2
CONFIGURE command, 2
RESTORE command, 3, 3
SEND command, 3
SHOW command, 3
SQL command, 3
channel parameters, 3
channels
allocating for duplication, 2
allocating for restore, 3
allocating for validation, 3
allocating manually, 2, 2
allocating to shared server sessions, 2
configuring for RAC (example), 2
configuring type for recovery, 3
device type default, 2
identifying database server sessions, 3
maximum number, 2
naming conventions, 2
releasing, 3
restoring in Data Guard, 3
setting for restore (example), 3
with proxy capabilities, 2
character sets, CLOB storage, 2
CHECK LOGICAL parameter
BACKUP command, 2, 2
RECOVER command, 3
RESTORE command, 3
VALIDATE command, 3
checksums, 2
CHECKSYNTAX parameter, RMAN command, 3
client compatibility, B.1
client, opening RMAN, 3
CLOB data type, transporting, 2
closing RMAN, 2, 2
Cloud computing, C.1
CMDFILE parameter, RMAN command, 3
cmdLine clause
parameter descriptions, 3
syntax diagram, 3
cmdLine command
See RMAN command
command entry description, 1.1
command files, 2, 2, 3
command format, 1.3
COMMAND ID TO parameter
SET command, 3
command line arguments, 3
command subclause summary, 1.6
command subclauses
See specific subclause name
command summary, 1.5
command terminator, 1.3
commands
creating blocks, 3
deprecated, A, A
executing host, 2
executing SQL, 3
RMAN, 3
sending to media manager, 3
sending to media managers, 3
See specific command name
comment character (#), 1.3
COMMENT parameter
CREATE SCRIPT command, 2
DUPLICATE command, 2
REPLACE SCRIPT command, 3
compatibility, B.1
COMPATIBLE initialization parameter, 2
completedTimeSpec subclause, 4
compression, 2
COMPRESSION ALGORITHM parameter
BASIC, 2
CONFIGURE command, 2
HIGH, 2
LOW, 2
MEDIUM, 2
SHOW command, 3
compression levels, 2
configuration
displaying, 2
displaying settings, 3
overriding, 3, 3
restoring default settings, 2
setting, 2
configuration files, excluded from backup, 2
CONFIGURE BACKUP OPTIMIZATION setting, 2
configure clause
parameter descriptions, 2
syntax diagram, 2
CONFIGURE command, 2
backupConf subclause, 2, 2
cfauConf subclause, 2, 2
configure clause, 2, 2
delalConf subclause, 2, 2
deviceConf subclause, 2, 2
encryption settings, 2
forDbUniqueNameOption subclause, 2
sizeSpec subclause, 2
CONFIGURE commands, 3
CONFIGURE CONTROLFILE AUTOBACKUP parameter, 2
CONNECT command, 2
CONNECT IDENTIFIER parameter, CONFIGURE command, 2
CONNECT parameter, allocOperandList subclause, 4
connect strings, 4
to auxiliary database, 3
to recovery catalog database, 3
to target database, 3
connections, changing, 2
connectStringSpec subclause, 4
consistent shutdowns, 2
control file backups, available information, 2
control file copies
available information, 2
tag names, 2
control files
adding copies to repository, 2
autobackup validation, 3
automatic backups, 2
backing up copies, 2
copies
cataloging in RMAN repository, 2
validating, 3
filenames for control file autobackup, 3
including in database backup, 2
limiting search, 3
re-creating, 3
restoring, 3, 3, 3
restoring (example), 3
restoring autobackups, 3
restoring for primary database, 3
resynchronization, 3
snapshots, 2, 2
validating, 3
validation report, 3
CONTROL_FILES initialization parameter, 2
CONTROLFILE AUTOBACKUP FORMAT parameter, SET command, 3
CONTROLFILE AUTOBACKUP parameter
CONFIGURE command, 2
SHOW command, 3
CONTROLFILE parameter
RESTORE command, 3, 3
VALIDATE command, 3, 3
CONTROLFILE parameter, listObjList subclause, 4
CONTROLFILECOPY parameter
BACKUP command, 2
CATALOG command, 2
RESYNC CATALOG command, 3
VALIDATE command, 3
recordSpec subclause, 4
convert clause
parameter descriptions, 2
syntax diagram, 2
CONVERT command, 2
convert clause, 2, 2
convertOptionList subclause, 2, 2
fileNameConversionSpec parameter, 4
formatSpec subclause, 2
skipSpec subclause, 2, 2
transportOptionList subclause, 2, 2
convertOptionList subclause
parameter descriptions, 2
syntax diagram, 2
copies
changing availability, 2, 2
creating multiple backups, 2
deleting, 2, 2
deleting obsolete, 2
expired, 2
minimum required, 3
of backup sets, available information, 2
validating in repository, 2
viewing status, 2
COPIES parameter, BACKUP command, 2
copy location, 2
COPY OF parameter
BACKUP command, 2
RECOVER command, 3
COPY parameter
BACKUP command, 2
LIST command, 2
maintSpec subclause, 4
copying files, 2
copyOfSpec subclause
parameter descriptions, 2
syntax diagram, 2, 3
corrupt blocks
checking for, 3
restoring, 3
tolerance for, 3
tolerance for (example), 2
CORRUPTION LIST parameter, RECOVER command, 3
CORRUPTION parameter
RECOVER command, 3
CPU_COUNT initialization parameter, 3
CREATE CATALOG command, 2
CREATE SCRIPT command, 2
CREATE TYPE privilege, 3
CROSSCHECK command, 2
maintSpec subclause, 2, 4
recordSpec subclause, 4
cross-platform compatibility, 2
cumulative backups, 2
CUMULATIVE parameter
BACKUP command, 2
CURRENT CONTROLFILE parameter
BACKUP command, 2
VALIDATE command, 3, 3

D

data block address (DBA), 3
data blocks
checking for corrupted, 2
recovering corrupt, 3
recovering individual, 3
recovering logically corrupt, 3
recovering physically corrupt, 3
data compression, 2
data encryption, 2
Data Guard
changing backup associations, 2
configuring databases, 2
creating physical standby databases, 2
creating standby databases (example), 2
deleting backups and copies, 2
restoring backups, 3
RMAN configuration in recovery catalog, 2
specifying databases, 4
updating backup status, 2
Data Guard backups
accessibility by databases, 2
changing associated database, 2
database association, 2
Data Pump, 2, 2, 3, B.4
Data Recovery Advisor, 2, 3
data types, endian conversion, 2
database changes, reversing, 2
database configuration
See configuration
database duplication
See duplication
database failure, repairing, 3
database identifiers
changing, 2
duplicates, 3
database incarnations, 2
DATABASE parameter
BACKUP command, 2
RECOVER clause, 3
REPORT command, 3
RESTORE command, 3
SWITCH command, 3
UNREGISTER command, 3
VALIDATE command, 3
DATABASE parameter, DUPLICATE command, 2
database point-in-time recovery (DBPITR), 3
database registration, 3
database schemas
report output, 3
database server sessions
identifying channels, 3
DATABASE SKIP TABLESPACE parameter, listObjList subclause, 4
databases, 2
available information, 2
backing up, 2
changing connections, 2
connecting to, 2
converting platform format, 2
copying, 2
deleting, 2
encryption settings, 3
mounting, 2
opening, 2
platform conversion scripts, 2
recovering, 3, 3
recovering with incremental backups (example), 3
recovering with incremental updates, 3
registering, 2, 3
removing from recovery catalog, 3
resetting incarnation, 3
resynchronization, 3
revoking registration privileges, 3
shutting down target, 3
specifying in Data Guard environment, 4
standby, restoring control files, 3
starting target from RMAN, 3
transparent encryption, 2
transporting re-created files, 2
updating filenames, 3
validating, 3
DATAFILE BACKUP COPIES parameter
CONFIGURE command, 2
SHOW command, 3
datafile backup sets, available information, 2
datafile backups
available information, 2
expired, 2
DATAFILE BLOCK parameter
RECOVER command, 3
datafile copies
available information, 2
deleting, 2
displaying information, 2
listing, 3
obsolete, 3
report output, 3
restoring only from, 3
tag names, 2
validating, 3
DATAFILE parameter
BACKUP command, 2
CONVERT command, 2
RECOVER command, 3
REPORT command, 3
RESTORE command, 3
SWITCH command, 3, 3
VALIDATE command, 3
DATAFILECOPY parameter
CATALOG command, 2
RECOVER command, 3, 3
RESTORE command, 3
recordSpec subclause, 4
datafileCopySpec subclause
parameter descriptions, 2
syntax diagram, 2
datafiles
auxiliary filenames, 2
backing up, 2, 2, 2
backing up copies, 2
backing up large, 2
backing up new only, 2
backups
deleting obsolete, 2
converting platform format, 2
copies
adding to repository, 2
cataloging in RMAN repository, 2
incremental backups, 2
tag names, 2
validating, 3
days of archived redo logs, 3
excluding from backup, 2, 2
excluding from conversion, 2
excluding from validation, 3
flashback status changes, 2
forcing restore, 3
image copies, 2
in backup sets
available information, 2
listing within a tablespace, 3
minimum number of backups, 3
offline, 2
optimization algorithms, 2
point-in-time lists, 3
readonly, 2
read-only, omitting from restore, 3
recovering, 3, 3
recovering corrupt data blocks, 3
renaming, 3, 3, 3
report output, 3, 3, 3, 3, 3
requiring backup
report output, 3
requiring new backups, 3
restored location, 3
restoring, 3
all online, 3
from image copies, 3
individual, 3
to new locations, 3
reversing changes, 2
unrecoverable, 3
updating filenames, 3
validating, 3, 3
validation report, 3
datafileSpec subclause, 4
DATAPUMP DIRECTORY parameter, TRANSPORT TABLESPACE command, 3
date ranges of backup sets, 2
dates in RMAN commands, 4
DAYS parameter, REPORT command, 3
DB_BLOCK_CHECKSUM initialization parameter, 2
DB_CREATE_FILE_DEST initialization parameter, 4
DB_FILE_NAME_CONVERT initialization parameter, 2, 2, 2, 3, 4
DB_FLASHBACK_RETENTION_TARGET initialization parameter, 2
DB_NAME parameter
IMPORT CATALOG command, 2
RESTORE command, 3
DB_NAME, changing, 2
DB_RECOVERY_FILE_DEST initialization parameter, 3
DB_RECOVERY_FILE_DEST parameter
BACKUP command, 2
CATALOG command, 2
RESTORE command, 3
VALIDATE command, 3
DB_UNIQUE_NAME initialization parameter, 3
DB_UNIQUE_NAME parameter
CHANGE command, 2
CONFIGURE command, 2, 2
DELETE command, 2
LIST command, 2
RESTORE command, 3
RESYNC CATALOG command, 3
SHOW command, 3
UNREGISTER command, 3
DB_UNIQUE_NAME parameter, forDbUniqueNameOption, 4
DB_UNIQUE_NAME setting, 2, 2, 2, 3
DBA parameter, STARTUP command, 3
DBID parameter
IMPORT CATALOG command, 2
SET command, 3, 3, 3
DBIDs
available information, 2
changing, 2
duplicates, 3
of standby databases, 2
DBNEWID utility, 3
dbObject subclause
parameter descriptions, 3, 4
syntax diagram, 3, 4
DECRYPTION parameter, SET command, 3
DEFAULT DEVICE TYPE parameter
CONFIGURE command, 2
SHOW command, 3
delalConf subclause
command parameters, 2
syntax diagram, 2
DELETE ARCHIVELOG parameter, RECOVER command, 3
delete clause, syntax diagram, 2
DELETE command, 2
delete clause, 2
forDbUniqueNameOption subclause, 2
maintSpec subclause, 2, 4
recordSpec subclause, 4
DELETE INPUT parameter, BACKUP command, 2
DELETE SCRIPT command, 2
deprecated commands, A
DESTINATION parameter, RECOVER command, 3
DESTINATION PLATFORM parameter, CONVERT command, 2
destinations for restoring datafiles, 3
DEVICE TYPE parameter
ALLOCATE CHANNEL command, 2
ALLOCATE CHANNEL FOR MAINTENANCE command, 2
BACKUP command, 2
CHANGE command, 2
CONFIGURE command, 2
DELETE command, 2
DUPLICATE command, 2
FLASHBACK DATABASE command, 2
RECOVER command, 3
REPORT command, 3
RESTORE command, 3
SEND command, 3
SHOW command, 3
VALIDATE command, 3
maintSpec subclause, 4
DEVICE TYPE parameter, maintQualifier subclause, 4
device types, specifying, 2
deviceConf subclause
parameter descriptions, 2
syntax diagram, 2
deviceSpecifier subclause, 4
diagnostic repository, 2
diagrams of syntax, 1.2
disk device type setting, 2
disk drives, using several for backup, 2
disk files, creating from stored scripts, 2
DISK parameter, deviceSpecifier subclause, 4
DISKRATIO parameter, BACKUP command, 2
displaying scripts, 2
DORECOVER parameter, DUPLICATE command, 2
double at sign command (@@), 2
double quotes, 1.2.3
DROP CATALOG command, 2
DROP DATABASE command, 2
dual-mode encryption, 2
duplexing, 2, 2, 3, 3
duplicate clause
parameter descriptions, 2
syntax diagram, 2
DUPLICATE command, 2
duplicate clause, 2, 2
dupOptionList subclause, 2, 2
fileNameConversionSpec parameter, 4
logSpec subclause, 2, 2
setParameter subclause, 2, 2
sizeSpec subclause, 2
duplicate databases
creating
using CONFIGURE AUXNAME, 2
duplicate databases, opening, 2, 2
duplicating files, 2
duplication
backup based, 2
configuration, 2
example using auxiliary channels, 2
dupOptionList subclause
parameter descriptions, 2
syntax diagram, 2
DURATION parameter, BACKUP command, 2
duration subclause
parameter descriptions, 2
syntax diagram, 2
DVDs as backup media, 2
dynamic performance views
summary list, 5.1
V$BACKUP_PIECE, 2
V$BACKUP_SET, 2
V$DATABASE, 3
V$DATABASE_BLOCK_CORRUPTION, 2, 3, 3, 3, 3, 3, 3
V$DATABASE_FLASHBACK_ON, 2
V$DATABASE_INCARNATION, 3
V$DATABASE.CURRENT_SCN, 2
V$DATAFILE_COPY, 2
V$FLASHBACK_DATABASE_LOG, 2
V$RMAN_COMPRESSION_ALGORITHM, 2, 3
V$RMAN_ENCRYPTION_ALGORITHMS, 2, 2, 3, 3
V$RMAN_OUTPUT, 2, 3
V$RMAN_STATUS, 3
V$SESSION, 3
V$TABLESPACE, 2
V$TRANSPORTABLE_PLATFORM, 2

E

ECHO parameter, SET command, 3
encryption
backup sets, 2, 2, 3
of duplicate databases, 2
recovering tablespaces, 3
specifying decryption passwords, 3
ENCRYPTION ALGORITHM parameter, CONFIGURATION command, 2
encryption algorithms, 2, 3
ENCRYPTION parameter
CONFIGURE command, 2
SET command, 3
SHOW command, 3
encryption settings
overriding, 2, 2
transparent mode, 2
V$RMAN_ENCRYPTION_ALGORITHMS view, 2
encryption wallets
See wallets
end times
for restore, 3
endian formats
converting, 2
transportable tablespaces, 3
transporting across platforms, 2
environment variables
in RMAN strings, 1.2.2
NLS_DATE_FORMAT, 3
NLS_LANG, 3
error messages
ORA-1152, 2
ORA-1578, 3
ORA-19504, 2
ORA-19624, 2
ORA-19916, 2
ORA-27086, 2
RMAN-0558, 3
RMAN-06004, 2, 2, 2
RMAN-06445, 2, 2
RMAN-06496, 3, 3
RMAN-06710, 2
RMAN-10031, 2
RMAN-10035, 2
RMAN-20401, 2
RMAN-6758, 3
too many open files, 4
EXCLUDE FLASHBACK LOG parameter, RECOVER command, 3, 3
EXCLUDE FOR TABLESPACE parameter, CONFIGURE command, 2
EXCLUDE parameter, SHOW command, 3
EXECUTE SCRIPT command, 2
EXIT command, 2
exiting RMAN, 2
EXPIRED parameter
DELETE command, 2
LIST command, 2
EXPIRED status, 2, 2
EXPORT LOG parameter, TRANSPORT TABLESPACE command, 3
export utilities, 2
external tables, excluded from backup, 2

F

failed backups, restarting, 2
FAILURE parameter
CHANGE command, 2
LIST command, 2
failure summary, 2
failures, available information, 2
fast recovery, 2
fast recovery areas
cataloging contents, 2
defining for duplicate databases, 2
location of autobackup, 2
specifying for restore, 3
validating, 3
file copies, 2, 3
See also backups
FILE parameter
CREATE SCRIPT command, 2
LIST command, 2
PRINT SCRIPT command, 2
REPLACE SCRIPT command, 3
file recovery, 3
file sections, sizing, 2
filename formats, 3
fileNameConversionSpec subclause, 4
filenames
changing during platform conversion, 2
datafile image copies, 2
generating new, 4
setting auxiliary, 2
updating, 3
files
backing up new only, 2
backing up with proxy copy, 2
changing availability, 2, 2
creating from stored scripts, 2
excluded from backup, 2
listing those needing backup, 3
naming backups, 2
overwriting backups, 2
sources for duplication, 2
unavailable, 2
validating, 2
FILESPERSET parameter, BACKUP command, 2
flashback, 2
FLASHBACK DATABASE command, 2
FLASHBACK LOG parameter, RECOVER command, 3, 3
flashback logs, 2, 3
flashback NOLOGGING operations, 2
FOR DB_UNIQUE_NAME parameter, forDbUniqueNameOption subclause, 4
FOR DB_UNIQUE_NAME parameter, RESTORE command, 3
FOR RECOVER OF COPY parameter, BACKUP command, 2
FOR RECOVER OF TAG parameter, BACKUP command, 2
FORCE parameter
BACKUP command, 2
DELETE command, 2
RESTORE command, 3
STARTUP command, 3
forDbUniqueNameOption subclause
parameter descriptions, 4
syntax, 4
syntax diagram, 2, 2, 2
foreignlogRecordSpecifier subclause
syntax diagram, 4
FOREVER parameter, RECOVER command, 3
FORMAT parameter
ALLOCATE CHANNEL command, 4
BACKUP command, 2
CONVERT command, 2
FORMAT parameter, allocOperandList subclause, 4
formatSpec subclause, syntax diagram, 2
forRecoveryOfSpec subclause
parameter descriptions, 2
syntax diagram, 2
FROM ACTIVE DATABASE parameter
DUPLICATE command, 2
FROM AUTOBACKUP parameter, RESTORE command, 3
FROM BACKUPSET parameter
RECOVER command, 3
RESTORE command, 3
FROM CONTROLFILECOPY parameter, RESYNC CATALOG command, 3
FROM DATAFILECOPY parameter
RECOVER command, 3
RESTORE command, 3
FROM DB_UNIQUE_NAME parameter, RESYNC CATALOG command, 3
FROM FILE parameter, REPLACE SCRIPT command, 3
FROM SCN parameter, archlogRange subclause, 4
FROM SEQUENCE parameter, archlogRange subclause, 4
FROM TAG parameter
BACKUP command, 2, 2
RECOVER command, 3
RESTORE command, 3, 3
FROM TIME parameter, archlogRange subclause, 4
FTP, moving backups, 2
FULL parameter, BACKUP command, 2

G

GLOBAL parameter
CREATE SCRIPT command, 2
DELETE SCRIPT command, 2
EXECUTE SCRIPT command, 2
PRINT SCRIPT command, 2
REPLACE SCRIPT command, 3
GLOBAL SCRIPT NAMES parameter, LIST command, 2
global scripts
executing, 2
importing, 2
listing names, 2
printing, 2
See also scripts
GRANT command, 2

H

hardware error recovery (example), 3
header blocks, 3
HEADER parameter
RECOVER command, 3
RESTORE command, 3
HOST command, 2

I

image copies
adding to repository, 2
applying incremental backups, 3
backing up, 2
creating, 2
deleting, 2
displaying information, 2
format, 4, 4, 4
restoring, 3, 3
retention policies, 2
IMMEDIATE parameter, SHUTDOWN command, 3
IMPORT CATALOG command, 2
IMPORT SCRIPT parameter, TRANSPORT TABLESPACE command, 3
import utilities, 2
INACCESSIBLE parameter
CONVERT command, 2
VALIDATE command, 3
INCARNATION parameter
Archived redo log file ranges, 4
DUPLICATE command
orphan, 2
LIST command, 2
RESET DATABASE TO INCARNATION, 3
SET command, 3
incarnations, 2, 3
INCLUDE CURRENT CONTROLFILE parameter
BACKUP command, 2, 2
VALIDATE command, 3
INCLUDING BACKUPS parameter
DROP DATABASE command, 2
UNREGISTER command, 3
inconsistent backups, 2
inconsistent shutdowns, 2
incremental backups, 2, 2
adding datafile copies, 2
bitmap limit, 2
report output, 3
sample script, 2
using datafile copy, 2
INCREMENTAL parameter
BACKUP command, 2
REPORT command, 3
index blocks, logical corruption, 3
initialization files
for auxiliary databases, 2
for database startup, 3
initialization parameters
BACKUP_TAPE_IO_SLAVES, 2
COMPATIBLE, 2
CONTROL_FILES, 2
CPU_COUNT, 3
DB_BLOCK_CHECKSUM, 2
DB_CREATE_FILE_DEST, 4
DB_FILE_NAME_CONVERT, 2, 2, 3, 4
DB_FLASHBACK_RETENTION_TARGET, 2
DB_RECOVERY_FILE_DEST, 3
DB_UNIQUE_NAME, 3
LOG_ARCHIVE_DEST_n, 3, 3
LOG_ARCHIVE_FORMAT, 3
LOG_FILE_NAME_CONVERT, 2, 3
RECOVERY_PARALLELISM, 3
replacing values, 2
setting for duplicate database, 2
input files, deleting, 2

J

job commands, 3

K

KEEP parameter
BACKUP command, 2
KEEP parameter, keepOption subclause, 4
keepOption subclause, 4
keywords in syntax diagrams, 1.2.1

L

LIKE parameter
archivelogRecordSpecifier subclause, 4
maintQualifier subclause, 4
LIKE parameter, BACKUP command, 2
Linux commands, 2
Linux-to-Windows conversion (example), 2
list clause
parameter descriptions, 2
syntax diagram, 2
LIST command, 2
list clause, 2, 2
listBackupOption subclause, 2, 2
listObjectSpec subclause, 2, 2
maintQualifier subclause, 2
recordSpec subclause, 4
recoverableClause subclause, 2, 2
listBackupOption subclause
parameter descriptions, 2
syntax diagram, 2
listObjectSpec subclause
parameter descriptions, 2
syntax diagram, 2
listObjList subclause, 4
parameter descriptions, 4
syntax diagram, 4
LOB data types, transporting, 2
local scripts
executing, 2
listing names, 2
printing, 2
See also scripts
LOCATION parameter, 3
log files
appending output, 3
creating for RMAN sessions, 3
directing output to, 3
LOG parameter, RMAN command, 3
log sequence number, 3
log sequence numbers
point-in-time recovery, 2
undoing changes, 2
log sequence, resetting, 2
LOG_ARCHIVE_DEST_n initialization parameter, 3, 3, 3
LOG_ARCHIVE_FORMAT initialization parameter, 3
LOG_FILE_NAME_CONVERT initialization parameter, 2, 3
LOG_FILE_NAME_CONVERT parameter, DUPLICATE command, 2
LOGFILE parameter
DUPLICATE command, 2, 2
logging in, 4
logical corruption, checking for, 3
LogMiner utility, 2, 2, 2, 2, 4
logSpec subclause
parameter descriptions, 2
syntax diagram, 2

M

maintenance channels
allocating, 2
naming conventions, 2
releasing, 3
maintenance commands, 3
maintenance job configuration, 2
maintenanceCommands subclause, syntax diagram, 3
maintQualifier subclause
parameter descriptions, 4
syntax diagram, 2, 4
maintSpec subclause, 4
syntax diagram, 2, 2, 2
MAXCORRUPT parameter
SET command, 3
MAXDAYS parameter, RESTORE command, 3
MAXOPENFILES parameter, allocOperandList subclause, 4
MAXPIECESIZE parameter, allocOperandList subclause, 4
MAXSEQ parameter, RESTORE command, 3
MAXSETSIZE parameter
BACKUP command, 2
CONFIGURE command, 2
SHOW command, 3
media failure, restoring backups, 3
media libraries for sbt channels, 4
media managers, 2
compressing data, 2
controlling data transfer, 2
sending commands, 3, 3
specifying environment variables, 4
status of offsite backups, 3
validating metadata, 2
See also Oracle Secure Backup
media pool, backup storage, 2
media recovery
parallel processing, 3
single processing, 3
message logs
appending output, 3
controlling content, 3
message numbers, 3
metadata
changing catalog schemas, 2
resynchronization, 3
validating in repository, 2
miscellaneous commands, 3
missing files
checking for, 3
deleting from repository, 2
MOUNT parameter
ALTER DATABASE command, 2
STARTUP command, 3
mounting databases, 2
moving backups, 2
MSGNO parameter, RMAN command, 3
multisection backups, 2

N

NEED BACKUP parameter, REPORT command, 3
needBackupOption subclause
parameter descriptions, 3
syntax diagram, 3
nested command files, 2
net service names, 2, 4
NEW DATABASE parameter, CONVERT command, 2
new files, backing up only, 2
NEWNAME FOR DATAFILE parameter, SET command, 3, 3, 3
NEWNAME FOR TEMPFILE parameter, SET command, 3
NEWNAME setting, persistent alternative, 2
NLS_DATE_FORMAT configuration setting, 2
NLS_DATE_FORMAT environment variable, 3
NLS_LANG environment variable, 3
NLS_LANG environment variables, 2
NO UNREGISTER parameter, IMPORT CATALOG command, 2
NOARCHIVELOG mode, 2, 2
NOCATALOG parameter, RMAN command, 3
NOCHECKSUM parameter, BACKUP command, 2
NOEXCLUDE parameter
BACKUP command, 2
VALIDATE command, 3
NOFILENAMECHECK parameter, DUPLICATE command, 2, 2
NOKEEP parameter, keepOption subclause, 4
NOMOUNT parameter, STARTUP command, 3
nonquoted strings, 1.2.2
NOPARALLEL parameter, RECOVER command, 3
NOPROMPT parameter
DELETE command, 2
DROP DATABASE command, 2
NOREDO parameter
DUPLICATE command, 2
RECOVER command, 3
NORMAL parameter, SHUTDOWN command, 3
normal resynchronization, 3
NOT BACKED UP parameter, BACKUP command, 2
notBackedUpSpec subclause
parameter descriptions, 2
syntax diagram, 2
numbers, displaying message, 3

O

OBSOLETE parameter
DELETE command, 2
REPORT command, 3
obsOperandList subclause, 4
OFF parameter, SPOOL command, 3
OFFLINE parameter
CONVERT command, 2
VALIDATE command, 3
offsite backups, 3
OMF format, 2
online redo logs
for duplicate database, 2
for RAC, 2
OPEN parameter, ALTER DATABASE command, 2
OPEN RESTRICTED parameter, DUPLICATE command, 2, 2
opening databases, 2
operating system commands, 2
operating systems
compatibility, 2
duplicating databases across, 2
transporting across, 2
optimization algorithms, 2
optimization, overriding backup, 2
ORA$RMAN_RPI_IN pipe, 3
ORA$RMAN_RPI_OUT pipe, 3
ORA-1152 error message, 2
ORA-1578 error message, 3
ORA-19504 error message, 2
ORA-19624 error message, 2
ORA-19916 error message, 2
ORA-27086 error message, 2
Oracle Advanced Compression, 2
Oracle home, excluded from backup, 2
Oracle Managed Files (OMF), 2, 4
duplicating databases (example), 2
Oracle Net connections, 3
Oracle RAC
recovering from failure, 3
See RAC
Oracle Secure Backup, 2
creating encrypted backups, 2
sending commands to (example), 3
undo data, 2
Oracle Secure Backup (OSB) Cloud Module
configuring RMAN channel, C.1.9
creating an AWS account, C.1.4
environment variables
ENV parameter of PARMS option, C.1.9
SBT_PARMS parameter, C.1.9
getting AWS Identifiers, C.1.5
prerequisites, C.1.2
registering for OTN account, C.1.3
running the S3 Backup installer
first time, C.1.6
Linux example, C.1.7
recommended method, C.1.7
Securing backups, C.1.10
storing configuration in RMAN repository, C.1.8
Troubleshooting, C.1.11
Oracle wallets, 3, 3
Oracle10g compatibility, B.1
Oracle8i compatibiity, B.1
Oracle9i compatibiity, B.1
output
displaying message numbers, 3
storing in files, 3
overwriting backup files, 2

P

PARALLEL parameter, RECOVER command, 3
parallelism
allocating channels, 2
backup using channels (example), 2
channel allocation, 2
specifying for recovery, 3
validation, 3
PARALLELISM parameter, CONVERT command, 2
parallelism settings, 3
parameter files
backing up, 2, 2
restoring, 3, 3
See also initialization parameter files, server parameter files, 3
specifying path, 3
PARAMETER_VALUE_CONVERT parameter
DUPLICATE command, 2
overriding, 2
parameters
deprecated, A
for sbt channels, 4
in syntax diagrams, 1.2.2
parameters in stored scripts, 2
PARMS parameter
allocOperandList subclause, 4
SEND command, 3
partial backups, 2
password encryption, 2
PASSWORD FILE parameter, DUPLICATE command, 2
password files
excluded from backup, 2
for duplicate databases, 2
password-based encryption, 2
passwords, 4
encrypted, 2
encrypted backup sets, 3
for decryption, 3
RAC SYSDBA, 2
performance
allocating channels, 2
incremental backups, 2
PFILE parameter
DUPLICATE command, 2
STARTUP command, 3
PIPE parameter, RMAN command, 3
pipes
opening input and output, 3
timing out, 3
placeholders in syntax diagrams, 1.2.2
platform compatibility, 2
PLATFORM parameter, CONVERT command, 2
platforms
duplicating databases across, 2
transporting across, 2
PL/SQL code, converting formats, 2
PL/SQL stored procedures, 3
PLUS ARCHIVELOG parameter, VALIDATE command, 3
point-in-time recovery, 2, 3, 3, 4
POOL parameter, BACKUP command, 2
PREVIEW parameter, RESTORE command, 3
previewing backups, 3
PRIMARY CONTROLFILE parameter, RESTORE command, 3
primary databases
backing up, 2
copying, 2
PRINT SCRIPT command, 2
private catalog schema, assigning privileges, 2
privileges
assigning, 2
CATALOG, 2
CREATE TYPE, 3
REGISTER, 2
revoking, 3
SYSDBA, 2
processing time for backup, 2
proxy backups, restoring, 3
proxy copies
available information, 2
crosschecking, 2
definition, 2
deleting, 2, 2
obsolete
report output, 3
restoring, 3
tag names, 2
PROXY parameter
BACKUP command, 2
recordSpec subclause, 4

Q

QUIT command, 2
quoted strings, 1.2.2, 1.2.2

R

RAC
automatic channels (example), 2
creating online redo logs, 2
crosschecking backups, 2
crosschecking or deleting, 2
spreading work, 4
SYSDBA passwords, 2
RATE parameter, allocOperandList subclause, 4
RC_ARCHIVED_LOG view, 5.1
RC_BACKUP_ARCHIVELOG_DETAILS view, 5.1
RC_BACKUP_ARCHIVELOG_SUMMARY view, 5.1
RC_BACKUP_CONTROLFILE view, 5.1
RC_BACKUP_CONTROLFILE_DETAILS view, 5.1
RC_BACKUP_CONTROLFILE_SUMMARY view, 5.1
RC_BACKUP_COPY_DETAILS view, 5.1
RC_BACKUP_COPY_SUMMARY view, 5.1
RC_BACKUP_CORRUPTION view, 5.1, 5.1
RC_BACKUP_DATAFILE view, 5.1, 5.1
RC_BACKUP_DATAFILE_DETAILS view, 5.1
RC_BACKUP_DATAFILE_SUMMARY view, 5.1
RC_BACKUP_FILES view, 5.1
RC_BACKUP_PIECE view, 5.1
RC_BACKUP_PIECE_DETAILS, 5.1
RC_BACKUP_REDOLOG view, 5.1
RC_BACKUP_SET view, 5.1
RC_BACKUP_SET_DETAILS view, 5.1
RC_BACKUP_SET_SUMMARY view, 5.1
RC_BACKUP_SPFILE view, 5.1
RC_BACKUP_SPFILE_DETAILS view, 5.1
RC_BACKUP_SPFILE_SUMMARY view, 5.1
RC_CHECKPOINT view
See RC_RESYNC view
RC_CONTROLFILE_COPY view, 5.1
RC_COPY_CORRUPTION view, 5.1
RC_DATABASE view, 3, 5.1
RC_DATABASE_BLOCK_CORRUPTION view, 5.1
RC_DATABASE_INCARNATION view, 3, 5.1
RC_DATAFILE view, 5.1
RC_DATAFILE_COPY view, 5.1
RC_LOG_HISTORY view, 5.1
RC_OFFLINE_RANGE view, 5.1
RC_PROXY_ARCHIVEDLOG view, 5.1
RC_PROXY_ARCHIVELOG_DETAILS view, 5.1
RC_PROXY_CONTROLFILE view, 5.1
RC_PROXY_COPY_DETAILS view, 5.1
RC_PROXY_COPY_SUMMARY view, 5.1
RC_PROXY_DATAFILE view, 5.1
RC_REDO_LOG view, 5.1
RC_REDO_THREAD view, 5.1
RC_RESTORE_POINT view, 5.1
RC_RESYNC view, 5.1
RC_RMAN_BACKUP_JOB_DETAILS view, 5.1
RC_RMAN_BACKUP_SUBJOB_DETAILS view, 5.1
RC_RMAN_BACKUP_TYPE view, 5.1
RC_RMAN_CONFIGURATION view, 5.1
RC_RMAN_OUTPUT view, 5.1
RC_RMAN_STATUS view, 5.1
RC_SITE view, 5.1
RC_STORED_SCRIPT view, 5.1
RC_STORED_SCRIPT_LINE view, 5.1
RC_TABLESPACE view, 5.1
RC_TEMPFILE view, 5.1
RC_UNUSABLE_BACKUPFILE_DETAILS view, 5.1
READONLY parameter
CONVERT command, 2
RECOVER command, 3
VALIDATE command, 3
Real Application Clusters
See RAC
recordSpec subclause, 4
recover clause
parameter descriptions, 3
syntax diagram, 3
RECOVER command, 3
blockObject subclause, 3, 3
dbObject subclause, 3, 3
recover clause, 3, 3
recoverObject subclause, 3, 3
recoverOptionList subclause, 3, 3
recoverSpec subclause, 3, 3
sizeSpec subclause, 3
RECOVER OF COPY parameter, BACKUP command, 2
RECOVER OF TAG parameter, BACKUP command, 2
RECOVERABLE parameter, LIST command, 2
recoverableClause subclause
parameter descriptions, 2
syntax diagram, 2
recoverObject subclause
parameter descriptions, 3
syntax diagram, 3
recoverOptionList subclause
parameter descriptions, 3
syntax diagram, 3
recoverSpec subclause
parameter descriptions, 3
syntax diagram, 3
recovery
allowing corrupt blocks, 3
database in NOARCHIVELOG mode (example), 3
incremental, 3
point-in-time of duplicate databases, 2
search order for backups, 3
RECOVERY AREA parameter
BACKUP command, 2
CATALOG command, 2
RESTORE command, 3
VALIDATE command, 3
recovery catalog
connecting to, 4
DB_UNIQUE_NAME, 3
granting access, 2
registering databases, 3
removing databases, 3
removing references, 2
removing repository records, 2
replacing scripts, 3
updating DB_UNIQUE_NAME, 2
upgrading versions, 3
recovery catalog databases, connecting to, 2
recovery catalog views, 5
RC_DATABASE, 3
RC_DATABASE_INCARNATION, 3
summary list, 5.1
See also specific view names
recovery catalogs
creating, 2
creating stored scripts, 2
deleting, 2
removing references, 2
resynchronization, 3
revoking privileges, 3, 3
running RMAN without, 3
stored scripts, available information, 2
unregistering, 2
recovery catalogs, moving metadata, 2
recovery catalogs.NOCATALOG mode, 2
RECOVERY FILES parameter
BACKUP command, 2
VALIDATE command, 3
recovery files, backing up, 2
Recovery Manager
compatibility, B.1
dates in commands, 4
Recovery Manager client, opening, 3
Recovery Manager, control file autobackups, 2
RECOVERY WINDOW OF parameter, obsOperandList subclause, 4
RECOVERY WINDOW parameter
CONFIGURE command, 2
REPORT command, 3
recovery windows
report output, 3
recovery windows, report output, 3
RECOVERY_CATALOG_OWNER role, 2, 2, 2, 3
RECOVERY_PARALLELISM initialization parameter, 3
redo logs
archiving, 2
backing up, 2
for duplicate databases, 2
for RAC, 2
omitting from recovery, 3
sequence numbers, 2
redo threads, 4
REDUNDANCY parameter
CONFIGURE command, 2
REPORT command, 3
REDUNDANCY parameter, obsOperandList subclause, 4
redundant backups, 3
REGISTER DATABASE command, 3
REGISTER DATABASE parameter
GRANT command, 2
REVOKE command, 3
REGISTER privilege, 2
RELEASE CHANNEL command, 3
release clause, 3
releaseForMaint clause, 3
release clause, syntax diagram, 3
releaseForMaint clause
syntax diagram, 3
repair clause
parameter description, 3
syntax diagram, 3
REPAIR FAILURE command, 3
repair clause, 3, 3
repair options, 2, 2
repair status, 2
repair strategies, 2
REPLACE SCRIPT command, 3
replaceScript clause, 3
replaceScript clause
syntax diagram, 3
report clause
parameter descriptions, 3
syntax diagram, 3
REPORT command, 3
atClause subclause, 3, 3
needBackupOption subclause, 3, 3
report clause, 3, 3
reportObject subclause, 3, 3
reportObject subclause
parameter descriptions, 3
syntax diagram, 3
repositories
analyzing, 3
listing contents, 2
updating, 2
updating availability status, 2
updating filenames, 3
validating contents, 2
reserved words, 1.4
reset clause, syntax diagram, 3
RESET DATABASE command, 3
reset clause, 3
RESET DB_UNIQUE_NAME parameter, CHANGE command, 2
resetDbUniqueNameOption subclause
parameter descriptions, 2
syntax diagram, 2
RESETLOGS parameter, FLASHBACK DATABASE command, 2
restoration configuration, 2
restore clause
parameter descriptions, 3
syntax diagram, 3
RESTORE command, 3
autoBackupOptList subclause, 3, 3
restore clause, 3, 3
restoreObject subclause, 3, 3
restoreSpecOperand subclause, 3
restore commands, 3
restore failover, 3
RESTORE POINT parameter
DUPLICATE command, 2
FLASHBACK DATABASE command, 2
LIST command, 2
RECOVER command, 3
RESTORE command, 3
SET command, 3
TRANSPORT TABLESPACE command, 3
restore points, 2, 2
restoreCommands subclause, syntax diagram, 3
restoreObject subclause
parameter descriptions, 3
syntax diagram, 3
restoreSpecOperand subclause, syntax diagram, 3
RESTRICTED SESSION privilege, 3
RESYNC CATALOG command, 3
RESYNC CATALOG, resync clause, 3
resync clause, syntax diagram, 3
resynchronization, 3
retention policies, 4
exemptions (example), 2
overriding, 2, 2
window-based, 3
RETENTION POLICY parameter
CONFIGURE command, 2
SHOW command, 3
REUSE parameter, BACKUP command, 2
reverse resynchronization, 3
revoke clause, syntax diagram, 3
REVOKE command, 3
revoke clause, 3
RMAN command, 3
cmdLine clause, 3, 3
RMAN command (operating system), 3
RMAN commands
See specific command names
executing from files, 3
RMAN-0558 error message, 3
RMAN-06004 error message, 2, 2, 2
RMAN-06445 error message, 2, 2
RMAN-06496 error message, 3, 3
RMAN-06710 error message, 2
RMAN-10031 error message, 2
RMAN-10035 error message, 2
RMAN-20401 error message, 2
RMAN-6758 error message, 3
roles
RECOVER_CATALOG_OWNER, 2
RECOVERY_CATALOG_OWNER, 2, 3
rollback segments, resynchronization, 3
run clause, syntax diagram, 3
RUN command, 3
backupCommands subclause, 3
maintenanceCommands subclause, 3
restoreCommands subclause, 3
run clause, 3

S

saving scripts, 2
sbt channels, specifying parameters, 4
SCHEMA parameter, REPORT command, 3
SCN
for restore, 3
setting restore point, 3
See also system change numbers
SCN BETWEEN parameter, archlogRange subclause, 4
SCN parameter
FLASHBACK DATABASE command, 2
REPORT command, 3
scopes, creating for scripts, 3
SCRIPT NAMES parameter, LIST command, 2
SCRIPT parameter
DELETE SCRIPT command, 2
EXECUTE SCRIPT command, 2
REPLACE SCRIPT command, 3
RMAN command, 3
scripts
available information, 2
creating from files, 2
creating in recovery catalog, 2
listing names, 2
printing, 2
replacing, 3
See command files
substitution variables, 2
SECTION SIZE parameter
BACKUP command, 2
VALIDATE command, 3
Secure Backup, 2
SEND command, 3
SEND parameter
RMAN command, 3
SEND parameter, allocOperandList subclause, 4
SEQUENCE BETWEEN parameter, archlogRange subclause, 4
SEQUENCE parameter
FLASHBACK DATABASE command, 2, 2
REPORT command, 3
SEQUENCE parameter, archivelogRecordSpecifier subclause, 4
server parameter files
backing up, 2, 2
for auxiliary databases, 2
restoring, 3, 3
restoring lost, 3
validating, 3
validation report, 3
sessions
ending RMAN, 2
identifying channels, 3
set clause, syntax diagram, 3
SET command, 3
encryption settings, 2
set clause, 3
setRmanOption subclause, 3, 3
setRmanOrRunOption subclause, 3, 3
setRunOption subclause, 3, 3
SET MAXCORRUPT command, 2
SET NEWNAME command, 3
SET parameter, DUPLICATE command, 2
setParameter subclause
parameter descriptions, 2
syntax diagram, 2
setRmanOption subclause
parameter descriptions, 3
syntax diagram, 3
setRmanOrRunOption subclause
parameter descriptions, 3
syntax diagram, 3
setRunOption subclause
parameter descriptions, 3
syntax diagram, 3
shared servers, allocating channels, 2
shell commands, 2
show clause, syntax diagram, 3
SHOW command, 3
show clause, 3
SHUTDOWN command, 3
shutdowns, 2
single quotes, 1.2.3
SITE_KEY column null values, 2
sizeSpec subclause
parameter descriptions, 2, 4
syntax diagram, 2, 2, 2, 3, 3, 4
SKIP keyword, CONVERT command, 2
SKIP parameter
BACKUP command, 2
RECOVER command, 3
RESTORE command, 3
VALIDATE command, 3
SKIP READONLY parameter
DUPLICATE command, 2
RECOVER command, 3
RESTORE command, 3
SKIP TABLESPACE parameter, DUPLICATE command, 2
SKIP TABLESPACE parameter, listObjList subclause, 4
skipSpec subclause
parameter descriptions, 2, 2, 3
syntax diagram, 2, 2, 3
SNAPSHOT CONTROLFILE NAME parameter, CONFIGURE command, 2
SNAPSHOT CONTROLFILE parameter, SHOW command, 3
snapshots
control file, 2
Volume Shadow Copy Service (VSS), 2
source databases
copying, 2
used for duplication, 2
SPFILE parameter
BACKUP command, 2
DUPLICATE command, 2
RESTORE command, 3
VALIDATE command, 3
listObjList subclause, 4
SPFILE SET, overriding, 2
SPOOL command, 3
SQL command, 3
standard output
printing scripts, 2
redirecting to files, 3
STANDBY CONTROLFILE parameter, RESTORE command, 3
standby databases
backing up, 2
copying, 2
fast recovery areas, 2
password files, 2
updating (example), 2
STANDBY parameter, DUPLICATE command, 2
STARTUP command, 3
stdout, redirecting, 3
stored scripts
available information, 2
deleting, 2
executing, 2, 3
printing, 2
See also scripts
strings
valid characters in RMAN commands, 1.2.2
striped files, allocating channels, 2
striping backup sets, 2
subclause summary, 1.6
subclauses
See specific subclause name
substitution variables, 2
complete list, 4
example of %D, 2
example of %F, 2
example of %U, 2
in scripts, 2, 2, 3
passing to stored scripts, 2
providing values, 3
SUMMARY parameter, LIST command, 2
switch clause
parameter descriptions, 3
syntax diagram, 3
SWITCH command, 3
effect on RESTORE, 3
switch clause, 3, 3
switchFile subclause, 3, 3
switchFile subclause
parameter descriptions, 3
syntax diagram, 3
syntax conventions, 1.2
syntax diagrams
keywords, 1.2.1
parameters, 1.2.2
placeholders, 1.2.2
syntax errors, checking for, 3
syntax, deprecated, A
SYSAUX tablespaces, 3
SYSDBA passwords
for active duplication, 2
RAC environment, 2
SYSDBA privilege, 2, 4
system change numbers
See also SCN
system change numbers (SCN), 2, 2, 2

T

TABLESPACE DBA parameter, RECOVER command, 3
TABLESPACE DESTINATION parameter, TRANSPORT TABLESPACE command, 3
TABLESPACE parameter
BACKUP command, 2
CONVERT command, 2
DUPLICATE command, 2, 2
RECOVER command, 3, 3
REPORT command, 3
RESTORE command, 3
SWITCH command, 3
VALIDATE command, 3
tablespace point-in-time recovery (TSPITR), 3, 3
tablespace recovery (example), 3
tablespaces
backing up, 2
converting platform format, 2
duplicating, 2
encryption settings, 3
excluding from database backup, 2
excluding from duplicate database, 2
including in duplicate database, 2, 2
listing datafiles, 3
point-in-time lists, 3
recovering individual, 3
recovering undo segments, 3
renamed, 2
show excluded, 3
transparent encryption, 2
updating filenames, 3
validating individual, 3
See also transportable tablespaces
TAG parameter
BACKUP command, 2
RECOVER command, 3, 3, 3
RESTORE command, 3
RESTORE commands, 3
maintQualifier subclause, 4
tape backups, allocating channels, 2
tape device type setting, 2
target control files, 2
TARGET DATABASE parameter, DUPLICATE command, 2
target databases
connecting to, 2, 4
deleting, 2
maintaining single metadata catalog, 2
registering, 3
starting from RMAN, 3
TARGET parameter
CONNECT command, 2
RMAN command, 3
target times, undoing changes, 2
tee command (Linux), 3
TEMPFILE parameter, SWITCH command, 3
tempfiles
re-creating, 2, 2
renaming, 3
tempfileSpec subclause, 4
temporary tablespaces, 2
TEST parameter, RECOVER command, 3
THREAD parameter
FLASHBACK DATABASE command, 2
REPORT command, 3
THREAD parameter, archlogRange subclause, 4
TIME BETWEEN parameter, archlogRange clause, 4
time constraints
partial backups, 2
recovery period, 2
time limits, 4
TIME parameter
FLASHBACK DATABASE command, 2, 2
REPORT command, 3
time ranges, 4
time, backup completion, 4
time-based backups, 2
TIMEOUT parameter, RMAN command, 3
TO BEFORE RESETLOGS parameter, FLASHBACK DATABASE command, 2
TO BEFORE SCN parameter, FLASHBACK DATABASE command, 2
TO BEFORE SEQUENCE parameter, FLASHBACK DATABASE command, 2
TO BEFORE TIME parameter, FLASHBACK DATABASE command, 2
TO FILE parameter, PRINT SCRIPT command, 2
TO parameter, SPOOL command, 3
TO RESTORE POINT parameter
DUPLICATE command, 2
FLASHBACK DATABASE command, 2
RECOVER command, 3
RESTORE command, 3
SET command, 3
TRANSPORT TABLESPACE command, 3
TO SEQUENCE parameter, FLASHBACK DATABASE command, 2
TO TIME parameter, FLASHBACK DATABASE command, 2
TRANSACTIONAL parameter
SHUTDOWN command, 3
transferring backups, 2
transparent encryption, 2, 2
TRANSPORT SCRIPT parameter, CONVERT command, 2
TRANSPORT TABLESPACE command, 3
transpt_tbs clause, 3, 3
transpt_tbs_optlist subclause, 3, 3
transportable tablespaces
backing up read-only, 2
creating from backups, 3
duplicating, 2
transportOptionList subclause
parameter descriptions, 2
syntax diagram, 2
transpt_tbs clause
parameter descriptions, 3
syntax diagram, 3
transpt_tbs_optlist subclause
parameter descriptions, 3
syntax diagram, 3
trial recovery, 3

U

UNAVAILABLE parameter, CHANGE command, 2
UNAVAILABLE status, DELETE command, 2
UNCATALOG parameter, CHANGE command, 2
undo data, 2
undo segments, 2
UNDO TABLESPACE parameter, RECOVER command, 3
UNIX commands, 2
unrecoverable operations
report output, 3
UNRECOVERABLE parameter, REPORT command, 3
UNREGISTER DATABASE command, 3
UNTIL SCN parameter
archlogRange subclause, 4
untilClause subclause, 4
UNTIL SEQUENCE parameter
archlogRange subclause, 4
untilClause subclause, 4
UNTIL TIME parameter
archlogRange subclause, 4
untilClause subclause, 4
untilClause subclause, 4
unused block compression, 2, 2
UPGRADE CATALOG command, 3
USE_DB_RECOVERY_FILE_DEST parameter, 3
user names, 4
user privileges, 2
user roles, 2
user-managed backups, 2
USING ADVISE OPTION parameter, REPAIR FAILURE command, 3
USING parameter, RMAN command, 3
UTF character set, CLOB storage, 2
utlirp script, converting PL/SQL code, 2

V

V$ARCHIVED_LOG view, 2, 4, 4
V$BACKUP_DEVICE view, 2, 2
V$BACKUP_PIECE view, 2, 2, 2
V$BACKUP_SET view, 2, 2, 2, 2, 2
V$DATABASE view, 3
V$DATABASE_BLOCK_CORRUPTION view, 2, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3
V$DATABASE_INCARNATION view, 3
V$DATABASE.CURRENT_SCN view, 2
V$DATABASE.FLASHBACK_ON view, 2
V$DATAFILE view, 4, 4
V$DATAFILE_COPY view, 2, 2, 4
V$DATAFILE_HEADER view, 4
V$FLASHBACK_DATABASE_LOG view, 2
V$PROXY_DATAFILE view, 2
V$RMAN_COMPRESSION_ALGORITHM view, 2, 3
V$RMAN_ENCRYPTION_ALGORITHMS view, 2, 2, 3, 3
V$RMAN_OUTPUT view, 2, 3
V$RMAN_STATUS view, 3
V$SESSION view, 3, 3
V$TABLESPACE view, 2
V$TRANSPORTABLE_PLATFORM view, 2
validate clause
parameter descriptions, 3
syntax diagram, 3
VALIDATE command, 3
blockObject subclause, 3
copyOfSpec subclause, 3
sizeSpec subclause, 3
skipSpec subclause, 3, 3
validate clause, 3, 3
validateObject subclause, 3, 3
validateOperand subclause, 3, 3
VALIDATE HEADER parameter, RECOVER command, 3
VALIDATE parameter
BACKUP command, 2
RESTORE command, 3
validateObject subclause
parameter descriptions, 3
syntax diagram, 3
validateOperand subclause
parameter descriptions, 3
syntax diagram, 3
validating backups, 3
variables in command files, 2
views, recovery catalog, 5
VIRTUAL parameter, CREATE CATALOG command, 2
virtual private catalog schema, assigning privileges, 2
virtual private catalogs
access to global scripts, 2
creating, 2
deleting, 2
virtual recovery catalog
See virtual private catalog
Volume Shadow Copy Service (VSS) snapshots, 2

W

wallet-based encryption, 2
wallets, 2, 3
windows, 4
recovery, 2, 2
Windows commands, 2
WITH TAG parameter
RECOVER command, 3

X

XMLType datatype in transportable tablespaces, 3