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

? symbol in quoted strings, 1.2.2

@ command, 2

@ parameter, RMAN command, 3

@ symbol in quoted strings, 1.2.2

@@ command, 2

%U format, 4

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

recordSpec subclause, 4

VALIDATE command, 3

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 file name 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 data files, 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

data files, 2, 2

data files 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

recordSpec subclause, 4

RECOVER command, 3

RESTORE command, 3

VALIDATE command, 3

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

file names for control file autobackup, 3

including in database backup, 2

limiting search, 3

re-creating, 3

restoring, 3, 3, 3

restoring autobackups, 3

restoring (example), 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

recordSpec subclause, 4

RESYNC CATALOG command, 3

VALIDATE command, 3

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 file backup sets, available information, 2

data file backups

available information, 2

expired, 2

data file 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

data files

auxiliary file names, 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 file names, 3

validating, 3, 3

validation report, 3

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 file names, 3

validating, 3

DATAFILE BACKUP COPIES parameter

CONFIGURE command, 2

SHOW command, 3

DATAFILE BLOCK parameter

RECOVER command, 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

recordSpec subclause, 4

RECOVER command, 3, 3

RESTORE command, 3

datafileCopySpec subclause

parameter descriptions, 2

syntax diagram, 2

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 data files, 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

maintSpec subclause, 4

RECOVER command, 3

REPORT command, 3

RESTORE command, 3

SEND command, 3

SHOW command, 3

VALIDATE command, 3

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 name formats, 3

file names

changing during platform conversion, 2

data file image copies, 2

generating new, 4

setting auxiliary, 2

updating, 3

FILE parameter

CREATE SCRIPT command, 2

LIST command, 2

PRINT SCRIPT command, 2

REPLACE SCRIPT command, 3

file recovery, 3

file sections, sizing, 2

fileNameConversionSpec subclause, 4

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 data file copies, 2

bitmap limit, 2

report output, 3

sample script, 2

using data file 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.2.8

creating an AWS account, C.2.3

environment variables

ENV parameter of PARMS option, C.2.8

SBT_PARMS parameter, C.2.8

getting AWS Identifiers, C.2.4

prerequisites, C.2.1

registering for OTN account, C.2.2

running the S3 Backup installer

first time, C.2.5

Linux example, C.2.6

Securing backups, C.3

storing configuration in RMAN repository, C.2.7

Troubleshooting, C.5

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

specifying path, 3

See also initialization parameter files, server parameter files,

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

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

GRANT command, 2

REVOKE command, 3

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 file names, 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

executing from files, 3

See specific command names

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

substitution variables, 2

See command files

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

listObjList subclause, 4

RESTORE command, 3

VALIDATE command, 3

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 data files, 3

point-in-time lists, 3

recovering individual, 3

recovering undo segments, 3

renamed, 2

show excluded, 3

transparent encryption, 2

updating file names, 3

validating individual, 3

See also transportable tablespaces

TAG parameter

BACKUP command, 2

maintQualifier subclause, 4

RECOVER command, 3, 3, 3

RESTORE command, 3

RESTORE commands, 3

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

temp files

re-creating, 2, 2

renaming, 3

TEMPFILE parameter, SWITCH command, 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

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