Index

A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X  

Symbols

  • ? symbol in quoted strings 1
  • @@ command 1
  • @ command 1
  • @ symbol in quoted strings 1

A

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

B

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

C

  • CATALOG command 1
  • CATALOG privilege 1
  • catalogs
    • importing 1
  • CDBs
    • backing up
      • as image copies 1
      • tablespaces 1
    • connecting to 1 , 2
    • control file autobackups 1
    • converting 1
    • deleting archived redo logs 1
    • duplicating 1
    • recovering 1
    • resetting the incarnation 1
    • restoring 1
    • transporting tablespaces 1
  • CDs as backup media 1
  • cfauConf subclause
    • parameter descriptions 1
    • syntax diagram 1
  • CHANGE command
    • changeFailure subclause 1
    • forDbUniqueNameOption subclause 1
    • maintSpec subclause 1 , 2
    • recordSpec subclause 1
    • resetDbUniqueNameOption subclause 1
  • changeFailure subclause
    • parameter descriptions 1
    • syntax diagram 1
  • changes, reversing 1
  • channel names 1
  • CHANNEL parameter
    • SHOW command 1
  • channels
    • allocating manually 1 , 2
    • allocating to shared server sessions 1
    • configuring for RAC (example) 1
    • identifying database server sessions 1
    • maximum number 1
    • naming conventions 1
    • releasing 1
    • restoring in Data Guard 1
    • setting for restore (example) 1
    • with proxy capabilities 1
  • character sets, CLOB storage 1
  • CHECK LOGICAL parameter
    • BACKUP command 1
  • checksums 1
  • client, opening RMAN 1
  • client compatibility 1
  • CLOB data type, transporting 1
  • closing RMAN 1 , 2
  • Cloud computing 1
  • cmdLine clause
    • parameter descriptions 1
    • syntax diagram 1
  • command files 1 , 3
  • command format 1
  • COMMAND ID TO parameter
    • SET command 1
  • command line arguments 1
  • commands
    • creating blocks 1
    • deprecated 1
    • executing host 1
    • executing SQL 1
    • RMAN 1
    • sending to media managers 1
  • command subclause summary 1
  • command summary 1
  • command terminator 1
  • comment character (#) 1
  • compatibility 1
  • COMPATIBLE initialization parameter 1
  • completedTimeSpec subclause 1
  • compression 1
  • COMPRESSION ALGORITHM parameter
    • HIGH 1
    • LOW 1
    • MEDIUM 1
  • configuration
    • displaying 1
    • displaying settings 1
    • overriding 1 , 2
    • restoring default settings 1
    • setting 1
  • configuration files, excluded from backup 1
  • configuration parameters
    • OSB Cloud Module 1
  • CONFIGURE BACKUP OPTIMIZATION setting 1
  • configure clause
    • parameter descriptions 1
    • syntax diagram 1
  • CONFIGURE command
    • backupConf subclause 1
    • cfauConf subclause 1
    • configure clause 1
    • delalConf subclause 1
    • deviceConf subclause 1
    • encryption settings 1
    • forDbUniqueNameOption subclause 1
  • CONFIGURE commands 1
  • CONFIGURE CONTROLFILE AUTOBACKUP parameter 1
  • CONNECT command 1
  • connecting
    • to CDBs 1 , 2
    • to PDBs 1 , 2
    • to root 1
  • connections, changing 1
  • connectStringSpec subclause 1
  • consistent shutdowns 1
  • CONTROL_FILES initialization parameter 1
  • CONTROLFILE AUTOBACKUP FORMAT parameter, SET command 1
  • CONTROLFILE AUTOBACKUP parameter
    • SHOW command 1
  • control file copies
    • available information 1
    • tag names 1
  • control files
    • automatic backups 1
    • backing up copies 1
    • copies
      • cataloging in RMAN repository 1
    • file names for control file autobackup 1
    • restoring 1
    • restoring (example) 1
    • restoring autobackups 1
    • restoring for primary database 1
    • resynchronization 1
    • snapshots 1 , 2
    • validation report 1
  • convert clause
    • parameter descriptions 1
    • syntax diagram 1
  • CONVERT command
    • convert clause 1
    • convertOptionList subclause 1
    • fileNameConversionSpec parameter 1
    • formatSpec subclause 1
    • skipSpec subclause 1
    • transportOptionList subclause 1
  • converting
    • CDBs 1
    • PDBs 1
    • root 1
  • convertOptionList subclause
    • parameter descriptions 1
    • syntax diagram 1
  • copies
    • changing availability 1
    • creating multiple backups 1
    • deleting 1 , 2
    • of backup sets, available information 1
    • validating in repository 1
    • viewing status 1
  • copying files 1
  • copy location 1
  • COPY OF parameter
    • BACKUP command 1
  • copyOfSpec subclause
    • parameter descriptions 1
    • syntax diagram 1 , 2
  • corrupt blocks
    • checking for 1
    • restoring 1
    • tolerance for (example) 1
  • CORRUPTION LIST parameter, RECOVER command 1
  • CPU_COUNT initialization parameter 1
  • CREATE CATALOG command 1
  • CREATE SCRIPT command 1
  • CREATE TYPE privilege 1
  • CROSSCHECK command
    • maintSpec subclause 1 , 2
    • recordSpec subclause 1
  • cross-platform backup
    • export dump file 1
  • cross-platform compatibility 1
  • cross-platform transport
    • creating backups 1
  • cumulative backups 1

D

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

E

  • encryption
    • backup sets 1 , 3
    • of duplicate databases 1
    • recovering tablespaces 1
  • ENCRYPTION ALGORITHM parameter, CONFIGURATION command 1
  • encryption algorithms 1
  • encryption settings
    • overriding 1
    • V$RMAN_ENCRYPTION_ALGORITHMS view 1
  • endian formats
    • converting 1
    • transportable tablespaces 1
    • transporting across platforms 1
  • end times
    • for restore 1
  • environment variables
    • in RMAN strings 1
    • NLS_DATE_FORMAT 1
    • NLS_LANG 1
  • error messages
    • ORA-1152 1
    • ORA-1578 1
    • ORA-19504 1
    • ORA-19624 1
    • ORA-19916 1
    • ORA-27086 1
    • RMAN-0558 1
    • RMAN-06004 1
    • RMAN-06445 1
    • RMAN-06496 1
    • RMAN-10031 1
    • RMAN-10035 1
    • RMAN-6758 1
    • too many open files 1
  • EXECUTE SCRIPT command 1
  • EXIT command 1
  • exiting RMAN 1
  • EXPORT LOG parameter, TRANSPORT TABLESPACE command 1
  • export utilities 1
  • external tables, excluded from backup 1

F

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

G

  • global scripts
    • executing 1
    • importing 1
    • printing 1
  • GRANT command 1

H

  • hardware error recovery (example) 1
  • HOST command 1

I

  • image copies
    • adding to repository 1
    • applying incremental backups 1
    • backing up
      • in CDBs 1
    • creating 1
    • deleting 1
    • restoring 1
  • IMPORT CATALOG command 1
  • IMPORT SCRIPT parameter, TRANSPORT TABLESPACE command 1
  • import utilities 1
  • INCARNATION parameter
    • DUPLICATE command
      • orphan 1
    • RESET DATABASE TO INCARNATION 1
    • SET command 1
  • incarnations 1 , 2
  • inconsistent backups 1
  • inconsistent shutdowns 1
  • incremental backups
    • adding data file copies 1
    • bitmap limit 1
    • report output 1
    • sample script 1
    • using data file copy 1
  • initialization files
    • for auxiliary databases 1
  • initialization parameters
    • BACKUP_TAPE_IO_SLAVES 1
    • COMPATIBLE 1
    • CONTROL_FILES 1
    • CPU_COUNT 1
    • DB_BLOCK_CHECKSUM 1
    • DB_CREATE_FILE_DEST 1
    • DB_FILE_NAME_CONVERT 1 , 3 , 4
    • DB_FLASHBACK_RETENTION_TARGET 1
    • DB_UNIQUE_NAME 1
    • LOG_ARCHIVE_DEST_n 1
    • LOG_FILE_NAME_CONVERT 1 , 2
    • RECOVERY_PARALLELISM 1
  • input files, deleting 1

J

  • job commands 1

K

  • keepOption subclause 1
  • KEEP parameter
    • BACKUP command 1
  • keystore-based encryption 1
  • keystores 1 , 2
  • keywords in syntax diagrams 1

L

  • LIKE parameter
    • archivelogRecordSpecifier subclause 1
  • Linux commands 1
  • Linux-to-Windows conversion (example) 1
  • listBackupOption subclause
    • parameter descriptions 1
    • syntax diagram 1
  • list clause
    • parameter descriptions 1
    • syntax diagram 1
  • LIST command
    • listBackupOption subclause 1
    • list clause 1
    • listObjectSpec subclause 1
    • maintQualifier subclause 1
    • recordSpec subclause 1
    • recoverableClause subclause 1
  • listObjectSpec subclause
    • parameter descriptions 1
    • syntax diagram 1
  • listObjList subclause
    • parameter descriptions 1
    • syntax diagram 1
  • LOB data types, transporting 1
  • local scripts
    • executing 1
    • printing 1
  • LOG_ARCHIVE_DEST_n initialization parameter 1 , 2
  • LOG_FILE_NAME_CONVERT initialization parameter 1 , 2
  • log files
    • directing output to 1
  • logging in 1
  • LogMiner utility 1 , 2 , 3
  • log sequence number 1
  • log sequence numbers
    • point-in-time recovery 1
    • undoing changes 1
  • logSpec subclause
    • parameter descriptions 1
    • syntax diagram 1

M

  • maintenance channels
    • allocating 1
    • naming conventions 1
    • releasing 1
  • maintenance commands 1
  • maintenanceCommands subclause, syntax diagram 1
  • maintenance job configuration 1
  • maintQualifier subclause
    • parameter descriptions 1
    • syntax diagram 1 , 2
  • maintSpec subclause
    • syntax diagram 1 , 2 , 3
  • media failure, restoring backups 1
  • media libraries for sbt channels 1
  • media managers
    • compressing data 1
    • controlling data transfer 1
    • sending commands 1
    • specifying environment variables 1
    • status of offsite backups 1
    • validating metadata 1
  • media pool, backup storage 1
  • metadata
    • changing catalog schemas 1
    • resynchronization 1
    • validating in repository 1
  • miscellaneous commands 1
  • missing files
    • checking for 1
  • moving backups 1
  • multisection backups 1
  • multitenant container databases 1

N

  • needBackupOption subclause
    • parameter descriptions 1
    • syntax diagram 1
  • nested command files 1
  • net service names 1
  • new files, backing up only 1
  • NEWNAME FOR DATAFILE parameter, SET command 1
  • NEWNAME FOR TEMPFILE parameter, SET command 1
  • NLS_DATE_FORMAT configuration setting 1
  • NLS_DATE_FORMAT environment variable 1
  • NLS_LANG environment variable 1
  • NLS_LANG environment variables 1
  • NOARCHIVELOG mode 1 , 2
  • NOFILENAMECHECK parameter, DUPLICATE command 1
  • nonquoted strings 1
  • NOREDO parameter
    • DUPLICATE command 1
  • normal resynchronization 1
  • notBackedUpSpec subclause
    • parameter descriptions 1
    • syntax diagram 1

O

  • obsOperandList subclause 1
  • offsite backups 1
  • OMF format 1
  • online redo logs
    • for duplicate database 1
    • for RAC 1
  • operating system commands 1
  • operating systems
    • compatibility 1
    • duplicating databases across 1
  • optimization, overriding backup 1
  • optimization algorithms 1
  • ORA-1152 error message 1
  • ORA-1578 error message 1
  • ORA-19504 error message 1
  • ORA-19624 error message 1
  • ORA-19916 error message 1
  • ORA-27086 error message 1
  • Oracle10g compatibility 1
  • Oracle8i compatibility 1
  • Oracle9i compatibility 1
  • Oracle home, excluded from backup 1
  • Oracle keystores 1 , 2
  • Oracle Managed Files (OMF)
    • duplicating databases (example) 1
  • Oracle Net connections 1
  • Oracle RAC
    • recovering from failure 1
  • Oracle Secure Backup
    • creating encrypted backups 1
    • sending commands to (example) 1
    • undo data 1
  • Oracle Secure Backup (OSB) Cloud Module
    • configuring RMAN channel 1
    • creating an AWS account 1
    • environment variables
      • ENV parameter of PARMS option 1
      • SBT_PARMS parameter 1
    • getting AWS Identifiers 1
    • prerequisites 1
    • registering for OTN account 1
    • running the S3 Backup installer
      • first time 1
      • Linux example 1
    • Securing backups 1
    • storing configuration in RMAN repository 1
    • Troubleshooting 1
  • overwriting backup files 1

P

  • parallelism
    • allocating channels 1
    • backup using channels (example) 1
    • channel allocation 1
  • parallelism settings 1
  • PARAMETER_VALUE_CONVERT parameter
    • overriding 1
  • parameter files
    • backing up 1
    • restoring 1
  • parameters
    • deprecated 1
    • in syntax diagrams 1
  • parameters in stored scripts 1
  • partial backups 1
  • password-based encryption 1
  • password encryption 1
  • password files
    • excluded from backup 1
    • for duplicate databases 1
  • passwords
    • encrypted 1
    • encrypted backup sets 1
    • RAC SYSBACKUP 1
  • PDBs
    • backing up 1
    • connecting to 1 , 2
    • converting 1
    • listing backups 1
    • recovering 1
    • recovering tables 1
    • restoring 1
  • performance
    • allocating channels 1
    • incremental backups 1
  • PL/SQL code, converting formats 1
  • PL/SQL stored procedures 1
  • placeholders in syntax diagrams 1
  • platform compatibility 1
  • platforms
    • duplicating databases across 1
  • PLUGGABLE DATABASE parameter
    • REPORT command 1
  • pluggable databases 1
  • PLUS ARCHIVELOG parameter, VALIDATE command 1
  • point-in-time recovery 1 , 2 , 3 , 4
  • prerequisites
    • backups for cross-platform transport 1
    • cross-platform backups 1
  • previewing backups 1
  • primary databases
    • backing up 1
    • copying 1
  • PRINT SCRIPT command 1
  • private catalog schema, assigning privileges 1
  • privileges
    • assigning 1
    • CATALOG 1
    • CREATE TYPE 1
    • REGISTER 1
    • revoking 1
    • SYSBACKUP 1
  • processing time for backup 1
  • proxy backups, restoring 1
  • proxy copies
    • available information 1
    • cross-checking 1
    • definition 1
    • deleting 1 , 2
    • obsolete
      • report output 1
    • restoring 1
    • tag names 1

Q

  • QUIT command 1
  • QUOTEDSQLCOMMAND command 1
  • quoted strings 1

R

  • RAC
    • automatic channels (example) 1
    • creating online redo logs 1
    • crosschecking backups 1
    • cross-checking or deleting 1
    • SYSBACKUP passwords 1
  • RC_ARCHIVED_LOG view 1
  • RC_BACKUP_ARCHIVELOG_DETAILS view 1
  • RC_BACKUP_ARCHIVELOG_SUMMARY view 1
  • RC_BACKUP_CONTROLFILE_DETAILS view 1
  • RC_BACKUP_CONTROLFILE_SUMMARY view 1
  • RC_BACKUP_CONTROLFILE view 1
  • RC_BACKUP_COPY_DETAILS view 1
  • RC_BACKUP_COPY_SUMMARY view 1
  • RC_BACKUP_CORRUPTION view 1
  • RC_BACKUP_DATAFILE_DETAILS view 1
  • RC_BACKUP_DATAFILE_SUMMARY view 1
  • RC_BACKUP_DATAFILE view 1
  • RC_BACKUP_FILES view 1
  • RC_BACKUP_PIECE_DETAILS 1
  • RC_BACKUP_PIECE view 1
  • RC_BACKUP_REDOLOG view 1
  • RC_BACKUP_SET_DETAILS view 1
  • RC_BACKUP_SET_SUMMARY view 1
  • RC_BACKUP_SET view 1
  • RC_BACKUP_SPFILE_DETAILS view 1
  • RC_BACKUP_SPFILE_SUMMARY view 1
  • RC_BACKUP_SPFILE view 1
  • RC_CHECKPOINT view 1
  • RC_CONTROLFILE_COPY view 1
  • RC_COPY_CORRUPTION view 1
  • RC_DATABASE_BLOCK_CORRUPTION view 1
  • RC_DATABASE_INCARNATION view 1
  • RC_DATABASE view 1
  • RC_DATAFILE_COPY view 1
  • RC_DATAFILE view 1
  • RC_DISK_RESTORE_RANGE view 1
  • RC_LOG_HISTORY view 1
  • RC_OFFLINE_RANGE view 1
  • RC_PDBS view 1
  • RC_PLUGGABLE_DATABASE_INC view 1
  • RC_PROXY_ARCHIVEDLOG view 1
  • RC_PROXY_ARCHIVELOG_DETAILS view 1
  • RC_PROXY_CONTROLFILE view 1
  • RC_PROXY_COPY_DETAILS view 1
  • RC_PROXY_COPY_SUMMARY view 1
  • RC_PROXY_DATAFILE view 1
  • RC_REDO_LOG view 1
  • RC_REDO_THREAD view 1
  • RC_RESTORE_POINT view 1
  • RC_RESTORE_RANGE view 1
  • RC_RESYNC view 1
  • RC_RMAN_BACKUP_JOB_DETAILS view 1
  • RC_RMAN_BACKUP_SUBJOB_DETAILS view 1
  • RC_RMAN_BACKUP_TYPE view 1
  • RC_RMAN_CONFIGURATION view 1
  • RC_RMAN_OUTPUT view 1
  • RC_RMAN_STATUS view 1
  • RC_SBT_RESTORE_RANGE view 1
  • RC_SITE view 1
  • RC_STORED_SCRIPT_LINE view 1
  • RC_STORED_SCRIPT view 1
  • RC_TABLESPACE view 1
  • RC_TEMPFILE view 1
  • RC_UNUSABLE_BACKUPFILE_DETAILS view 1
  • Real Application Clusters 1
  • recordSpec subclause 1
  • recoverableClause subclause
    • parameter descriptions 1
    • syntax diagram 1
  • recover clause
    • parameter descriptions 1
    • syntax diagram 1
  • RECOVER command
    • blockObject subclause 1
    • dbObject subclause 1
    • recover clause 1
    • recoverObject subclause 1
    • recoverOptionList subclause 1
    • recoverSpec subclause 1
  • recovering
    • PDBs 1
    • root 1
    • tablespaces
      • in CDBs 1
  • recoverObject subclause
    • parameter descriptions 1
    • syntax diagram 1
  • recoverOptionList subclause
    • parameter descriptions 1
    • syntax diagram 1
  • recoverSpec subclause
    • parameter descriptions 1
    • syntax diagram 1
  • recovery
    • CDBs 1
    • database in NOARCHIVELOG mode (example) 1
    • PDBs 1
    • point-in-time of duplicate databases 1
    • search order for backups 1
    • using storage snapshots 1
  • RECOVERY_CATALOG_OWNER role 1
  • RECOVERY_PARALLELISM initialization parameter 1
  • recovery catalog
    • connecting to 1
    • registering databases 1
    • removing databases 1
    • removing references 1
    • removing repository records 1
    • replacing scripts 1
    • updating DB_UNIQUE_NAME 1
    • upgrading versions 1
  • recovery catalog databases, connecting to 1
  • recovery catalogs
    • creating 1
    • creating stored scripts 1
    • deleting 1
    • resynchronization 1
    • revoking privileges 1
    • stored scripts, available information 1
    • unregistering 1
  • recovery catalogs, moving metadata 1
  • recovery catalogs.NOCATALOG mode 1
  • recovery catalog views
    • summary list 1
  • recovery files, backing up 1
  • Recovery Manager
    • compatibility 1
    • dates in commands 1
  • Recovery Manager, control file autobackups 1
  • Recovery Manager client, opening 1
  • recovery windows
    • report output 1
  • recovery windows, report output 1
  • redo logs
    • backing up 1
    • for RAC 1
  • redo threads 1
  • redundant backups 1
  • REGISTER DATABASE command 1
  • REGISTER privilege 1
  • RELEASE CHANNEL command
    • release clause 1
    • releaseForMaint clause 1
  • release clause, syntax diagram 1
  • releaseForMaint clause
    • syntax diagram 1
  • remote host
    • restoring data files 1
  • repair clause
    • parameter description 1
    • syntax diagram 1
  • REPAIR FAILURE command
    • repair clause 1
  • repair options 1
  • repair status 1
  • repair strategies 1
  • replaceScript clause
    • syntax diagram 1
  • REPLACE SCRIPT command
    • replaceScript clause 1
  • report clause
    • parameter descriptions 1
    • syntax diagram 1
  • REPORT command
    • atClause subclause 1
    • needBackupOption subclause 1
    • report clause 1
    • reportObject subclause 1
  • reportObject subclause
    • parameter descriptions 1
    • syntax diagram 1
  • repositories
    • analyzing 1
    • listing contents 1
    • updating 1
    • updating availability status 1
    • updating file names 1
    • validating contents 1
  • reserved words 1 , 2
  • reset clause, syntax diagram 1
  • RESET DATABASE command
    • reset clause 1
  • resetDbUniqueNameOption subclause
    • parameter descriptions 1
    • syntax diagram 1
  • resetting incarnations
    • CDBs 1
  • restoration configuration 1
  • restore clause
    • parameter descriptions 1
    • syntax diagram 1
  • RESTORE command
    • autoBackupOptList subclause 1
    • restore clause 1
    • restoreObject subclause 1
    • restoreSpecOperand subclause 1
  • restore commands 1
  • restoreCommands subclause, syntax diagram 1
  • restore failover 1
  • restoreObject subclause
    • parameter descriptions 1
    • syntax diagram 1
  • RESTORE POINT parameter
    • RECOVER command 1
    • SET command 1
    • TRANSPORT TABLESPACE command 1
  • restore points 1 , 2
  • restoreSpecOperand subclause, syntax diagram 1
  • restoring
    • CDBs 1
    • data files over the network 1
    • from remote hosts 1
    • PDBs 1
    • root 1
  • RESTRICTED SESSION privilege 1
  • RESYNC CATALOG, resync clause 1
  • RESYNC CATALOG command 1
  • resync clause, syntax diagram 1
  • resynchronization 1
  • retention policies
    • exemptions (example) 1
    • overriding 1 , 2
  • RETENTION POLICY parameter
    • SHOW command 1
  • reverse resynchronization 1
  • revoke clause, syntax diagram 1
  • REVOKE command
    • revoke clause 1
  • RMAN-0558 error message 1
  • RMAN-06004 error message 1
  • RMAN-06445 error message 1
  • RMAN-06496 error message 1
  • RMAN-10031 error message 1
  • RMAN-10035 error message 1
  • RMAN-6758 error message 1
  • RMAN command
    • cmdLine clause 1
  • RMAN command (operating system) 1
  • RMAN reserved words 1
  • roles
    • RECOVERY_CATALOG_OWNER 1
  • rollback segments, resynchronization 1
  • root
    • backing up 1
    • connecting to 1
    • converting 1
    • listing backups 1
    • listing data file copies 1
    • recovering 1
    • restoring 1
  • run clause, syntax diagram 1
  • RUN command
    • backupCommands subclause 1
    • maintenanceCommands subclause 1
    • restoreCommands subclause 1
    • run clause 1

S

  • saving scripts 1
  • SCN
    • for restore 1
    • setting restore point 1
  • scopes, creating for scripts 1
  • scripts
    • available information 1
    • creating in recovery catalog 1
    • printing 1
    • replacing 1
    • substitution variables 1
  • Secure Backup 1
  • SEND command 1
  • SEQUENCE BETWEEN parameter, archlogRange subclause 1
  • server parameter files
    • backing up 1
    • for auxiliary databases 1
    • restoring 1
    • restoring lost 1
    • validation report 1
  • sessions
    • ending RMAN 1
    • identifying channels 1
  • set clause, syntax diagram 1
  • SET command
    • encryption settings 1
    • set clause 1
    • setRmanOption subclause 1
    • setRmanOrRunOption subclause 1
    • setRunOption subclause 1
  • SET MAXCORRUPT command 1
  • SET NEWNAME command 1
  • setParameter subclause
    • parameter descriptions 1
    • syntax diagram 1
  • setRmanOption subclause
    • parameter descriptions 1
    • syntax diagram 1
  • setRmanOrRunOption subclause
    • parameter descriptions 1
    • syntax diagram 1
  • setRunOption subclause
    • parameter descriptions 1
    • syntax diagram 1
  • shared servers, allocating channels 1
  • shell commands 1
  • show clause, syntax diagram 1
  • SHOW command
    • show clause 1
  • SHUTDOWN command 1
  • shutdowns 1
  • single quotes 1
  • SITE_KEY column null values 1
  • sizeSpec subclause
    • syntax diagram 1
  • skipSpec subclause
    • parameter descriptions 1 , 2 , 3
    • syntax diagram 1 , 2 , 3
  • SNAPSHOT CONTROLFILE parameter, SHOW command 1
  • snapshots
    • control file 1
    • storage 1
    • Volume Shadow Copy Service (VSS) 1
  • source databases
    • copying 1
    • used for duplication 1
  • SPFILE SET, overriding 1
  • SPOOL command 1
  • SQL commands
    • executing 1
  • standard output
    • printing scripts 1
  • standby databases
    • backing up 1
    • copying 1
    • fast recovery areas 1
    • password files 1
    • updating (example) 1
  • STARTUP command 1
  • stdout, redirecting 1
  • stored scripts
    • available information 1
    • deleting 1
    • executing 1
    • printing 1
  • strings
    • valid characters in RMAN commands 1
  • striped files, allocating channels 1
  • striping backup sets 1
  • subclause summary 1
  • substitution variables
    • complete list 1
    • example of %D 1
    • example of %F 1
    • example of %U 1
    • in scripts 1 , 2 , 3
    • passing to stored scripts 1
  • switch clause
    • parameter descriptions 1
    • syntax diagram 1
  • SWITCH command
    • effect on RESTORE 1
    • switch clause 1
    • switchFile subclause 1
  • switchFile subclause
    • parameter descriptions 1
    • syntax diagram 1
  • syntax, deprecated 1
  • syntax conventions 1
  • syntax diagrams
    • keywords 1
    • parameters 1
    • placeholders 1
  • SYSAUX tablespaces 1
  • SYSBACKUP passwords
    • RAC environment 1
  • SYSBACKUP privilege
    • connectStringSpec 1
  • SYSDBA passwords
    • for active duplication 1
  • SYSDBA privilege 1
  • system change numbers (SCN) 1 , 2

T

  • tables
    • recovering
      • in PDBs 1
  • TABLESPACE DESTINATION parameter, TRANSPORT TABLESPACE command 1
  • tablespace point-in-time recovery (TSPITR) 1
  • tablespace recovery (example) 1
  • tablespaces
    • backing up 1
    • recovering
      • in CDBs 1
    • renamed 1
    • transparent encryption 1
    • updating file names 1
  • tape backups, allocating channels 1
  • target control files 1
  • target databases
    • connecting to 1 , 2
    • deleting 1
    • maintaining single metadata catalog 1
    • registering 1
    • starting from RMAN 1
  • target times, undoing changes 1
  • tee command (Linux) 1
  • temp files
    • re-creating 1
    • renaming 1
  • tempfileSpec subclause 1
  • temporary tablespaces 1
  • time, backup completion 1
  • time-based backups 1
  • time constraints
    • partial backups 1
  • time limits 1
  • TO PLATFORM
    • clauses not compatible with 1
  • TO RESTORE POINT parameter
    • RECOVER command 1
    • SET command 1
    • TRANSPORT TABLESPACE command 1
  • transferring backups 1
  • transparent encryption 1 , 2
  • transportable tablespaces
    • backing up read-only 1
    • creating from backups 1
    • duplicating 1
  • transporting
    • tablespaces
      • in CDBs 1
      • in PDBs 1
  • transportOptionList subclause
    • parameter descriptions 1
    • syntax diagram 1
  • TRANSPORT TABLESPACE command
    • transpt_tbs_optlist subclause 1
    • transpt_tbs clause 1
  • transpt_tbs_optlist subclause
    • parameter descriptions 1
    • syntax diagram 1
  • transpt_tbs clause
    • parameter descriptions 1
    • syntax diagram 1

U

  • undo data 1
  • undo segments 1
  • UNIX commands 1
  • unrecoverable operations
    • report output 1
  • UNREGISTER DATABASE command 1
  • untilClause subclause 1
  • UNTIL SCN parameter
    • untilClause subclause 1
  • UNTIL SEQUENCE parameter
    • archlogRange subclause 1
    • untilClause subclause 1
  • UNTIL TIME parameter
    • archlogRange subclause 1
    • untilClause subclause 1
  • unused block compression 1
  • UPGRADE CATALOG command 1
  • user-managed backups 1
  • user names 1
  • user privileges 1
  • UTF character set, CLOB storage 1
  • utlirp script, converting PL/SQL code 1

V

  • V$BACKUP_DEVICE view 1 , 2
  • V$DATABASE_BLOCK_CORRUPTION view 1 , 2 , 4
  • V$DATABASE.CURRENT_SCN view 1
  • V$DATABASE.FLASHBACK_ON view 1
  • V$FLASHBACK_DATABASE_LOG view 1
  • V$RMAN_COMPRESSION_ALGORITHM view 1 , 2
  • V$RMAN_ENCRYPTION_ALGORITHMS view 1 , 2 , 3
  • V$RMAN_OUTPUT view 1 , 2
  • V$RMAN_STATUS view 1
  • V$SESSION view 1
  • V$TABLESPACE view 1
  • V$TRANSPORTABLE_PLATFORM view 1
  • validate clause
    • parameter descriptions 1
    • syntax diagram 1
  • VALIDATE command
    • blockObject subclause 1
    • copyOfSpec subclause 1
    • skipSpec subclause 1
    • validate clause 1
    • validateObject subclause 1
    • validateOperand subclause 1
  • validateObject subclause
    • parameter descriptions 1
    • syntax diagram 1
  • validateOperand subclause
    • parameter descriptions 1
    • syntax diagram 1
  • validating backups 1
  • variables in command files 1
  • views, recovery catalog 1
  • virtual private catalog 1
  • virtual private catalogs
    • deleting 1
  • virtual private catalog schema, assigning privileges 1
  • virtual recovery catalog 1
  • Volume Shadow Copy Service (VSS) snapshots 1

W

  • windows
    • recovery 1
  • Windows commands 1

X

  • XMLType datatype in transportable tablespaces 1