1. Index

Index

Symbols  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.1.2
  • @@ command 2.2
  • @ command 2.1
  • @ symbol in quoted strings 1.1.2

A

  • Advanced Security Option 2.6
  • ADVISE FAILURE command 2.3
  • AL16UTF16 character set, CLOB storage 2.11
  • ALL FOREIGN DATAFILES parameter, foreignFileSpec 4.10
  • ALL FOREIGN DATAFILES parameter, foreignFileSpec subclause 4.10
  • ALLOCATE CHANNEL command 2.4
    • allocOperandList subclause 4.1
  • ALLOCATE CHANNEL FOR MAINTENANCE command 2.5
    • shared server 2.5
  • allocOperandList subclause
    • parameter descriptions 4.1
    • syntax diagram 4.1
  • ALTER DATABASE BACKUP command (SQL) 2.6
  • analyzing RMAN repositories 3.6
  • archived log backups 2.27
  • archived log copies 2.27
  • archived log failover 2.6
  • archived logs
    • in backup sets 2.27
    • validation report 3.25
  • archived redo files, optimization algorithms 2.9
  • archived redo logs 4.2
    • backing up 2.6, 4.15
    • cataloging in RMAN repository 2.7
    • deleting 2.6, 2.9, 2.19
    • deletion policies 2.9
    • excluding from backup 2.6
    • foreign (LogMiner) 4.11
    • image copies 2.6
    • limiting number of backups 2.6
    • missing or inaccessible 3.1
    • obsolete 3.6
    • recovering 3.1
    • report output 3.6
    • restoring 3.8
    • restoring a range 3.8
    • specifying a range 4.2
    • using for recovery (example) 3.1
    • validating 3.25
  • ARCHIVELOG BACKUP COPIES parameter
    • CONFIGURE command 2.9
  • ARCHIVELOG mode 2.6, 2.20, 2.23
  • ARCHIVELOG parameter
    • VALIDATE command 3.25
  • archivelogRecordSpecifier subclause 4.2, 4.11
    • parameter descriptions 4.2
    • syntax diagram 4.2
  • archlogRange subclause
    • parameter descriptions 4.2
    • syntax diagram 4.2, 4.11
  • arguments to stored scripts 2.13
  • atClause subclause
    • parameter descriptions 3.6
    • syntax diagram 3.6
  • at sign command (@) 2.1
  • autoBackupOptList subclause
    • parameter descriptions 3.8
    • syntax diagram 3.8
  • AUTOBACKUP parameter, RESTORE command 3.8
  • autobackups
    • control files
  • autobackups, control files 2.9
  • Automated Diagnostic Repository, logging failures 3.25
  • automated repair 3.4
  • automatic diagnostic repository 2.3
    • changing logged failures 2.8
  • Automatic Storage Management (ASM)
    • channel allocation 2.4
    • converting formats 2.11
    • converting format to 2.11
    • converting format to (example) 2.11
    • disk groups 3.8
    • duplicating databases 2.20
    • specifying disk groups 2.9
  • AUXILIARY CHANNEL parameter
  • auxiliary databases
  • auxiliary instances, specifying channels 2.9
  • availability, changing status for backup or copy 2.8

B

  • BACKED UP parameter, maintQualifier subclause 4.15
  • backing up, excluded files 2.6
  • BACKUP_TAPE_IO_SLAVES initialization parameter 2.4, 2.9
  • backup clause
    • parameter descriptions 2.6
    • syntax diagram 2.6
  • BACKUP command 2.6
    • backup clause 2.6
    • backupOperand subclause 2.6
    • backupSpecOperand subclause 2.6
    • backupSpec subclause 2.6
    • backupTypeSpec subclause 2.6
    • copyOfSpec subclause 2.6
    • datafileCopySpec subclause 2.6
    • duration subclause 2.6
    • fileNameConversionSpec parameter 4.8
    • forRecoveryOfSpec subclause 2.6
    • limiting processing time 2.6
    • notBackedUpSpec subclause 2.6
    • skipSpec subclause 2.6
  • backup commands 3.12
  • backupCommands subclause, syntax diagram 3.12
  • backupConf subclause
    • parameter descriptions 2.9
    • syntax diagram 2.9
  • BACKUP COPIES parameter
  • backup levels 2.6
  • backup media 2.6
  • backupOperand subclause
    • parameter descriptions 2.6
    • syntax diagram 2.6
  • BACKUP OPTIMIZATION parameter
  • backup pieces
    • adding to repository 2.7
    • available information 2.27
    • cross-checking or deleting 2.5
    • definition 2.6
    • maximum size 4.1
    • obsolete 3.6
    • overriding default copies 3.14
    • restoring 3.8
  • backups
    • applying incremental 3.1
    • archivelogs in CDBs 2.6
    • binary compression 2.6
    • CDBs 2.6
    • changing availability 2.8
    • configuration 2.9
    • corruption tolerance (example) 2.6
    • creating multiple copies 2.9
    • creating transportable tablespaces 3.22
    • criteria for obsolescence 4.17
    • cumulative 2.6
    • data files 2.6
    • deleting 2.15
    • duplexing example 2.9
    • duplicate copies 2.4
    • duplicating 2.20
    • for cross-platform transport 2.6
    • inconsistent 2.6
    • incremental 2.6
    • limiting duration 2.6
    • listing 2.27
    • multisection 2.6
    • obsolete 3.6
    • overwriting 2.6
    • partial 2.6
    • PDBs 2.6
    • redundant 3.6
    • restarting 2.6
    • retention policies 2.9
    • root 2.6
    • tablespaces in CDBs 2.6
    • using incremental (example) 3.1
    • using incremental updates (example) 3.1
    • validating in repository 2.14
  • backup sections, sizing 2.6
  • backup set failover 2.6
  • backup sets
    • about archived logs 2.27
    • available information 2.27
    • backing up 2.6
    • backing up encrypted 2.6
    • backup pieces, available information 2.27
    • binary compression 2.6
    • cataloging in RMAN repository 2.7
    • date ranges 2.14
    • deleting 2.6, 2.19
    • encryption 2.6
    • information about copies 2.27
    • information about data files 2.27
    • maximum size 2.6
    • obsolete
      • report output 3.6
    • optimization algorithms 2.9
    • status 2.14
    • summary information 2.27
    • tag names 2.6
    • unused block compression 2.6
  • backupSpecOperand subclause
    • parameter descriptions 2.6
    • syntax diagram 2.6
  • backupSpec subclause
    • parameter descriptions 2.6
    • syntax diagram 2.6
  • backupTypeSpec subclause
    • parameter descriptions 2.6
    • syntax diagram 2.6
  • Backus Naur Form syntax diagrams 1.1
  • base recovery catalog 2.12
  • batch files 2.1
  • BFILE data type, excluded from backup 2.6
  • binary compression 2.6
  • block change tracking files
    • excluded from backup 2.6
    • improving performance 2.6
  • block checksums 2.6
  • block corruptions
  • block media recovery 3.1
  • blockObject subclause
    • parameter descriptions 3.1
    • syntax diagram 3.1, 3.25
  • blocks
  • block sizes of backup media 2.6
  • BNF syntax diagrams 1.1
  • braces {} 3.12

C

  • CATALOG command 2.7
  • CATALOG privilege 2.12
  • catalogs
  • CDBs
    • backing up 2.6
      • as image copies 2.6
      • tablespaces 2.6
    • connecting to 2.10, 4.4
    • control file autobackups 2.9
    • converting 2.11
    • deleting archived redo logs 2.15
    • duplicating 2.20
    • recovering 3.1
    • resetting the incarnation 3.7
    • restoring 3.8
    • transporting tablespaces 2.11
  • CDs as backup media 2.6
  • cfauConf subclause
    • parameter descriptions 2.9
    • syntax diagram 2.9
  • CHANGE command 2.8
    • changeFailure subclause 2.8
    • forDbUniqueNameOption subclause 2.8
    • maintSpec subclause 2.8, 4.16
    • recordSpec subclause 4.18
    • resetDbUniqueNameOption subclause 2.8
  • changeFailure subclause
    • parameter descriptions 2.8
    • syntax diagram 2.8
  • changes, reversing 2.23
  • channel names 2.4
  • CHANNEL parameter
  • channels
    • allocating manually 2.4, 2.5
    • allocating to shared server sessions 2.5
    • configuring for RAC (example) 2.9
    • identifying database server sessions 3.14
    • maximum number 2.4
    • naming conventions 2.9
    • releasing 3.3
    • restoring in Data Guard 3.8
    • setting for restore (example) 3.1
    • with proxy capabilities 2.6
  • character sets, CLOB storage 2.11
  • CHECK LOGICAL parameter
    • BACKUP command 2.6
  • checksums 2.6
  • client, opening RMAN 3.11
  • client compatibility C.1
  • CLOB data type, transporting 2.11
  • closing RMAN 2.22, 2.29
  • Cloud computing E.1
  • cmdLine clause
    • parameter descriptions 3.11
    • syntax diagram 3.11
  • command files 2.1, 2.2
  • command format 1.2
  • COMMAND ID TO parameter
  • command line arguments 3.11
  • commands
    • creating blocks 3.12
    • deprecated B
    • executing host 2.25
    • executing SQL 3.19
    • RMAN 3.11
    • sending to media managers 3.13
  • command subclause summary 1.5
  • command summary 1.4
  • command terminator 1.2
  • comment character (#) 1.2
  • compatibility C.1
  • COMPATIBLE initialization parameter 2.20
  • completedTimeSpec subclause 4.3
  • compression 2.6
  • COMPRESSION ALGORITHM parameter
  • configuration
    • displaying 2.9
    • displaying settings 3.15
    • overriding 3.12, 3.14
    • restoring default settings 2.9
    • setting 2.9
  • configuration files, excluded from backup 2.6
  • configuration parameters
  • CONFIGURE BACKUP OPTIMIZATION setting 2.6
  • configure clause
    • parameter descriptions 2.9
    • syntax diagram 2.9
  • CONFIGURE command 2.9
    • backupConf subclause 2.9
    • cfauConf subclause 2.9
    • configure clause 2.9
    • delalConf subclause 2.9
    • deviceConf subclause 2.9
    • encryption settings 2.6
    • forDbUniqueNameOption subclause 2.9
  • CONFIGURE commands 3.15
  • CONFIGURE CONTROLFILE AUTOBACKUP parameter 2.6
  • CONNECT command 2.10
  • connecting
  • connections, changing 2.10
  • connectStringSpec subclause 4.4
  • consistent shutdowns 2.6
  • CONTROL_FILES initialization parameter 2.20
  • CONTROLFILE AUTOBACKUP FORMAT parameter, SET command 3.14
  • CONTROLFILE AUTOBACKUP parameter
  • control file copies
    • available information 2.27
    • tag names 2.6
  • control files
    • automatic backups 2.9
    • backing up copies 2.6
    • copies
      • cataloging in RMAN repository 2.7
    • file names for control file autobackup 3.14
    • restoring 3.8
    • restoring (example) 3.1
    • restoring autobackups 3.8
    • restoring for primary database 3.8
    • resynchronization 3.9
    • snapshots 2.6, 2.9
    • validation report 3.25
  • convert clause
    • parameter descriptions 2.11
    • syntax diagram 2.11
  • CONVERT command
    • convert clause 2.11
    • convertOptionList subclause 2.11
    • fileNameConversionSpec parameter 4.8
    • formatSpec subclause 2.11
    • skipSpec subclause 2.11
    • transportOptionList subclause 2.11
  • converting
  • convertOptionList subclause
    • parameter descriptions 2.11
    • syntax diagram 2.11
  • copies
    • changing availability 2.8
    • creating multiple backups 2.9
    • deleting 2.15, 2.19
    • of backup sets, available information 2.27
    • validating in repository 2.14
    • viewing status 2.14
  • copying files 2.6
  • copy location 2.6
  • COPY OF parameter
    • BACKUP command 2.6
  • copyOfSpec subclause
    • parameter descriptions 2.6
    • syntax diagram 2.6, 3.25
  • corrupt blocks
    • checking for 3.25
    • restoring 3.8
    • tolerance for (example) 2.6
  • CORRUPTION LIST parameter, RECOVER command 3.1
  • CPU_COUNT initialization parameter 3.1
  • CREATE CATALOG command 2.12
  • CREATE SCRIPT command 2.13
  • CREATE TYPE privilege 3.24
  • CROSSCHECK command 2.14
  • cross-platform backup
    • export dump file 2.6
  • cross-platform compatibility 2.6
  • cross-platform transport
    • creating backups 2.6
  • cumulative backups 2.6

D

  • database changes, reversing 2.23
  • database configuration 3.15
  • database duplication 2.4
  • database failure, repairing 3.4
  • database identifiers
  • database incarnations 2.27
  • DATABASE parameter, listObjList subclause 4.14
  • database point-in-time recovery (DBPITR) 3.1
  • DATABASE ROOT parameter
    • REPORT command 3.6
    • RESTORE command 3.8
  • DATABASE ROOT parameter, dbObject subclause 4.6
  • databases 2.20
    • available information 2.27
    • backing up 2.6
    • changing connections 2.10
    • connecting to 2.10
    • copying 2.20
    • deleting 2.19
    • platform conversion scripts 2.11
    • recovering 3.1
    • recovering with incremental backups (example) 3.1
    • recovering with incremental updates 3.1
    • registering 3.2
    • removing from recovery catalog 3.23
    • resetting incarnation 3.7
    • resynchronization 3.9
    • shutting down target 3.16
    • specifying in Data Guard environment 4.9
    • starting target from RMAN 3.20
    • transparent encryption 2.9
    • transporting re-created files 2.11
    • updating file names 3.21
  • database schemas
    • report output 3.6
  • database server sessions
    • identifying channels 3.14
  • data blocks
    • checking for corrupted 2.6
    • recovering corrupt 3.1
    • recovering physically corrupt 3.1
  • data compression 2.6
  • data encryption 2.20
  • DATAFILE BACKUP COPIES parameter
    • CONFIGURE command 2.9
    • SHOW command 3.15
  • data file backups
    • available information 2.27
  • data file backup sets, available information 2.27
  • data file copies
    • available information 2.27
    • deleting 2.6
    • obsolete 3.6
      • report output 3.6
    • PDBs
    • tag names 2.6
    • validating 3.25
  • datafileCopySpec subclause
    • parameter descriptions 2.6
    • syntax diagram 2.6
  • data files
    • backing up 2.6
    • backing up copies 2.6
    • backing up large 2.6
    • backing up new only 2.6
    • copies
      • cataloging in RMAN repository 2.7
      • incremental backups 2.7
      • tag names 2.7
    • excluding from backup 2.6
    • excluding from conversion 2.11
    • flashback status changes 2.23
    • image copies 2.6
    • in backup sets
      • available information 2.27
    • offline 2.6
    • optimization algorithms 2.9
    • readonly 2.6
    • recovering 3.1
    • recovering corrupt data blocks 3.1
    • renaming 3.14
    • report output 3.6
    • requiring backup
      • report output 3.6
    • restored location 3.8
    • restoring 3.8
      • to new locations 3.8
    • restoring over the network 3.8
    • reversing changes 2.23
    • updating file names 3.21
    • validation report 3.25
  • datafileSpec subclause 4.5
  • Data Guard
    • changing backup associations 2.8
    • configuring databases 2.9
    • creating physical standby databases 2.9
    • creating standby databases (example) 2.20
    • deleting backups and copies 2.15
    • restoring backups 3.8
    • RMAN configuration in recovery catalog 2.9
    • specifying databases 4.9
    • updating backup status 2.14
  • Data Guard backups
    • accessibility by databases 2.6
    • changing associated database 2.8
    • database association 2.6
  • Data Pump 2.11, 2.23, 3.22, C.4
  • DATAPUMP DIRECTORY parameter, TRANSPORT TABLESPACE command 3.22
  • Data Recovery Advisor 2.3, 3.4
  • data types, endian conversion 2.11
  • date ranges of backup sets 2.14
  • dates in RMAN commands 4.22
  • DB_BLOCK_CHECKSUM initialization parameter 2.6
  • DB_CREATE_FILE_DEST initialization parameter 4.1
  • DB_FILE_NAME_CONVERT initialization parameter 2.20, 3.22, 4.8
  • DB_FLASHBACK_RETENTION_TARGET initialization parameter 2.23
  • DB_NAME, changing 2.6
  • DB_UNIQUE_NAME initialization parameter 3.8
  • DB_UNIQUE_NAME parameter
    • CONFIGURE command 2.9
    • DELETE command 2.15
  • DB_UNIQUE_NAME setting 2.7, 2.8, 2.27
  • DBIDs
    • available information 2.27
    • changing 2.6
    • duplicates 3.2
    • of standby databases 2.20
  • DBNEWID utility 3.2
  • dbObject subclause
    • parameter descriptions 4.6
    • RECOVER command 3.1
  • dbObject subclause diagram
    • RECOVER command 3.1
  • DEFAULT DEVICE TYPE parameter
  • delalConf subclause
    • command parameters 2.9
    • syntax diagram 2.9
  • delete clause, syntax diagram 2.15
  • DELETE command 2.15
    • delete clause 2.15
    • forDbUniqueNameOption subclause 2.15
    • maintSpec subclause 2.15, 4.16
    • recordSpec subclause 4.18
  • DELETE SCRIPT command 2.16
  • deleting
    • archived redo logs
  • deprecated commands B
  • destinations for restoring data files 3.8
  • deviceConf subclause
    • parameter descriptions 2.9
    • syntax diagram 2.9
  • deviceSpecifier subclause 4.7
  • DEVICE TYPE parameter
    • maintSpec subclause 4.16
    • SEND command 3.13
    • SHOW command 3.15
  • device types, specifying 2.9
  • diagnostic repository 2.3
  • diagrams of syntax 1.1
  • disk drives, using several for backup 2.4
  • disk files, creating from stored scripts 2.28
  • displaying scripts 2.28
  • double at sign command (@@) 2.2
  • double quotes 1.1.3
  • DROP CATALOG command 2.18
  • DROP DATABASE command 2.19
  • dual-mode encryption 2.6
  • DUMP FILE parameter, foreignFileSpec 4.10
  • DUMP FILE parameter, foreignFileSpec subclause 4.10
  • duplexing 2.9, 3.14
  • duplicate clause
    • parameter descriptions 2.20
    • syntax diagram 2.20
  • DUPLICATE command 2.20
    • duplicate clause 2.20
    • dupOptionList subclause 2.20
    • fileNameConversionSpec parameter 4.8
    • logSpec subclause 2.20
    • setParameter subclause 2.20
  • duplicate databases
    • creating
      • using CONFIGURE AUXNAME 2.20
  • duplicating
  • duplicating files 2.6
  • duplication
    • backup based 2.20
    • configuration 2.9
    • example using auxiliary channels 2.4
  • dupOptionList subclause
    • parameter descriptions 2.20
    • syntax diagram 2.20
  • duration subclause
    • parameter descriptions 2.6
    • syntax diagram 2.6
  • DVDs as backup media 2.6
  • dynamic performance views
    • summary list 5.1
    • V$DATABASE_BLOCK_CORRUPTION 2.6, 3.1, 3.25
    • V$DATABASE_FLASHBACK_ON 2.23
    • V$DATABASE.CURRENT_SCN 2.23
    • V$FLASHBACK_DATABASE_LOG 2.23
    • V$RMAN_COMPRESSION_ALGORITHM 2.9, 3.14
    • V$RMAN_ENCRYPTION_ALGORITHMS 2.6, 2.9, 3.14
    • V$RMAN_OUTPUT 2.6, 3.11
    • V$RMAN_STATUS 3.11
    • V$SESSION 3.14
    • V$TABLESPACE 2.23
    • V$TRANSPORTABLE_PLATFORM 2.11

E

  • encryption
    • backup sets 2.6, 3.8
    • of duplicate databases 2.20
    • recovering tablespaces 3.1
  • ENCRYPTION ALGORITHM parameter, CONFIGURATION command 2.9
  • encryption algorithms 2.6
  • encryption settings
    • overriding 2.9
    • V$RMAN_ENCRYPTION_ALGORITHMS view 2.9
  • endian formats
    • converting 2.11
    • transportable tablespaces 3.22
    • transporting across platforms 2.11
  • end times
  • environment variables
    • in RMAN strings 1.1.2
    • NLS_DATE_FORMAT 3.6
    • NLS_LANG 3.6
  • error messages
  • EXECUTE SCRIPT command 2.21
  • EXIT command 2.22
  • exiting RMAN 2.29
  • EXPORT LOG parameter, TRANSPORT TABLESPACE command 3.22
  • export utilities 2.11
  • external tables, excluded from backup 2.6

F

  • failed backups, restarting 2.6
  • failures, available information 2.27
  • failure summary 2.3
  • fast recovery 2.6
  • fast recovery areas
    • defining for duplicate databases 2.20
    • location of autobackup 2.9
  • file copies 2.6
  • fileNameConversionSpec subclause 4.8
  • file name formats 3.14
  • file names
    • changing during platform conversion 2.11
    • data file image copies 2.6
    • generating new 4.8
    • updating 3.21
  • files
    • backing up new only 2.6
    • backing up with proxy copy 2.6
    • changing availability 2.8
    • creating from stored scripts 2.28
    • excluded from backup 2.6
    • listing those needing backup 3.6
    • naming backups 2.6
    • overwriting backups 2.6
    • sources for duplication 2.20
    • unavailable 2.8
    • validating 2.6
  • file sections, sizing 2.6
  • FLASHBACK DATABASE command 2.23
  • flashback logs 2.23, 3.8
  • flashback NOLOGGING operations 2.23
  • forDbUniqueNameOption subclause
  • foreignFileSpec 4.10
  • foreignFileSpec subclause 4.10
  • foreignlogRecordSpecifier subclause
    • syntax diagram 4.11
  • formatSpec subclause, syntax diagram 2.11
  • forRecoveryOfSpec subclause
    • parameter descriptions 2.6
    • syntax diagram 2.6
  • FOR TRANSPORT
    • clauses not compatible with 2.6
  • FROM AUTOBACKUP parameter, RESTORE command 3.8
  • FTP, moving backups 2.6

G

H

  • hardware error recovery (example) 3.1
  • HOST command 2.25

I

  • image copies
    • adding to repository 2.7
    • applying incremental backups 3.1
    • backing up 2.6
    • creating 2.6
    • deleting 2.19
    • restoring 3.8
  • IMPORT CATALOG command 2.26
  • IMPORT SCRIPT parameter, TRANSPORT TABLESPACE command 3.22
  • import utilities 2.11
  • INCARNATION parameter
    • DUPLICATE command
    • RESET DATABASE TO INCARNATION 3.7
    • SET command 3.14
  • incarnations 2.27, 3.7
  • inconsistent backups 2.6
  • inconsistent shutdowns 2.6
  • incremental backups 2.6
    • adding data file copies 2.7
    • bitmap limit 2.6
    • report output 3.6
    • sample script 2.6
    • using data file copy 2.7
  • initialization files
    • for auxiliary databases 2.20
  • initialization parameters
    • BACKUP_TAPE_IO_SLAVES 2.9
    • COMPATIBLE 2.20
    • CONTROL_FILES 2.20
    • CPU_COUNT 3.1
    • DB_BLOCK_CHECKSUM 2.6
    • DB_CREATE_FILE_DEST 4.1
    • DB_FILE_NAME_CONVERT 2.20, 3.22, 4.8
    • DB_FLASHBACK_RETENTION_TARGET 2.23
    • DB_UNIQUE_NAME 3.8
    • LOG_ARCHIVE_DEST_n 3.14
    • LOG_FILE_NAME_CONVERT 2.20, 3.22
    • RECOVERY_PARALLELISM 3.1
  • input files, deleting 2.6

J

K

  • keepOption subclause 4.13
  • KEEP parameter
    • BACKUP command 2.6
  • keystore-based encryption 2.6
  • keystores 2.20, 3.22
  • keywords in syntax diagrams 1.1.1

L

  • LIKE parameter
    • archivelogRecordSpecifier subclause 4.2
  • Linux commands 2.25
  • Linux-to-Windows conversion (example) 2.11
  • listBackupOption subclause
    • parameter descriptions 2.27
    • syntax diagram 2.27
  • list clause
    • parameter descriptions 2.27
    • syntax diagram 2.27
  • LIST command 2.27
    • listBackupOption subclause 2.27
    • list clause 2.27
    • listObjectSpec subclause 2.27
    • maintQualifier subclause 2.27
    • recordSpec subclause 4.18
    • recoverableClause subclause 2.27
  • listObjectSpec subclause
    • parameter descriptions 2.27
    • syntax diagram 2.27
  • listObjList subclause 4.14
    • parameter descriptions 4.14
    • syntax diagram 4.14
  • LOB data types, transporting 2.11
  • local scripts
  • LOG_ARCHIVE_DEST_n initialization parameter 3.1, 3.14
  • LOG_FILE_NAME_CONVERT initialization parameter 2.20, 3.22
  • log files
    • directing output to 3.17
  • logging in 4.4
  • LogMiner utility 2.8, 2.9, 4.11
  • log sequence number 3.14
  • log sequence numbers
    • point-in-time recovery 2.20
    • undoing changes 2.23
  • logSpec subclause
    • parameter descriptions 2.20
    • syntax diagram 2.20

M

  • maintenance channels
    • allocating 2.5
    • naming conventions 2.5
    • releasing 3.3
  • maintenance commands 3.12
  • maintenanceCommands subclause, syntax diagram 3.12
  • maintenance job configuration 2.9
  • maintQualifier subclause
  • maintSpec subclause 4.16
  • media failure, restoring backups 3.8
  • media libraries for sbt channels 4.1
  • media managers 2.6
    • compressing data 2.6
    • controlling data transfer 2.6
    • sending commands 3.13
    • specifying environment variables 4.1
    • status of offsite backups 3.8
    • validating metadata 2.14
  • media pool, backup storage 2.6
  • metadata
    • changing catalog schemas 2.26
    • resynchronization 3.9
    • validating in repository 2.14
  • miscellaneous commands 3.12
  • missing files
  • moving backups 2.6
  • multisection backups 2.6
  • multitenant container databases 2.6

N

  • needBackupOption subclause
    • parameter descriptions 3.6
    • syntax diagram 3.6
  • nested command files 2.2
  • net service names 4.4
  • new files, backing up only 2.6
  • NEWNAME FOR DATABASE parameter, SET command 3.14
  • NEWNAME FOR DATAFILE parameter, SET command 3.14
  • NEWNAME FOR TABLESPACE parameter, SET command 3.14
  • NEWNAME FOR TEMPFILE parameter, SET command 3.14
  • NLS_DATE_FORMAT configuration setting 2.27
  • NLS_DATE_FORMAT environment variable 3.6
  • NLS_LANG environment variable 3.6
  • NLS_LANG environment variables 2.27
  • NOARCHIVELOG mode 2.6, 2.20
  • NOFILENAMECHECK parameter, DUPLICATE command 2.20
  • nonquoted strings 1.1.2
  • NOREDO parameter
    • DUPLICATE command 2.20
  • normal resynchronization 3.9
  • notBackedUpSpec subclause
    • parameter descriptions 2.6
    • syntax diagram 2.6

O

  • obsOperandList subclause 4.17
  • offsite backups 3.8
  • OMF format 2.20
  • online redo logs
    • for duplicate database 2.20
    • for RAC 2.20
  • operating system commands 2.25
  • operating systems
    • compatibility 2.6
    • duplicating databases across 2.20
  • optimization, overriding backup 2.9
  • optimization algorithms 2.9
  • ORA-1152 error message 2.20
  • ORA-1578 error message 3.1
  • ORA-19504 error message 2.20
  • ORA-19624 error message 2.20
  • ORA-19916 error message 2.6
  • ORA-27086 error message 2.20
  • Oracle10g compatibility C.1
  • Oracle8i compatibility C.1
  • Oracle9i compatibility C.1
  • Oracle home, excluded from backup 2.6
  • Oracle keystores 3.8, 3.22
  • Oracle Managed Files (OMF) 2.20, 4.8
    • duplicating databases (example) 2.20
  • Oracle Net connections 3.9
  • Oracle RAC
    • recovering from failure 3.4
  • Oracle Secure Backup 2.6
    • creating encrypted backups 2.6
    • sending commands to (example) 3.13
    • undo data 2.9
  • Oracle Secure Backup (OSB) Cloud Module
    • configuring RMAN channel E.2.8
    • creating an AWS account E.2.3
    • environment variables
      • ENV parameter of PARMS option E.2.8
      • SBT_PARMS parameter E.2.8
    • getting AWS Identifiers E.2.4
    • prerequisites E.2.1
    • registering for OTN account E.2.2
    • running the S3 Backup installer
    • Securing backups E.3
    • storing configuration in RMAN repository E.2.7
    • Troubleshooting E.5
  • overwriting backup files 2.6

P

  • parallelism
    • allocating channels 2.4
    • backup using channels (example) 2.6
    • channel allocation 2.4
  • parallelism settings 3.15
  • PARAMETER_VALUE_CONVERT parameter
  • parameter files 3.8
    • backing up 2.6
    • restoring 3.8
  • parameters
    • deprecated B
    • in syntax diagrams 1.1.2
  • parameters in stored scripts 2.13
  • partial backups 2.6
  • password-based encryption 2.6
  • password encryption 2.9
  • password files
    • excluded from backup 2.6
    • for duplicate databases 2.20
  • passwords 4.4
    • encrypted 2.9
    • encrypted backup sets 3.8
    • RAC SYSBACKUP 2.4
  • PDBs
    • backing up 2.6
    • connecting to 2.10, 4.4
    • converting 2.6
    • listing backups 3.6
    • recovering 3.1
    • recovering tables 3.1
    • restoring 3.8
  • performance
    • allocating channels 2.4
    • incremental backups 2.6
  • PL/SQL code, converting formats 2.20
  • PL/SQL stored procedures 3.19
  • placeholders in syntax diagrams 1.1.2
  • platform compatibility 2.6
  • platforms
    • duplicating databases across 2.20
  • PLUGGABLE DATABASE parameter
    • REPORT command 3.6
  • pluggable databases 2.6
  • PLUS ARCHIVELOG parameter, VALIDATE command 3.25
  • point-in-time recovery 2.20, 3.1, 3.8, 4.2
  • prerequisites
    • backups for cross-platform transport 2.6
    • cross-platform backups 2.6
  • previewing backups 3.8
  • primary databases
  • PRINT SCRIPT command 2.28
  • private catalog schema, assigning privileges 2.24
  • privileges
  • processing time for backup 2.6
  • proxy backups, restoring 3.1
  • proxy copies
    • available information 2.27
    • cross-checking 2.5
    • definition 2.6
    • deleting 2.5, 2.19
    • obsolete
      • report output 3.6
    • restoring 3.8
    • tag names 2.6

Q

  • QUIT command 2.29
  • QUOTEDSQLCOMMAND command 3.19
  • quoted strings 1.1.2

R

  • RAC
    • automatic channels (example) 2.9
    • creating online redo logs 2.20
    • crosschecking backups 2.5
    • cross-checking or deleting 2.5
    • SYSBACKUP passwords 2.4
  • RC_ARCHIVED_LOG view 5.2
  • RC_BACKUP_ARCHIVELOG_DETAILS view 5.3
  • RC_BACKUP_ARCHIVELOG_SUMMARY view 5.4
  • RC_BACKUP_CONTROLFILE_DETAILS view 5.6
  • RC_BACKUP_CONTROLFILE_SUMMARY view 5.7
  • RC_BACKUP_CONTROLFILE view 5.5
  • RC_BACKUP_COPY_DETAILS view 5.8
  • RC_BACKUP_COPY_SUMMARY view 5.9
  • RC_BACKUP_CORRUPTION view 5.10
  • RC_BACKUP_DATAFILE_DETAILS view 5.12
  • RC_BACKUP_DATAFILE_SUMMARY view 5.13
  • RC_BACKUP_DATAFILE view 5.11
  • RC_BACKUP_FILES view 5.14
  • RC_BACKUP_PIECE_DETAILS 5.16
  • RC_BACKUP_PIECE view 5.15
  • RC_BACKUP_REDOLOG view 5.17
  • RC_BACKUP_SET_DETAILS view 5.19
  • RC_BACKUP_SET_SUMMARY view 5.20
  • RC_BACKUP_SET view 5.18
  • RC_BACKUP_SPFILE_DETAILS view 5.22
  • RC_BACKUP_SPFILE_SUMMARY view 5.23
  • RC_BACKUP_SPFILE view 5.21
  • RC_CHECKPOINT view 5.24
  • RC_CONTROLFILE_COPY view 5.25
  • RC_COPY_CORRUPTION view 5.26
  • RC_DATABASE_BLOCK_CORRUPTION view 5.28
  • RC_DATABASE_INCARNATION view 5.29
  • RC_DATABASE view 5.27
  • RC_DATAFILE_COPY view 5.31
  • RC_DATAFILE view 5.30
  • RC_DISK_RESTORE_RANGE view 5.32
  • RC_LOG_HISTORY view 5.33
  • RC_OFFLINE_RANGE view 5.34
  • RC_PDBS view 5.35
  • RC_PLUGGABLE_DATABASE_INC view 5.36
  • RC_PROXY_ARCHIVEDLOG view 5.37
  • RC_PROXY_ARCHIVELOG_DETAILS view 5.38
  • RC_PROXY_CONTROLFILE view 5.40
  • RC_PROXY_COPY_DETAILS view 5.41
  • RC_PROXY_COPY_SUMMARY view 5.42
  • RC_PROXY_DATAFILE view 5.43
  • RC_REDO_LOG view 5.44
  • RC_REDO_THREAD view 5.45
  • RC_RESTORE_POINT view 5.46
  • RC_RESTORE_RANGE view 5.47
  • RC_RESYNC view 5.48
  • RC_RMAN_BACKUP_JOB_DETAILS view 5.49
  • RC_RMAN_BACKUP_SUBJOB_DETAILS view 5.50
  • RC_RMAN_BACKUP_TYPE view 5.51
  • RC_RMAN_CONFIGURATION view 5.52
  • RC_RMAN_OUTPUT view 5.53
  • RC_RMAN_STATUS view 5.54
  • RC_SBT_RESTORE_RANGE view 5.55
  • RC_SITE view 5.56
  • RC_STORED_SCRIPT_LINE view 5.58
  • RC_STORED_SCRIPT view 5.57
  • RC_TABLESPACE view 5.59
  • RC_TEMPFILE view 5.60
  • RC_UNUSABLE_BACKUPFILE_DETAILS view 5.61
  • Real Application Clusters 2.5
  • recordSpec subclause 4.18
  • recoverableClause subclause
    • parameter descriptions 2.27
    • syntax diagram 2.27
  • recover clause
    • parameter descriptions 3.1
    • syntax diagram 3.1
  • RECOVER command 3.1
    • blockObject subclause 3.1
    • dbObject subclause 3.1
    • recover clause 3.1
    • recoverObject subclause 3.1
    • recoverOptionList subclause 3.1
    • recoverSpec subclause 3.1
  • recovering
  • recoverObject subclause
    • parameter descriptions 3.1
    • syntax diagram 3.1
  • recoverOptionList subclause
    • parameter descriptions 3.1
    • syntax diagram 3.1
  • recoverSpec subclause
    • parameter descriptions 3.1
    • syntax diagram 3.1
  • recovery
    • CDBs 3.1
    • database in NOARCHIVELOG mode (example) 3.1
    • PDBs 3.1
    • point-in-time of duplicate databases 2.20
    • search order for backups 3.1
    • using storage snapshots 3.1
  • RECOVERY_CATALOG_OWNER role 3.24
  • RECOVERY_PARALLELISM initialization parameter 3.1
  • recovery catalog
    • connecting to 4.4
    • registering databases 3.2
    • removing databases 3.23
    • removing references 2.8
    • removing repository records 2.15
    • replacing scripts 3.5
    • updating DB_UNIQUE_NAME 2.8
    • upgrading versions 3.24
  • recovery catalog databases, connecting to 2.10
  • recovery catalogs
    • creating 2.12
    • creating stored scripts 2.13
    • deleting 2.18
    • resynchronization 3.9
    • revoking privileges 3.10
    • stored scripts, available information 2.27
    • unregistering 2.19
  • recovery catalogs, moving metadata 2.26
  • recovery catalogs.NOCATALOG mode 2.6
  • recovery catalog views 5
    • summary list 5.1
  • recovery files, backing up 2.6
  • Recovery Manager
    • compatibility C.1
    • dates in commands 4.22
  • Recovery Manager, control file autobackups 2.9
  • Recovery Manager client, opening 3.11
  • recovery windows
    • report output 3.6
  • recovery windows, report output 3.6
  • redo logs
  • redo threads 4.22
  • redundant backups 3.6
  • REGISTER DATABASE command 3.2
  • REGISTER privilege 2.12
  • RELEASE CHANNEL command 3.3
    • release clause 3.3
    • releaseForMaint clause 3.3
  • release clause, syntax diagram 3.3
  • releaseForMaint clause
    • syntax diagram 3.3
  • remote host
    • restoring data files 3.8
  • repair clause
    • parameter description 3.4
    • syntax diagram 3.4
  • REPAIR FAILURE command 3.4
    • repair clause 3.4
  • repair options 2.3
  • repair status 2.27
  • repair strategies 2.3
  • replaceScript clause
    • syntax diagram 3.5
  • REPLACE SCRIPT command 3.5
    • replaceScript clause 3.5
  • report clause
    • parameter descriptions 3.6
    • syntax diagram 3.6
  • REPORT command 3.6
    • atClause subclause 3.6
    • needBackupOption subclause 3.6
    • report clause 3.6
    • reportObject subclause 3.6
  • reportObject subclause
    • parameter descriptions 3.6
    • syntax diagram 3.6
  • repositories
    • analyzing 3.6
    • listing contents 2.27
    • updating 2.15
    • updating availability status 2.8
    • updating file names 3.21
    • validating contents 2.14
  • reserved words 1.3, A.1
  • reset clause, syntax diagram 3.7
  • RESET DATABASE command 3.7
    • reset clause 3.7
  • resetDbUniqueNameOption subclause
    • parameter descriptions 2.8
    • syntax diagram 2.8
  • resetting incarnations
  • restoration configuration 2.9
  • restore clause
    • parameter descriptions 3.8
    • syntax diagram 3.8
  • RESTORE command 3.8
    • autoBackupOptList subclause 3.8
    • restore clause 3.8
    • restoreObject subclause 3.8
    • restoreSpecOperand subclause 3.8
  • restore commands 3.12
  • restoreCommands subclause, syntax diagram 3.12
  • restore failover 3.8
  • restoreObject subclause
    • parameter descriptions 3.8
    • syntax diagram 3.8
  • RESTORE POINT parameter
    • RECOVER command 3.1
    • SET command 3.14
    • TRANSPORT TABLESPACE command 3.22
  • restore points 2.6, 2.27
  • restoreSpecOperand subclause, syntax diagram 3.8
  • restoring
    • CDBs 3.8
    • data files over the network 3.8
    • from remote hosts 3.8
    • PDBs 3.8
    • root 3.8
  • RESTRICTED SESSION privilege 3.20
  • RESYNC CATALOG, resync clause 3.9
  • RESYNC CATALOG command 3.9
  • resync clause, syntax diagram 3.9
  • resynchronization 3.9
  • retention policies 4.13
    • exemptions (example) 2.6
    • overriding 2.6, 2.8
  • RETENTION POLICY parameter
  • reverse resynchronization 3.9
  • revoke clause, syntax diagram 3.10
  • REVOKE command 3.10
    • revoke clause 3.10
  • RMAN-0558 error message 3.11
  • RMAN-06004 error message 2.21
  • RMAN-06445 error message 2.10
  • RMAN-06496 error message 3.8
  • RMAN-10031 error message 2.20
  • RMAN-10035 error message 2.20
  • RMAN-6758 error message 3.8
  • RMAN command 3.11
    • cmdLine clause 3.11
  • RMAN command (operating system) 3.11
  • RMAN reserved words A.1
  • roles
    • RECOVERY_CATALOG_OWNER 3.24
  • rollback segments, resynchronization 3.9
  • root
    • backing up 2.6
    • connecting to 4.4
    • converting 2.11
    • listing backups 3.6
    • listing data file copies 3.6
    • recovering 3.1
    • restoring 3.8
  • run clause, syntax diagram 3.12
  • RUN command 3.12
    • backupCommands subclause 3.12
    • maintenanceCommands subclause 3.12
    • restoreCommands subclause 3.12
    • run clause 3.12

S

  • saving scripts 2.28
  • SCN
    • for restore 3.14
    • setting restore point 3.14
  • scopes, creating for scripts 3.12
  • scripts 2.1
    • available information 2.27
    • creating in recovery catalog 2.13
    • printing 2.28
    • replacing 3.5
    • substitution variables 2.13
  • Secure Backup 2.6
  • SEND command 3.13
  • SEQUENCE BETWEEN parameter, archlogRange subclause 4.2
  • server parameter files 3.8
    • backing up 2.6
    • for auxiliary databases 2.20
    • restoring 3.8
    • restoring lost 3.20
    • validation report 3.25
  • sessions
    • ending RMAN 2.22
    • identifying channels 3.14
  • set clause, syntax diagram 3.14
  • SET command 3.14
    • encryption settings 2.6
    • set clause 3.14
    • setRmanOption subclause 3.14
    • setRmanOrRunOption subclause 3.14
    • setRunOption subclause 3.14
  • SET MAXCORRUPT command 2.6
  • SET NEWNAME command 3.8
  • setParameter subclause
    • parameter descriptions 2.20
    • syntax diagram 2.20
  • setRmanOption subclause
    • parameter descriptions 3.14
    • syntax diagram 3.14
  • setRmanOrRunOption subclause
    • parameter descriptions 3.14
    • syntax diagram 3.14
  • setRunOption subclause
    • parameter descriptions 3.14
    • syntax diagram 3.14
  • shared servers, allocating channels 2.5
  • shell commands 2.25
  • show clause, syntax diagram 3.15
  • SHOW command 3.15
  • SHUTDOWN command 3.16
  • shutdowns 2.6
  • single quotes 1.1.3
  • SITE_KEY column null values 2.6
  • sizeSpec subclause 4.19
    • syntax diagram 4.19
  • skipSpec subclause
  • SNAPSHOT CONTROLFILE parameter, SHOW command 3.15
  • snapshots
    • control file 2.6
    • storage 3.1
    • Volume Shadow Copy Service (VSS) 2.6
  • source databases
    • copying 2.20
    • used for duplication 2.20
  • SPFILE SET, overriding 2.20
  • SPOOL command 3.17
  • SQL commands
  • standard output
    • printing scripts 2.28
  • standby databases
    • backing up 2.6
    • copying 2.20
    • fast recovery areas 2.20
    • password files 2.20
    • updating (example) 2.6
  • STARTUP command 3.20
  • stdout, redirecting 3.17
  • stored scripts 2.13
  • strings
    • valid characters in RMAN commands 1.1.2
  • striped files, allocating channels 2.4
  • striping backup sets 2.6
  • subclause summary 1.5
  • substitution variables 2.9
  • switch clause
    • parameter descriptions 3.21
    • syntax diagram 3.21
  • SWITCH command 3.21
    • effect on RESTORE 3.8
    • switch clause 3.21
    • switchFile subclause 3.21
  • switchFile subclause
    • parameter descriptions 3.21
    • syntax diagram 3.21
  • syntax, deprecated B
  • syntax conventions 1.1
  • syntax diagrams
  • SYSAUX tablespaces 3.22
  • SYSBACKUP passwords
    • RAC environment 2.4
  • SYSBACKUP privilege 2.10, 4.4
    • connectStringSpec 4.4
  • SYSDBA passwords
    • for active duplication 2.20
  • SYSDBA privilege 4.4
  • system change numbers (SCN) 2.20, 2.23

T

  • tables
    • recovering
  • TABLESPACE DESTINATION parameter, TRANSPORT TABLESPACE command 3.22
  • tablespace point-in-time recovery (TSPITR) 3.1
  • tablespace recovery (example) 3.1
  • tablespaces
    • backing up 2.6
    • recovering
    • renamed 2.6
    • transparent encryption 2.9
    • updating file names 3.21
  • tape backups, allocating channels 2.4
  • target control files 2.15
  • target databases
    • connecting to 2.10, 4.4
    • deleting 2.19
    • maintaining single metadata catalog 2.26
    • registering 3.2
    • starting from RMAN 3.20
  • target times, undoing changes 2.23
  • tee command (Linux) 3.11
  • temp files
  • tempfileSpec subclause 4.20
  • temporary tablespaces 2.6
  • time, backup completion 4.3
  • time-based backups 2.6
  • time constraints
    • partial backups 2.6
  • time limits 4.22
  • TO PLATFORM
    • clauses not compatible with 2.6
  • TO RESTORE POINT parameter
    • RECOVER command 3.1
    • SET command 3.14
    • TRANSPORT TABLESPACE command 3.22
  • transferring backups 2.6
  • transparent encryption 2.6, 2.20
  • transportable tablespaces
    • backing up read-only 2.6
    • creating from backups 3.22
    • duplicating 2.20
  • transporting
  • transportOptionList subclause
    • parameter descriptions 2.11
    • syntax diagram 2.11
  • TRANSPORT TABLESPACE command 3.22
    • transpt_tbs_optlist subclause 3.22
    • transpt_tbs clause 3.22
  • transpt_tbs_optlist subclause
    • parameter descriptions 3.22
    • syntax diagram 3.22
  • transpt_tbs clause
    • parameter descriptions 3.22
    • syntax diagram 3.22

U

  • undo data 2.9
  • undo segments 2.11
  • UNIX commands 2.25
  • unrecoverable operations
    • report output 3.6
  • UNREGISTER DATABASE command 3.23
  • untilClause subclause 4.22
  • UNTIL SCN parameter
    • untilClause subclause 4.22
  • UNTIL SEQUENCE parameter
    • archlogRange subclause 4.2
    • untilClause subclause 4.22
  • UNTIL TIME parameter
    • archlogRange subclause 4.2
    • untilClause subclause 4.22
  • unused block compression 2.6
  • UPGRADE CATALOG command 3.24
  • user-managed backups 2.7
  • user names 4.4
  • user privileges 2.10
  • UTF character set, CLOB storage 2.11
  • utlirp script, converting PL/SQL code 2.20

V

  • V$BACKUP_DEVICE view 2.4, 2.5
  • V$DATABASE_BLOCK_CORRUPTION view 2.6, 3.1, 3.25
  • V$DATABASE.CURRENT_SCN view 2.23
  • V$DATABASE.FLASHBACK_ON view 2.23
  • V$FLASHBACK_DATABASE_LOG view 2.23
  • V$RMAN_COMPRESSION_ALGORITHM view 2.9, 3.14
  • V$RMAN_ENCRYPTION_ALGORITHMS view 2.6, 2.9, 3.14
  • V$RMAN_OUTPUT view 2.6, 3.11
  • V$RMAN_STATUS view 3.11
  • V$SESSION view 3.14
  • V$TABLESPACE view 2.23
  • V$TRANSPORTABLE_PLATFORM view 2.11
  • validate clause
    • parameter descriptions 3.25
    • syntax diagram 3.25
  • VALIDATE command 3.25
    • blockObject subclause 3.25
    • copyOfSpec subclause 3.25
    • skipSpec subclause 3.25
    • validate clause 3.25
    • validateObject subclause 3.25
    • validateOperand subclause 3.25
  • validateObject subclause
    • parameter descriptions 3.25
    • syntax diagram 3.25
  • validateOperand subclause
    • parameter descriptions 3.25
    • syntax diagram 3.25
  • validating backups 3.8
  • variables in command files 2.1
  • views, recovery catalog 5
  • virtual private catalog 2.12
  • virtual private catalogs
  • virtual private catalog schema, assigning privileges 2.24
  • virtual recovery catalog 2.12
  • Volume Shadow Copy Service (VSS) snapshots 2.6

W

X

  • XMLType datatype in transportable tablespaces 3.22