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.5
  • AL16UTF16 character set, CLOB storage 2.10
  • ALL FOREIGN DATAFILES parameter, foreignFileSpec 4.10
  • ALL FOREIGN DATAFILES parameter, foreignFileSpec subclause 4.10
  • ALLOCATE CHANNEL command 2.3
    • allocOperandList subclause 4.1
  • ALLOCATE CHANNEL FOR MAINTENANCE command 2.4
    • shared server 2.4
  • allocOperandList subclause
    • parameter descriptions 4.1
    • syntax diagram 4.1
  • ALTER DATABASE BACKUP command (SQL) 2.5
  • analyzing RMAN repositories 3.5
  • archived log backups 2.26
  • archived log copies 2.26
  • archived log failover 2.5
  • archived logs
    • in backup sets 2.26
    • validation report 3.25
  • archived redo files, optimization algorithms 2.8
  • archived redo logs 4.2
    • backing up 2.5, 4.15
    • cataloging in RMAN repository 2.6
    • deleting 2.5, 2.8, 2.18
    • deletion policies 2.8
    • excluding from backup 2.5
    • foreign (LogMiner) 4.11
    • image copies 2.5
    • limiting number of backups 2.5
    • missing or inaccessible 3.1
    • obsolete 3.5
    • recovering 3.1
    • report output 3.5
    • restoring 3.7
    • restoring a range 3.7
    • specifying a range 4.2
    • using for recovery (example) 3.1
    • validating 3.25
  • ARCHIVELOG BACKUP COPIES parameter
    • CONFIGURE command 2.8
  • ARCHIVELOG mode 2.5, 2.19, 2.22
  • 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.12
  • atClause subclause
    • parameter descriptions 3.5
    • syntax diagram 3.5
  • at sign command (@) 2.1
  • autoBackupOptList subclause
    • parameter descriptions 3.7
    • syntax diagram 3.7
  • AUTOBACKUP parameter, RESTORE command 3.7
  • autobackups
    • control files
  • autobackups, control files 2.8
  • Automated Diagnostic Repository, logging failures 3.25
  • automatic diagnostic repository
    • changing logged failures 2.7
  • Automatic Storage Management (ASM)
    • channel allocation 2.3
    • converting formats 2.10
    • converting format to 2.10
    • converting format to (example) 2.10
    • disk groups 3.7
    • duplicating databases 2.19
    • specifying disk groups 2.8
  • AUXILIARY CHANNEL parameter
  • auxiliary databases
    • connecting to 2.9, 4.4
    • initialization files 2.19
  • auxiliary instances, specifying channels 2.8
  • availability, changing status for backup or copy 2.7

B

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

C

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

D

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

E

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

F

  • failed backups, restarting 2.5
  • failures, available information 2.26
  • fast recovery 2.5
  • fast recovery areas
    • defining for duplicate databases 2.19
    • location of autobackup 2.8
  • file copies 2.5
  • fileNameConversionSpec subclause 4.8
  • file name formats 3.13
  • file names
    • changing during platform conversion 2.10
    • data file image copies 2.5
    • generating new 4.8
    • updating 3.20
  • files
    • backing up new only 2.5
    • backing up with proxy copy 2.5
    • changing availability 2.7
    • creating from stored scripts 2.27
    • excluded from backup 2.5
    • listing those needing backup 3.5
    • naming backups 2.5
    • overwriting backups 2.5
    • sources for duplication 2.19
    • unavailable 2.7
    • validating 2.5
  • file sections, sizing 2.5
  • FLASHBACK DATABASE command 2.22
  • flashback logs 2.22, 3.7
  • flashback NOLOGGING operations 2.22
  • forDbUniqueNameOption subclause
  • foreignFileSpec 4.10
  • foreignFileSpec subclause 4.10
  • foreignlogRecordSpecifier subclause
    • syntax diagram 4.11
  • formatSpec subclause, syntax diagram 2.10
  • forRecoveryOfSpec subclause
    • parameter descriptions 2.5
    • syntax diagram 2.5
  • FOR TRANSPORT
    • clauses not compatible with 2.5
  • FROM AUTOBACKUP parameter, RESTORE command 3.7
  • FTP, moving backups 2.5

G

H

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

I

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

J

K

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

L

  • LIKE parameter
    • archivelogRecordSpecifier subclause 4.2
  • Linux commands 2.24
  • Linux-to-Windows conversion (example) 2.10
  • listBackupOption subclause
    • parameter descriptions 2.26
    • syntax diagram 2.26
  • list clause
    • parameter descriptions 2.26
    • syntax diagram 2.26
  • LIST command 2.26
    • listBackupOption subclause 2.26
    • list clause 2.26
    • listObjectSpec subclause 2.26
    • maintQualifier subclause 2.26
    • recordSpec subclause 4.18
    • recoverableClause subclause 2.26
  • listObjectSpec subclause
    • parameter descriptions 2.26
    • syntax diagram 2.26
  • listObjList subclause 4.14
    • parameter descriptions 4.14
    • syntax diagram 4.14
  • LOB data types, transporting 2.10
  • local scripts
  • LOG_ARCHIVE_DEST_n initialization parameter 3.1, 3.13
  • LOG_FILE_NAME_CONVERT initialization parameter 2.19, 3.22
  • log files
    • directing output to 3.16
  • logging in 4.4
  • LogMiner utility 2.7, 2.8, 4.11
  • log sequence number 3.13
  • log sequence numbers
    • point-in-time recovery 2.19
    • undoing changes 2.22
  • logSpec subclause
    • parameter descriptions 2.19
    • syntax diagram 2.19

M

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

N

  • needBackupOption subclause
    • parameter descriptions 3.5
    • syntax diagram 3.5
  • nested command files 2.2
  • net service names 4.4
  • new files, backing up only 2.5
  • NEWNAME FOR DATABASE parameter, SET command 3.13
  • NEWNAME FOR DATAFILE parameter, SET command 3.13
  • NEWNAME FOR TABLESPACE parameter, SET command 3.13
  • NEWNAME FOR TEMPFILE parameter, SET command 3.13
  • NLS_DATE_FORMAT configuration setting 2.26
  • NLS_DATE_FORMAT environment variable 3.5
  • NLS_LANG environment variable 3.5
  • NLS_LANG environment variables 2.26
  • NOARCHIVELOG mode 2.5, 2.19
  • NOFILENAMECHECK parameter, DUPLICATE command 2.19
  • nonquoted strings 1.1.2
  • NOREDO parameter
    • DUPLICATE command 2.19
  • normal resynchronization 3.8
  • notBackedUpSpec subclause
    • parameter descriptions 2.5
    • syntax diagram 2.5

O

  • obsOperandList subclause 4.17
  • offsite backups 3.7
  • OMF format 2.19
  • online redo logs
    • for duplicate database 2.19
    • for RAC 2.19
  • operating system commands 2.24
  • operating systems
    • compatibility 2.5
    • duplicating databases across 2.19
  • optimization, overriding backup 2.8
  • optimization algorithms 2.8
  • ORA-1152 error message 2.19
  • ORA-1578 error message 3.1
  • ORA-19504 error message 2.19
  • ORA-19624 error message 2.19
  • ORA-19916 error message 2.5
  • ORA-27086 error message 2.19
  • Oracle10g compatibility D.1
  • Oracle8i compatibility D.1
  • Oracle9i compatibility D.1
  • Oracle home, excluded from backup 2.5
  • Oracle keystores 3.7, 3.22
  • Oracle Managed Files (OMF) 2.19, 4.8
    • duplicating databases (example) 2.19
  • Oracle Net connections 3.8
  • Oracle Secure Backup 2.5
    • creating encrypted backups 2.5
    • sending commands to (example) 3.12
    • undo data 2.8
  • Oracle Secure Backup (OSB) Cloud Module
    • configuring RMAN channel F.2.8
    • creating an AWS account F.2.3
    • getting AWS Identifiers F.2.4
    • prerequisites F.2.1
    • registering for OTN account F.2.2
    • running the S3 Backup installer
    • Securing backups F.3
    • storing configuration in RMAN repository F.2.7
    • Troubleshooting F.5
  • overwriting backup files 2.5

P

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

Q

  • QUIT command 2.28
  • QUOTEDSQLCOMMAND command 3.18
  • quoted strings 1.1.2

R

  • RAC
    • automatic channels (example) 2.8
    • creating online redo logs 2.19
    • crosschecking backups 2.4
    • cross-checking or deleting 2.4
    • SYSBACKUP passwords 2.3
  • 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_CMD_STATISTICS view 5.27
  • RC_CONTROLFILE_COPY view 5.25
  • RC_COPY_CORRUPTION view 5.26
  • RC_DATABASE_BLOCK_CORRUPTION view 5.29
  • RC_DATABASE_INCARNATION view 5.30
  • RC_DATABASE view 5.28
  • RC_DATAFILE_COPY view 5.32
  • RC_DATAFILE view 5.31
  • RC_DISK_RESTORE_RANGE view 5.33
  • RC_LOG_HISTORY view 5.34
  • RC_OFFLINE_RANGE view 5.35
  • RC_PDBS view 5.36
  • RC_PLUGGABLE_DATABASE_INC view 5.37
  • RC_PROXY_ARCHIVEDLOG view 5.38
  • RC_PROXY_ARCHIVELOG_DETAILS view 5.39
  • RC_PROXY_CONTROLFILE view 5.41
  • RC_PROXY_COPY_DETAILS view 5.42
  • RC_PROXY_COPY_SUMMARY view 5.43
  • RC_PROXY_DATAFILE view 5.44
  • RC_REDO_LOG view 5.45
  • RC_REDO_THREAD view 5.46
  • RC_RESTORE_POINT view 5.47
  • RC_RESTORE_RANGE view 5.48
  • RC_RESYNC view 5.49
  • RC_RMAN_BACKUP_JOB_DETAILS view 5.50
  • RC_RMAN_BACKUP_SUBJOB_DETAILS view 5.51
  • RC_RMAN_BACKUP_TYPE view 5.52
  • RC_RMAN_CONFIGURATION view 5.53
  • RC_RMAN_OUTPUT view 5.54
  • RC_RMAN_STATUS view 5.55
  • RC_SBT_RESTORE_RANGE view 5.56
  • RC_SITE view 5.57
  • RC_STORED_SCRIPT_LINE view 5.59
  • RC_STORED_SCRIPT view 5.58
  • RC_TABLESPACE view 5.60
  • RC_TEMPFILE view 5.61
  • RC_UNUSABLE_BACKUPFILE_DETAILS view 5.62
  • Real Application Clusters 2.4
  • recordSpec subclause 4.18
  • recoverableClause subclause
    • parameter descriptions 2.26
    • syntax diagram 2.26
  • 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.19
    • 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.7
    • removing repository records 2.14
    • replacing scripts 3.4
    • updating DB_UNIQUE_NAME 2.7
    • upgrading versions 3.21, 3.24
  • recovery catalog databases, connecting to 2.9
  • recovery catalogs
    • creating 2.11
    • creating stored scripts 2.12
    • deleting 2.17
    • resynchronization 3.8
    • revoking privileges 3.9
    • stored scripts, available information 2.26
    • unregistering 2.18
  • recovery catalogs, moving metadata 2.25
  • recovery catalogs.NOCATALOG mode 2.5
  • recovery catalog views 5
    • summary list 5.1
  • recovery files, backing up 2.5
  • Recovery Manager
    • compatibility D.1
    • dates in commands 4.22
  • Recovery Manager, control file autobackups 2.8
  • Recovery Manager client, opening 3.10
  • recovery windows
    • report output 3.5
  • recovery windows, report output 3.5
  • redo logs
  • redo threads 4.22
  • redundant backups 3.5
  • REGISTER DATABASE command 3.2
  • REGISTER privilege 2.11
  • 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.7
  • replaceScript clause
    • syntax diagram 3.4
  • REPLACE SCRIPT command 3.4
    • replaceScript clause 3.4
  • report clause
    • parameter descriptions 3.5
    • syntax diagram 3.5
  • REPORT command 3.5
    • atClause subclause 3.5
    • needBackupOption subclause 3.5
    • report clause 3.5
    • reportObject subclause 3.5
  • reportObject subclause
    • parameter descriptions 3.5
    • syntax diagram 3.5
  • repositories
    • analyzing 3.5
    • listing contents 2.26
    • updating 2.14
    • updating availability status 2.7
    • updating file names 3.20
    • validating contents 2.13
  • reserved words 1.3, A.1
  • reset clause, syntax diagram 3.6
  • RESET DATABASE command 3.6
    • reset clause 3.6
  • resetDbUniqueNameOption subclause
    • parameter descriptions 2.7
    • syntax diagram 2.7
  • resetting incarnations
  • restoration configuration 2.8
  • restore clause
    • parameter descriptions 3.7
    • syntax diagram 3.7
  • RESTORE command 3.7
    • autoBackupOptList subclause 3.7
    • restore clause 3.7
    • restoreObject subclause 3.7
    • restoreSpecOperand subclause 3.7
  • restore commands 3.11
  • restoreCommands subclause, syntax diagram 3.11
  • restore failover 3.7
  • restoreObject subclause
    • parameter descriptions 3.7
    • syntax diagram 3.7
  • RESTORE POINT parameter
    • RECOVER command 3.1
    • SET command 3.13
    • TRANSPORT TABLESPACE command 3.22
  • restore points 2.5, 2.26
  • restoreSpecOperand subclause, syntax diagram 3.7
  • restoring
    • CDBs 3.7
    • data files over the network 3.7
    • from remote hosts 3.7
    • PDBs 3.7
    • root 3.7
  • RESTRICTED SESSION privilege 3.19
  • RESYNC CATALOG, resync clause 3.8
  • RESYNC CATALOG command 3.8
  • resync clause, syntax diagram 3.8
  • resynchronization 3.8
  • retention policies 4.13
    • exemptions (example) 2.5
    • overriding 2.5, 2.7
  • RETENTION POLICY parameter
  • reverse resynchronization 3.8
  • revoke clause, syntax diagram 3.9
  • REVOKE command 3.9
    • revoke clause 3.9
  • RMAN-0558 error message 3.10
  • RMAN-06004 error message 2.20
  • RMAN-06445 error message 2.9
  • RMAN-06496 error message 3.7
  • RMAN-10031 error message 2.19
  • RMAN-10035 error message 2.19
  • RMAN-6758 error message 3.7
  • RMAN command 3.10
    • cmdLine clause 3.10
  • RMAN command (operating system) 3.10
  • RMAN reserved words A.1
  • roles
    • RECOVERY_CATALOG_OWNER 3.24
  • rollback segments, resynchronization 3.8
  • root
    • backing up 2.5
    • connecting to 4.4
    • converting 2.10
    • listing backups 3.5
    • listing data file copies 3.5
    • recovering 3.1
    • restoring 3.7
  • run clause, syntax diagram 3.11
  • RUN command 3.11
    • backupCommands subclause 3.11
    • maintenanceCommands subclause 3.11
    • restoreCommands subclause 3.11
    • run clause 3.11

S

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

T

  • tables
    • recovering in PDBs 3.1
  • TABLESPACE DESTINATION parameter, TRANSPORT TABLESPACE command 3.22
  • tablespace point-in-time recovery (TSPITR) 3.1
  • tablespace recovery (example) 3.1
  • tablespaces
    • renamed 2.5
    • transparent encryption 2.8
    • updating file names 3.20
  • tablespaces7
    • backing up 2.5
  • tape backups, allocating channels 2.3
  • target control files 2.14
  • target databases
    • connecting to 2.9, 4.4
    • deleting 2.18
    • maintaining single metadata catalog 2.25
    • registering 3.2
    • starting from RMAN 3.19
  • target times, undoing changes 2.22
  • tee command (Linux) 3.10
  • temp files
  • tempfileSpec subclause 4.20
  • temporary tablespaces 2.5
  • time, backup completion 4.3
  • time-based backups 2.5
  • time constraints
    • partial backups 2.5
  • time limits 4.22
  • TO PLATFORM 2.5
  • TO RESTORE POINT parameter
    • RECOVER command 3.1
    • SET command 3.13
    • TRANSPORT TABLESPACE command 3.22
  • transferring backups 2.5
  • transparent encryption 2.5, 2.19
  • transportable tablespaces
    • backing up read-only 2.5
    • creating from backups 3.22
    • duplicating 2.19
  • transporting
  • transportOptionList subclause
    • parameter descriptions 2.10
    • syntax diagram 2.10
  • 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.8
  • undo segments 2.10
  • UNIX commands 2.24
  • unrecoverable operations
    • report output 3.5
  • 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.5
  • UPGRADE CATALOG command 3.21, 3.24
  • user-managed backups 2.6
  • user names 4.4
  • user privileges 2.9
  • UTF character set, CLOB storage 2.10
  • utlirp script, converting PL/SQL code 2.19

V

  • V$BACKUP_DEVICE view 2.3, 2.4
  • V$DATABASE_BLOCK_CORRUPTION view 2.5, 3.1, 3.25
  • V$DATABASE.CURRENT_SCN view 2.22
  • V$DATABASE.FLASHBACK_ON view 2.22
  • V$FLASHBACK_DATABASE_LOG view 2.22
  • V$RMAN_COMPRESSION_ALGORITHM view 2.8, 3.13
  • V$RMAN_ENCRYPTION_ALGORITHMS view 2.5, 2.8, 3.13
  • V$RMAN_OUTPUT view 2.5, 3.10
  • V$RMAN_STATUS view 3.10
  • V$SESSION view 3.13
  • V$TABLESPACE view 2.22
  • V$TRANSPORTABLE_PLATFORM view 2.10
  • 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.7
  • variables in command files 2.1
  • views, recovery catalog 5
  • virtual private catalog 2.11
  • virtual private catalogs
  • virtual private catalog schema, assigning privileges 2.23
  • virtual recovery catalog 2.11
  • Volume Shadow Copy Service (VSS) snapshots 2.5

W

X

  • XMLType datatype in transportable tablespaces 3.22