Index
A
- ABORT option
- about
- 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 35.6.5
- ALTER DATABASE statement
- CLEAR LOGFILE clause 36.7.2.1.3
- END BACKUP clause 34.4.2.3.1
- OPEN RESETLOGS clause 13.8.5
- RECOVER clause 35.2.4.2, 35.3.1, 35.3.2
- RESETLOGS option 35.5
- ALTER SYSTEM statement
- ALTER TABLESPACE statement
- BEGIN BACKUP clause 34.4.2.1, 34.4.2.2.2
- END BACKUP option 34.4.2.2.2
- application containers
- application errors 1.1.2
- application PDBs
- application root
- 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 35.2.1, 35.2.3, 35.2.4.2
- backing up 9.7.3
- backing up, in CDBs 9.7.5
- cataloging 12.4.3
- changing default location 35.2.4.1
- corrupted 35.6.1
- delete after backups 9.7.6
- delete after backups, in CDBs 9.7.7
- deleting 14.3.1, 35.3.1
- deletion after backup 9.7.1
- failover 9.7.1.1
- incompatible format 35.6.1
- location during recovery 35.2.1
- loss of 35.4
- restoring using RMAN 17.2.5
- ARCHIVELOG mode
- backups in 2.4.2
- AS SELECT clause
- CREATE TABLE statement 36.5
- autobackups, control file 8.8, 9.3.3, 9.9.2
- automated repairs
- Data Recovery Advisor 1.5
- automatic channel allocation 6.1.1
- automatic channels 3.3, 3.3.2
- 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 35.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
- backup
- to Recovery Appliance 3.8.1
- backup and recovery
- 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 34.1.1
- BACKUP COPIES parameter
- CONFIGURE command 6.2.3
- backup encryption 6.2.6.1, 8.3.5, 14.2.3
- backup mode 8.4.2
- ending with ALTER DATABASE END BACKUP 34.4.2.3.1
- for online user-managed backups 34.4.2.1, 34.10
- instance failure 34.4.2.3
- backup optimization 9.7.4
- backup pieces 8.3.1
- backup retention policies 1.1.3, 3.6, 5.4.1
- 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 34.2
- consistent 34.2
- making using RMAN 8.1.1
- control file 9.3.3, 34.6
- control files 34.6
- binary 34.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
- DBVERIFY utility 34.11
- default type for RMAN 5.1.3
- determining data file status 34.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 34.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 34.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 34.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 34.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 35.2.1
- root
- 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 34.4.2.2
- testing RMAN 16.1.2.4, 16.2, 16.3
- using media manager 5.2.4.2
- user-managed 34
- using storage snapshots 34.10
- validating 16.2, 16.3
- verifying 34.11
- whole CDB 9.4.2
- whole database 9.3.1, 34.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
- backups
- 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 34.4.2.1
- binary compression for backups 9.2.5
- block change tracking 1.1.1, 8.9.2, 9.8.6
- 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 35.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
- complete restore 17.4
- connecting to 4.2.5
- crash recovery 35.3.3
- Data Recovery Advisor 15.1.4
- diagnose failures 15.1.4
- instance recovery 35.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 34.3
- validating 16.5.1
- CDBs, restore points 7.1.6.1
- CHANGE command
- CHANGE FAILURE command 15.6
- channels, RMAN 3.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 36.7.2.1.3
- client, RMAN 2.1, 3.1, 3.5
- Cloud computing 33.1
- cold failover cluster
- definition 34.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
- 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
- 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
- comments in RMAN syntax 4.5.3
- COMPATIBLE initialization parameter 6.2.6.1
- complete recovery
- compressed backups 5.1.3, 9.2.5
- algorithms 6.2.5
- configuration parameters
- OSB Cloud Module 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
- configuring Recovery Manager
- connecting
- consistent backups 8.1.1
- 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, 36.1.2
- control file autobackups 12.2.3
- control files
- backups 34.1.1, 34.6
- circular reuse records 12.2.1
- configuring location 5.4.4
- creating after loss of all copies 36.3
- finding file names 34.1.1
- multiplexed 5.4.1, 5.4.4, 12.2.3, 17.2.1.1, 34.1.1, 35.2.1, 36.1.1
- loss of 36.1
- multiplexing 12.2.3
- re-created 36.3
- restoring 20.3.1.1, 36.1.1, 36.1.2
- snapshot 13.8.2.1
- specifying location of 6.4
- user-managed restore after loss of all copies 36.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, 35.6.1
- crash recovery
- of CDBs 35.3.3
- CREATE CATALOG command 13.2.3
- CREATE DATAFILE clause, ALTER DATABASE statement 36.4
- CREATE SCRIPT command 13.7.2
- CREATE TABLESPACE statement 36.2.3
- CREATE TABLE statement
- AS SELECT clause 36.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
- cross-platform data transport
- data pump destination 28.6.1
- cross-platform transport
- cross-platform transportable tablespace 28
- cumulative incremental backups 2.4.4, 2.4.5, 8.9.1, 8.9.1.2
D
- database connections
- Database Home page, accessing 1.6.2
- database point-in-time recovery 18, 18.5
- databases
- duplicating 25.4.1
- listing for backups 34.1
- media recovery procedures, user-managed 35
- media recovery scenarios 36
- multitenant container 9.4
- recovery
- registering in recovery catalog 13.3.2
- reporting on schemas 11.3.5
- suspending 34.8.1
- transporting across platforms
- 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, 35.6.1
- data dictionary views 34.4.1, 34.4.2.1, 34.4.2.4, 34.5.1
- data files
- Data Guard environment
- 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
- 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 34.4.1, 34.4.2.1, 34.4.2.4, 34.5.1
- DBID
- DBMS_PIPE package 4.6
- DBPITR 18.5
- DBVERIFY utility 34.11
- DELETE command 12.4.3.1, 12.5, 12.5.3
- deleting
- 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
- duplicating a PDB
- duplicating databases
- duplicatingOracle Cloud
- to 25.6
- duplicating PDBs
- to new CDB 25.5.3.5
- duplication
- DURATION parameter, BACKUP command 10.8.2
E
- enabling
- encrypted backups 10.6, 14.2.3
- environment variables
- error codes
- error messages, RMAN
- interpreting 24.1.5
- error stacks, RMAN
- interpreting 24.1.5
- example
- examples
- 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
- 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 34.1
- file sections 8.3.7, 8.3.9, 10.1.3, 16.2
- flashback CDB 18.4.3
- flashback CDB, using SQL*Plus 35.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 35.1.3
- flashback retention target 7.1.1
- Flashback Table 18.1.4.2
- FLASHBACK TABLE statement 18.2.1, 18.2.2
- Flashback Technology 18.1.2
- 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
H
- Health Monitor 15.1.2.2
- hot backup mode
- failed backups 34.4.2.3, 34.4.2.3.1
- for online user-managed backups 34.4.2.1
I
- I/O errors
- effect on backups 10.7.1
- image copies 2.4, 8.1, 8.4
- IMPORT CATALOG command 13.8.7
- INCARNATION option
- incarnations
- INCLUDE CURRENT CONTROLFILE option
- BACKUP command 9.3.3.1
- incomplete media recovery 35.4
- incomplete recovery
- inconsistent backups 8.1.2
- inconsistent tablespaces
- transporting across platforms 28.10
- incremental backups 2.4.4, 9.8
- initialization parameter file 14.3
- initialization parameters
- instance failures
- backup mode and 34.4.2.3
- instance recovery
- of CDBs 35.3.3
- integrity checks 16.1.2
- interpreting RMAN error stacks 24.1.5
- interrupting media recovery 35.2.6
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
- listing
- 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, 35.2.2, 35.2.3, 35.3.1, 35.4.1, 35.4.2
- LOG_ARCHIVE_FORMAT initialization parameter 35.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 35.2.1
- LOGSOURCE variable
- long waits 23.3.2.2
- loss of
- inactive log group 36.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
- media failures 1.1.2
- 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 36.2.3
- after control file damage 36.1.1, 36.1.2
- applying archived redo logs 35.2.1
- cancel-based 35.4, 35.4.2
- complete 35.3
- closed database 35.3.1
- complete, user-managed 35.3
- corruption
- allowing to occur 35.6.4
- errors 35.6.1
- incomplete 35.4
- interrupting 35.2.6
- lost files
- NOARCHIVELOG mode 35.5
- offline tablespaces in open database 35.3.2
- online redo log files 36.7
- parallel 35.2.7
- problems 35.6.1, 35.6.2, 35.6.3
- restarting 35.2.6
- restoring
- whole database backups 35.5
- resuming after interruption 35.2.6
- roll forward phase 35.2.1
- scenarios 36
- time-based 35.4
- transportable tablespaces 36.6
- trial 35.6.6, 35.6.6.1
- troubleshooting 35.6.1
- user-managed 35
- using Recovery Manager 14.3
- metadata, RMAN 3.4, 11, 12, 13
- mirrored files
- 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, 34.1.1, 35.2.1, 36.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
O
- obsolete backups 8.10
- off-site backups 17.2.3.1
- online redo logs 36.7.2.1
- active group 36.7.1, 36.7.2
- applying during media recovery 35.2.1
- archived group 36.7.1, 36.7.2
- clearing
- failure 36.7.2.1.3
- clearing inactive logs
- archived 36.7.2.1.1
- unarchived 36.7.2.1.2
- configuring location 5.4.4
- current group 36.7.1, 36.7.2
- inactive group 36.7.1, 36.7.2
- loss of 36.7.2.1
- active group 36.7.2.2.1
- all members 36.7.2
- group 36.7.2
- recovery 36.7
- loss of group 36.7.2.2.1
- multiple group loss 36.7.2.3
- replacing damaged member 36.7.1
- status of members 36.7.1, 36.7.2
- OPEN RESETLOGS clause
- ORA-01578 error message 36.5
- Oracle Advanced Compression option 6.2.5.2.2
- Oracle Backup Solutions Program (BSP) 3.5.3
- Oracle Cloud
- duplicating to 25.6
- Oracle Data Pump 1.1.1, 18.4.2
- Oracle Enterprise Manager Cloud Control
- Oracle Flashback Database 1.4.2
- Oracle Flashback Drop 1.4.1
- Oracle Flashback Query 1.4.1
- Oracle Flashback Table 1.4.1
- Oracle Flashback Transaction 1.4.1
- Oracle Flashback Transaction Query 1.4.1
- Oracle Flashback Version Query 1.4.1
- Oracle keystore 6.2.6.1.1
- Oracle Managed Files
- fast recovery 5.4.1.1
- Oracle Real Application Clusters (Oracle RAC)
- RMAN channels and 6.1.2
- Oracle Secure Backup 3.5.2, 5.2
- Oracle Secure Backup (OSB) Cloud Module
- 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
- 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 34.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
- short waits
- performance tuning, RMAN
- 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, 35.4
- point of recoverability
- recovery window 8.10.1
- preplugin backups
- 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
R
- raw devices
- 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
- RECOVER clause
- RECOVER command 14.3
- recovering
- recovering database file
- over the network 20.7.2
- recovering database files
- recovering files over the network
- scenarios 20.7.3
- recovering table partitions
- recovering tables
- recovery
- ADD DATAFILE operation 36.2.3
- automatically applying archived logs 35.2.2
- cancel-based 35.4.2
- complete 17.1, 35.3
- corruption
- intentionally allowing 35.6.4
- database
- database, point-in-time 18, 18.5
- database files
- data files 35.2.1
- disaster using RMAN 20.4
- dropped table 36.8
- errors 35.6.1
- failures requiring 1.1.2
- interrupting 35.2.6
- media 35, 35.6, 36
- multiple redo threads 35.2.2.2
- of lost or damaged recovery catalog 13.6.2
- online redo logs 36.7
- loss of group 36.7.2
- parallel 35.2.7
- preparing for 17.2.1.2
- problems 35.6.1
- stuck 35.6.1
- third-party snapshots
- example 35.2.5
- time-based 35.4.2
- transportable tablespaces 36.6
- trial 35.6.6
- troubleshooting 35.6.1
- user errors 36.8
- user-managed 35, 35.6, 36
- using backup control file 20.3.1
- without recovery catalog 20.3.2
- using logs in a nondefault location 35.2.4.1
- using logs in default location 35.2.3
- using logs in nondefault location 35.2.4.2
- using storage snapshots 35.2.5
- using third-party snapshots 35.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
- 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
- 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
- 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
- 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
- reports 11.3.1
- 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
- recycle bin 18.1.4.2, 18.3.2
- restoring objects from 18.3.3
- redo logs
- redo records
- problems when applying 35.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
- reporting
- reports, RMAN 2.5, 11.1.2, 11.3.1
- 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 35.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
- 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
- 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 34.8.2
- resuming recovery after interruption 35.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
- SET command
- 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
S
- SBT 3.3.1, 3.5.2, 5.2.5.2
- sbttest program 24.3.1
- scenarios, Recovery Manager
- scripts, RMAN 2.4.7
- substitution variables in 9.9.3
- server parameter files
- server sessions, Recovery Manager 3.3
- session architecture, Recovery Manager 3.3
- SET command
- SET statement
- shadow copies 9.8.3.1
- shared server
- 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
- size of backup sets, setting 8.3.7
- skipping files in RMAN backups 10.3
- snapshot control file
- snapshot control files 6.4, 13.8.2.1
- snapshots
- 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
- sparse tablespaces
- backing up 9.6.2
- split mirrors
- SPOOL command 15.5.1
- standby databases 3.1
- statements, SQL
- status
- dropped PDB backups 12.4.2.3
- Storage Snapshot Optimization 34.10
- storage snapshots 7.1.5.1, 34.10, 35.2.5
- recovering 35.2.5
- stored scripts 3.4, 9.9.3, 13.1.2.4, 13.7.1, 13.8.7.1
- stuck recovery 35.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 34.8.1
- SUSPEND clause
- ALTER SYSTEM statement 34.8.2
- suspending a database 34.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 35.4.2
- changing
T
- tables, recovery of dropped 36.8
- tablespace point-in-time recovery 18.1.2
- tablespaces
- backups 9.10.2, 9.10.3, 34.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 34.4.2.1
- read-only
- backing up 34.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 35.3.2
- transporting across platforms, in PDBs 28.12.5
- transporting with RMAN 27
- user-managed backups, in CDBs 34.5
- user-managed backups, in PDBs 34.5
- tape devices 3.5.2
- target database
- terminating RMAN commands 24.4
- test disk API 5.2.4
- testing RMAN
- third-party snapshots
- specifying recovery time 35.2.5
- time-based recovery 35.4.2
- time format
- RECOVER DATABASE UNTIL TIME statement 35.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
- transporting tablespaces 27
- trial recovery 16.4, 35.6.6, 35.6.6.1
- tuning Recovery Manager
- V$ views 24.2
U
- UNAVAILABLE option
- of CHANGE 12.4.2.1
- UNCATALOG option
- undo optimization, backup 5.6.1, 8.3.4
- unrecoverable objects
- recovery 36.5
- UNREGISTER DATABASE command 13.8.4
- unregistering databases 13.8.4
- UNTIL TIME option
- RECOVER command 35.4.2
- upgrading
- virtual private catalog 13.5.6
- upgrading the recovery catalog 13.8.6.1
- user errors
- user-managed backups 34, 34.2
- backup mode 34.4.2.1, 34.4.2.3
- control files 34.6
- definition 8.4.2
- determining data file status 34.1.2
- hot backups 8.2, 34.4.2.3.1
- listing files before 34.1
- of CDBs 34.3
- offline tablespaces 34.4.1
- of PDBs 34.3
- read-only tablespaces 34.4.2.4
- tablespaces 34.4.2.2
- tablespaces in CDBs 34.5
- tablespaces in PDBs 34.5
- verifying 34.11
- whole database 34.2
- user-managed recovery 35.4
- user-managed restore operations 35.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 34.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 34.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, 34.1.1
- listing files for backups 34.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 35.3.1
- V$LOGFILE view 21.6.1.2, 36.7.1, 36.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, 35.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 35.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, 34.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
- validation, RMAN 15.3
- 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
- Volume Shadow Copy Service (VSS) 5.4.1, 9.8.3.1