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

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

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

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

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

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

Securing backups, C.1.10

storing configuration in RMAN repository, C.1.8

Troubleshooting, C.1.12

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

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

S

saving scripts, 2

sbt channels, specifying parameters, 4

SCHEMA parameter, REPORT command, 3

SCN

for restore, 3

setting restore point, 3

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

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

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