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.5.1

  • backing up PDBs 4.2.5.1

• about, flashback database for CDBs 18.1.4.3

• about, flashback database for PDBs 18.1.4.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 36.6.5

• ALTER DATABASE statement

  • CLEAR LOGFILE clause 37.7.2.1.3

  • END BACKUP clause 35.4.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 24.4.1

  • RESUME clause 35.8.2

  • SUSPEND clause 35.8.2

• ALTER TABLESPACE statement

  • BEGIN BACKUP clause 35.4.2.1, 35.4.2.2.2

  • END BACKUP option 35.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 36.2.1, 36.2.3, 36.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 36.2.4.1

  • corrupted 36.6.1

  • delete after backups 9.7.6

  • delete after backups, in CDBs 9.7.7

  • deleting 14.3.1, 36.3.1

  • deletion after backup 9.7.1

  • failover 9.7.1.1

  • incompatible format 36.6.1

  • location during recovery 36.2.1

  • loss of 36.4

  • restoring using RMAN 17.2.5

• ARCHIVELOG mode

  • backups in 2.4.2

• AS SELECT clause

  • CREATE TABLE statement 37.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 36.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

• Azure Backup 32.3.3

• Azure Cloud Backup Module 32.3.3

---

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 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 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 35.4.2.3.1

  • for online user-managed backups 35.4.2.1, 35.10

  • instance failure 35.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 35.2

  • consistent 35.2

    • making using RMAN 8.1.1

  • control file 9.3.3, 35.6

  • control files 35.6

    • binary 35.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 35.11

  • default type for RMAN 5.1.3

  • 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 35.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 35.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 35.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 35.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 36.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 35.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 35

  • using storage snapshots 35.10

  • validating 16.2, 16.3

  • verifying 35.11

  • whole CDB 9.4.2

  • whole database 9.3.1, 35.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 35.4.2.1

• binary compression for backups 9.2.5

• block change tracking 1.1.1, 8.9.2, 9.8.6

  • disk space used for 9.8.6.1.3

  • enabling and disabling 9.8.6.2, 9.8.6.3

  • moving the change tracking file 9.8.6.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 36.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 36.3.3

  • Data Recovery Advisor 15.1.4

  • diagnose failures 15.1.4

  • instance recovery 36.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 35.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 37.7.2.1.3

• client, RMAN 2.1, 3.1, 3.5

• Cloud computing 33.1

• cold failover cluster

  • definition 35.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 36.4.2

  • SET 36.2.2, 36.2.4.2, 36.3.1, 36.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 36.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

• configuration parameters

  • Oracle Database Cloud Backup for Amazon S3 33.4

• 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 35.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, 37.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 35.1.1, 35.6

    • binary 35.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 37.3

  • finding file names 35.1.1

  • multiplexed 5.4.1, 5.4.4, 12.2.3, 17.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 20.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 28.10.1.1

• COPIES option

  • BACKUP command 10.4.2

• corrupt blocks 14.1.1.2, 16.1.2.1, 36.6.1

  • recovering 19.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.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.3

  • Flashback Database and 7.1.1

  • prerequisites 18.5.1

  • user-managed 36.4

• databases

  • duplicating 25.4.1

  • listing for backups 35.1

  • media recovery procedures, user-managed 36

  • media recovery scenarios 37

  • multitenant container 9.4

  • 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.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, 36.6.1

• data dictionary views 35.4.1, 35.4.2.1, 35.4.2.4, 35.5.1

• data files

  • backing up 9.3.2, 9.10.2, 9.10.3, 35.4.1

  • backing up, in PDBs 9.4.8

  • determining status 35.1.2

  • listing 35.1

  • losing 36.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.6.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 35.4.1, 35.4.2.1, 35.4.2.4, 35.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 35.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

  • Using Cloud Backups 25.2.5.1

• duplicate databases

  • active database duplication 4.2.7

• duplicating

  • Cloud database to on-premises 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.6

  • tablespaces 25.4.2

• duplicating a PDB

  • to existing CDBs 25.5.3.3, 25.5.3.4

• 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.5

• 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 36.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.4.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 35.1

• file sections 8.3.7, 8.3.9, 10.1.3, 16.2

• flashback CDB 18.4.3

• flashback CDB, using SQL*Plus 36.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.2.1

• flashback database, PDBs 18.4.4

• FLASHBACK DATABASE command 18.4.2

• flashback database window 7.1.2

• Flashback Drop 18.1.4.2, 18.3.1

• flashback logs 1.4.2, 2.8, 7.1.1, 12.3.3, 18.1.4.1

  • guaranteed restore points and 7.1.5

• flashback PDB, local undo 18.1.4.4

• flashback PDB, shared undo 18.1.4.4

• flashback PDB, using SQL*Plus 36.1.3

• flashback retention target 7.1.1

• Flashback Table 18.1.4.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.4.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 37.7.1, 37.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 35.4.2.3, 35.4.2.3.1

  • for online user-managed backups 35.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 36.4

• incomplete recovery

  • defined 18.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 28.10

• incremental backups 2.4.4, 9.8

  • block change tracking 9.8.6

  • 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, 37.1.2

  • DB_FILE_NAME_CONVERT 21.6.1.2

  • DB_NAME 21.6.1.2

  • LOG_ARCHIVE_DEST_n 36.2.3

  • LOG_ARCHIVE_FORMAT 36.2.3

  • LOG_FILE_NAME_CONVERT 21.6.1.2

• instance failures

  • backup mode and 35.4.2.3

• instance recovery

  • of CDBs 36.3.3

• integrity checks 16.1.2

• interpreting RMAN error stacks 24.1.5

• interrupting media recovery 36.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.4.4

• LOG_ARCHIVE_DEST_n initialization parameter 5.4.4.3, 5.4.5, 17.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 21.6.1.2

• logical backups 1.1.1

• logical block corruption 16.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 23.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

• 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 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.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 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.6

  • 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.7

  • problems 36.6.1, 36.6.2, 36.6.3

  • restarting 36.2.6

  • restoring

    • whole database backups 36.5

  • resuming after interruption 36.2.6

  • 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.8.1

    • suspend/resume mode 35.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, 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, 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 36.5

  • recovery 36.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 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.4.4

  • 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, 18.4.2, 18.6.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 25.6

• Oracle Database Cloud Backup for Amazon S3 3.5.2

  • 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 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 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 35.3

  • validating 16.5.2

• PDBs, clean PDB restore point 7.1.6.2

• PDBs, flashback database and PITR 18.1.2.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.2.1

• pluggable databases 4.2.5

• point-in-time recovery 18.1.2, 36.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

• 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 35.9

  • UNIX backups 35.9.1

  • Windows backups 35.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 35.4.2.4

  • transporting across platforms

    • using backup sets 28.8

    • using image copies 28.3

• RECOVER clause

  • ALTER DATABASE statement 36.2.4.2, 36.3.1, 36.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 36.2.7

  • TEST option 16.4

  • unrecoverable objects and standby databases 37.5

  • UNTIL TIME option 36.4.2

  • USING BACKUP CONTROLFILE clause 37.2.4

• recovering

  • dropped PDBs 18.5.3.3

  • 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 37.2.3

  • automatically applying archived logs 36.2.2

  • cancel-based 36.4.2

  • complete 17.1, 36.3

    • CDBs 17.4.1

    • CDBs using Oracle Enterprise Manager Cloud Control 17.4.4

    • closed database 36.3.1

    • data files in PDBs 17.4.6

    • offline tablespaces 36.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 36.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 36.2.1

  • disaster using RMAN 20.4

  • dropped table 37.8

  • errors 36.6.1

  • failures requiring 1.1.2

  • interrupting 36.2.6

  • media 36, 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.7

  • preparing for 17.2.1.2

  • problems 36.6.1

    • fixing 36.6.3

    • investigating 36.6.2

  • stuck 36.6.1

  • third-party snapshots

    • example 36.2.5

  • 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, 36.6, 37

  • using backup control file 20.3.1

    • without recovery catalog 20.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

  • using storage snapshots 36.2.5

  • using third-party snapshots 36.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.4.2, 18.3.2

  • restoring objects from 18.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

• 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 36.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 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 20.2

  • testing 16.4, 17.2.4

  • user-managed backups 36.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 35.8.2

• resuming recovery after interruption 36.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 36.2.2

  • LOGSOURCE variable 36.2.4.2, 36.3.1, 36.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.4.4

• short waits

  • definition 23.3.2.2

• SHOW command 2.3, 5.1.1

• 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

• snapshots

  • backing up using third-party technologies 35.10

  • using Storage Snapshot Optimization 35.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.6

• sparse tablespaces

  • backing up 9.6.2

• split mirrors

  • suspend/resume mode 35.8.1

  • using as backups 10.5

• SPOOL command 15.5.1

• 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 Snapshot Optimization 35.10

• storage snapshots 7.1.5.1, 35.10, 36.2.5

  • recovering 36.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 36.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 35.8.1

• SUSPEND clause

  • ALTER SYSTEM statement 35.8.2

• suspending a database 35.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 36.4.2

---

T

• tables, recovery of dropped 37.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, 35.4.2.2

    • offline 35.4.1

    • online 35.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 35.4.2.1

  • read-only

    • backing up 35.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 36.3.2

  • transporting across platforms, in PDBs 28.12.5

  • transporting with RMAN 27

  • user-managed backups, in CDBs 35.5

  • user-managed backups, in PDBs 35.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 36.2.5

• time-based recovery 36.4.2

• time format

  • RECOVER DATABASE UNTIL TIME statement 36.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 37.6

• transporting tablespaces 27

• trial recovery 16.4, 36.6.6, 36.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 37.5

• UNREGISTER DATABASE command 13.8.4

• unregistering databases 13.8.4

• UNTIL TIME option

  • RECOVER command 36.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 37.8

• user-managed backups 35, 35.2

  • backup mode 35.4.2.1, 35.4.2.3

  • control files 35.6

  • definition 8.4.2

  • determining data file status 35.1.2

  • hot backups 8.2, 35.4.2.3.1

  • listing files before 35.1

  • of CDBs 35.3

  • offline tablespaces 35.4.1

  • of PDBs 35.3

  • read-only tablespaces 35.4.2.4

  • tablespaces 35.4.2.2

  • tablespaces in CDBs 35.5

  • tablespaces in PDBs 35.5

  • verifying 35.11

  • whole database 35.2

• user-managed recovery 36.4

  • ADD DATAFILE operation 37.2.3

  • complete 36.3

  • incomplete 36.4

  • interrupting 36.2.6

  • scenarios 37

• user-managed restore operations 36.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 35.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 35.1.2

• V$BLOCK_CHANGE_TRACKING view 9.8.6.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, 35.1.1

  • listing files for backups 35.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 36.3.1

• V$LOGFILE view 21.6.1.2, 37.7.1, 37.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, 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.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, 35.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 35.2

  • inconsistent 35.2

  • NOARCHIVELOG mode 35.2

  • preparing for 35.2

  • using RMAN 9.3.1

---

Z

• Zero Data Loss Recovery Appliance 1.7