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 36.5, 37.1.1, 37.1.2
about
- backing up CDBs 4.2.4
- backing up PDBs 4.2.4
about, flashback database for PDBs 17.1.4.1.1
active database duplication 4.2.7
Advanced Security Option 8.3.5
alert log 12.2.2
algorithm AES-XTS 6.2.6.1
algorithm encryption ((
- AES-CFB) 6.2.6.1
- AES-XTS 6.2.6.1
ALLOCATE CHANNEL command 5.5.1, 6.1.1, 9.2.3.1
- MAXPIECESIZE option 6.2.2
ALLOW ... CORRUPTION clause, RECOVER command 36.6.5
ALTER DATABASE statement
- CLEAR LOGFILE clause 37.7.2.1.3
- END BACKUP clause 35.3.2.3.1
- OPEN RESETLOGS clause 13.8.5
- RECOVER clause 36.2.4.2, 36.3.1, 36.3.2
- RESETLOGS option 36.5
ALTER SYSTEM statement
- KILL SESSION clause 23.4.1
- RESUME clause 35.6.2
- SUSPEND clause 35.6.2
ALTER TABLESPACE statement
- BEGIN BACKUP clause 35.3.2.1, 35.3.2.2.2
- END BACKUP option 35.3.2.2.2
application containers
- about backing up 9.4.1
- backing up 9.4, 9.4.3
- complete recovery 16.5.2
application errors 1.1.2
application PDBs
- backing up 9.4.4
- complete recovery 16.5.3
- point-in-time recovery 17.6
application root
- backing up 9.4.2
- complete recovery 16.5.1
archival backups 1.1.3, 9.8.1, 12.4.2.2
archived redo log deletion policies 5.13.1, 5.13.2, 9.6.3
archived redo log files
- applying during media recovery 36.2.1, 36.2.3, 36.2.4.2
- backing up 9.6.2
  - using RMAN 9.6
  - with other backups 9.6.1.2
- cataloging 12.4.3
- changing default location 36.2.4.1
- corrupted 36.6.1
- delete after backups 9.6.4
- deleting 14.3.1, 36.3.1
- deletion after backup 9.6.1
- failover 9.6.1.1
- incompatible format 36.6.1
- location during recovery 36.2.1
- loss of 36.4
- restoring using RMAN 16.2.5
ARCHIVELOG mode
- backups in 2.4.2
AS SELECT clause
- CREATE TABLE statement 37.5
Audit Trail, RMAN
- monitoring audit records 22.3.3
autobackups, control file 8.8, 9.3.8, 9.8.2
- configuring 5.6
- format 5.6.1
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.7.5.1, 8.8.2, 12.2.1, 15.1.2.2, 15.1.2.4, 23.1.1
Automatic Storage Management (ASM)
- backups to 9.2.3
Automatic Workload Repository (AWR) 7.5.4
AUTORECOVERY option
- SET statement 36.2.2
auxiliary instance parameter file
- with TRANSPORT TABLESPACE 26.2
availability
- of RMAN backups 12.4.2.1
AVAILABLE option
- of CHANGE command 12.4.2.1
Azure Backup 32.3.3
Azure Cloud Backup Module 32.3.3

B

backing up
- application containers 9.4.3
- application PDBs 9.4.4
- application root 9.4.2
- database 9
- data files in PDBs 9.3.7
- sparse PDBs 9.5.3
- tablespaces in PDBs 9.3.7
- with Oracle Enterprise Manager Cloud Control 1.5.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 24.3.1.1
BACKUP command 2.4, 2.4.2, 2.4.3, 3.3.2, 3.7.2.3, 5.10.4, 5.12.1, 6.1.1, 6.2.1, 6.2.4, 8.1, 8.3, 9.1.2, 9.6.3
- ALLOW INCONSISTENT option 27.8.2.3.1
- ARCHIVELOG option 9.6.1.2, 9.6.2
- 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.9.1, 9.9.2
- CHANNEL option 5.5.3
- COMPRESSED BACKUPSET option 9.2.5
- COPIES parameter 8.7, 8.7.1
- COPY OF option 8.7, 8.7.2.2, 9.9.1, 9.9.3
- CURRENT CONTROLFILE option 9.3.8, 9.3.8.2
- DATABASE option 9.3.1
- DATAFILE option 9.3.6
- DATAPUMP option 27.6.4.2, 27.8.1, 27.8.2.4
- DB_FILE_NAME_CONVERT parameter 8.4.1
- DELETE INPUT option 9.6.4, 12.5.1.1
- DELETE option 9.6.1
- DEVICE TYPE clause 5.3, 5.12.1, 9.2.1, 9.3.8.2
- DURATION parameter 10.8.2
- FILESPERSET parameter 8.3.9
- FORMAT parameter 2.4.1, 5.7.4, 5.7.6.1, 8.3.6, 8.7.1, 9.2.3
- FOR RECOVER OF COPY option 9.7.4.1
- FOR TRANSPORT parameter 27.6.4.1, 27.7.2
- INCREMENTAL LEVEL 1 parameter 27.8.2.3.1, 27.8.2.4
- INCREMENTAL LEVEL O parameter 27.8.2.3.1, 27.8.2.4
- INCREMENTAL option 2.4.4, 2.4.5, 9.7, 9.7.3, 9.7.3.1
- KEEP option 9.8.1, 9.8.3.1, 9.8.4
- MAXSETSIZE parameter 10.1
- NOT BACKED UP clause 9.6.3
- PLUS ARCHIVELOG option 9.6.1.2
- PROXY ONLY option 8.3.10
- PROXY option 8.3.10
- RECOVERY AREA option 9.9.1
- SECTION SIZE parameter 8.3.1, 9.2.6, 10.1.3
- SPFILE option 9.3.9
- TABLESPACE option 9.3.6
- TAG parameter 2.4.1, 9.2.4.1
- TO PLATFORM parameter 27.6.4.1
- VALIDATE option 2.4.6, 15.2
BACKUP CONTROLFILE clause
- ALTER DATABASE statement 35.1.1
BACKUP COPIES parameter
- CONFIGURE command 6.2.3
backup encryption 6.2.6.1, 8.3.5, 14.2.3
- decrypting backups 16.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 35.3.2.3.1
- for online user-managed backups 35.3.2.1
- instance failure 35.3.2.3
backup optimization 9.6.3
- configuring 5.12, 10.2
- definition 5.12.1, 9.6.3
- disabling 5.12.1, 5.12.3
- enabling 5.12.1, 5.12.3
- redundancy and 5.12.2.2
- retention policies and 5.12.2
backup pieces 8.3.1
- definition 2.4
- maximum size 6.2.2
- names 8.3.6
- names on tape 5.7.6.1
backup retention policies 1.1.3, 3.6, 5.10.1
- affect on backup optimization 5.12.2
- configuring 5.11
- configuring for redundancy 5.11.1
- definition 8.10
- disabling 5.11.3
- exempt backups 9.8.1, 12.4.2.2
- recovery window 8.10
- recovery windows 5.11.2
- redundancy 8.10, 8.10.2
backups
- archival 1.1.3, 9.8.1
- archived redo logs
  - using RMAN 9.6
- availability 12.4.2.1
- backup sets 9.9.1
- consistent
  - making using RMAN 8.1.1
- control file 9.3.8, 35.4
- control files 35.4
  - binary 35.4.1
- correlating RMAN channels with 23.2.2.2.1, 23.2.2.2.2
- crosschecking 12.4.1
- cumulative incremental 8.9.1.2
- data file
  - using RMAN 9.9.2, 9.9.3
- DBVERIFY utility 35.8
- default type for RMAN 5.4
- determining data file status 35.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
  - making using RMAN 8.1.1
- incremental 8.9.1.1, 9.7, 10.4.1, 10.4.2
- incrementally updated 9.7.4
- listing files needed 35.1
- logical 1.1.1
- long-term 1.1.3
- managing 12.1.1
- multisection 3.3.2, 8.3.1, 15.2
- NOARCHIVELOG mode 9.3.10
- obsolete 8.10.3, 12.5.5
- offline 35.3.1
- offsite 16.2.3.1
- optimizing 5.12.1, 9.6.3
- orphaned 14.3.2.4
- PDBs, using Oracle Enterprise Manager Cloud Control 9.3.5
- PDBs, using RMAN 9.3.4
- physical 1.1.1
- previewing 16.2.3
- read-only tablespaces 35.3.2.4
- recovering pre-RESETLOGS 17.8.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 36.2.1
- root
  - using Oracle Enterprise Manager Cloud Control 9.3.3
  - using RMAN 9.3.2
- server parameter files 9.3.9
- skipping files during 10.3
- split mirror 8.4.2
  - using RMAN 10.5
- stored scripts 13.1.2.4, 13.7.1
- tablespace 35.3.2.2
  - using RMAN 9.3.6, 9.9.2, 9.9.3
- testing RMAN 15.1.2.4, 15.2, 15.3
  - using media manager 5.7.5.2
- user-managed 35
- validating 15.2, 15.3
- verifying 35.8
- whole CDB 9.3.1
- whole database 9.3.1
backup sets 2.4, 8.1
- backing up 8.7.2.1, 9.9.1
- backups
  - backups of 8.7.2.1
- compressed 5.4, 6.2.5, 9.2.5
- configuring as default 5.4
- 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, 22.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 16.2.4
Backup Solutions Program (BSP) 3.5.3
backup strategy
- fast recovery area 5.10
backup tags, RMAN 9.2.4
backup techniques, comparison 1.2
backup windows 10.8.1
BEGIN BACKUP clause
- ALTER TABLESPACE statement 35.3.2.1
binary compression for backups 9.2.5
block change tracking 1.1.1, 8.9.2, 9.7.6
- disk space used for 9.7.6.1.3
- enabling and disabling 9.7.6.2, 9.7.6.3
- moving the change tracking file 9.7.6.5
block corruptions 1.1.2
- stored in V$DATABASE_BLOCK_CORRUPTION 15.2
block media recovery 1.1.2, 15.1.2.4
- automatic 18.1.2
BSP 3.5.3

C

cancel-based media recovery 36.4.2
canceling RMAN commands 23.4
CATALOG command 12.4.3
- START WITH parameter 13.4
CDB, rewinding 17.4.2
CDB restore point 7.1.6.1
CDB restore points, creating 7.4.1
CDB restore points, viewing 7.4.4
CDBs
- about backup and recovery of 4.2.4
- backing up 9.3.1
- complete recovery 16.3.2
  - using Oracle Enterprise Manager Cloud Control 16.3.6
- complete restore 16.3
- connecting to 4.2
- crash recovery 36.3.3
- instance recovery 36.3.3
- performing point-in-time recovery 17.5.2
- user-managed backups 35.2
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
channels, RMAN 3.3
- configuring 5.5
- configuring advanced options 6.1
- definition 3.3
- generic 5.5.1
- naming conventions 3.3.2
- Oracle RAC environment 6.1.2
- parallel 5.5.3
character sets
- setting for use with RMAN 4.5
circular reuse records 12.2.1
clean PDB restore points 7.1.6.2
CLEAR LOGFILE clause
- of ALTER DATABASE 37.7.2.1.3
client, RMAN 2.1, 3.1, 3.5
Cloud computing 33.1
command files, RMAN 2.4.7
command interface
- RMAN 3.2
commands, Recovery Manager
- ALLOCATE CHANNEL 5.5.1, 6.1.1, 6.2.2, 9.2.3.1
- BACKUP 2.4, 2.4.1, 2.4.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.3, 5.5.3, 5.7.4, 5.7.6.1, 5.10.4, 5.12.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.1.2, 9.2.1, 9.2.5, 9.3.1, 9.3.6, 9.3.8, 9.3.8.2, 9.3.9, 9.6.1, 9.6.1.2, 9.6.3, 9.6.4, 9.7, 9.7.3, 9.7.3.1, 9.7.4.1, 9.8.1, 9.8.3.1, 9.8.4, 9.9.1, 9.9.2, 9.9.3
  - PROXY ONLY option 8.3.10
  - PROXY option 8.3.10
- BACKUP CURRENT CONTROLFILE 9.3.8.2
- canceling 23.4
- CATALOG 12.4.3
- CHANGE 3.7.2.2, 12.4.1
- CONFIGURE 3.7.1, 5.5.1, 5.11, 5.14, 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
  - INCARNATION option 11.2.6, 13.8.5
- MAXSETSIZE 6.2.1
- piping 4.8
- PRINT SCRIPT 13.7.6
- RECOVER 14.3
- 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 16.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.2
- SWITCH 16.3.9
- terminating 23.4
- UNREGISTER DATABASE 13.8.4
- UPGRADE CATALOG 13.8.6.1, 13.8.6.4, 13.8.6.4.2, 13.8.6.4.3
- VALIDATE 15.2
commands, RMAN maintenance mode
- UPGRADE CATALOG 13.8.6.4.4
commands, SQL*Plus
- RECOVER
  - UNTIL TIME option 36.4.2
- SET 36.2.2, 36.2.4.2, 36.3.1, 36.3.2
comments in RMAN syntax 4.4.3
COMPATIBLE initialization parameter 6.2.6.1
complete recovery
- application containers 16.5.2
- application PDBs 16.5.3
- application root 16.5.1
- overview 16.1
- procedures 36.3
- sparse databases 16.6.2
- using preplugin backups 16.4.2
compressed backups 5.4, 9.2.5
- algorithms 6.2.5
configuration parameters
- OSB Cloud Module 33.4
CONFIGURE command
- AUXNAME option 6.3
- BACKUP OPTIMIZATION option 5.12.3
- CHANNEL option 5.5.1, 6.1.1
- CONTROLFILE AUTOBACKUP option 8.8.1, 9.8.2
- DB_UNIQUE_NAME option 5.14
- 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.11
configuring media managers 5.7.4
- installing 5.7.2
- prerequisites 5.7.2
configuring Recovery Manager
- autobackups 5.6, 5.6.1, 8.8
- backup optimization 5.12
- backup retention policies 5.11
- backup set size 6.2.1
- default backup type 5.4
- default devices 5.3
- 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
- to PDBs 4.2
consistent backups 8.1.1
- using RMAN 8.1.1
CONTROL_FILE_RECORD_KEEP_TIME initialization parameter 12.2.1, 12.2.2
CONTROL_FILES initialization parameter 19.3.1.1, 20.6.1.2, 37.1.2
control file autobackups 12.2.3
- after structural changes to database 8.8
- configuring 5.6, 5.6.1, 8.8
- default format 8.8.2
- format 5.6.1
control files
- backups 35.1.1, 35.4
  - binary 35.4.1
  - including within database backup 9.3.8.1
  - manual 9.3.8.2
  - recovery using 19.3.1
  - using RMAN 9.3.8
- circular reuse records 12.2.1
- configuring location 5.9
- creating after loss of all copies 37.3
- finding file names 35.1.1
- multiplexed 5.9, 5.10.1, 12.2.3, 16.2.1.1, 35.1.1, 36.2.1, 37.1.1
  - loss of 37.1
- multiplexing 12.2.3
- re-created 37.3
- restoring 19.3.1.1, 37.1.1, 37.1.2
- snapshot 13.8.2.1
  - specifying location of 6.4
- user-managed restore after loss of all copies 37.3
CONVERT command
- ALLOW INCONSISTENT option 27.8.2.3.1
COPIES option
- BACKUP command 10.4.2
corrupt blocks 15.1.2.1, 36.6.1
- recovering 18.1.2.2
- RMAN and 10.7.1
crash recovery
- of CDBs 36.3.3
CREATE CATALOG command 13.2.3
CREATE DATAFILE clause, ALTER DATABASE statement 37.4
CREATE SCRIPT command 13.7.2
CREATE TABLESPACE statement 37.2.3
CREATE TABLE statement
- AS SELECT clause 37.5
creating
- virtual private catalogs 13.5.3
creating, PDB restore points 7.4.2
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 27.6.1
cross-platform transport
- databases
  - using backup sets 27.7.2
  - using image copies 27.5
- data files, using image copies 27.4
- inconsistent tablespaces 27.8.2
  - about 27.8.2.1
  - example 27.8.2.4
  - steps 27.8.2.3
- methods 27.1.2, 28.1.1
  - using backup sets 27.6
  - using image copies 27.2
- of PDBs 27.7.1
- over the network 27.9
- PDB to a new CDB 27.7.3, 27.7.4
- read-only tablespaces
  - using backup sets 27.8.1
  - using image copies 27.3
- tablespaces, DataPump export dump file 27.6.4.2
- tablespaces in PDBs 27.8.3
cross-platform transportable tablespace 27, 28.1
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.8
  - without a catalog 4.2
- SYSBACKUP required for RMAN 4.2.2
- types in RMAN 4.2.1
Database Home page, accessing 1.5.2
database point-in-time recovery 17, 17.5
- definition 17.1.3
- Flashback Database and 7.1.1
- prerequisites 17.5.1
- user-managed 36.4
databases
- listing for backups 35.1
- media recovery procedures, user-managed 36
- media recovery scenarios 37
- recovery
  - after control file damage 37.1.1, 37.1.2
- registering in recovery catalog 13.3.2
- reporting on schemas 11.3.5
- suspending 35.6.1
- transporting across platforms
  - using backup sets 27.7.2
  - using image copies 27.5
- unregistering from recovery catalog 13.8.4
data blocks, corrupted 1.1.1, 1.1.2, 2.8.4, 15.2, 18.1.1, 36.6.1
data dictionary views 35.3.2.1, 35.3.2.4
data files
- backing up 9.3.6, 9.9.2, 9.9.3, 35.3.1
- backing up, in PDBs 9.3.7
- determining status 35.1.2
- listing 35.1
- losing 36.2.1
- restoring 14.2
- transporting across platforms 27.4
Data Guard environment
- archived log deletion policies 5.13.1.2
- changing a DB_UNIQUE_NAME 13.8.3
- configuring RMAN 5.14
- 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.8
- RMAN usage 3.7
data preservation, definition of 1.1.3
data protection, definition 1.1.1
data pump destination 27.6.1
data repair
- overview 14.1.1
- techniques 14.1.2
data transfer, RMAN 1.1.4
data transport
- using recovery catalog 28.2.4.1, 28.2.4.3
DB_BLOCK_CHECKSUM initialization parameter 15.1.2.1
DB_CREATE_FILE_DEST initialization parameter 9.7.6.2
DB_FILE_NAME_CONVERT initialization parameter 20.6.1.2
DB_FLASHBACK_RETENTION_TARGET initialization parameter 5.10.2.1
DB_LOST_WRITE_PROTECT initialization parameter 6.6
DB_NAME initialization parameter 20.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.14, 11.1.3
DBA_DATA_FILES view 35.3.2.1, 35.3.2.4
DBID
- determining 16.2.2
- problems registering copied database 13.1.2.1
DBMS_PIPE package 4.8
DBPITR 17.5
DBVERIFY utility 35.8
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.6.4
- 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.13.1
- enabling 5.13.2
devices, configuring default 5.3
differential incremental backups 2.4.4, 8.9.1, 8.9.1.1
direct ancestral path 14.3.2.2, 17.8.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.7.5
disk failures 1.1.2
disk usage
- monitoring 12.3.2
DROP DATABASE command 12.6
dropped tables, retrieving 17.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
- Using Cloud Backups 24.3.2.1
duplicate databases
- active database duplication 4.2.7
duplicating
- Cloud database to on-premises 24.7
- configuring channels 24.3.1
- PDBs 24.9.7
- preparing auxiliary instance 24.3.3
- sparse CDBs 24.4.6.1
- sparse PDBs 24.4.6.2
- tablespaces 24.4.2
duplicating a PDB
- to existing CDBs 24.4.3.3, 24.4.3.4
duplicating databases
- initialization file 24.3.3.2
- Oracle keystore 24.3.3.6
- preparing 24.3
duplicatingOracle Cloud
- to 24.6
duplicating PDBs
- to new CDB 24.4.3.5
duplication
- SET NEWNAME 25.1.1.1
- using encrypted backups 24.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 24.9.9
- decrypting 16.2.6
environment variables
- NLS_DATE_FORMAT 4.5
- NLS_LANG 4.5
error codes
- media manager 23.1.4.2
- RMAN 23.1, 23.1.4, 23.1.4.1
error messages, RMAN
- interpreting 23.1.5
error stacks, RMAN
- interpreting 23.1.5
example
- duplicating databases 24.10
- multisection incremental backups 9.2.6
- recovering tables into new schema 21.5.3
- recovery using preplugin backups 16.4.3
examples
- preplugin backups 9.3.12.1
- rolling forward a physical standby 19.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
fast recovery area 3.1, 3.6, 17.1.4.1
- autobackups 5.6.1
- changing locations 12.3.5
- configuring 5.10
- definition 2.1
- disabling 12.3.6
- effect of retention policy 8.10.4
- enabling 5.10.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.10.1.1
- permanent and impermanent files 5.10.1
- RMAN files in 5.10.4
- setting location 5.10.2.2
- setting size 5.10.2.1
- snapshot control files 6.4
- space management 5.10.1.2
file names, listing for backup 35.1
file sections 8.3.7, 8.3.9, 10.1.3, 15.2
flashback CDB 17.4.2
flashback CDB, using SQL*Plus 36.1.1
flashback data archive
- definition 1.4.1
Flashback Database 1.4.2, 2.7, 14.1.2, 17
- 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 17.4.1
- purpose 17.1.1
- requirements 7.3
- space management 12.3.3
  - estimating disk space requirement 5.10.2.3
- tuning performance 7.5.3
flashback database, and PITR for PDBs 17.1.2.1
flashback database, PDBs 17.4.3
flashback database window 7.1.2
Flashback Drop 17.1.4.2, 17.3.1
flashback logs 1.4.2, 2.7, 7.1.1, 12.3.3, 17.1.4.1
- guaranteed restore points and 7.1.5
flashback PDB, local undo 17.1.4.3
flashback PDB, shared undo 17.1.4.3
flashback PDB, using SQL*Plus 36.1.2
flashback retention target 7.1.1
Flashback Table 17.1.4.2
- using 17.2.1, 17.2.2
FLASHBACK TABLE statement 17.2.1, 17.2.2
Flashback Technology 17.1.2
- logical features 17.1.4.2
- overview 1.4
flashback undrop
- restoring objects 17.3.3
foreign data file 27.6.1
foreign data file copy 27.6.1
foreign tablespace 27.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.5.1
groups, redo log 37.7.1, 37.7.2
guaranteed restore points 1.4.2, 5.10.2.1
- alternative to storage snapshots 7.1.5.1
- compared to storage snapshots 7.1.5.1
- flashback logs and 7.1.5
- requirements 7.3
- space usage in fast recovery area 7.4.4

H

hot backup mode
- failed backups 35.3.2.3, 35.3.2.3.1
- for online user-managed backups 35.3.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 16.2.4
IMPORT CATALOG command 13.8.7
INCARNATION option
- LIST command 11.2.6, 13.8.5
- RESET DATABASE command 13.8.5
incarnations
- database 11.2.6, 14.3.2, 17.8.2
INCLUDE CURRENT CONTROLFILE option
- BACKUP command 9.3.8.1
incomplete media recovery 36.4
incomplete recovery
- defined 17.5
- in Oracle Real Application Clusters configuration 36.2.2.2
- overview 14.3
- time-based 36.4.2
- with backup control file 36.2.2.2
inconsistent backups 8.1.2
- using RMAN 2.4.2, 8.1.1
inconsistent tablespaces
- transporting across platforms 27.8.2
incremental backups 2.4.4, 9.7
- block change tracking 9.7.6
- differential 8.9.1.1
- how RMAN applies 14.3.1
- making 9.7
- multisection incremental backups 9.2.6
- using RMAN 10.4.1, 10.4.2
initialization parameter file 14.3
initialization parameters
- CONTROL_FILES 19.3.1.1, 37.1.2
- DB_FILE_NAME_CONVERT 20.6.1.2
- DB_NAME 20.6.1.2
- LOG_ARCHIVE_DEST_n 36.2.3
- LOG_ARCHIVE_FORMAT 36.2.3
- LOG_FILE_NAME_CONVERT 20.6.1.2
instance failures
- backup mode and 35.3.2.3
instance recovery
- of CDBs 36.3.3
integrity checks 15.1.2
interpreting RMAN error stacks 23.1.5
interrupting media recovery 36.2.5

J

jobs, RMAN
- monitoring progress 22.3.1
- querying details about 11.4.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
- INCARNATION option 13.8.5
listing
- dropped PDB backups 11.2.4
- preplugin backups 11.2.5
local undo, flashback PDB operations 17.1.4.3
LOG_ARCHIVE_DEST_n initialization parameter 5.9.3, 5.10.4, 16.2.5, 36.2.2, 36.2.3, 36.3.1, 36.4.1, 36.4.2
LOG_ARCHIVE_FORMAT initialization parameter 36.2.3
LOG_FILE_NAME_CONVERT initialization parameter 20.6.1.2
logical backups 1.1.1
logical block corruption 15.1.2.2
log sequence numbers 36.2.1
LOGSOURCE variable
- SET statement 36.2.4.2, 36.3.1, 36.3.2
long waits 22.3.2.2
loss of
- inactive log group 37.7.2.1
lost write protection
- enabling 6.7
lost writes, detecting 6.6

M

maintenance commands, RMAN 2.6, 12.1.2
- Data Guard environment 12.1.2.2
maintenance mode 13.8.6.4.3
managing RMAN metadata 11, 12
MAXPIECESIZE parameter
- SET command 5.7.6.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 36.4
- complete recovery 36.3
- complete recovery, user-managed 36.3
- control file loss 37.3
- datafile loss 36.2.1
- definition 1.1.2
- NOARCHIVELOG mode 36.5
- online redo log group loss 37.7.2
- recovery 36.3
- recovery procedures
  - examples 36.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.7.6.1
- Backup Solutions Program 3.5.3
- catalog 3.1
- configuring for use with RMAN 5.7.4
- crosschecking 12.4.1.1
- definition 2.1
- error codes 23.1.4.2
- file restrictions 5.7.6.1
- installing 5.7.2
- library location 5.7.3
- linking
  - testing 5.7.5
- linking to software 3.5.2, 5.7.3
- multiplexing backups 8.3.9
- prerequisites for configuring 5.7.2
- SBT library 5.7.1
- sbttest program 23.3.1
- testing 5.7.5.1, 5.7.5.2
- testing backups 5.7.5.2
- testing the API 23.3
- third-party 5.7
- troubleshooting 5.7.5.2
media recovery 8.9.4
- ADD DATAFILE operation 37.2.3
- after control file damage 37.1.1, 37.1.2
- applying archived redo logs 36.2.1
- cancel-based 36.4, 36.4.2
- complete 36.3
  - closed database 36.3.1
- complete, user-managed 36.3
- corruption
  - allowing to occur 36.6.4
- errors 36.6.1
- incomplete 36.4
- interrupting 36.2.5
- lost files
  - lost archived redo log files 36.4
  - lost data files 36.2.1
  - lost mirrored control files 37.1
- NOARCHIVELOG mode 36.5
- offline tablespaces in open database 36.3.2
- online redo log files 37.7
- parallel 36.2.6
- problems 36.6.1, 36.6.2, 36.6.3
- restarting 36.2.5
- restoring
  - whole database backups 36.5
- resuming after interruption 36.2.5
- roll forward phase 36.2.1
- scenarios 37
- time-based 36.4
- transportable tablespaces 37.6
- trial 36.6.6, 36.6.6.1
- troubleshooting 36.6.1
- user-managed 36
- using Recovery Manager 14.3
metadata, RMAN 3.4, 11, 12, 13
mirrored files
- backups using 10.5
- splitting 35.6.1
  - suspend/resume mode 35.6.1
  - using RMAN 10.5
monitoring fast recovery area usage 12.3.2
monitoring RMAN 23.2
multiplexed backup sets 6.2.1, 8.3.9, 9.2.4.2, 22.2.1.1
multiplexed control files 5.9, 5.10.1, 12.2.3, 16.2.1.1, 35.1.1, 36.2.1, 37.1.1
multisection backups 3.3.2, 8.3.1, 8.3.7, 8.3.9, 10.1.3, 15.2
- views 9.2.6
multisection incremental backups 9.2.6
- example 9.2.6
multitenant container databases 4.2

N

naming
- duplicate database files 25.1.1.1
naming backup sets 8.3.6
native library
- SBT 5.7.1
Native library
- SBT 5.7
NLS_DATE_FORMAT environment variable 4.5
NLS_LANG environment variable 4.5
NOARCHIVELOG mode
- backing up 9.3.10
- disadvantages 36.5
- recovery 36.5
non-CDBs
- preplugin backups 9.3.11

O

obsolete backups 8.10
- definition 8.10
- deleting 2.6.2, 8.10.3, 12.5.5
off-site backups 16.2.3.1
online redo logs 37.7.2.1
- active group 37.7.1, 37.7.2
- applying during media recovery 36.2.1
- archived group 37.7.1, 37.7.2
- clearing
  - failure 37.7.2.1.3
- clearing inactive logs
  - archived 37.7.2.1.1
  - unarchived 37.7.2.1.2
- configuring location 5.9
- current group 37.7.1, 37.7.2
- inactive group 37.7.1, 37.7.2
- loss of 37.7.2.1
  - active group 37.7.2.2.1
  - all members 37.7.2
  - group 37.7.2
  - recovery 37.7
- loss of group 37.7.2.2.1
- multiple group loss 37.7.2.3
- replacing damaged member 37.7.1
- status of members 37.7.1, 37.7.2
OPEN RESETLOGS clause
- ALTER DATABASE statement 13.8.5, 14.3.2.1, 17.8.1
ORA-01578 error message 37.5
Oracle Advanced Compression option 6.2.5.2.2
Oracle Backup Solutions Program (BSP) 3.5.3
Oracle Cloud
- duplicating to 24.6
Oracle Data Pump 1.1.1
Oracle Enterprise Manager Cloud Control
- about 1.5.1
- accessing the Database Home page 1.5.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.10.1.1
Oracle Real Application Clusters (Oracle RAC)
- RMAN channels and 6.1.2
Oracle Secure Backup 3.5.2, 5.7
Oracle Secure Backup (OSB) Cloud Module
- configuring RMAN channel 33.6
- getting AWS Identifiers 33.2
- running the S3 Backup installer
  - first time 33.3
  - Linux example 33.3.3
- storing configuration in RMAN repository 33.5
- Troubleshooting 33.7
Oracle software keystore
- and backups 6.2.6.1.1
Oracle VSS writer 5.10.1
orphaned backups 14.3.2.4

P

packages
- DBMS_PIPE 4.8
password backup encryption 6.2.6.1.2
password-mode encryption 10.6.3
passwords
- connecting to RMAN 4.2.8
PDB restore points 7.1.6.2
PDB restore points, creating 7.4.2
PDB restore points, namespace 7.1.6.3
PDB restore points, viewing 7.4.4
PDBs 4.2
- about backup and recovery of 4.2.4
- about duplicating 24.4.3.1, 24.5.1
- backing up, using Oracle Enterprise Manager Cloud Control 9.3.5
- backing up, using RMAN 9.3.4
- complete recovery
  - data files 16.3.7
  - tablespaces 16.3.7
  - using RMAN 16.3.5
- complete restore 16.3
- connecting to 4.2
- orphaned backups 14.3.2.5
- performing point-in-time recovery 17.5.3
- preplugin backups 9.3.12
- recovering table partitions 21.4
- recovering tables 21.4
- restrictions when connected to 4.2.6.1
- transporting across platforms 27.7.1
- user-managed backups 35.2
- validating 15.2.1
PDBs, clean PDB restore point 7.1.6.2
PDBs, flashback database and PITR 17.1.2.1
PDBs, flashback database operation 17.4.3
PDBs, restore points 7.1.6.2
PDBs, rewinding 17.4.3
performance tuning
- short waits
  - definition of 22.3.2.2
performance tuning, RMAN
- backup performance 22.4
- long waits 22.3.2.2
physical backups 1.1.1
physical block corruption 15.1.2.2
pipe interface, RMAN 4.8
PITR, for PDBs 17.1.2.1
pluggable databases 4.2
point-in-time recovery 17.1.2, 36.4
- application PDBs 17.6
- of CDBs 17.5.2
- of PDBs 17.5.3
point of recoverability
- recovery window 8.10.1
preplugin backups
- about 8.6
- example 9.3.12.1
- non-CDB 9.3.11
- PDBs 9.3.12
previewing backups 16.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 35.7
- UNIX backups 35.7.1
- Windows backups 35.7.2
RC_ARCHIVED_LOG view 11.5.1.1
RC_BACKUP_FILES view 11.5.3
RC_BACKUP_PIECE view 11.5.1
RC_BACKUP_SET view 12.5.1
read-only tablespaces
- backups 35.3.2.4
- transporting across platforms
  - using backup sets 27.8.1
  - using image copies 27.3
RECOVER clause
- ALTER DATABASE statement 36.2.4.2, 36.3.1, 36.3.2
RECOVER command 14.3
- COPY option 9.7.4
- FOREIGN DATAFILECOPY clause 27.8.2.3.3, 27.8.2.4
- PARALLEL and NOPARALLEL options 36.2.6
- TEST option 15.4
- unrecoverable objects and standby databases 37.5
- UNTIL TIME option 36.4.2
- USING BACKUP CONTROLFILE clause 37.2.4
recovering
- dropped PDBs 17.5.5
- table partitions in PDBs 21.4
- tables in PDBs 21.4
recovering database file
- over the network 19.7.2
recovering database files
- over the network, example 19.7.5
- using physical standby 19.7.2
recovering files over the network
- scenarios 19.7.3
recovering table partitions
- example 21.5.2
- limitations 21.1.4
- overview 21.1
- prerequisites 21.2.1
- steps 21.3
recovering tables
- example 21.5.1
- limitations 21.1.4
- new schema 21.1.3.5
- overview 21.1
- prerequisites 21.2.1
- steps 21.3
recovery
- ADD DATAFILE operation 37.2.3
- automatically applying archived logs 36.2.2
- cancel-based 36.4.2
- complete 16.1, 36.3
  - CDBs 16.3.2
  - CDBs using Oracle Enterprise Manager Cloud Control 16.3.6
  - closed database 36.3.1
  - data files in PDBs 16.3.7
  - offline tablespaces 36.3.2
  - PDBs 16.3.5
  - root 16.3.3
  - tablespaces in PDBs 16.3.7
  - tablespaces in PDBs using Cloud Control 16.3.8
- corruption
  - intentionally allowing 36.6.4
- database
  - complete 16
  - in NOARCHIVELOG mode 19.1
- database, point-in-time 17, 17.5
- database files
  - how RMAN applies changes 14.3.1
  - overview 14.3
- data files 36.2.1
- disaster using RMAN 19.4
- dropped table 37.8
- errors 36.6.1
- failures requiring 1.1.2
- interrupting 36.2.5
- media 36.6, 37
- multiple redo threads 36.2.2.2
- of lost or damaged recovery catalog 13.6.2
- online redo logs 37.7
  - loss of group 37.7.2
- parallel 36.2.6
- preparing for 16.2.1.2
- problems 36.6.1
  - fixing 36.6.3
  - investigating 36.6.2
- stuck 36.6.1
- time-based 36.4.2
- transportable tablespaces 37.6
- trial 36.6.6
  - explanation 36.6.6.1
  - overview 36.6.6
- troubleshooting 36.6.1
- user errors 37.8
- user-managed 36.6, 37
- using backup control file 19.3.1
  - without recovery catalog 19.3.2
- using logs in a nondefault location 36.2.4.1
- using logs in default location 36.2.3
- using logs in nondefault location 36.2.4.2
- with Oracle Enterprise Manager Cloud Control 1.5.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
- maintenance mode 13.8.6.4.4
- 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
- schedule upgrade 13.8.6.4.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, 13.8.6.4, 13.8.6.4.2, 13.8.6.4.3
- views, querying 11.5
- virtual private catalogs 3.4
recovery catalog (Recovery Manager
- recovery catalog
  - upgrading 13.8.6.4.3
recovery catalogs
- backing up 13.6.1
- dropping 13.9
- importing 13.8.7
- moving 13.8.7.5
Recovery Manager
- allocating tape buffers 22.2.3.1.1
- archived redo logs
  - backups 9.6
- audit trail, monitoring audit records 22.3.3
- backups 9.1.2
  - archived redo logs 9.6.1
  - backing up 9.9.1
  - batch deletion of obsolete 8.10.3
  - control files 9.3.8
  - data file 9.3.6, 9.9.2, 9.9.3
  - duplexed 8.7.1
  - image copy 8.4
  - incremental 9.7, 10.4.1, 10.4.2
  - optimization 5.12.1, 9.6.3
  - tablespace 9.9.2, 9.9.3
  - testing 15.1.2.4, 15.2, 15.3
  - validating 15.2, 15.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.5
- database connections 4.2.1
  - auxiliary database 4.2.7
  - duplicate database 4.2.7
  - hiding passwords 4.2.8
  - SYSBACKUP or SYSDBA required for target 4.2.2
  - without a catalog 4.2
- DBMS_PIPE package 4.8
- definition 2.1
- disconnecting from 2.2
- error codes
  - message numbers 23.1.4.1
- errors 23.1, 23.1.4
  - interpreting 23.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 15.1.2
- jobs, monitoring progress 22.3.1
- jobs, querying details of 11.4.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.7.3
- metadata 3.4, 11, 12, 13
- monitoring 23.2
- overview 2.1, 3.2
- performance
  - monitoring 23.2
- pipe interface 4.8
- proxy copy 3.5.1
- recovery
  - after total media failure 19.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, 13.8.6.4, 13.8.6.4.2
- 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 16.2.5
- retention policies
  - configuring 5.11
- return codes 23.1.6
- setting time parameters 4.5
- snapshot control file location 6.4
- starting 2.2
- synchronous and asynchronous I/O 22.2.1.2, 22.2.1.3, 22.2.3.1.3
- terminating commands 23.4
- test disk API 5.7.5
- types of backups 8.4
- using RMAN commands 3.2
Recovery Manager,
- recovery catalog
  - managing recovery catalog upgrade 13.8.6.4.4
recovery window 5.11
- point of recoverability 8.10.1
RECOVERY WINDOW parameter
- CONFIGURE command 5.11.2
recovery windows
- configuring for retention policy 5.11.2
- definition 8.10.1
recycle bin 17.1.4.2, 17.3.2
- restoring objects from 17.3.3
redo logs
- incompatible format 36.6.1
- naming 36.2.3
- parallel redo 36.6.1
redo records
- problems when applying 36.6.1
REGISTER command 13.3.2
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
reports, RMAN 2.5, 11.1.2, 11.3.1
- backup jobs 11.4.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 36.5
restartable backups 10.7.1
RESTORE command 14.2, 16.2.1.2
- ALL FOREIGN DATAFILES clause 27.6.4.4
- BACKUPSET clause 27.6.4.3
- DATAPUMP DESTINATION clause 27.8.2.3.3, 27.8.2.4
- DUMPFILE clause 27.6.4.3, 27.8.2.3.3, 27.8.2.4
- FORCE option 14.2.5
- FOREIGN DATABASE clause 27.6.4.4, 27.7.2
- FOREIGN DATAFILE clause 27.6.4.4, 27.8.2.4
- FOREIGN TABLESPACE clause 27.6.4.4
- FROM BACKUPSET clause 27.8.2.3.3
- FROM PLATFORM parameter 27.6.4.3
- FROM SERVICE parameter 19.7.4
- PREVIEW option 11.1.2, 16.2.3
- VALIDATE HEADER option 11.1.2, 16.2.3
restore optimization 14.2.5
restore points 1.4.2, 2.7
- dropping 7.4.5
- flashing back to 17.8.2
- guaranteed 1.4.2, 7.1.5
  - compared to storage snapshots 7.1.5.1
- listing 7.4.3
- multitenant environment 7.1.6
- requirements 7.3
restore points, creating in CDBs 7.4.1
restore points, creating in PDBs 7.4.2
restore points, in CDBs 7.1.6.1
restore validation 16.2.4
restoring
- control files 19.3.1.1
  - to default location 37.1.1
  - to nondefault location 37.1.2
- database
  - to default location 36.5
- database files 14.2, 14.2.1, 14.2.5
- encrypted backups 14.2.3
- server parameter files 19.2
- testing 15.4, 16.2.4
- user-managed backups 36.2.1
restoring database file
- over the network 19.7.1
restoring database files
- over the network, example 19.7.4
restoring files over the network
- scenarios 19.7.3
restrictions
- PDBs 4.2.6.1
RESUME clause
- ALTER SYSTEM statement 35.6.2
resuming recovery after interruption 36.2.5
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 23.1.6
REVOKE command 13.5.5
rewinding
- CDBs 17.4.2
RMAN repository 1.2, 2.1
RMAN sessions 3.3
root
- backing up
  - using Oracle Enterprise Manager Cloud Control 9.3.3
  - using RMAN 9.3.2
- complete recovery 16.3.3
- complete restore 16.3

S

SBT 3.3.1, 3.5.2, 5.7.6.2
SBT Library
- native 5.7.1
sbttest program 23.3.1
scenarios, Recovery Manager
- NOARCHIVELOG backups 9.3.10
- recovering pre-resetlogs backup 17.8.3, 19.1
- recovery after total media failure 19.4
scripts, RMAN 2.4.7
- substitution variables in 9.8.3
server parameter files
- autobackups 8.8
- backups 9.3.9
- configuring autobackups 5.6, 5.6.1, 8.8
- restoring 19.2
server sessions, Recovery Manager 3.3
session architecture, Recovery Manager 3.3
SET command
- ENCRYPTION option 6.2.6.1.2
- MAXCORRUPT option 15.1.2.3
SET statement
- AUTORECOVERY option 36.2.2
- LOGSOURCE variable 36.2.4.2, 36.3.1, 36.3.2
shadow copies 9.7.3.1
shared server
- configuring for use with RMAN 6.5
- configuring RMAN 6.5
shared undo, flashback PDB operations 17.1.4.3
short waits
- definition 22.3.2.2
SHOW command 2.3, 5.2
SHUTDOWN statement
- ABORT option 36.5, 37.1.1, 37.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
sparse backups 8.5
sparse CDBs
- duplicating 24.4.6.1
sparse data files
- backing up 9.5.2
sparse PDBs
- backing up 9.5.3
- duplicating 24.4.6.2
sparse tablespaces
- backing up 9.5.2
split mirrors
- suspend/resume mode 35.6.1
- using as backups 10.5
standby databases 3.1
statements, SQL
- ALTER DATABASE 36.2.4.2, 36.3.1, 36.3.2
status
- dropped PDB backups 12.4.2.3
storage snapshots 7.1.5.1
stored scripts 3.4, 9.8.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 36.6.1
substitution variables, FORMAT parameter 5.7.6.1, 8.3.6, 8.4.1
substitution variables, stored scripts 13.7.5
suspend/resume mode 35.6.1
SUSPEND clause
- ALTER SYSTEM statement 35.6.2
suspending a database 35.6.1
SWITCH command 16.3.9
SYSBACKUP privilege 4.2.2.2
SYSBACKUP privilege, dictionary protection
- SYSBACKUP 2.2
system backup to tape 3.5.2
system time
- changing
  - effect on recovery 36.4.2

T

tables, recovery of dropped 37.8
tablespace point-in-time recovery 17.1.2
- performing on dropped tablespaces 20.1.1
- planning 20.3
- preparing the auxiliary instance 20.6.1
- restrictions 20.2.2
- why perform 20.1.1
tablespaces
- backups 9.9.2, 9.9.3, 35.3.2.2
  - offline 35.3.1
  - online 35.3.2.2
- backups, in PDBs 9.3.7
- backups using RMAN 9.3.6
- excluding from backups 6.2.4
- excluding from RMAN backups 6.2.4
- read/write
  - backing up 35.3.2.1
- read-only
  - backing up 35.3.2.4
- recovering accessible
  - when database is open 16.3.4
- recovering in PDBs
  - using Cloud Control 16.3.8
- recovering offline in open database 36.3.2
- transporting across platforms, in PDBs 27.8.3
- transporting with RMAN 26
tape devices 3.5.2
target database
- connecting to 2.2
- definition 2.1, 3.1
terminating RMAN commands 23.4
test disk API 5.7.5
testing RMAN
- backups 15.1.2.4, 15.2, 15.3
- with media management API 23.3
time-based recovery 36.4.2
time format
- RECOVER DATABASE UNTIL TIME statement 36.4.2
time parameters
- setting for Recovery Manager use 4.5
trace files, RMAN 23.1.1
transparent backup encryption 6.2.6.1.1
transparent-mode backup encryption 10.6.2
transportable tablespaces
- creating with RMAN 26.1.1
  - and Data Pump Export 26.5.2
  - and past points in time 26.5.1
  - auxiliary destination 26.1.2
  - auxiliary instance parameter file 26.2, 26.2.2
  - file locations 26.5.3
  - initialization parameters 26.2.1
- cross-platform 27, 28.1
- recovery 37.6
transporting data over network
- transport PDB
  - incrementally using PDB backups 28.4.3
  - using PDB backup 28.4.2
transporting PDB
- using PDB backup
  - NOCATALOG mode 28.3.3.1
transporting PDBs 28.2.4.5
- NOCATALOG mode 28.3.4.1, 28.3.4.3
- using PDB backup
  - catalog connection mode 28.2.3.1
  - NOCATALOG mode 28.3.2.2, 28.3.4.2
- using PDB Backup
  - NOCATALOG mode 28.3.2.1
- using PDB backups 28.2.2.2, 28.2.4.2
  - catalog connection mode 28.2.4.4
  - NOCATALOG mode 28.3.3.2, 28.3.4.4, 28.3.4.5
- using preexisting PDB backups 28.2.3.2
Transporting PDBs
- using PDB backup
  - catalog connection mode 28.2.2.1
transporting tablespace
- using tablespace backup 28.5.4.3
  - catalog connection mode 28.5.3.1
transporting tablespaces 26
- using tablespace backup 28.5.4.1, 28.6.4.1
  - catalog connection mode 28.5.2.1, 28.5.2.2, 28.5.3.2, 28.5.4.2, 28.5.4.5
  - NOCATALOG mode 28.6.2.1, 28.6.2.2, 28.6.3.1, 28.6.3.2, 28.6.4.3, 28.6.4.5
  - physical standby database 28.8.2
- using tablespace backups
  - NOCATALOG mode 28.6.4.2, 28.6.4.4
transporting tablespaces over network
- using incremental tablespace backup 28.7.3
- using tablespace backup 28.7.2
transport tablespace
- using tablespace backup
  - catalog connection mode 28.5.4.4
trial recovery 15.4, 36.6.6, 36.6.6.1
tuning Recovery Manager
- V$ views 23.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.12.1, 8.3.4
unrecoverable objects
- recovery 37.5
UNREGISTER DATABASE command 13.8.4
unregistering databases 13.8.4
UNTIL TIME option
- RECOVER command 36.4.2
upgrade,
- recovery catalog 13.8.6.4.1
upgrading
- virtual private catalog 13.5.6
upgrading the recovery catalog 13.8.6.1, 13.8.6.4, 13.8.6.4.2, 13.8.6.4.3
user errors
- definition 1.1.2
- recovery from 37.8
user-managed backups 35
- backup mode 35.3.2.1, 35.3.2.3
- control files 35.4
- definition 8.4.2
- determining data file status 35.1.2
- hot backups 8.2, 35.3.2.3.1
- listing files before 35.1
- of CDBs 35.2
- offline tablespaces 35.3.1
- of PDBs 35.2
- read-only tablespaces 35.3.2.4
- tablespaces 35.3.2.2
- verifying 35.8
user-managed recovery 36.4
- ADD DATAFILE operation 37.2.3
- complete 36.3
- incomplete 36.4
- interrupting 36.2.5
- scenarios 37
user-managed restore operations 36.2.1

V

V$ARCHIVED_LOG view 5.10.2.3, 11.5.1.1, 17.7
- listing all archived logs 35.5
V$BACKUP_ASYNC_IO view 22.3.2
V$BACKUP_DATAFILE view 9.7.2, 12.4.3.3
V$BACKUP_FILES view 5.11.2, 12.4.1.1, 12.4.3.2
V$BACKUP_PIECE view 11.5.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 22.3.2
V$BACKUP view 35.1.2
V$BLOCK_CHANGE_TRACKING view 9.7.6.4
V$CONTROLFILE view 9.3.8
V$DATABASE_BLOCK_CORRUPTION view 1.3, 2.8.4, 15.1.2.4, 15.2, 18, 18.1.2, 18.1.2.2, 18.4
V$DATABASE_INCARNATION view 13.8.5
V$DATABASE view 11.5.2, 17.2.2, 17.8.1
V$DATAFILE_HEADER view 11.1.2, 16.2.1.2.2
V$DATAFILE view 16.2.1.2.2, 20.6.1.2, 35.1.1
- listing files for backups 35.1
V$DIAG_INFO view 18.3.1
V$EVENT_NAME view 23.2.1
V$FLASHBACK_DATABASE_LOG view 5.10.2.3, 17.8.1
V$FLASHBACK_DATABASE_STAT view 7.5.4
V$INSTANCE view 16.2.1.2.2
V$LOG_HISTORY view
- listing all archived logs 36.3.1
V$LOGFILE view 20.6.1.2, 37.7.1, 37.7.2
V$PARAMETER view 17.2.2
V$PROCESS view 11.1.2, 23.2.2
V$RECOVER_FILE view 16.2.1.2.2, 36.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 36.3.1
V$RESTORE_POINT 7.4.4
V$RESTORE_POINT view 17.2.2
V$RMAN_BACKUP_JOB_DETAILS view 11.4.1
V$RMAN_BACKUP_SUBJOB_DETAILS view 11.4.1
V$RMAN_ENCRYPTION_ALGORITHMS view 6.2.6.1, 6.2.6.3, 22.2.2
V$RMAN_OUTPUT view 11.5.2
V$RMAN_STATUS view 23.1.1
V$SESSION_LONGOPS view 22.3.1
V$SESSION_WAIT view 23.2.1
V$SESSION view 6.5, 11.1.2, 23.2.2
V$SGASTAT view 22.4.3
V$SYSSTAT view 7.5.4
V$TABLESPACE view 16.2.1.2.2, 35.1.1
V$UNIFIED_AUDIT_TRAIL 22.3.3
VALIDATE command 15.2
- SECTION SIZE parameter 15.2
VALIDATE HEADER option, RESTORE command 11.1.2
validating
- PDBs 15.2.1
validation, RMAN
- backups 2.4.6, 15.2, 15.3
- database files 2.4.6, 15.2
- restore operations 16.2.4
viewing, CDB restore points 7.4.4
viewing, PDB restore points 7.4.4
views
- for multisection backups 9.2.6
views, recovery catalog 11.1.2, 11.5
virtual private catalogs 3.4
- creating 13.5.3
- upgrading 13.5.6
Volume Shadow Copy Service (VSS) 5.10.1, 9.7.3.1

W

whole database backups
- using RMAN 9.3.1

Z

Zero Data Loss Recovery Appliance 1.6