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 Z

Symbols

%d substitution variable
- BACKUP FORMAT 2.4.1
%p substitution variable
- BACKUP FORMAT 2.4.1
%s substitution variable
- BACKUP FORMAT 2.4.1
%t substitution variable
- BACKUP FORMAT 2.4.1
%U substitution variable 9.2.3.1
- BACKUP FORMAT 2.4.1

A

ABORT option
- SHUTDOWN statement 30.5, 31.1.1, 31.1.2
about
- backing up CDBs 4.2.5.1
- backing up PDBs 4.2.5.1
about, flashback database for CDBs 18.1.3
about, flashback database for PDBs 18.1.3
active database duplication 4.2.7
Advanced Security Option 8.3.5
ADVISE FAILURE command 15.1.2.4, 15.4
alert log 12.2.2
ALLOCATE CHANNEL command 5.1.4.1, 6.1.1, 9.2.3.1
- MAXPIECESIZE option 6.2.2
ALLOW ... CORRUPTION clause, RECOVER command 30.6.5
ALTER DATABASE statement
- CLEAR LOGFILE clause 31.7.2.1.3
- END BACKUP clause 29.4.2.3.1
- OPEN RESETLOGS clause 13.8.5
- RECOVER clause 30.2.4.2, 30.3.1, 30.3.2
- RESETLOGS option 30.5
ALTER SYSTEM statement
- KILL SESSION clause 24.4.1
- RESUME clause 29.8.2
- SUSPEND clause 29.8.2
ALTER TABLESPACE statement
- BEGIN BACKUP clause 29.4.2.1, 29.4.2.2.2
- END BACKUP option 29.4.2.2.2
application containers
- about backing up 9.5.1
- backing up 9.5, 9.5.3
- complete recovery 17.5.2
application errors 1.1.2
application PDBs
- backing up 9.5.4
- complete recovery 17.5.3
- point-in-time recovery 18.5.4
application root
- backing up 9.5.2
- complete recovery 17.5.1
archival backups 1.1.3, 9.9.1, 12.4.2.2
archived redo log deletion policies 5.7.1, 5.7.2, 9.7.4
archived redo log files
- applying during media recovery 30.2.1, 30.2.3, 30.2.4.2
- backing up 9.7.3
  - using RMAN 9.7
  - with other backups 9.7.1.2
- backing up, in CDBs 9.7.5
- cataloging 12.4.3
- changing default location 30.2.4.1
- corrupted 30.6.1
- delete after backups 9.7.6
- delete after backups, in CDBs 9.7.7
- deleting 14.3.1, 30.3.1
- deletion after backup 9.7.1
- failover 9.7.1.1
- incompatible format 30.6.1
- location during recovery 30.2.1
- loss of 30.4
- restoring using RMAN 17.2.5
ARCHIVELOG mode
- backups in 2.4.2
AS SELECT clause
- CREATE TABLE statement 31.5
autobackups, control file 8.8, 9.3.3, 9.9.2
- configuring 5.1.5
- format 5.1.5.1
automated repairs
- Data Recovery Advisor 1.5
automatic channel allocation 6.1.1
automatic channels 3.3, 3.3.2
- configuring 6.1.2
- naming conventions 3.3.2
- overriding 6.1
Automatic Diagnostic Repository (ADR) 5.2.4.1, 8.8.2, 12.2.1, 15.1.2.2, 16.1.2.2, 16.1.2.4, 24.1.1
Automatic Storage Management (ASM)
- backups to 9.2.3
Automatic Workload Repository (AWR) 7.5.4
AUTORECOVERY option
- SET statement 30.2.2
auxiliary instance parameter file
- with TRANSPORT TABLESPACE 27.2
availability
- of RMAN backups 12.4.2.1
AVAILABLE option
- of CHANGE command 12.4.2.1

B

backing up
- application containers 9.5.3
- application PDBs 9.5.4
- application root 9.5.2
- database 9
- data files in PDBs 9.4.8
- sparse PDBs 9.6.4
- tablespaces in PDBs 9.4.8
- with Oracle Enterprise Manager Cloud Control 1.6.3
backup
- to Recovery Appliance 3.8.1
backup and recovery
- definition 1.1
- introduction 1
- solutions 1.2
- strategy 1.1.1
- user-managed 1.2
backup-based duplication
- configuring channels 25.4.5.1
BACKUP command 2.4, 2.4.2, 9.1.2, 2.4.3, 3.3.2, 3.7.2.3, 5.4.5, 5.6.1, 6.1.1, 6.2.1, 6.2.4, 8.1, 8.3, 9.7.4
- ALLOW INCONSISTENT option 28.10.1.1
- ARCHIVELOG option 9.7.1.2, 9.7.3
- AS COMPRESSION BACKUPSET option 9.2.5
- AS COPY option 2.4, 8.4.1
- BACKUPSET option 6.2.6.1, 8.7, 8.7.2.1, 9.10.1, 9.10.2
- CHANNEL option 5.1.4.3
- COMPRESSED BACKUPSET option 9.2.5
- COPIES parameter 8.7, 8.7.1
- COPY OF option 8.7, 8.7.2.2, 9.10.1, 9.10.3
- CURRENT CONTROLFILE option 9.3.3, 9.3.3.2
- DATABASE option 9.3.1
- DATAFILE option 9.3.2
- DATAPUMP option 28.6.3, 28.8.1, 28.10.2
- DB_FILE_NAME_CONVERT parameter 8.4.1
- DELETE INPUT option 9.7.6, 12.5.1.1
- DELETE option 9.7.1
- DEVICE TYPE clause 5.1.2, 5.6.1, 9.2.1, 9.3.3.2
- DURATION parameter 10.8.2
- FILESPERSET parameter 8.3.9
- FORMAT parameter 2.4.1, 5.2.3, 5.2.5.1, 8.3.6, 8.7.1, 9.2.3
- FOR RECOVER OF COPY option 9.8.4.1
- FOR TRANSPORT parameter 28.6.2, 28.7.1
- INCREMENTAL LEVEL 1 parameter 28.10.1.1, 28.10.2
- INCREMENTAL LEVEL O parameter 28.10.1.1, 28.10.2
- INCREMENTAL option 2.4.4, 2.4.5, 9.8, 9.8.3, 9.8.3.1
- KEEP option 9.9.1, 9.9.3.1, 9.9.4
- MAXSETSIZE parameter 10.1
- NOT BACKED UP clause 9.7.4
- PLUS ARCHIVELOG option 9.7.1.2
- PROXY ONLY option 8.3.10
- PROXY option 8.3.10
- RECOVERY AREA option 9.10.1
- SECTION SIZE parameter 8.3.1, 9.2.6, 10.1.3
- SPFILE option 9.3.4
- TABLESPACE option 9.3.2
- TAG parameter 2.4.1, 9.2.4.1
- TO PLATFORM parameter 28.6.2, 28.8.1
- VALIDATE option 2.4.6, 15.1.2.2, 15.3, 16.2
BACKUP CONTROLFILE clause
- ALTER DATABASE statement 29.1.1
BACKUP COPIES parameter
- CONFIGURE command 6.2.3
backup encryption 6.2.6.1, 8.3.5, 14.2.3
- decrypting backups 17.2.6
- default algorithm 6.2.6
- dual-mode 6.2.6.1.3, 10.6.4
- overview 10.6
- password 6.2.6.1.2, 10.6.3
- transparent 6.2.6.1.1, 10.6.2
backup mode 8.4.2
- ending with ALTER DATABASE END BACKUP 29.4.2.3.1
- for online user-managed backups 29.4.2.1, 29.10
- instance failure 29.4.2.3
backup optimization 9.7.4
- configuring 5.6, 10.2
- definition 5.6.1, 9.7.4
- disabling 5.6.1, 5.6.3
- enabling 5.6.1, 5.6.3
- redundancy and 5.6.2.2
- retention policies and 5.6.2
backup pieces 8.3.1
- definition 2.4
- maximum size 6.2.2
- names 8.3.6
- names on tape 5.2.5.1
backup retention policies 1.1.3, 3.6, 5.4.1
- affect on backup optimization 5.6.2
- configuring 5.5
- configuring for redundancy 5.5.1
- definition 8.10
- disabling 5.5.3
- exempt backups 9.9.1, 12.4.2.2
- recovery window 8.10
- recovery windows 5.5.2
- redundancy 8.10, 8.10.2
backups
- archival 1.1.3, 9.9.1
- archived redo log files, in CDBs 9.7.5
- archived redo logs
  - using RMAN 9.7
- availability 12.4.2.1
- backup sets 9.10.1
- closed 29.2
- consistent 29.2
  - making using RMAN 8.1.1
- control file 9.3.3, 29.6
- control files 29.6
  - binary 29.6.1
- correlating RMAN channels with 24.2.2.2.1, 24.2.2.2.2
- crosschecking 12.4.1
- cumulative incremental 8.9.1.2
- data file
  - using RMAN 9.10.2, 9.10.3
- DBVERIFY utility 29.11
- default type for RMAN 5.1.3
- determining data file status 29.1.2
- duplexing 6.2.3, 10.4
- excluding tablespaces from backups 6.2.4
- exempt from retention policy 12.4.2.2
- expired, deleting 12.5.4
- generating reports for 11.1.2, 11.3.1
- image copies 8.4
- inconsistent 29.2
  - making using RMAN 8.1.1
- incremental 8.9.1.1, 9.8, 10.4.1, 10.4.2
- incrementally updated 9.8.4
- listing files needed 29.1
- logical 1.1.1
- long-term 1.1.3
- managing 12.1.1
- multisection 3.3.2, 8.3.1, 16.2
- NOARCHIVELOG mode 9.3.5
- obsolete 8.10.3, 12.5.5
- offline 29.4.1
- offsite 17.2.3.1
- optimizing 5.6.1, 9.7.4
- orphaned 14.3.2.4
- PDBs, using Oracle Enterprise Manager Cloud Control 9.4.7
- PDBs, using RMAN 9.4.5
- physical 1.1.1
- previewing 17.2.3
- read-only tablespaces 29.4.2.4
- recovering pre-RESETLOGS 18.6.3
- recovery catalog 13.6.1
- Recovery Manager 9.1.2
- reporting objects needing backups 11.3.2
- restartable 10.7.1
- restoring user-managed 30.2.1
- root
  - using Oracle Enterprise Manager Cloud Control 9.4.4
  - using RMAN 9.4.3
- server parameter files 9.3.4
- skipping files during 10.3
- split mirror 8.4.2
  - using RMAN 10.5
- stored scripts 13.1.2.4, 13.7.1
- tablespace 29.4.2.2
  - using RMAN 9.3.2, 9.10.2, 9.10.3
- testing RMAN 16.1.2.4, 16.2, 16.3
  - using media manager 5.2.4.2
- user-managed 29
- using storage snapshots 29.10
- validating 16.2, 16.3
- verifying 29.11
- whole CDB 9.4.2
- whole database 9.3.1, 29.2
backup sets 2.4, 8.1
- backing up 8.7.2.1, 9.10.1
- backups
  - backups of 8.7.2.1
- compressed 5.1.3, 6.2.5, 9.2.5
- configuring as default 5.1.3
- configuring maximum size 6.2.1
- crosschecking 12.4.1.1
- duplexing 10.4
- how RMAN generates 8.3.8
- limiting size 8.3.8
- maximum size 6.2.1, 10.1
- multiplexed 2.4, 6.2.1, 8.3.9, 9.2.4.2, 23.2.1.1
- naming 8.3.6
- overview 8.3
- Recovery Manager
  - backups
    - backing up 8.7.2.1
- specifying maximum size 8.3.7
- specifying number 8.3.8
- testing restore of 17.2.4
Backup Solutions Program (BSP) 3.5.3
backup strategy
- fast recovery area 5.4
backup tags, RMAN 9.2.4
backup techniques, comparison 1.2
backup windows 10.8.1
BEGIN BACKUP clause
- ALTER TABLESPACE statement 29.4.2.1
binary compression for backups 9.2.5
block change tracking 1.1.1, 8.9.2, 9.8.5
- disk space used for 9.8.5.1.3
- enabling and disabling 9.8.5.2, 9.8.5.3
- moving the change tracking file 9.8.5.5
block corruptions 1.1.2
- stored in V$DATABASE_BLOCK_CORRUPTION 16.2
block media recovery 1.1.2, 16.1.2.4
- automatic 19.1.2
BSP 3.5.3

C

cancel-based media recovery 30.4.2
canceling RMAN commands 24.4
CATALOG command 12.4.3
- START WITH parameter 13.4
CDB, rewinding 18.4.3
CDB restore point 7.1.6.1
CDB restore points, creating 7.4.2
CDB restore points, viewing 7.4.5
CDBs
- about backup and recovery of 4.2.5.1
- backing up 9.4.2
- complete recovery 17.4.1
  - after switching to a copy 17.4.8
  - using Oracle Enterprise Manager Cloud Control 17.4.4
- complete restore 17.4
- connecting to 4.2.5
- crash recovery 30.3.3
- Data Recovery Advisor 15.1.4
- diagnose failures 15.1.4
- instance recovery 30.3.3
- performing point-in-time recovery 18.5.3.1
- repairing failures 15.1.4
- reporting 11.4.1
- transporting across platforms 28.12.2
- user-managed backups 29.3
- validating 16.5.1
CDBs, restore points 7.1.6.1
CHANGE command
- AVAILABLE option 12.4.2.1
- DB_UNIQUE_NAME parameter 13.8.3
- RESET DB_UNIQUE_NAME option 3.7.2.2
- UNCATALOG option 12.4.4.1
CHANGE FAILURE command 15.6
channels, RMAN 3.3
- configuring 5.1.4
- configuring advanced options 6.1
- definition 3.3
- generic 5.1.4.1
- naming conventions 3.3.2
- Oracle RAC environment 6.1.2
- parallel 5.1.4.3
character sets
- setting for use with RMAN 4.4
circular reuse records 12.2.1
clean PDB restore points 7.1.6.2
CLEAR LOGFILE clause
- of ALTER DATABASE 31.7.2.1.3
client, RMAN 2.1, 3.1, 3.5
cold failover cluster
- definition 29.4.2.3
command files, RMAN 2.4.7
command interface
- RMAN 3.2
commands, Recovery Manager
- ADVISE FAILURE 15.1.2.4, 15.4
- ALLOCATE CHANNEL 5.1.4.1, 6.1.1, 6.2.2, 9.2.3.1
- BACKUP 2.4, 2.4.1, 2.4.2, 9.1.2, 2.4.3, 2.4.4, 9.2.4.1, 2.4.5, 2.4.6, 3.3.2, 3.7.2.3, 5.1.2, 5.1.4.3, 5.2.3, 5.2.5.1, 5.4.5, 5.6.1, 6.1.1, 6.2.1, 6.2.4, 6.2.6.1, 8.1, 8.3, 8.3.1, 8.3.9, 8.3.10, 8.4.1, 8.7, 8.7.1, 8.7.2.1, 8.7.2.2, 9.2.1, 9.2.5, 9.3.1, 9.3.2, 9.3.3, 9.3.3.2, 9.3.4, 9.7.1, 9.7.1.2, 9.7.4, 9.7.6, 9.8, 9.8.3, 9.8.3.1, 9.8.4.1, 9.9.1, 9.9.3.1, 9.9.4, 9.10.1, 9.10.2, 9.10.3
  - PROXY ONLY option 8.3.10
  - PROXY option 8.3.10
- BACKUP CURRENT CONTROLFILE 9.3.3.2
- canceling 24.4
- CATALOG 12.4.3
- CHANGE 3.7.2.2, 12.4.1
- CHANGE FAILURE 15.6
- CONFIGURE 3.7.1, 5.1.4.1, 5.5, 5.8, 6.1.1, 6.2.2, 6.2.6.2, 6.3
- CREATE CATALOG 13.2.3
- CREATE SCRIPT 13.7.2
- CROSSCHECK 12.4.1
- DELETE 12.4.1.1, 12.4.3.1, 12.5
- DROP CATALOG 13.9
- DROP DATABASE 12.6
- EXECUTE SCRIPT 13.7.1, 13.7.4
- EXIT 2.2
- FLASHBACK DATABASE 13.8.5
- how RMAN interprets 3.2
- IMPORT CATALOG 13.8.7
- LIST 2.5.1, 11.1.2, 11.2, 11.2.1, 13.8.5, 15.2
  - INCARNATION option 11.2.5, 13.8.5
- MAXSETSIZE 6.2.1
- piping 4.6
- PRINT SCRIPT 13.7.6
- RECOVER 14.3
- REPAIR FAILURE 15.5.1, 15.6
- REPLACE SCRIPT 13.7.3
- REPORT 2.5.2, 11.3.1, 11.3.2
  - NEED BACKUP option 11.3.2
- RESET DATABASE
  - INCARNATION option 13.8.5
- RESTORE 17.2.1.2
- RESYNC CATALOG 13.6.2, 13.8.2, 13.8.2.3
  - FROM CONTROLFILECOPY option 13.6.2
- REVOKE 13.5.5
- SET 6.2.6.1.2
- SHOW 2.3, 5.1.1
- SPOOL 15.5.1
- SWITCH 17.3.4
- terminating 24.4
- UNREGISTER DATABASE 13.8.4
- UPGRADE CATALOG 13.8.6.1
- VALIDATE 15.1.2.2, 15.3, 16.2
commands, SQL*Plus
- RECOVER
  - UNTIL TIME option 30.4.2
- SET 30.2.2, 30.2.4.2, 30.3.1, 30.3.2
comments in RMAN syntax 4.5.3
COMPATIBLE initialization parameter 6.2.6.1
complete recovery
- application containers 17.5.2
- application PDBs 17.5.3
- application root 17.5.1
- overview 17.1
- procedures 30.3
- sparse databases 17.6.3
- using preplugin backups 17.4.5.2
compressed backups 5.1.3, 9.2.5
- algorithms 6.2.5
CONFIGURE command
- AUXNAME option 6.3
- BACKUP OPTIMIZATION option 5.6.3
- CHANNEL option 5.1.4.1, 6.1.1
- CONTROLFILE AUTOBACKUP option 8.8.1, 9.9.2
- DB_UNIQUE_NAME option 5.8
- ENCRYPTION option 6.2.6.2
- EXCLUDE option 6.2.4
- FOR DB_UNIQUE_NAME option 3.7.1
- MAXPIECESIZE option 6.2.2
- MAXSETSIZE option 6.2.1
- RETENTION POLICY clause 8.10
- RETENTION POLICY option 5.5
configuring media managers 5.2.3
- installing 5.2.1
- prerequisites 5.2.1
configuring Recovery Manager
- autobackups 5.1.5, 5.1.5.1, 8.8
- backup optimization 5.6
- backup retention policies 5.5
- backup set size 6.2.1
- default backup type 5.1.3
- default devices 5.1.2
- overview 5.1
- shared server 6.5
- snapshot control file location 6.4
- specific channels 6.1.2
- tablespace exclusion for backups 6.2.4
connecting
- to CDBs 4.2.5
- to PDBs 4.2.5
consistent backups 8.1.1
- using RMAN 8.1.1
- whole database 29.2
CONTROL_FILE_RECORD_KEEP_TIME initialization parameter 12.2.1, 12.2.2
CONTROL_FILES initialization parameter 20.3.1.1, 21.6.1.2, 31.1.2
control file autobackups 12.2.3
- after structural changes to database 8.8
- configuring 5.1.5, 5.1.5.1, 8.8
- default format 8.8.2
- format 5.1.5.1
control files
- backups 29.1.1, 29.6
  - binary 29.6.1
  - including within database backup 9.3.3.1
  - manual 9.3.3.2
  - recovery using 20.3.1
  - using RMAN 9.3.3
- circular reuse records 12.2.1
- configuring location 5.4.4
- creating after loss of all copies 31.3
- finding file names 29.1.1
- multiplexed 5.4.1, 5.4.4, 12.2.3, 17.2.1.1, 29.1.1, 30.2.1, 31.1.1
  - loss of 31.1
- multiplexing 12.2.3
- re-created 31.3
- restoring 20.3.1.1, 31.1.1, 31.1.2
- snapshot 13.8.2.1
  - specifying location of 6.4
- user-managed restore after loss of all copies 31.3
CONVERT command
- ALLOW INCONSISTENT option 28.10.1.1
COPIES option
- BACKUP command 10.4.2
corrupt blocks 14.1.1.2, 16.1.2.1, 30.6.1
- recovering 19.1.2.2
- RMAN and 10.7.1
crash recovery
- of CDBs 30.3.3
CREATE CATALOG command 13.2.3
CREATE DATAFILE clause, ALTER DATABASE statement 31.4
CREATE SCRIPT command 13.7.2
CREATE TABLESPACE statement 31.2.3
CREATE TABLE statement
- AS SELECT clause 31.5
creating
- virtual private catalogs 13.5.3
creating, PDB restore points 7.4.3
CROSSCHECK command 12.4.1
crosschecking, RMAN 2.6, 12.1.2.2.1, 12.4.1
- definition 12.4.1.1
- recovery catalog with the media manager 12.4.1.1
cross-platform data transport
- data pump destination 28.6.1
cross-platform transport
- databases
  - using backup sets 28.7
  - using image copies 28.5
- data files, using image copies 28.4
- inconsistent tablespaces 28.10
  - about 28.9
  - example 28.10.2
  - steps 28.10.1
- methods 28.1.2
  - using backup sets 28.6
  - using image copies 28.2
- of CDBs 28.12.2
- of PDBs 28.12.1
- over the network 28.11
- PDB to a new CDB 28.12.3, 28.12.4
- read-only tablespaces
  - using backup sets 28.8
  - using image copies 28.3
- tablespaces, DataPump export dump file 28.6.3
- tablespaces in PDBs 28.12.5
cross-platform transportable tablespace 28
cumulative incremental backups 2.4.4, 2.4.5, 8.9.1, 8.9.1.2

D

database connections
- Recovery Manager
  - auxiliary database 4.2.7
  - hiding passwords 4.2.6
  - without a catalog 4.2
- SYSBACKUP required for RMAN 4.2.2
- types in RMAN 4.2.1
Database Home page, accessing 1.6.2
database point-in-time recovery 18, 18.5
- definition 18.1.2.1
- Flashback Database and 7.1.1
- prerequisites 18.5.1
- user-managed 30.4
databases
- duplicating 25.4.1
- listing for backups 29.1
- media recovery procedures, user-managed 30
- media recovery scenarios 31
- multitenant container 9.4
- recovery
  - after control file damage 31.1.1, 31.1.2
- registering in recovery catalog 13.3.2
- reporting on schemas 11.3.5
- suspending 29.8.1
- transporting across platforms
  - using backup sets 28.7
  - using image copies 28.5
- unregistering from recovery catalog 13.8.4
data blocks, corrupted 1.1.1, 1.1.2, 2.7.1, 2.9.4, 14.1.1.2, 15.3, 15.6, 16.2, 19.1.1, 30.6.1
data dictionary views 29.4.1, 29.4.2.1, 29.4.2.4, 29.5.1
data files
- backing up 9.3.2, 9.10.2, 9.10.3, 29.4.1
- backing up, in PDBs 9.4.8
- determining status 29.1.2
- listing 29.1
- losing 30.2.1
- restoring 14.2
- transporting across platforms 28.4
Data Guard environment
- archived log deletion policies 5.7.1.2
- changing a DB_UNIQUE_NAME 13.8.3
- configuring RMAN 5.8
- reporting in a 11.1.3
- RMAN backups 9.1.2
- RMAN backups, accessibility of 3.7.2.3
- RMAN backups, association of 3.7.2.2
- RMAN backups, interchangeability of 3.7.2.1, 9.3.3
- RMAN usage 3.7
data integrity checks 1.5, 15.1.2.2, 15.3
data preservation, definition of 1.1.3
data protection, definition 1.1.1
data pump destination 28.6.1
Data Recovery Advisor 2.7, 11.2.1, 14.1.2
- automated repairs 1.5
- data integrity checks 15.1.2.2, 15.3
- failure consolidation 15.1.2.3.3
- failure priority 15.1.2.3.2
- failures 15.1.2.1, 15.1.2.3
- feasibility checks 15.1.2.4
- for CDBs 15.1.4
- overview 1.5
- purpose 15.1.1
- repairing failures 15.5.1
- repair options 15.4
- repairs 15.1.2.1, 15.1.2.4, 15.1.2.4.1
- user interfaces 15.1.2.1
data repair
- overview 14.1.1
- techniques 14.1.2
data transfer, RMAN 1.1.4
DB_BLOCK_CHECKSUM initialization parameter 16.1.2.1
DB_CREATE_FILE_DEST initialization parameter 9.8.5.2, 17.3.2
DB_FILE_NAME_CONVERT initialization parameter 21.6.1.2
DB_FLASHBACK_RETENTION_TARGET initialization parameter 5.4.2.1
DB_LOST_WRITE_PROTECT initialization parameter 6.6
DB_NAME initialization parameter 21.6.1.2
DB_RECOVERY_FILE_DEST_SIZE initialization parameter 2.1
DB_RECOVERY_FILE_DEST initialization parameter 2.1
DB_UNIQUE_NAME initialization parameter 3.7, 3.7.2.2, 5.8, 11.1.3
DBA_DATA_FILES view 29.4.1, 29.4.2.1, 29.4.2.4, 29.5.1
DBID
- determining 17.2.2
- problems registering copied database 13.1.2.1
DBMS_PIPE package 4.6
DBPITR 18.5
DBVERIFY utility 29.11
DELETE command 12.4.3.1, 12.5, 12.5.3
- EXPIRED option 12.4.1.1, 12.5.4
- OBSOLETE option 8.10.3, 12.5.5
deleting
- archived redo log files 9.7.6
- archived redo log files, in CDBs 9.7.7
- dropped PDB backups 12.5.6
deleting backups 2.6.2, 12.5, 12.5.1.1, 12.5.3
deletion policies, archived redo log 5.7.1
- enabling 5.7.2
devices, configuring default 5.1.2
diagnose failures
- in CDBs 15.1.4
differential incremental backups 2.4.4, 8.9.1, 8.9.1.1
direct ancestral path 14.3.2.2, 18.4.2, 18.6.2
disabling
- Flashback Database 7.5.2
disaster recovery 1.1.3
- definition 1.1.2
disconnecting
- from Recovery Manager 2.2
disk API 5.2.4
disk failures 1.1.2
disk usage
- monitoring 12.3.2
DROP DATABASE command 12.6
dropped tables, retrieving 18.3.1
dropping a database 12.6
dropping the recovery catalog 13.9
dual mode backup encryption 6.2.6.1.3
dual-mode backup encryption 10.6.4
duplexing backup sets 6.2.3, 8.7.1, 10.4
duplicate databases
- active database duplication 4.2.7
duplicating
- Cloud database to on-premise 25.7
- configuring channels 25.4.5
- databases 25.4.1
- PDBs 25.9.7
- preparing auxiliary instance 25.3
- sparse CDBs 25.5.2
- sparse databases 25.4.4
- sparse PDBs 25.5.3.5
- tablespaces 25.4.2
duplicating a PDB
- to existing CDBs 25.5.3.3
duplicating databases
- initialization file 25.3.2
- Oracle keystore 25.3.6
duplicatingOracle Cloud
- to 25.6
duplicating PDBs
- to new CDB 25.5.3.4
duplication
- SET NEWNAME 26.1.1.1
- using encrypted backups 25.9.9
DURATION parameter, BACKUP command 10.8.2

E

enabling
- Flashback Database 7.5.1
- lost write protection 6.7
encrypted backups 10.6, 14.2.3
- backup-based duplication 25.9.9
- decrypting 17.2.6
environment variables
- NLS_DATE_FORMAT 4.4
- NLS_LANG 4.4
error codes
- media manager 24.1.4.2
- RMAN 24.1, 24.1.4, 24.1.4.1
error messages, RMAN
- interpreting 24.1.5
error stacks, RMAN
- interpreting 24.1.5
example
- duplicating databases 25.10
- multisection incremental backups 9.2.6
- recovering tables into new schema 22.5.3
- recovery using preplugin backups 17.4.5.3
examples
- preplugin backups 9.4.9
- recovering using third-party snapshots 30.2.5
- rolling forward a physical standby 20.7.5
EXECUTE SCRIPT command 13.7.4
EXIT command 2.2
exiting RMAN 2.2
expired backups 8.10, 12.4.1.1
- deleting 12.5.4
EXPIRED option
- DELETE command 12.5.4

F

failover, when restoring files 14.2.2
failures
- definition 1.1.2
- media 1.1.2
failures, Data Recovery Advisor 15.1.2.1, 15.1.2.3
- consolidation 15.1.2.3.3
- priority 15.1.2.3.2
fast recovery area 3.1, 3.6, 18.1.2.3.1
- autobackups 5.1.5.1
- changing locations 12.3.5
- configuring 5.4
- definition 2.1
- disabling 12.3.6
- effect of retention policy 8.10.4
- enabling 5.4.2
- flashback database window 7.1.2
- maintaining 12.3
- monitoring disk usage 12.3.2
- monitoring usage 12.3.2
- Oracle Managed Files 5.4.1.1
- PDB point-in-time recovery 18.5.3
- permanent and impermanent files 5.4.1
- RMAN files in 5.4.5
- setting location 5.4.2.2
- setting size 5.4.2.1
- snapshot control files 6.4
- space management 5.4.1.2
feasibility checks, Data Recovery Advisor 15.1.2.4
file names, listing for backup 29.1
file sections 8.3.7, 8.3.9, 10.1.3, 16.2
flashback CDB 18.4.3
flashback CDB, using SQL*Plus 30.1.2
flashback data archive
- definition 1.4.1
Flashback Database 1.4.2, 2.8, 14.1.2, 18
- determining the flashback database window 18.4.2
- disabling 7.5.2
- enabling 7.5.1
- flashback logs 1.4.2, 7.2.1
- limitations 7.1.3
- monitoring 7.5.4
- overview 1.4.2
- prerequisites 18.4.1
- purpose 18.1.1
- requirements 7.3
- space management 12.3.3
  - estimating disk space requirement 5.4.2.3
- tuning performance 7.5.3
flashback database, and PITR for PDBs 18.1.3.1
flashback database, PDBs 18.4.4
FLASHBACK DATABASE command 18.4.2
flashback database window 7.1.2
Flashback Drop 18.1.2.3.2, 18.3.1
flashback logs 1.4.2, 2.8, 7.1.1, 12.3.3, 18.1.2.3.1
- guaranteed restore points and 7.1.5
flashback PDB, local undo 18.1.3.2
flashback PDB, shared undo 18.1.3.2
flashback PDB, using SQL*Plus 30.1.3
flashback retention target 7.1.1
Flashback Table 18.1.2.3.2
- using 18.2.1, 18.2.2
FLASHBACK TABLE statement 18.2.1, 18.2.2
Flashback Technology 18.1.2
- logical features 18.1.2.3.2
- overview 1.4
flashback undrop
- restoring objects 18.3.3
foreign data file 28.6.1
foreign data file copy 28.6.1
foreign tablespace 28.6.1
formats, for RMAN backups 9.2.3
fractured blocks 8.2
- detection 8.2
full backups 8.9
- incremental backups and 2.4.4

G

generic channels
- definition 5.1.4.1
groups, redo log 31.7.1, 31.7.2
guaranteed restore points 1.4.2, 5.4.2.1
- alternative to storage snapshots 7.1.5.1
- compared to storage snapshots 7.1.5.1
- creating 7.4.1
- flashback logs and 7.1.5
- requirements 7.3
- space usage in fast recovery area 7.4.5

H

Health Monitor 15.1.2.2
hot backup mode
- failed backups 29.4.2.3, 29.4.2.3.1
- for online user-managed backups 29.4.2.1

I

I/O errors
- effect on backups 10.7.1
image copies 2.4, 8.1, 8.4
- definition 8.4
- testing restore of 17.2.4
IMPORT CATALOG command 13.8.7
INCARNATION option
- LIST command 11.2.5, 13.8.5
- RESET DATABASE command 13.8.5
incarnations
- database 11.2.5, 14.3.2, 18.4.2, 18.6.2
INCLUDE CURRENT CONTROLFILE option
- BACKUP command 9.3.3.1
incomplete media recovery 30.4
incomplete recovery
- defined 18.5
- in Oracle Real Application Clusters configuration 30.2.2.2
- overview 14.3
- time-based 30.4.2
- with backup control file 30.2.2.2
inconsistent backups 8.1.2
- using RMAN 2.4.2, 8.1.1
inconsistent tablespaces
- transporting across platforms 28.10
incremental backups 2.4.4, 9.8
- block change tracking 9.8.5
- differential 8.9.1.1
- how RMAN applies 14.3.1
- making 9.8
- multisection incremental backups 9.2.6
- using RMAN 10.4.1, 10.4.2
initialization parameter file 14.3
initialization parameters
- CONTROL_FILES 20.3.1.1, 31.1.2
- DB_FILE_NAME_CONVERT 21.6.1.2
- DB_NAME 21.6.1.2
- LOG_ARCHIVE_DEST_n 30.2.3
- LOG_ARCHIVE_FORMAT 30.2.3
- LOG_FILE_NAME_CONVERT 21.6.1.2
instance failures
- backup mode and 29.4.2.3
instance recovery
- of CDBs 30.3.3
integrity checks 16.1.2
interpreting RMAN error stacks 24.1.5
interrupting media recovery 30.2.6

J

jobs, RMAN
- monitoring progress 23.3.1
- querying details about 11.5.1

K

KEEP option
- BACKUP command 12.4.2.2

L

level 0 incremental backups 2.4.4, 8.9.1, 8.9.2
level 1 incremental backups 8.9.1.1, 8.9.1.2
LIST command 2.5.1, 11.1.2, 11.2, 11.2.1
- FAILURE option 15.2
- INCARNATION option 13.8.5
listing
- dropped PDB backups 11.4.2.1
- preplugin backups 11.2.4
local undo, flashback PDB operations 18.1.3.2
LOG_ARCHIVE_DEST_n initialization parameter 5.4.4.3, 5.4.5, 17.2.5, 30.2.2, 30.2.3, 30.3.1, 30.4.1, 30.4.2
LOG_ARCHIVE_FORMAT initialization parameter 30.2.3
LOG_FILE_NAME_CONVERT initialization parameter 21.6.1.2
logical backups 1.1.1
logical block corruption 16.1.2.2
log sequence numbers 30.2.1
LOGSOURCE variable
- SET statement 30.2.4.2, 30.3.1, 30.3.2
long waits 23.3.2.2
loss of
- inactive log group 31.7.2.1
lost write protection
- enabling 6.7
lost writes, detecting 6.6

M

maintenance commands, RMAN 2.6, 3.3.2, 12.1.2
- Data Guard environment 12.1.2.2
managing RMAN metadata 11, 12
MAXPIECESIZE parameter
- SET command 5.2.5.1
MAXSETSIZE parameter
- BACKUP command 6.2.1, 10.1
- CONFIGURE command 6.2.1
media failures 1.1.2
- archived redo log file loss 30.4
- complete recovery 30.3
- complete recovery, user-managed 30.3
- control file loss 31.3
- datafile loss 30.2.1
- definition 1.1.2
- NOARCHIVELOG mode 30.5
- online redo log group loss 31.7.2
- recovery 30.3
- recovery procedures
  - examples 30.2.1
Media Management Layer (MML) API 3.5, 6.2.2
media managers 3.1, 3.3.1, 3.5, 3.5.2
- backing up files 3.5.1
- backup piece names 5.2.5.1
- Backup Solutions Program 3.5.3
- catalog 3.1
- configuring for use with RMAN 5.2.3
- crosschecking 12.4.1.1
- definition 2.1
- error codes 24.1.4.2
- file restrictions 5.2.5.1
- installing 5.2.1
- library location 5.2.2
- linking
  - testing 5.2.4
- linking to software 3.5.2, 5.2.2
- multiplexing backups 8.3.9
- prerequisites for configuring 5.2.1
- sbttest program 24.3.1
- testing 5.2.4.1, 5.2.4.2
- testing backups 5.2.4.2
- testing the API 24.3
- third-party 5.2
- troubleshooting 5.2.4.2
media recovery 8.9.4
- ADD DATAFILE operation 31.2.3
- after control file damage 31.1.1, 31.1.2
- applying archived redo logs 30.2.1
- cancel-based 30.4, 30.4.2
- complete 30.3
  - closed database 30.3.1
- complete, user-managed 30.3
- corruption
  - allowing to occur 30.6.4
- errors 30.6.1
- incomplete 30.4
- interrupting 30.2.6
- lost files
  - lost archived redo log files 30.4
  - lost data files 30.2.1
  - lost mirrored control files 31.1
- NOARCHIVELOG mode 30.5
- offline tablespaces in open database 30.3.2
- online redo log files 31.7
- parallel 30.2.7
- problems 30.6.1, 30.6.2, 30.6.3
- restarting 30.2.6
- restoring
  - whole database backups 30.5
- resuming after interruption 30.2.6
- roll forward phase 30.2.1
- scenarios 31
- time-based 30.4
- transportable tablespaces 31.6
- trial 30.6.6, 30.6.6.1
- troubleshooting 30.6.1
- user-managed 30
- using Recovery Manager 14.3
metadata, RMAN 3.4, 11, 12, 13
mirrored files
- backups using 10.5
- splitting 29.8.1
  - suspend/resume mode 29.8.1
  - using RMAN 10.5
monitoring fast recovery area usage 12.3.2
monitoring RMAN 24.2
MTTR 15.1.1
multiplexed backup sets 6.2.1, 8.3.9, 9.2.4.2, 23.2.1.1
multiplexed control files 5.4.1, 5.4.4, 12.2.3, 17.2.1.1, 29.1.1, 30.2.1, 31.1.1
multisection backups 3.3.2, 8.3.1, 8.3.7, 8.3.9, 10.1.3, 16.2
- views 9.2.6
multisection incremental backups 9.2.6
- example 9.2.6
multitenant container databases 4.2.5

N

naming
- duplicate database files 26.1.1.1
naming backup sets 8.3.6
NLS_DATE_FORMAT environment variable 4.4
NLS_LANG environment variable 4.4
NOARCHIVELOG mode
- backing up 9.3.5
- disadvantages 30.5
- recovery 30.5
non-CDBs
- preplugin backups 9.3.6

O

obsolete backups 8.10
- definition 8.10
- deleting 2.6.2, 8.10.3, 12.5.5
off-site backups 17.2.3.1
online redo logs 31.7.2.1
- active group 31.7.1, 31.7.2
- applying during media recovery 30.2.1
- archived group 31.7.1, 31.7.2
- clearing
  - failure 31.7.2.1.3
- clearing inactive logs
  - archived 31.7.2.1.1
  - unarchived 31.7.2.1.2
- configuring location 5.4.4
- current group 31.7.1, 31.7.2
- inactive group 31.7.1, 31.7.2
- loss of 31.7.2.1
  - active group 31.7.2.2.1
  - all members 31.7.2
  - group 31.7.2
  - recovery 31.7
- loss of group 31.7.2.2.1
- multiple group loss 31.7.2.3
- replacing damaged member 31.7.1
- status of members 31.7.1, 31.7.2
OPEN RESETLOGS clause
- ALTER DATABASE statement 13.8.5, 14.3.2.1, 18.4.2, 18.6.1
ORA-01578 error message 31.5
Oracle Advanced Compression option 6.2.5.2.2
Oracle Backup Solutions Program (BSP) 3.5.3
Oracle Cloud
- duplicating to 25.6
Oracle Data Pump 1.1.1, 18.4.2
Oracle Enterprise Manager Cloud Control
- about 1.6.1
- accessing the Database Home page 1.6.2
Oracle Flashback Database 1.4.2
Oracle Flashback Drop 1.4.1
Oracle Flashback Query 1.4.1
Oracle Flashback Table 1.4.1
Oracle Flashback Transaction 1.4.1
Oracle Flashback Transaction Query 1.4.1
Oracle Flashback Version Query 1.4.1
Oracle keystore 6.2.6.1.1
Oracle Managed Files
- fast recovery 5.4.1.1
Oracle Real Application Clusters (Oracle RAC)
- RMAN channels and 6.1.2
Oracle Secure Backup 3.5.2, 5.2
Oracle software keystore
- and backups 6.2.6.1.1
Oracle VSS writer 5.4.1
orphaned backups 14.3.2.4

P

packages
- DBMS_PIPE 4.6
password backup encryption 6.2.6.1.2
password-mode encryption 10.6.3
passwords
- connecting to RMAN 4.2.6
PDB restore points 7.1.6.2
PDB restore points, creating 7.4.3
PDB restore points, namespace 7.1.6.3
PDB restore points, viewing 7.4.5
PDBs 4.2.5
- about backup and recovery of 4.2.5.1
- about duplicating 25.5.3.1
- backing up, using Oracle Enterprise Manager Cloud Control 9.4.7
- backing up, using RMAN 9.4.5
- complete recovery
  - data files 17.4.6
  - tablespaces 17.4.6
  - using RMAN 17.4.3
- complete restore 17.4
- connecting to 4.2.5
- orphaned backups 14.3.2.5
- performing point-in-time recovery 18.5.3.2
- point-in-time recovery and fast recovery area 18.5.3
- preplugin backups 9.4.6
- recovering table partitions 22.4
- recovering tables 22.4
- reporting 11.4.2
- restrictions when connected to 4.2.5.2
- transporting across platforms 28.12.1
- user-managed backups 29.3
- validating 16.5.2
PDBs, clean PDB restore point 7.1.6.2
PDBs, flashback database and PITR 18.1.3.1
PDBs, flashback database operation 18.4.4
PDBs, restore points 7.1.6.2
PDBs, rewinding 18.4.4
performance tuning
- short waits
  - definition of 23.3.2.2
performance tuning, RMAN
- backup performance 23.4
- long waits 23.3.2.2
physical backups 1.1.1
physical block corruption 16.1.2.2
pipe interface, RMAN 4.6
PITR, for PDBs 18.1.3.1
pluggable databases 4.2.5
point-in-time recovery 30.4
- application PDBs 18.5.4
- of CDBs 18.5.3.1
- of PDBs 18.5.3.2
- performing
  - with current control file 18.5.2
- tablespace 18.1.2
point of recoverability
- recovery window 8.10.1
preplugin backups
- about 8.6
- example 9.4.9
- non-CDB 9.3.6
- PDBs 9.4.6
previewing backups 17.2.3
PREVIEW option, RESTORE command 11.1.2
PRINT SCRIPT command 13.7.6
proxy copies 3.5.1, 8.3.10
PROXY option
- BACKUP command 8.3.10

Q

QUIT command 2.2
quitting RMAN 2.2

R

raw devices
- backing up to 29.9
- UNIX backups 29.9.1
- Windows backups 29.9.2
RC_ARCHIVED_LOG view 11.6.1.1
RC_BACKUP_FILES view 11.6.3
RC_BACKUP_PIECE view 11.6.1
RC_BACKUP_SET view 12.5.1
read-only tablespaces
- backups 29.4.2.4
- transporting across platforms
  - using backup sets 28.8
  - using image copies 28.3
RECOVER clause
- ALTER DATABASE statement 30.2.4.2, 30.3.1, 30.3.2
RECOVER command 14.3
- COPY option 9.8.4
- FOREIGN DATAFILECOPY clause 28.10.1.3, 28.10.2
- PARALLEL and NOPARALLEL options 30.2.7
- TEST option 16.4
- unrecoverable objects and standby databases 31.5
- UNTIL TIME option 30.4.2
- USING BACKUP CONTROLFILE clause 31.2.4
recovering
- table partitions in PDBs 22.4
- tables in PDBs 22.4
recovering database file
- over the network 20.7.2
recovering database files
- over the network, example 20.7.5
- using physical standby 20.7.2
recovering files over the network
- scenarios 20.7.3
recovering table partitions
- example 22.5.2
- limitations 22.1.4
- overview 22.1
- prerequisites 22.2.1
- steps 22.3
recovering tables
- example 22.5.1
- limitations 22.1.4
- new schema 22.1.3.6
- overview 22.1
- prerequisites 22.2.1
- steps 22.3
recovery
- ADD DATAFILE operation 31.2.3
- automatically applying archived logs 30.2.2
- cancel-based 30.4.2
- complete 17.1, 30.3
  - CDBs 17.4.1
  - CDBs using Oracle Enterprise Manager Cloud Control 17.4.4
  - closed database 30.3.1
  - data files in PDBs 17.4.6
  - offline tablespaces 30.3.2
  - PDBs 17.4.3
  - root 17.4.2
  - tablespaces in PDBs 17.4.6
  - tablespaces in PDBs using Cloud Control 17.4.7
- corruption
  - intentionally allowing 30.6.4
- database
  - complete 17
  - in NOARCHIVELOG mode 20.1
- database, point-in-time 18, 18.5
- database files
  - how RMAN applies changes 14.3.1
  - overview 14.3
- data files 30.2.1
- disaster using RMAN 20.4
- dropped table 31.8
- errors 30.6.1
- failures requiring 1.1.2
- interrupting 30.2.6
- media 30, 30.6, 31
- multiple redo threads 30.2.2.2
- of lost or damaged recovery catalog 13.6.2
- online redo logs 31.7
  - loss of group 31.7.2
- parallel 30.2.7
- preparing for 17.2.1.2
- problems 30.6.1
  - fixing 30.6.3
  - investigating 30.6.2
- stuck 30.6.1
- third-party snapshots
  - example 30.2.5
- time-based 30.4.2
- transportable tablespaces 31.6
- trial 30.6.6
  - explanation 30.6.6.1
  - overview 30.6.6
- troubleshooting 30.6.1
- user errors 31.8
- user-managed 30, 30.6, 31
- using backup control file 20.3.1
  - without recovery catalog 20.3.2
- using logs in a nondefault location 30.2.4.1
- using logs in default location 30.2.3
- using logs in nondefault location 30.2.4.2
- using storage snapshots 30.2.5
- using third-party snapshots 30.2.5
- with Oracle Enterprise Manager Cloud Control 1.6.3
- without a recovery catalog 12.2.3
RECOVERY_CATALOG_OWNER role 13.5.3
Recovery Appliance
- backing up to 3.8.1
recovery catalog 3.4, 13.1
- backing up 13.6.1
- cataloging backups 12.4.3, 13.4
- centralization of metadata 13.1.2.2
- creating 13.2
- crosschecking 12.4.1.1
- DBID problems 13.1.2.1
- definition 2.1, 3.1
- deleting backups 12.5
- deleting records 12.5.3
- dropping 13.9
- log switch record 12.4.3
- managing size of 13.8.2.2.4
- operating with 3.4
- purpose of 13.1.1
- recovery of 13.6.2
- refreshing 13.8.2
- registering databases 13.1.2.1, 13.3.1, 13.3.2
- resynchronizing 13.8.2, 13.8.2.1
- space requirements 13.2.1.2
- stored scripts 13.7.1
  - creating 13.7.2
- synchronization 13.8.2.1
- unregistering databases 13.8.4
- updating
  - after operating system deletions 12.4.4.2
- upgrading 13.8.6, 13.8.6.1
- views, querying 11.6
- virtual private catalogs 3.4
recovery catalogs
- backing up 13.6.1
- dropping 13.9
- importing 13.8.7
- moving 13.8.7.5
Recovery Manager
- allocating tape buffers 23.2.3.1.1
- archived redo logs
  - backups 9.7
- backups 9.1.2
  - archived redo logs 9.7.1
  - backing up 9.10.1
  - batch deletion of obsolete 8.10.3
  - control files 9.3.3
  - data file 9.3.2, 9.10.2, 9.10.3
  - duplexed 8.7.1
  - image copy 8.4
  - incremental 9.8, 10.4.1, 10.4.2
  - optimization 5.6.1, 9.7.4
  - tablespace 9.10.2, 9.10.3
  - testing 16.1.2.4, 16.2, 16.3
  - validating 16.2, 16.3
  - whole database 9.3.1
- channels 3.3
  - naming conventions 3.3.2
- client 2.1
- connecting to databases 2.2
- corrupt data file blocks
  - handling I/O errors and 10.7.1
- crosschecking recovery catalog 12.4.1.1
- database character set 4.4
- database connections 4.2.1
  - auxiliary database 4.2.7
  - duplicate database 4.2.7
  - hiding passwords 4.2.6
  - SYSBACKUP or SYSDBA required for target 4.2.2
  - without a catalog 4.2
- DBMS_PIPE package 4.6
- definition 2.1
- disconnecting from 2.2
- error codes
  - message numbers 24.1.4.1
- errors 24.1, 24.1.4
  - interpreting 24.1.5
- file deletion 12.5.1.1
- fractured block detection in 8.2
- image copy backups 8.4
- incremental backups
  - cumulative 8.9.1.2
  - differential 8.9.1.1
  - level 0 8.9.1
- integrity checking 16.1.2
- jobs, monitoring progress 23.3.1
- jobs, querying details of 11.5.1
- lists 11.2
- maintenance commands 2.6
- media management
  - backing up files 3.5.1
  - Backup Solutions Program (BSP) 3.5.3
  - crosschecking 12.4.1.1
  - media manager, linking with a 5.2.2
- metadata 3.4, 11, 12, 13
- monitoring 24.2
- overview 2.1, 3.2
- performance
  - monitoring 24.2
- pipe interface 4.6
- proxy copy 3.5.1
- recovery
  - after total media failure 20.4
- recovery catalog 13.1
  - backing up 13.6.1
  - crosschecking 12.4.1.1
  - managing the size of 13.8.2.2.4
  - operating with 3.4
  - recovering 13.6.2
  - registration of target databases 13.1.2.1, 13.3.1, 13.3.2
  - resynchronizing 13.8.2
  - synchronization 13.8.2.1
  - upgrading 13.8.6.1
- reports 11.3.1
  - database schema 11.3.5
  - objects needing a backup 11.3.2
  - obsolete backups 11.3.4
- repository 3.4
- restoring
  - archived redo logs 17.2.5
- retention policies
  - configuring 5.5
- return codes 24.1.6
- setting time parameters 4.4
- snapshot control file location 6.4
- starting 2.2
- synchronous and asynchronous I/O 23.2.1.2, 23.2.1.3, 23.2.3.1.3
- terminating commands 24.4
- test disk API 5.2.4
- types of backups 8.4
- using RMAN commands 3.2
recovery window 5.5
- point of recoverability 8.10.1
RECOVERY WINDOW parameter
- CONFIGURE command 5.5.2
recovery windows
- configuring for retention policy 5.5.2
- definition 8.10.1
recycle bin 18.1.2.3.2, 18.3.2
- restoring objects from 18.3.3
redo logs
- incompatible format 30.6.1
- naming 30.2.3
- parallel redo 30.6.1
redo records
- problems when applying 30.6.1
REGISTER command 13.3.2
REPAIR FAILURE command 15.5.1, 15.6
repair failures
- in CDBs 15.1.4
repair options, Data Recovery Advisor 15.4
repairs, Data Recovery Advisor 15.1.2.1
- consolidation of 15.1.2.4.1
- manual and automatic 15.1.2.4
REPLACE SCRIPT command 13.7.3
REPORT command 2.5.2, 11.1.2, 11.3.1
- NEED BACKUP option 11.3.2
- OBSOLETE option 8.10.3
reporting
- in CDBs 11.4.1
- in PDBs 11.4.2
reports, RMAN 2.5, 11.1.2, 11.3.1
- backup jobs 11.5.1
- database schema 11.3.5
- files needing backups 11.3.2
- obsolete backups 11.3.4
- unrecoverable backups 11.3.4
repository, RMAN 3.4
RESET DATABASE command
- INCARNATION option 13.8.5
RESETLOGS operation
- when necessary 14.3.2.1
RESETLOGS option
- of ALTER DATABASE 30.5
restartable backups 10.7.1
RESTORE command 14.2, 17.2.1.2
- ALL FOREIGN DATAFILES clause 28.6.5
- BACKUPSET clause 28.6.4
- DATAPUMP clause 28.6.7
- DATAPUMP DESTINATION clause 28.10.1.3, 28.10.2
- DUMPFILE clause 28.6.4, 28.10.1.3, 28.10.2
- FORCE option 14.2.5
- FOREIGN DATABASE clause 28.6.5, 28.7.1
- FOREIGN DATAFILE clause 28.6.5, 28.10.2
- FOREIGN TABLESPACE clause 28.6.5, 28.8.1
- FROM BACKUPSET clause 28.10.1.3
- FROM PLATFORM parameter 28.6.4
- FROM SERVICE parameter 20.7.4
- NOIMPORT option 28.6.7
- PREVIEW option 11.1.2, 17.2.3
- VALIDATE HEADER option 11.1.2, 17.2.3
restore optimization 14.2.5
restore points 1.4.2, 2.8
- creating 7.4.1
- dropping 7.4.6
- flashing back to 18.6.2
- guaranteed 1.4.2, 7.1.5
  - compared to storage snapshots 7.1.5.1
- listing 7.4.4
- multitenant environment 7.1.6
- requirements 7.3
restore points, creating in CDBs 7.4.2
restore points, creating in PDBs 7.4.3
restore points, in CDBs 7.1.6.1
restore validation 17.2.4
restoring
- control files 20.3.1.1
  - to default location 31.1.1
  - to nondefault location 31.1.2
- database
  - to default location 30.5
- database files 14.2, 14.2.1, 14.2.5
- encrypted backups 14.2.3
- server parameter files 20.2
- testing 16.4, 17.2.4
- user-managed backups 30.2.1
restoring database file
- over the network 20.7.1
restoring database files
- over the network, example 20.7.4
restoring files over the network
- scenarios 20.7.3
restrictions
- PDBs 4.2.5.2
RESUME clause
- ALTER SYSTEM statement 29.8.2
resuming recovery after interruption 30.2.6
RESYNC CATALOG command 13.8.2, 13.8.2.3
- FROM CONTROLFILECOPY option 13.6.2
resynchronizing the recovery catalog 13.8.2, 13.8.2.3
- SET command
  - DBID option 3.7.1
return codes
- RMAN 24.1.6
REVOKE command 13.5.5
rewinding
- CDBs 18.4.3
RMAN 3
RMAN repository 1.2, 2.1
RMAN sessions 2.7.2, 3.3
root
- backing up
  - using Oracle Enterprise Manager Cloud Control 9.4.4
  - using RMAN 9.4.3
- complete recovery 17.4.2
- complete restore 17.4

S

SBT 3.3.1, 3.5.2, 5.2.5.2
sbttest program 24.3.1
scenarios, Recovery Manager
- NOARCHIVELOG backups 9.3.5
- recovering pre-resetlogs backup 18.6.3, 20.1
- recovery after total media failure 20.4
scripts, RMAN 2.4.7
- substitution variables in 9.9.3
server parameter files
- autobackups 8.8
- backups 9.3.4
- configuring autobackups 5.1.5, 5.1.5.1, 8.8
- restoring 20.2
server sessions, Recovery Manager 3.3
session architecture, Recovery Manager 3.3
SET command
- ENCRYPTION option 6.2.6.1.2
- MAXCORRUPT option 16.1.2.3
SET statement
- AUTORECOVERY option 30.2.2
- LOGSOURCE variable 30.2.4.2, 30.3.1, 30.3.2
shadow copies 9.8.3.1
shared server
- configuring for use with RMAN 6.5
- configuring RMAN 6.5
shared undo, flashback PDB operations 18.1.3.2
short waits
- definition 23.3.2.2
SHOW command 2.3, 5.1.1
SHUTDOWN statement
- ABORT option 30.5, 31.1.1, 31.1.2
size of backup sets, setting 8.3.7
skipping files in RMAN backups 10.3
snapshot control file
- specifying location 6.4
- specifying location in Oracle Real Application Clusters environment 6.4.2
snapshot control files 6.4, 13.8.2.1
snapshots
- backing up using third-party technologies 29.10
- using Storage Snapshot Optimization 29.10
sparse backups 8.5
sparse CDBs
- duplicating 25.5.2
sparse databases
- duplicating 25.4.4
sparse data files
- backing up 9.6.2
sparse PDBs
- backing up 9.6.4
- duplicating 25.5.3.5
sparse tablespaces
- backing up 9.6.2
split mirrors
- suspend/resume mode 29.8.1
- using as backups 10.5
SPOOL command 15.5.1
standby databases 3.1
statements, SQL
- ALTER DATABASE 30.2.4.2, 30.3.1, 30.3.2
status
- dropped PDB backups 12.4.2.3
Storage Snapshot Optimization 29.10
storage snapshots 7.1.5.1, 29.10, 30.2.5
- recovering 30.2.5
stored scripts 3.4, 9.9.3, 13.1.2.4, 13.7.1, 13.8.7.1
- creating RMAN 13.7.2
- deleting 13.7.8
- dynamic 13.7.5
- executing 13.7.9
- listing names of 13.7.7
- managing 13.7.1
- printing 13.7.6
- substitution variables in 13.7.5
stuck recovery 30.6.1
substitution variables, FORMAT parameter 5.2.5.1, 8.3.6, 8.4.1
substitution variables, stored scripts 13.7.5
suspend/resume mode 29.8.1
SUSPEND clause
- ALTER SYSTEM statement 29.8.2
suspending a database 29.8.1
SWITCH command 17.3.4
SYSBACKUP privilege 4.2.2.2
system backup to tape 3.5.2
system time
- changing
  - effect on recovery 30.4.2

T

tables, recovery of dropped 31.8
tablespace point-in-time recovery 18.1.2
- performing on dropped tablespaces 21.1.1
- planning 21.3
- preparing the auxiliary instance 21.6.1
- restrictions 21.2.2
- why perform 21.1.1
tablespaces
- backups 9.10.2, 9.10.3, 29.4.2.2
  - offline 29.4.1
  - online 29.4.2.2
- backups, in PDBs 9.4.8
- backups using RMAN 9.3.2
- excluding from backups 6.2.4
- excluding from RMAN backups 6.2.4
- read/write
  - backing up 29.4.2.1
- read-only
  - backing up 29.4.2.4
- recovering accessible
  - when database is open 17.3.3
- recovering in PDBs
  - using Cloud Control 17.4.7
- recovering offline in open database 30.3.2
- transporting across platforms, in PDBs 28.12.5
- transporting with RMAN 27
- user-managed backups, in CDBs 29.5
- user-managed backups, in PDBs 29.5
tape devices 3.5.2
target database
- connecting to 2.2
- definition 2.1, 3.1
terminating RMAN commands 24.4
test disk API 5.2.4
testing RMAN
- backups 16.1.2.4, 16.2, 16.3
- with media management API 24.3
third-party snapshots
- specifying recovery time 30.2.5
time-based recovery 30.4.2
time format
- RECOVER DATABASE UNTIL TIME statement 30.4.2
time parameters
- setting for Recovery Manager use 4.4
trace files, RMAN 24.1.1
transparent backup encryption 6.2.6.1.1
transparent-mode backup encryption 10.6.2
transportable tablespaces
- creating with RMAN 27.1.1
  - and Data Pump Export 27.5.2
  - and past points in time 27.5.1
  - auxiliary destination 27.1.2
  - auxiliary instance parameter file 27.2, 27.2.2
  - file locations 27.5.3
  - initialization parameters 27.2.1
- cross-platform 28
- recovery 31.6
transporting tablespaces 27
trial recovery 16.4, 30.6.6, 30.6.6.1
tuning Recovery Manager
- V$ views 24.2

U

UNAVAILABLE option
- of CHANGE 12.4.2.1
UNCATALOG option
- CHANGE command 12.4.4.1
- deleting repository records 12.4.4.1
undo optimization, backup 5.6.1, 8.3.4
unrecoverable objects
- recovery 31.5
UNREGISTER DATABASE command 13.8.4
unregistering databases 13.8.4
UNTIL TIME option
- RECOVER command 30.4.2
upgrading
- virtual private catalog 13.5.6
upgrading the recovery catalog 13.8.6.1
user errors
- definition 1.1.2
- recovery from 31.8
user-managed backups 29, 29.2
- backup mode 29.4.2.1, 29.4.2.3
- control files 29.6
- definition 8.4.2
- determining data file status 29.1.2
- hot backups 8.2, 29.4.2.3.1
- listing files before 29.1
- of CDBs 29.3
- offline tablespaces 29.4.1
- of PDBs 29.3
- read-only tablespaces 29.4.2.4
- tablespaces 29.4.2.2
- tablespaces in CDBs 29.5
- tablespaces in PDBs 29.5
- verifying 29.11
- whole database 29.2
user-managed recovery 30.4
- ADD DATAFILE operation 31.2.3
- complete 30.3
- incomplete 30.4
- interrupting 30.2.6
- scenarios 31
user-managed restore operations 30.2.1

V

V$ARCHIVED_LOG view 5.4.2.3, 11.6.1.1, 18.5.2, 18.5.5
- listing all archived logs 29.7
V$BACKUP_ASYNC_IO view 23.3.2
V$BACKUP_DATAFILE view 9.8.2, 12.4.3.3
V$BACKUP_FILES view 5.5.2, 12.4.1.1, 12.4.3.2
V$BACKUP_PIECE view 11.6.1, 12.4.3.3
V$BACKUP_REDOLOG view 12.4.3.3
V$BACKUP_SET view 12.4.3.3, 12.5.1
V$BACKUP_SPFILE view 12.4.3.3
V$BACKUP_SYNC_IO view 23.3.2
V$BACKUP view 29.1.2
V$BLOCK_CHANGE_TRACKING view 9.8.5.4
V$CONTROLFILE view 9.3.3
V$DATABASE_BLOCK_CORRUPTION view 1.3, 2.9.4, 16.1.2.4, 16.2, 19, 19.1.2, 19.1.2.2, 19.4
V$DATABASE_INCARNATION view 13.8.5
V$DATABASE view 11.6.2, 18.2.2, 18.6.1
V$DATAFILE_HEADER view 11.1.2, 17.2.1.2.2
V$DATAFILE view 17.2.1.2.2, 21.6.1.2, 29.1.1
- listing files for backups 29.1
V$DIAG_INFO view 19.3.1
V$EVENT_NAME view 24.2.1
V$FLASHBACK_DATABASE_LOG view 5.4.2.3, 18.4.2, 18.6.1
V$FLASHBACK_DATABASE_STAT view 7.5.4
V$INSTANCE view 17.2.1.2.2
V$LOG_HISTORY view
- listing all archived logs 30.3.1
V$LOGFILE view 21.6.1.2, 31.7.1, 31.7.2
V$PARAMETER view 18.2.2
V$PROCESS view 11.1.2, 24.2.2
V$RECOVER_FILE view 17.2.1.2.2, 30.3.1
V$RECOVERY_AREA_USAGE view 12.3.2
V$RECOVERY_FILE_DEST 12.3.2
V$RECOVERY_FILE_DEST view 12.3.2
V$RECOVERY_LOG view
- listing logs needed for recovery 30.3.1
V$RESTORE_POINT 7.4.5
V$RESTORE_POINT view 18.2.2
V$RMAN_BACKUP_JOB_DETAILS view 11.5.1
V$RMAN_BACKUP_SUBJOB_DETAILS view 11.5.1
V$RMAN_ENCRYPTION_ALGORITHMS view 6.2.6.1, 6.2.6.3, 23.2.2
V$RMAN_OUTPUT view 11.6.2
V$RMAN_STATUS view 24.1.1
V$SESSION_LONGOPS view 23.3.1
V$SESSION_WAIT view 24.2.1
V$SESSION view 6.5, 11.1.2, 24.2.2
V$SGASTAT view 23.4.3
V$SYSSTAT view 7.5.4
V$TABLESPACE view 17.2.1.2.2, 29.1.1
VALIDATE command 15.1.2.2, 15.3, 16.2
- SECTION SIZE parameter 16.2
VALIDATE HEADER option, RESTORE command 11.1.2
validating
- CDBs 16.5.1
- PDBs 16.5.2
validation, RMAN 15.3
- backups 2.4.6, 16.2, 16.3
- database files 2.4.6, 16.2
- restore operations 17.2.4
viewing, CDB restore points 7.4.5
viewing, PDB restore points 7.4.5
views
- for multisection backups 9.2.6
views, recovery catalog 11.1.2, 11.6
virtual private catalogs 3.4
- creating 13.5.3
- upgrading 13.5.6
Volume Shadow Copy Service (VSS) 5.4.1, 9.8.3.1

W

whole database backups
- ARCHIVELOG mode 29.2
- inconsistent 29.2
- NOARCHIVELOG mode 29.2
- preparing for 29.2
- using RMAN 9.3.1

Z

Zero Data Loss Recovery Appliance 1.7