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 Z

Symbols

%U format, 3

? symbol in quoted strings, 1.2.2

@ command, 2

@ parameter, RMAN command, 2

@ symbol in quoted strings, 1.2.2

@@ command, 2

A

ABORT parameter, SHUTDOWN command, 2

ACTIVE DATABASE parameter, DUPLICATE command, 2, 2

Advanced Compression, 2

Advanced Security option, 2

ADVISE FAILURE command, 2

ADVISE OPTION parameter, REPAIR FAILURE command, 2

AFTER parameter, completedTimeSpec subclause, 3

AL16UTF16 character set, CLOB storage, 2

ALGORITHM parameter, SET command, 2

ALL parameter

BACKUP command, 2

SHOW command, 2

ALL parameter, archivelogRecordSpecifier subclause, 3

ALL PRIVILEGES parameter, REVOKE command, 2

ALL SCRIPT NAMES parameter, LIST command, 2

ALLOCATE CHANNEL command, 2

allocOperandList subclause, 3

ALLOCATE CHANNEL FOR MAINTENANCE command, 2

shared server, 2

allocOperandList subclause

parameter descriptions, 3

syntax diagram, 3

ALLOW CORRUPTION parameter, RECOVER command, 2

ALTER DATABASE BACKUP command (SQL), 2

ALTER DATABASE command, 2

analyzing RMAN repositories, 2

APPEND parameter, RMAN command, 2

archived log backups, 2

archived log copies, 2

archived log failover, 2

archived logs

in backup sets, 2

validation report, 2

archived redo files, optimization algorithms, 2

archived redo logs, 3

adding to repository, 2

backing up, 2, 2, 3

backing up n times, 2

cataloging in RMAN repository, 2

days for recovery, 2

deleting, 2, 2, 2, 2

deletion policies, 2

displaying information, 2

excluding from backup, 2, 2

excluding from validation, 2

foreign (LogMiner), 3

image copies, 2

limiting number of backups, 2

missing or inaccessible, 2

number of backups, 2

obsolete, 2

previewing, 2

recovering, 2

report output, 2

restoring, 2

restoring a range, 2

setting the destination, 2

specifying a range, 3

using for recovery (example), 2

validating, 2, 2

ARCHIVELOG BACKUP COPIES parameter

CONFIGURE command, 2

SHOW command, 2

ARCHIVELOG DELETION POLICY parameter

CONFIGURE command, 2

SHOW command, 2

ARCHIVELOG DESTINATION parameter, SET command, 2

ARCHIVELOG mode, 2, 2, 2

ARCHIVELOG parameter

CATALOG command, 2

VALIDATE command, 2

recordSpec subclause, 3

ARCHIVELOG TAG parameter, RECOVER command, 2

archivelogRecordSpecifier subclause, 3, 3

parameter descriptions, 3

syntax diagram, 3

archiving redo logs, 2, 2

archlogRange subclause

parameter descriptions, 3

syntax diagram, 3, 3

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, 2

AT SEQUENCE parameter, REPORT command, 2

at sign command (@), 2

at sign parameter, RMAN command, 2

AT TIME parameter, REPORT command, 2

atClause subclause

parameter descriptions, 2

syntax diagram, 2

AUTOBACKUP parameter, RESTORE command, 2

autoBackupOptList subclause

parameter descriptions, 2

syntax diagram, 2

autobackups, control file, 2

Automated Diagnostic Repository, logging failures, 2

automated repair, 2

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, 2

duplicating databases, 2

specifying disk groups, 2

AUXILIARY CHANNEL parameter

CONFIGURE command, 2

SHOW command, 2

auxiliary databases

connecting to, 2, 3

initialization files, 2

AUXILIARY DESTINATION parameter

RECOVER command, 2

TRANSPORT TABLESPACE command, 2

auxiliary filename settings, 2

AUXILIARY FORMAT parameter

allocOperandList subclause, 3

BACKUP command, 2

AUXILIARY INSTANCE PARAMETER FILE TO parameter, SET command, 2

auxiliary instances, specifying channels, 2

AUXILIARY parameter

ALLOCATE CHANNEL command, 2

CONNECT command, 2

RMAN command, 2

AUXNAME parameter

CONFIGURE command, 2

SHOW command, 2

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

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

forRecoveryOfSpec subclause, 2, 2

limiting processing time, 2

notBackedUpSpec subclause, 2, 2

sizeSpec subclause, 2, 2

skipSpec subclause, 2, 2

backup commands, 2

BACKUP COPIES parameter

SET command, 2

SHOW command, 2

backup levels, 2

backup media, 2

BACKUP OPTIMIZATION parameter

SHOW command, 2

BACKUP OPTIMIZATION parameter, CONFIGURE command, 2

BACKUP parameter

LIST command, 2

maintSpec subclause, 3

backup pieces

adding to repository, 2, 2

available information, 2, 2

crosschecking or deleting, 2

definition, 2

displaying information, 2

format, 3, 3

maximum size, 3

obsolete, 2

overriding default copies, 2

restoring, 2

validating, 2

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, 2

information about copies, 2

information about datafiles, 2

maximum size, 2

maximum size per channel, 2

obsolete

report output, 2

optimization algorithms, 2

recovering, 2

restoring only from, 2

retention policies, 2

status, 2

summary information, 2

tag names, 2

unused block compression, 2, 2

validating, 2, 2

BACKUP_TAPE_IO_SLAVES initialization parameter, 2, 2

backupCommands subclause, syntax diagram, 2

backupConf subclause

parameter descriptions, 2

syntax diagram, 2

backupOperand subclause

parameter descriptions, 2

syntax diagram, 2

BACKUPPIECE parameter

CATALOG command, 2

recordSpec subclause, 3

backups

applying incremental, 2

binary compression, 2, 2

changing availability, 2, 2

configuration, 2

corruption tolerance (example), 2

creating multiple copies, 2

creating transportable tablespaces, 2

criteria for obsolescence, 3

cumulative, 2

datafiles, 2, 2

datafiles requiring new, 2

deleting, 2

deleting obsolete, 2

duplexing example, 2

duplicate copies, 2

duplicating, 2

failures, 2

inconsistent, 2

incremental, 2, 2, 2

limiting duration, 2

listing, 2, 2

minimum required, 2

multisection, 2

obsolete, 2

overriding defaults in restore, 2

overwriting, 2

partial, 2

previewing, 2

redundant, 2

removing from recovery catalog, 2

restarting, 2

retaining multiple full (level 0), 2

retention policies, 2

summary list, 2

using incremental (example), 2

using incremental updates (example), 2

validating files, 2

validating in repository, 2

BACKUPS parameter, UNREGISTER command, 2

BACKUPSET parameter

BACKUP command, 2, 2

RECOVER command, 2

RESTORE command, 2

VALIDATE command, 2

recordSpec subclause, 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, 3

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

BFILE datatype, 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, 2

flashback, 2

block media recovery, 2

block sizes of backup media, 2

blockObject subclause

parameter descriptions, 2

syntax diagram, 2, 2

blocks

corrupt, 2

creating, 2

C

CATALOG command, 2

CATALOG FOR DATABASE parameter

GRANT command, 2

REVOKE command, 2

CATALOG parameter

CONNECT command, 2

RMAN command, 2

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

recordSpec subclause, 3

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, 2, 2

SEND command, 2

SHOW command, 2

SQL command, 2

channel parameters, 2

channels

allocating for duplication, 2

allocating for restore, 2

allocating for validation, 2

allocating manually, 2, 2

allocating to shared server sessions, 2

configuring for RAC (example), 2

configuring type for recovery, 2

device type default, 2

identifying database server sessions, 2

maximum number, 2

naming conventions, 2

releasing, 2

restoring in Data Guard, 2

setting for restore (example), 2

with proxy capabilities, 2

character sets, CLOB storage, 2

CHECK LOGICAL parameter

BACKUP command, 2, 2

RECOVER command, 2

RESTORE command, 2

VALIDATE command, 2

checksums, 2

CHECKSYNTAX parameter, RMAN command, 2

client compatibility, B.1

client, opening RMAN, 2

CLOB datatype, transporting, 2

closing RMAN, 2, 2

CMDFILE parameter, RMAN command, 2

cmdLine clause

parameter descriptions, 2

syntax diagram, 2

cmdLine command

See RMAN command

command entry description, 1.1

command files, 2, 2, 2

command format, 1.3

COMMAND ID TO parameter

SET command, 2

command line arguments, 2

command subclause summary, 1.6

command subclauses

See specific subclause name

command summary, 1.5

command terminator, 1.3

commands

creating blocks, 2

deprecated, A, A

executing host, 2

executing SQL, 2

RMAN, 2

sending to media manager, 2

sending to media managers, 2

See specific command name

comment character (#), 1.3

COMMENT parameter

CREATE SCRIPT command, 2

DUPLICATE command, 2

REPLACE SCRIPT command, 2

compatibility, B.1

COMPATIBLE initialization parameter, 2

completedTimeSpec subclause, 3

compression, 2

COMPRESSION ALGORITHM parameter

CONFIGURE command, 2

SHOW command, 2

compression algorithms, 2

configuration

displaying, 2

displaying settings, 2

overriding, 2, 2

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, 2

CONFIGURE CONTROLFILE AUTOBACKUP parameter, 2

CONNECT command, 2

CONNECT IDENTIFIER parameter, CONFIGURE command, 2

CONNECT parameter, allocOperandList subclause, 3

connect strings, 3

to auxiliary database, 2

to recovery catalog database, 2

to target database, 2

connections, changing, 2

connectStringSpec subclause, 3

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, 2

automatic backups, 2

backing up copies, 2

copies

cataloging in RMAN repository, 2

validating, 2

filenames for control file autobackup, 2

including in database backup, 2

limiting search, 2

re-creating, 2

restoring, 2, 2, 2

restoring (example), 2

restoring autobackups, 2

restoring for primary database, 2

resynchronization, 2

snapshots, 2, 2

validating, 2

validation report, 2

CONTROL_FILES initialization parameter, 2

CONTROLFILE AUTOBACKUP FORMAT parameter, SET command, 2

CONTROLFILE AUTOBACKUP parameter

CONFIGURE command, 2

SHOW command, 2

CONTROLFILE parameter

RESTORE command, 2, 2

VALIDATE command, 2, 2

CONTROLFILE parameter, listObjList subclause, 3

CONTROLFILECOPY parameter

BACKUP command, 2

CATALOG command, 2

RESYNC CATALOG command, 2

VALIDATE command, 2

recordSpec subclause, 3

convert clause

parameter descriptions, 2

syntax diagram, 2

CONVERT command, 2

convert clause, 2, 2

convertOptionList subclause, 2, 2

fileNameConversionSpec parameter, 3

skipSpec subclause, 2, 2

transportOptionList subclause, 2, 2

CONVERT command, formatSpec subclause, 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, 2

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, 2

COPY parameter

BACKUP command, 2

LIST command, 2

maintSpec subclause, 3

copying files, 2

copyOfSpec subclause

parameter descriptions, 2

syntax diagram, 2, 2

corrupt blocks

checking for, 2

restoring, 2

tolerance for, 2

tolerance for (example), 2

CORRUPTION LIST parameter, RECOVER command, 2

CORRUPTION parameter

RECOVER command, 2

CPU_COUNT initialization parameter, 2

CREATE CATALOG command, 2

CREATE SCRIPT command, 2

CREATE TYPE privilege, 2

CROSSCHECK command, 2

maintSpec subclause, 2, 3

recordSpec subclause, 3

cross-platform compatibility, 2

cumulative backups, 2

CUMULATIVE parameter

BACKUP command, 2

CURRENT CONTROLFILE parameter

BACKUP command, 2

VALIDATE command, 2, 2

D

data block address (DBA), 2

data blocks

checking for corrupted, 2

recovering corrupt, 2

recovering individual, 2

recovering logically corrupt, 2

recovering physically corrupt, 2

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, 2

RMAN configuration in recovery catalog, 2

specifying databases, 3

updating backup status, 2

Data Guard backups

accessibility by databases, 2

changing associated database, 2

database association, 2

Data Pump, 2, 2, 2, B.4

Data Recovery Advisor, 2, 2

database changes, reversing, 2

database configuration

See configuration

database duplication

See duplication

database failure, repairing, 2

database identifiers

changing, 2

duplicates, 2

database incarnations, 2

DATABASE parameter

BACKUP command, 2

RECOVER clause, 2

REPORT command, 2

RESTORE command, 2

SWITCH command, 2

UNREGISTER command, 2

VALIDATE command, 2

database point-in-time recovery (DBPITR), 2

database registration, 2

database schemas

report output, 2

database server sessions

identifying channels, 2

DATABASE SKIP TABLESPACE parameter, listObjList subclause, 3

databases, 2

available information, 2

backing up, 2

changing connections, 2

connecting to, 2

converting platform format, 2

copying, 2

deleting, 2

encryption settings, 2

mounting, 2

opening, 2

platform conversion scripts, 2

recovering, 2, 2

recovering with incremental backups (example), 2

recovering with incremental updates, 2

registering, 2, 2

removing from recovery catalog, 2

resetting incarnation, 2

resynchronization, 2

revoking registration privileges, 2

shutting down target, 2

specifying in Data Guard environment, 3

standby, restoring control files, 2

starting target from RMAN, 2

transparent encryption, 2

transporting re-created files, 2

updating filenames, 2

validating, 2

DATAFILE BACKUP COPIES parameter

CONFIGURE command, 2

SHOW command, 2

datafile backup sets, available information, 2

datafile backups

available information, 2

expired, 2

DATAFILE BLOCK parameter

RECOVER command, 2

datafile copies

available information, 2

deleting, 2

displaying information, 2

listing, 2

obsolete, 2

report output, 2

restoring only from, 2

tag names, 2

validating, 2

DATAFILE parameter

BACKUP command, 2

CONVERT command, 2

RECOVER command, 2

REPORT command, 2

RESTORE command, 2

SWITCH command, 2, 2

VALIDATE command, 2

DATAFILECOPY parameter

CATALOG command, 2

RECOVER command, 2, 2

RESTORE command, 2

recordSpec subclause, 3

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, 2

days of archived redo logs, 2

excluding from backup, 2, 2

excluding from conversion, 2

excluding from validation, 2

flashback status changes, 2

forcing restore, 2

image copies, 2

in backup sets

available information, 2

listing within a tablespace, 2

minimum number of backups, 2

offline, 2

optimization algorithms, 2

point-in-time lists, 2

readonly, 2

read-only, omitting from restore, 2

recovering, 2, 2

recovering corrupt data blocks, 2

renaming, 2

report output, 2, 2, 2, 2, 2

requiring backup

report output, 2

requiring new backups, 2

restored location, 2

restoring, 2

all online, 2

from image copies, 2

individual, 2

to new locations, 2

reversing changes, 2

unrecoverable, 2

updating filenames, 2

validating, 2, 2

validation report, 2

datafileSpec subclause, 3

DATAPUMP DIRECTORY parameter, TRANSPORT TABLESPACE command, 2

datatypes, endian conversion, 2

date ranges of backup sets, 2

dates in RMAN commands, 3

DAYS parameter, REPORT command, 2

DB_BLOCK_CHECKSUM initialization parameter, 2

DB_CREATE_FILE_DEST initialization parameter, 2, 3

DB_FILE_NAME_CONVERT initialization parameter, 2, 2, 2, 2, 3

DB_FLASHBACK_RETENTION_TARGET initialization parameter, 2

DB_NAME initialization parameter, 2

DB_NAME parameter

IMPORT CATALOG command, 2

RESTORE command, 2

DB_NAME, changing, 2

DB_RECOVERY_FILE_DEST initialization parameter, 2

DB_RECOVERY_FILE_DEST parameter

BACKUP command, 2

CATALOG command, 2

RESTORE command, 2

VALIDATE command, 2

DB_UNIQUE_NAME initialization parameter, 2

DB_UNIQUE_NAME parameter

CHANGE command, 2

CONFIGURE command, 2, 2

DELETE command, 2

LIST command, 2

RESTORE command, 2

RESYNC CATALOG command, 2

SHOW command, 2

UNREGISTER command, 2

DB_UNIQUE_NAME parameter, forDbUniqueNameOption, 3

DB_UNIQUE_NAME setting, 2, 2, 2, 2

DBA parameter, STARTUP command, 2

DBID parameter

IMPORT CATALOG command, 2

SET command, 2

DBIDs

available information, 2

changing, 2

duplicates, 2

of standby databases, 2

DBNEWID utility, 2

dbObject subclause

parameter descriptions, 2, 3

syntax diagram, 2, 3

DECRYPTION parameter, SET command, 2

DEFAULT DEVICE TYPE parameter

CONFIGURE command, 2

SHOW command, 2

delalConf subclause

command parameters, 2

syntax diagram, 2

DELETE ARCHIVELOG parameter, RECOVER command, 2

delete clause, syntax diagram, 2

DELETE command, 2

delete clause, 2

forDbUniqueNameOption subclause, 2

maintSpec subclause, 2, 3

recordSpec subclause, 3

DELETE INPUT parameter, BACKUP command, 2

DELETE SCRIPT command, 2

deprecated commands, A

DESTINATION parameter, RECOVER command, 2

DESTINATION PLATFORM parameter, CONVERT command, 2

destinations for restoring datafiles, 2

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, 2

REPORT command, 2

RESTORE command, 2

SEND command, 2

SHOW command, 2

VALIDATE command, 2

maintSpec subclause, 3

DEVICE TYPE parameter, maintQualifier subclause, 3

device types, specifying, 2

deviceConf subclause

parameter descriptions, 2

syntax diagram, 2

deviceSpecifier subclause, 3

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

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, 2, 2

duplicate clause

parameter descriptions, 2

syntax diagram, 2

DUPLICATE command, 2

duplicate clause, 2, 2

dupOptionList subclause, 2, 2

dupsbyOptionList subclause, 2, 2

fileNameConversionSpec parameter, 3

logSpec subclause, 2, 2

setParameter subclause, 2, 2

sizeSpec subclause, 2

duplicate databases, opening, 2

duplicating files, 2

duplication

backup based, 2

configuration, 2

example using auxiliary channels, 2

dupOptionList subclause

parameter descriptions, 2

syntax diagram, 2

dupsbyOptionList 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, 4.1

V$BACKUP_PIECE, 2

V$BACKUP_SET, 2

V$DATABASE, 2

V$DATABASE_BLOCK_CORRUPTION, 2, 2, 2, 2, 2, 2, 2

V$DATABASE_FLASHBACK_ON, 2

V$DATABASE_INCARNATION, 2

V$DATABASE.CURRENT_SCN, 2

V$DATAFILE_COPY, 2

V$FLASHBACK_DATABASE_LOG, 2

V$RMAN_COMPRESSION_ALGORITHM, 2, 2

V$RMAN_ENCRYPTION_ALGORITHMS, 2, 2, 2, 2

V$RMAN_OUTPUT, 2, 2

V$RMAN_STATUS, 2

V$SESSION, 2

V$TABLESPACE, 2

V$TRANSPORTABLE_PLATFORM, 2

E

ECHO parameter, SET command, 2

encryption

backup sets, 2, 2, 2

of duplicate databases, 2

recovering tablespaces, 2

specifying decryption passwords, 2

ENCRYPTION ALGORITHM parameter, CONFIGURATION command, 2

encryption algorithms, 2, 2

ENCRYPTION parameter

CONFIGURE command, 2

SET command, 2

SHOW command, 2

encryption settings

overriding, 2, 2

transparent mode, 2

V$RMAN_ENCRYPTION_ALGORITHMS view, 2

encryption wallets

See wallets

end times

for restore, 2

endian formats

converting, 2

duplicating databases, 2

transportable tablespaces, 2

transporting across platforms, 2

environment variables

in RMAN strings, 1.2.2

NLS_DATE_FORMAT, 2

NLS_LANG, 2

error messages

ORA-1152, 2

ORA-1578, 2

ORA-19504, 2

ORA-19624, 2

ORA-19916, 2

ORA-27086, 2

RMAN-0558, 2

RMAN-06004, 2, 2, 2

RMAN-06445, 2, 2

RMAN-06496, 2, 2

RMAN-06710, 2

RMAN-10031, 2

RMAN-10035, 2

RMAN-20401, 2

RMAN-6758, 2

too many open files, 3

EXCLUDE FLASHBACK LOG parameter, RECOVER command, 2

EXCLUDE FOR TABLESPACE parameter, CONFIGURE command, 2

EXCLUDE parameter, SHOW command, 2

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, 2

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

file copies, 2, 2

G

GLOBAL parameter

CREATE SCRIPT command, 2

DELETE SCRIPT command, 2

EXECUTE SCRIPT command, 2

PRINT SCRIPT command, 2

REPLACE SCRIPT command, 2

GLOBAL SCRIPT NAMES parameter, LIST command, 2

global scripts

executing, 2

importing, 2

listing names, 2

printing, 2

H

hardware error recovery (example), 2

header blocks, 2

HEADER parameter

RECOVER command, 2

RESTORE command, 2

HOST command, 2

I

image copies

adding to repository, 2

applying incremental backups, 2

backing up, 2

creating, 2

deleting, 2

displaying information, 2

format, 3, 3, 3

restoring, 2, 2

retention policies, 2

IMMEDIATE parameter, SHUTDOWN command, 2

IMPORT CATALOG command, 2

IMPORT SCRIPT parameter, TRANSPORT TABLESPACE command, 2

import utilities, 2

INACCESSIBLE parameter

CONVERT command, 2

VALIDATE command, 2

INCARNATION parameter, LIST command, 2

incarnations, 2, 2

INCLUDE CURRENT CONTROLFILE parameter

BACKUP command, 2, 2

VALIDATE command, 2

INCLUDING BACKUPS parameter

DROP DATABASE command, 2

UNREGISTER command, 2

inconsistent backups, 2

inconsistent shutdowns, 2

incremental backups, 2, 2

adding datafile copies, 2

bitmap limit, 2

report output, 2

sample script, 2

using datafile copy, 2

INCREMENTAL parameter

BACKUP command, 2

REPORT command, 2

index blocks, logical corruption, 2

initialization files

for auxiliary databases, 2

for database startup, 2

initialization parameters

BACKUP_TAPE_IO_SLAVES, 2

COMPATIBLE, 2

CONTROL_FILES, 2

CPU_COUNT, 2

DB_BLOCK_CHECKSUM, 2

DB_CREATE_FILE_DEST, 2, 3

DB_FILE_NAME_CONVERT, 2, 2, 2, 3

DB_FLASHBACK_RETENTION_TARGET, 2

DB_NAME, 2

DB_RECOVERY_FILE_DEST, 2

DB_UNIQUE_NAME, 2

LOG_ARCHIVE_DEST_n, 2, 2

LOG_ARCHIVE_FORMAT, 2

LOG_FILE_NAME_CONVERT, 2, 2

RECOVERY_PARALLELISM, 2

replacing values, 2

setting collections, 2

setting for duplicate database, 2

input files, deleting, 2

J

job commands, 2

K

KEEP parameter

BACKUP command, 2

KEEP parameter, keepOption subclause, 3

keepOption subclause, 3

keywords in syntax diagrams, 1.2.1

L

LIKE parameter

archivelogRecordSpecifier subclause, 3

maintQualifier subclause, 3

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

recoverableClause subclause, 2, 2

listBackupOption subclause

parameter descriptions, 2

syntax diagram, 2

listObjectSpec subclause

parameter descriptions, 2

syntax diagram, 2

listObjList subclause, 3

parameter descriptions, 3

syntax diagram, 3

LOB datatypes, transporting, 2

local scripts

executing, 2

listing names, 2

printing, 2

M

maintenance channels

allocating, 2

naming conventions, 2

releasing, 2

maintenance commands, 2

maintenance job configuration, 2

maintenanceCommands subclause, syntax diagram, 2

maintQualifier subclause

parameter descriptions, 3

syntax diagram, 2, 3

maintSpec subclause, 3

syntax diagram, 2, 2, 2

MAXCORRUPT parameter

SET command, 2

MAXDAYS parameter, RESTORE command, 2

MAXOPENFILES parameter, allocOperandList subclause, 3

MAXPIECESIZE parameter, allocOperandList subclause, 3

MAXSEQ parameter, RESTORE command, 2

MAXSETSIZE parameter

BACKUP command, 2

CONFIGURE command, 2

SHOW command, 2

media failure, restoring backups, 2

media libraries for sbt channels, 3

media managers, 2

compressing data, 2

controlling data transfer, 2

sending commands, 2, 2

specifying environment variables, 3

status of offsite backups, 2

validating metadata, 2

N

NEED BACKUP parameter, REPORT command, 2

needBackupOption subclause

parameter descriptions, 2

syntax diagram, 2

nested command files, 2

net service names, 2, 3

NEW DATABASE parameter, CONVERT command, 2

new files, backing up only, 2

NEWNAME FOR DATAFILE parameter, SET command, 2

NEWNAME FOR TEMPFILE parameter, SET command, 2

NEWNAME setting, persistent alternative, 2

NLS_DATE_FORMAT configuration setting, 2

NLS_DATE_FORMAT environment variable, 2

NLS_LANG environment variable, 2

NLS_LANG environment variables, 2

NO UNREGISTER parameter, IMPORT CATALOG command, 2

NOARCHIVELOG mode, 2, 2

NOCATALOG parameter, RMAN command, 2

NOCHECKSUM parameter, BACKUP command, 2

NOEXCLUDE parameter

BACKUP command, 2

VALIDATE command, 2

NOFILENAMECHECK parameter, DUPLICATE command, 2, 2, 2

NOKEEP parameter, keepOption subclause, 3

NOMOUNT parameter, STARTUP command, 2

nonquoted strings, 1.2.2

NOPARALLEL parameter, RECOVER command, 2

NOPROMPT parameter

DELETE command, 2

DROP DATABASE command, 2

NOREDO parameter

DUPLICATE command, 2

RECOVER command, 2

NORMAL parameter, SHUTDOWN command, 2

normal resynchronization, 2

NOT BACKED UP parameter, BACKUP command, 2

notBackedUpSpec subclause

parameter descriptions, 2

syntax diagram, 2

numbers, displaying message, 2

O

OBSOLETE parameter

DELETE command, 2

REPORT command, 2

obsOperandList subclause, 3

OFF parameter, SPOOL command, 2

OFFLINE parameter

CONVERT command, 2

VALIDATE command, 2

offsite backups, 2

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

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, 2

ORA$RMAN_RPI_OUT pipe, 2

ORA-1152 error message, 2

ORA-1578 error message, 2

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

duplicating databases (example), 2

Oracle Net connections, 2

Oracle RAC

recovering from failure, 2

See RAC

Oracle Secure Backup, 2

creating encrypted backups, 2

sending commands to (example), 2

undo data, 2

Oracle wallets, 2, 2

Oracle10g compatibility, B.1

Oracle8i compatibiity, B.1

Oracle9i compatibiity, B.1

output

displaying message numbers, 2

storing in files, 2

overwriting backup files, 2

P

PARALLEL parameter, RECOVER command, 2

parallelism

allocating channels, 2

backup using channels (example), 2

channel allocation, 2

specifying for recovery, 2

validation, 2

PARALLELISM parameter, CONVERT command, 2

parallelism settings, 2

parameter files

backing up, 2, 2

restoring, 2, 2

See also initialization parameter files, server parameter files, 2

specifying path, 2

PARAMETER_VALUE_CONVERT parameter

DUPLICATE command, 2, 2

overriding, 2

parameters

deprecated, A

for sbt channels, 3

in syntax diagrams, 1.2.2

parameters in stored scripts, 2

PARMS parameter

allocOperandList subclause, 3

SEND command, 2

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

encrypted, 2

encrypted backup sets, 2

for decryption, 2

RAC SYSDBA, 2

performance

allocating channels, 2

incremental backups, 2

PFILE parameter

DUPLICATE command, 2

STARTUP command, 2

PIPE parameter, RMAN command, 2

pipes

opening input and output, 2

timing out, 2

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, 2

PLUS ARCHIVELOG parameter, VALIDATE command, 2

point-in-time recovery, 2, 2, 2, 3

POOL parameter, BACKUP command, 2

PREVIEW parameter, RESTORE command, 2

previewing backups, 2

PRIMARY CONTROLFILE parameter, RESTORE command, 2

primary databases

backing up, 2

copying, 2

PRINT SCRIPT command, 2

private catalog schema, assigning privileges, 2

privileges

assigning, 2

CATALOG, 2

CREATE TYPE, 2

revoking, 2

SYSDBA, 2

processing time for backup, 2

proxy backups, restoring, 2

proxy copies

available information, 2

crosschecking, 2

definition, 2

deleting, 2, 2

obsolete

report output, 2

restoring, 2

tag names, 2

PROXY parameter

BACKUP command, 2

recordSpec subclause, 3

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

SYSDBA passwords, 2

RATE parameter, allocOperandList subclause, 3

RC_ARCHIVED_LOG view, 4.1

RC_BACKUP_ARCHIVELOG_DETAILS view, 4.1

RC_BACKUP_ARCHIVELOG_SUMMARY view, 4.1

RC_BACKUP_CONTROLFILE view, 4.1

RC_BACKUP_CONTROLFILE_DETAILS view, 4.1

RC_BACKUP_CONTROLFILE_SUMMARY view, 4.1

RC_BACKUP_COPY_DETAILS view, 4.1

RC_BACKUP_COPY_SUMMARY view, 4.1

RC_BACKUP_CORRUPTION view, 4.1, 4.1

RC_BACKUP_DATAFILE view, 4.1, 4.1

RC_BACKUP_DATAFILE_DETAILS view, 4.1

RC_BACKUP_DATAFILE_SUMMARY view, 4.1

RC_BACKUP_FILES view, 4.1

RC_BACKUP_PIECE view, 4.1

RC_BACKUP_PIECE_DETAILS, 4.1

RC_BACKUP_REDOLOG view, 4.1

RC_BACKUP_SET view, 4.1

RC_BACKUP_SET_DETAILS view, 4.1

RC_BACKUP_SET_SUMMARY view, 4.1

RC_BACKUP_SPFILE view, 4.1

RC_BACKUP_SPFILE_DETAILS view, 4.1

RC_BACKUP_SPFILE_SUMMARY view, 4.1

RC_CHECKPOINT view

See RC_RESYNC view

RC_CONTROLFILE_COPY view, 4.1

RC_COPY_CORRUPTION view, 4.1

RC_DATABASE view, 2, 4.1

RC_DATABASE_BLOCK_CORRUPTION view, 4.1

RC_DATABASE_INCARNATION view, 2, 4.1

RC_DATAFILE view, 4.1

RC_DATAFILE_COPY view, 4.1

RC_LOG_HISTORY view, 4.1

RC_OFFLINE_RANGE view, 4.1

RC_PROXY_ARCHIVEDLOG view, 4.1

RC_PROXY_ARCHIVELOG_DETAILS view, 4.1

RC_PROXY_CONTROLFILE view, 4.1

RC_PROXY_COPY_DETAILS view, 4.1

RC_PROXY_COPY_SUMMARY view, 4.1

RC_PROXY_DATAFILE view, 4.1

RC_REDO_LOG view, 4.1

RC_REDO_THREAD view, 4.1

RC_RESTORE_POINT view, 4.1

RC_RESYNC view, 4.1

RC_RMAN_BACKUP_JOB_DETAILS view, 4.1

RC_RMAN_BACKUP_SUBJOB_DETAILS view, 4.1

RC_RMAN_BACKUP_TYPE view, 4.1

RC_RMAN_CONFIGURATION view, 4.1

RC_RMAN_OUTPUT view, 4.1

RC_RMAN_STATUS view, 4.1

RC_SITE view, 4.1

RC_STORED_SCRIPT view, 4.1

RC_STORED_SCRIPT_LINE view, 4.1

RC_TABLESPACE view, 4.1

RC_TEMPFILE view, 4.1

RC_UNUSABLE_BACKUPFILE_DETAILS view, 4.1

RCMRF1938|RC_PROXY_ARCHIVEDLOG view, 4.1

RCMRF1947|RC_UNUSABLE_BACKUPFILE_DETAILS view, 4.1

READONLY parameter

CONVERT command, 2

RECOVER command, 2

VALIDATE command, 2

Real Application Clusters

See RAC

recordSpec subclause, 3

recover clause

parameter descriptions, 2

syntax diagram, 2

RECOVER command, 2

blockObject subclause, 2, 2

dbObject subclause, 2, 2

recover clause, 2, 2

recoverObject subclause, 2, 2

recoverOptionList subclause, 2, 2

recoverSpec subclause, 2, 2

sizeSpec subclause, 2

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, 2

syntax diagram, 2

recoverOptionList subclause

parameter descriptions, 2

syntax diagram, 2

recoverSpec subclause

parameter descriptions, 2

syntax diagram, 2

recovery

allowing corrupt blocks, 2

database in NOARCHIVELOG mode (example), 2

incremental, 2

point-in-time of duplicate databases, 2

search order for backups, 2

RECOVERY AREA parameter

BACKUP command, 2

CATALOG command, 2

RESTORE command, 2

VALIDATE command, 2

recovery catalog

connecting to, 3

DB_UNIQUE_NAME, 2

granting access, 2

registering databases, 2

removing databases, 2

removing references, 2

removing repository records, 2

replacing scripts, 2

updating DB_UNIQUE_NAME, 2

upgrading versions, 2

recovery catalog databases, connecting to, 2

recovery catalog views, 4

RC_DATABASE, 2

RC_DATABASE_INCARNATION, 2

summary list, 4.1

S

saving scripts, 2

sbt channels, specifying parameters, 3

SCHEMA parameter, REPORT command, 2

SCN

for restore, 2

setting restore point, 2

T

TABLESPACE DBA parameter, RECOVER command, 2

TABLESPACE DESTINATION parameter, TRANSPORT TABLESPACE command, 2

TABLESPACE parameter

BACKUP command, 2

CONVERT command, 2

DUPLICATE command, 2

RECOVER command, 2, 2

REPORT command, 2

RESTORE command, 2

SWITCH command, 2

VALIDATE command, 2

tablespace point-in-time recovery (TSPITR), 2, 2

tablespace recovery (example), 2

tablespaces

backing up, 2

converting platform format, 2

duplicating, 2

encryption settings, 2

excluding from database backup, 2

excluding from duplicate database, 2

including in duplicate database, 2

listing datafiles, 2

point-in-time lists, 2

recovering individual, 2

recovering undo segments, 2

renamed, 2

show excluded, 2

transparent encryption, 2

updating filenames, 2

validating individual, 2

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, 2

UNIX commands, 2

unrecoverable operations

report output, 2

UNRECOVERABLE parameter, REPORT command, 2

UNREGISTER DATABASE command, 2

UNTIL SCN parameter

archlogRange subclause, 3

untilClause subclause, 3

UNTIL SEQUENCE parameter

archlogRange subclause, 3

untilClause subclause, 3

UNTIL TIME parameter

archlogRange subclause, 3

untilClause subclause, 3

unused block compression, 2, 2

UPGRADE CATALOG command, 2

USE_DB_RECOVERY_FILE_DEST parameter, 2

user names, 3

user privileges, 2

user roles, 2

user-managed backups, 2

USING ADVISE OPTION parameter, REPAIR FAILURE command, 2

USING parameter, RMAN command, 2

UTF character set, CLOB storage, 2

utlirp script, converting PL/SQL code, 2

V

V$ARCHIVED_LOG view, 2, 3, 3

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, 2

V$DATABASE_BLOCK_CORRUPTION view, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2

V$DATABASE_INCARNATION view, 2

V$DATABASE.CURRENT_SCN view, 2

V$DATABASE.FLASHBACK_ON view, 2

V$DATAFILE view, 3, 3

V$DATAFILE_COPY view, 2, 2, 3

V$DATAFILE_HEADER view, 3

V$FLASHBACK_DATABASE_LOG view, 2

V$PROXY_DATAFILE view, 2

V$RMAN_COMPRESSION_ALGORITHM view, 2, 2

V$RMAN_ENCRYPTION_ALGORITHMS view, 2, 2, 2, 2

V$RMAN_OUTPUT view, 2, 2

V$RMAN_STATUS view, 2

V$SESSION view, 2, 2

V$TABLESPACE view, 2

V$TRANSPORTABLE_PLATFORM view, 2

validate clause

parameter descriptions, 2

syntax diagram, 2

VALIDATE command, 2

blockObject subclause, 2

copyOfSpec subclause, 2

sizeSpec subclause, 2

skipSpec subclause, 2, 2

validate clause, 2, 2

validateObject subclause, 2, 2

validateOperand subclause, 2, 2

VALIDATE HEADER parameter, RECOVER command, 2

VALIDATE parameter

BACKUP command, 2

RESTORE command, 2

validateObject subclause

parameter descriptions, 2

syntax diagram, 2

validateOperand subclause

parameter descriptions, 2

syntax diagram, 2

validating backups, 2

variables in command files, 2

views, recovery catalog, 4

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, 2

windows, 3

recovery, 2, 2

Windows commands, 2

WITH TAG parameter

RECOVER command, 2

X

XMLType datatype in transportable tablespaces, 2

Z

ZLIB compression algorithm, 2, 2