Index

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

%

  • %b substitution variable
    • SET NEWNAME [1]
  • %d substitution variable
    • BACKUP FORMAT [1]
  • %f substitution variable
    • SET NEWNAME [1]
  • %I substitution variable
    • SET NEWNAME [1]
  • %N substitution variable
    • SET NEWNAME [1]
  • %p substitution variable
    • BACKUP FORMAT [1]
  • %s substitution variable
    • BACKUP FORMAT [1]
  • %t substitution variable
    • BACKUP FORMAT [1]
  • %U substitution variable
    • BACKUP FORMAT [1]
    • SET NEWNAME [1]

A

  • ABORT option
  • about
    • backing up CDBs [1]
    • backing up PDBs [1]
  • active database duplication
    • compressing backup sets [1]
    • creating backup sets in parallel [1]
    • determining technique used [1]
  • Advanced Security Option [1]
  • ADVISE FAILURE command [1] , [2]
  • alert log [1]
  • ALLOCATE CHANNEL command
    • MAXPIECESIZE option [1]
  • ALLOW ... CORRUPTION clause, RECOVER command [1]
  • ALTER DATABASE statement
    • CLEAR LOGFILE clause [1]
    • END BACKUP clause [1]
    • OPEN RESETLOGS clause [1]
    • RECOVER clause [1] , [2] , [3]
    • RESETLOGS option [1]
  • ALTER SYSTEM statement
    • KILL SESSION clause [1]
    • RESUME clause [1]
    • SUSPEND clause [1]
  • ALTER TABLESPACE statement
    • BEGIN BACKUP clause [1] , [2]
    • END BACKUP option [1]
  • application errors [1]
  • archival backups [1] , [2] , [4]
  • archived redo log deletion policies [1] , [2] , [3]
  • archived redo log files
    • applying during media recovery [1] , [2] , [3]
    • backing up
      • using RMAN [1]
      • with other backups [1]
    • backing up, in CDBs [1]
    • cataloging [1]
    • changing default location [1]
    • corrupted [1]
    • delete after backups [1]
    • delete after backups, in CDBs [1]
    • deleting [1] , [2]
    • deletion after backup [1]
    • failover [1]
    • incompatible format [1]
    • location during recovery [1]
    • loss of [1]
    • restoring using RMAN [1]
  • ARCHIVELOG mode
    • backups in [1]
  • AS SELECT clause
    • CREATE TABLE statement [1]
  • autobackups, control file
  • automated repairs
    • Data Recovery Advisor [1]
  • automatic channel allocation [1]
  • automatic channels
    • configuring [1]
    • naming conventions [1]
    • overriding [1]
  • Automatic Diagnostic Repository (ADR) [1] , [2] , [3] , [4] , [5] , [6] , [7]
  • Automatic Storage Management (ASM)
    • backups to [1]
  • Automatic Workload Repository (AWR) [1]
  • AUTORECOVERY option
    • SET statement [1]
  • auxiliary channels [1]
  • auxiliary instance parameter file
    • with TRANSPORT TABLESPACE [1]
  • availability
    • of RMAN backups [1]
  • AVAILABLE option
    • of CHANGE command [1]

B

  • backing up
    • database [1]
    • data files in PDBs [1]
    • tablespaces in PDBs [1]
    • with Oracle Enterprise Manager Cloud Control [1]
  • backup and recovery
    • definition [1]
    • introduction [1]
    • solutions [1]
    • strategy [1]
    • user-managed [1]
  • BACKUP command
    • ALLOW INCONSISTENT option [1]
    • ARCHIVELOG option [1] , [2]
    • AS COMPRESSION BACKUPSET option [1]
    • AS COPY option [1] , [2]
    • BACKUPSET option [1] , [3] , [4] , [7] , [9]
    • CHANNEL option [1]
    • COMPRESSED BACKUPSET option [1]
    • COPIES parameter [1] , [2]
    • COPY OF option [1] , [2] , [3] , [4]
    • CURRENT CONTROLFILE option [1] , [2]
    • DATABASE option [1]
    • DATAFILE option [1]
    • DATAPUMP option [1] , [2] , [4]
    • DB_FILE_NAME_CONVERT parameter [1]
    • DELETE INPUT option [1] , [3]
    • DELETE option [1]
    • DEVICE TYPE clause [1] , [2] , [3] , [5]
    • DURATION parameter [1]
    • FILESPERSET parameter [1]
    • FORMAT parameter [1] , [2] , [3] , [4] , [5] , [6]
    • FOR RECOVER OF COPY option [1]
    • FOR TRANSPORT parameter [1] , [2]
    • INCREMENTAL LEVEL 1 parameter [1] , [3]
    • INCREMENTAL LEVEL O parameter [1] , [2]
    • INCREMENTAL option [1] , [3] , [4] , [5] , [6]
    • KEEP option [1] , [2] , [4]
    • MAXSETSIZE parameter [1]
    • NOT BACKED UP clause [1]
    • PLUS ARCHIVELOG option [1]
    • PROXY ONLY option [1]
    • PROXY option [1]
    • RECOVERY AREA option [1]
    • SECTION SIZE parameter [1] , [2] , [3]
    • SPFILE option [1]
    • TABLESPACE option [1]
    • TAG parameter [1] , [2]
    • TO PLATFORM parameter [1] , [2]
    • VALIDATE option [1] , [2] , [3] , [4]
  • BACKUP CONTROLFILE clause
    • ALTER DATABASE statement [1]
  • BACKUP COPIES parameter
    • CONFIGURE command [1]
  • backup encryption
  • backup mode
    • ending with ALTER DATABASE END BACKUP [1]
    • for online user-managed backups [1] , [2]
    • instance failure [1]
  • backup optimization
  • backup pieces
    • definition [1]
    • maximum size [1]
    • names [1]
    • names on tape [1]
  • backup retention policies
    • affect on backup optimization [1]
    • configuring [1]
    • configuring for redundancy [1]
    • definition [1]
    • disabling [1]
    • exempt backups [1] , [2]
    • recovery window [1]
    • recovery windows [1]
    • redundancy [1] , [2]
  • backups
    • archival [1] , [2]
    • archived redo log files, in CDBs [1]
    • archived redo logs
      • using RMAN [1]
    • availability [1]
    • backup sets [1]
    • backups of [1]
    • closed [1]
    • consistent
      • making using RMAN [1]
    • control file [1] , [2]
    • control files
    • correlating RMAN channels with [1] , [2]
    • crosschecking [1]
    • cumulative incremental [1]
    • data file
    • DBVERIFY utility [1]
    • default type for RMAN [1]
    • determining data file status [1]
    • duplexing [1] , [3]
    • excluding tablespaces from backups [1]
    • exempt from retention policy [1]
    • expired, deleting [1]
    • generating reports for [1] , [2]
    • image copies [1]
    • inconsistent
      • making using RMAN [1]
    • incremental [1] , [2] , [3] , [4]
    • incrementally updated [1]
    • listing files needed [1]
    • logical [1]
    • long-term [1]
    • managing [1]
    • multisection [1] , [2] , [3]
    • NOARCHIVELOG mode [1]
    • obsolete [1] , [2]
    • offline [1]
    • offsite [1]
    • optimizing [1] , [2]
    • orphaned [1]
    • PDBs, using Oracle Enterprise Manager Cloud Control [1]
    • PDBs, using RMAN [1]
    • physical [1]
    • previewing [1]
    • read-only tablespaces [1]
    • recovering pre-RESETLOGS [1]
    • recovery catalog [1]
    • Recovery Manager [1]
    • reporting objects needing backups [1]
    • restartable [1]
    • restoring user-managed [1]
    • root
      • using Oracle Enterprise Manager Cloud Control [1]
      • using RMAN [1]
    • server parameter files [1]
    • skipping files during [1]
    • split mirror
      • using RMAN [1]
    • stored scripts [1] , [2]
    • tablespace
    • testing RMAN
      • using media manager [1]
    • user-managed [1]
    • using storage snapshots [1]
    • validating [1] , [3]
    • verifying [1]
    • whole CDB [1]
    • whole database [1] , [3]
  • backup sets
  • Backup Solutions Program (BSP) [1]
  • backup strategy
    • fast recovery area [1]
  • backup tags, RMAN [1]
  • backup techniques, comparison [1]
  • backup windows [1]
  • BEGIN BACKUP clause
    • ALTER TABLESPACE statement [1]
  • binary compression for backups [1]
  • block change tracking
    • disk space used for [1]
    • enabling and disabling [1] , [3]
    • moving the change tracking file [1]
  • block corruptions
    • stored in V$DATABASE_BLOCK_CORRUPTION [1]
  • block media recovery
    • automatic [1]
  • BSP [1]

C

  • cancel-based media recovery [1]
  • canceling RMAN commands [1]
  • CATALOG command
    • START WITH parameter [1]
  • CDBs
    • about backup and recovery of [1]
    • backing up [1]
    • complete recovery
      • after switching to a copy [1]
      • using Oracle Enterprise Manager Cloud Control [1]
    • complete restore [1]
    • connecting to [1]
    • crash recovery [1]
    • Data Recovery Advisor [1]
    • diagnose failures [1]
    • duplicating [1]
    • flashback [1]
    • instance recovery [1]
    • performing point-in-time recovery [1]
    • repairing failures [1]
    • reporting [1]
    • rewinding beyond PDB point-in-time recovery [1]
    • transporting across platforms [1]
    • user-managed backups [1]
    • validating [1]
  • CHANGE command
    • AVAILABLE option [1]
    • DB_UNIQUE_NAME parameter [1]
    • RESET DB_UNIQUE_NAME option [1]
    • UNCATALOG option [1]
  • CHANGE FAILURE command [1]
  • channels, RMAN
    • auxiliary [1]
    • configuring [1]
    • configuring advanced options [1]
    • definition [1]
    • generic [1]
    • naming conventions [1]
    • Oracle RAC environment [1]
    • parallel [1]
  • character sets
    • setting for use with RMAN [1]
  • circular reuse records [1]
  • CLEAR LOGFILE clause
    • of ALTER DATABASE [1]
  • client, RMAN [1] , [3] , [4]
  • cold failover cluster
    • definition [1]
  • command files, RMAN [1]
  • command interface
  • commands, Recovery Manager
  • commands, SQL*Plus
  • comments in RMAN syntax [1]
  • COMPATIBLE initialization parameter [1]
  • complete recovery
  • compressed backups
    • algorithms [1]
  • compressing
    • backup sets, during active database duplication [1]
  • CONFIGURE command
    • AUXNAME option [1]
    • BACKUP OPTIMIZATION option [1]
    • CHANNEL option [1] , [2]
    • CONTROLFILE AUTOBACKUP option [1] , [2]
    • DB_UNIQUE_NAME option [1]
    • ENCRYPTION option [1]
    • EXCLUDE option [1]
    • FOR DB_UNIQUE_NAME option [1]
    • MAXPIECESIZE option [1]
    • MAXSETSIZE option [1]
    • RETENTION POLICY clause [1]
    • RETENTION POLICY option [1]
  • configuring media managers
    • installing [1]
    • prerequisites [1]
  • configuring Recovery Manager
    • autobackups [1] , [2] , [3]
    • backup optimization [1]
    • backup retention policies [1]
    • backup set size [1]
    • default backup type [1]
    • default devices [1]
    • overview [1]
    • shared server [1]
    • snapshot control file location [1]
    • specific channels [1]
    • tablespace exclusion for backups [1]
  • connecting
  • consistent backups
    • using RMAN [1]
    • whole database [1]
  • CONTROL_FILE_RECORD_KEEP_TIME initialization parameter [1] , [2]
  • CONTROL_FILES initialization parameter [1] , [2] , [3]
  • control file autobackups
    • after structural changes to database [1]
    • configuring [1] , [4] , [6]
    • default format [1]
    • format [1]
  • control files
    • backups
      • binary [1]
      • including within database backup [1]
      • manual [1]
      • recovery using [1]
      • using RMAN [1]
    • circular reuse records [1]
    • configuring location [1]
    • creating after loss of all copies [1]
    • finding file names [1]
    • multiplexed
    • multiplexing [1]
    • re-created [1]
    • restoring [1] , [2] , [3]
    • snapshot
      • specifying location of [1]
    • user-managed restore after loss of all copies [1]
  • CONVERT command
    • ALLOW INCONSISTENT option [1]
  • COPIES option
    • BACKUP command [1]
  • corrupt blocks
  • crash recovery
  • CREATE CATALOG command [1] , [2]
  • CREATE DATAFILE clause, ALTER DATABASE statement [1]
  • CREATE SCRIPT command [1]
  • CREATE TABLESPACE statement [1]
  • CREATE TABLE statement
    • AS SELECT clause [1]
  • CROSSCHECK command [1]
  • crosschecking, RMAN
    • definition [1]
    • recovery catalog with the media manager [1]
  • cross-platform data transport
    • data pump destination [1]
  • cross-platform transport
    • databases
      • using backup sets [1]
      • using image copies [1]
    • data files, using image copies [1]
    • inconsistent tablespaces
    • methods
      • using backup sets [1]
      • using image copies [1]
    • of CDBs [1]
    • of PDBs [1]
    • read-only tablespaces
      • using backup sets [1]
      • using image copies [1]
    • tablespaces, DataPump export dump file [1]
    • tablespaces in PDBs [1]
  • cross-platform transportable tablespace [1]
  • cumulative incremental backups [1] , [2] , [3] , [4]

D

  • database connections
    • Recovery Manager
      • auxiliary database [1]
      • hiding passwords [1]
      • without a catalog [1]
    • SYSBACKUP required for RMAN [1]
    • types in RMAN [1]
  • database duplication
    • initialization parameter file [1]
    • starting auxiliary instance [1]
  • Database Home page, accessing [1]
  • database point-in-time recovery
    • definition [1]
    • Flashback Database and [1]
    • prerequisites [1]
    • user-managed [1]
  • databases
    • listing for backups [1]
    • media recovery procedures, user-managed [1]
    • media recovery scenarios [1]
    • multitenant container [1]
    • recovery
      • after control file damage [1] , [2]
    • registering in recovery catalog [1]
    • reporting on schemas [1]
    • suspending [1]
    • transporting across platforms
      • using backup sets [1]
      • using image copies [1]
    • unregistering from recovery catalog [1]
  • data blocks, corrupted [1] , [2] , [3] , [4] , [5] , [6] , [7] , [8] , [9] , [10]
  • data dictionary views [1] , [2] , [3]
  • data files
    • backing up [1] , [2] , [3] , [4]
    • backing up, in PDBs [1]
    • determining status [1]
    • listing [1]
    • losing [1]
    • restoring [1]
    • transporting across platforms [1]
  • Data Guard environment
    • archived log deletion policies [1]
    • changing a DB_UNIQUE_NAME [1]
    • configuring RMAN [1]
    • reporting in a [1]
    • RMAN backups [1]
    • RMAN backups, accessibility of [1]
    • RMAN backups, association of [1]
    • RMAN backups, interchangeability of [1] , [2]
    • RMAN usage [1]
  • data integrity checks [1] , [2] , [3]
  • data preservation, definition of [1]
  • data protection
    • definition [1]
  • data pump destination [1]
  • Data Recovery Advisor
    • automated repairs [1]
    • data integrity checks [1] , [2]
    • failure consolidation [1]
    • failure priority [1]
    • failures [1] , [2]
    • feasibility checks [1]
    • for CDBs [1]
    • overview [1]
    • purpose [1]
    • repairing failures [1]
    • repair options [1]
    • repairs [1] , [2] , [3]
    • supported configurations [1]
    • user interfaces [1]
  • data repair
  • data transfer, RMAN [1]
  • DB_BLOCK_CHECKSUM initialization parameter [1]
  • DB_CREATE_FILE_DEST initialization parameter [1] , [2]
  • DB_FILE_NAME_CONVERT initialization parameter [1]
  • DB_FLASHBACK_RETENTION_TARGET initialization parameter [1]
  • DB_LOST_WRITE_PROTECT initialization parameter [1]
  • DB_NAME initialization parameter [1]
  • DB_RECOVERY_FILE_DEST_SIZE initialization parameter [1]
  • DB_RECOVERY_FILE_DEST initialization parameter [1]
  • DB_UNIQUE_NAME initialization parameter [1] , [2] , [3] , [4]
  • DBA_DATA_FILES view [1] , [2] , [3]
  • DBID
    • determining [1]
    • problems registering copied database [1]
  • DBMS_PIPE package [1]
  • DBNEWID utility [1]
  • DBPITR [1]
  • DBVERIFY utility [1]
  • DELETE command
  • deleting
    • archived redo log files [1]
    • archived redo log files, in CDBs [1]
  • deleting backups [1] , [2] , [4] , [5]
  • deletion policies, archived redo log
  • devices, configuring default [1]
  • diagnose failures
  • differential incremental backups [1] , [2] , [3]
  • direct ancestral path [1] , [2] , [3]
  • disabling
    • Flashback Database [1]
  • disaster recovery
    • definition [1]
  • disconnecting
    • from Recovery Manager [1]
  • disk API [1]
  • disk failures [1]
  • disk usage
    • monitoring [1]
  • DROP DATABASE command [1]
  • dropped tables, retrieving [1]
  • dropping a database [1]
  • dropping the recovery catalog [1]
  • dual mode backup encryption [1]
  • dual-mode backup encryption [1]
  • dummy API [1]
  • duplexing backup sets [1] , [3] , [4]
  • DUPLICATE command
    • NOOPEN clause [1]
    • restarting after a failure [1]
  • duplicate databases
    • active database duplication
      • advantages of using backup sets [1]
      • allocating channels [1]
      • configuring channels [1]
      • using backup sets [1]
      • using image copies [1]
    • active database duplication, connecting [1]
    • active database duplication, encrypting backup sets [1]
    • backup-based duplication
      • configuring channels [1]
      • no target/recovery connection [1]
      • no target connection [1]
      • target connection [1]
    • CDBs [1]
    • generating file names [1]
    • how RMAN creates [1]
    • PDBs [1]
    • restarting after failed DUPLICATE [1]
    • skipping offline normal tablespaces [1]
    • skipping read-only tablespaces [1]
    • specifying the state [1]
    • tablespaces in PDBs [1]
  • duplication
    • restarting after a failure [1]
  • DURATION parameter, BACKUP command [1]

E

  • enabling
    • Flashback Database [1]
  • encrypted backups
    • decrypting [1]
  • environment variables
    • NLS_DATE_FORMAT [1]
    • NLS_LANG [1]
  • error codes
  • error messages, RMAN
    • interpreting [1]
  • error stacks, RMAN
    • interpreting [1]
  • example
    • multisection incremental backups [1]
  • examples
    • recovering using third-party snapshots [1]
    • rolling forward a physical standby [1]
  • EXECUTE SCRIPT command [1]
  • EXIT command [1]
  • exiting RMAN [1]
  • expired backups
  • EXPIRED option
    • DELETE command [1]

F

  • failover, when restoring files [1]
  • failures
  • failures, Data Recovery Advisor
    • consolidation [1]
    • priority [1]
  • fast recovery area
    • autobackups [1]
    • changing locations [1]
    • configuring [1]
    • definition [1]
    • disabling [1]
    • effect of retention policy [1]
    • enabling [1]
    • flashback database window [1]
    • maintaining [1]
    • monitoring disk usage [1]
    • monitoring usage [1]
    • Oracle Managed Files [1]
    • PDB point-in-time recovery [1]
    • permanent and impermanent files [1]
    • RMAN files in [1]
    • setting location [1]
    • setting size [1]
    • snapshot control files [1]
    • space management [1]
  • feasibility checks, Data Recovery Advisor [1]
  • file names, listing for backup [1]
  • file sections [1] , [2] , [3] , [4]
  • flashback
  • flashback data archive
    • definition [1]
  • Flashback Database
    • determining the flashback database window [1]
    • disabling [1]
    • enabling [1]
    • flashback logs [1] , [2]
    • limitations [1]
    • monitoring [1]
    • overview [1]
    • prerequisites [1]
    • purpose [1]
    • requirements [1]
    • space management
      • estimating disk space requirement [1]
    • tuning performance [1]
  • FLASHBACK DATABASE command [1]
  • flashback database window [1]
  • Flashback Drop [1] , [2]
  • flashback logs
    • guaranteed restore points and [1]
  • flashback retention target [1]
  • Flashback Table
  • FLASHBACK TABLE statement [1] , [3]
  • Flashback Technology
    • logical features [1]
    • overview [1]
  • flashback undrop
    • restoring objects [1]
  • foreign data file [1]
  • foreign data file copy [1]
  • foreign tablespace [1]
  • formats, for RMAN backups [1]
  • fractured blocks
    • detection [1]
  • full backups
    • incremental backups and [1]

G

  • generic channels
    • definition [1]
  • GRANT command [1] , [2]
  • groups, redo log [1] , [3]
  • guaranteed restore points
    • alternative to storage snapshots [1]
    • compared to storage snapshots [1]
    • creating [1]
    • flashback logs and [1]
    • requirements [1]
    • space usage in fast recovery area [1]

H

  • Health Monitor [1]
  • hot backup mode
    • failed backups [1] , [2]
    • for online user-managed backups [1]

I

  • I/O errors
    • effect on backups [1]
  • image copies
    • definition [1]
    • testing restore of [1]
  • IMPORT CATALOG command [1]
  • INCARNATION option
    • LIST command [1] , [2]
    • RESET DATABASE command [1]
  • incarnations
  • INCLUDE CURRENT CONTROLFILE option
    • BACKUP command [1]
  • incomplete media recovery [1]
  • incomplete recovery
    • defined [1]
    • in Oracle Real Application Clusters configuration [1]
    • overview [1]
    • time-based [1]
    • with backup control file [1]
  • inconsistent backups
  • inconsistent tablespaces
    • transporting across platforms [1]
  • incremental backups
    • block change tracking [1]
    • differential [1]
    • how RMAN applies [1]
    • making [1]
    • multisection incremental backups [1]
    • using RMAN [1] , [2]
  • initialization parameter file [1]
  • initialization parameters
    • CONTROL_FILES [1] , [2]
    • DB_FILE_NAME_CONVERT [1]
    • DB_NAME [1]
    • LOG_ARCHIVE_DEST_n [1]
    • LOG_ARCHIVE_FORMAT [1]
    • LOG_FILE_NAME_CONVERT [1]
  • instance failures
    • backup mode and [1]
  • instance recovery
  • integrity checks [1]
  • interpreting RMAN error stacks [1]
  • interrupting media recovery [1]

J

  • jobs, RMAN
    • monitoring progress [1]
    • querying details about [1]

K

  • KEEP option
    • BACKUP command [1]

L

  • level 0 incremental backups [1] , [2] , [4]
  • level 1 incremental backups [1] , [2]
  • LIST command
    • FAILURE option [1]
    • INCARNATION option [1]
  • LOG_ARCHIVE_DEST_n initialization parameter [1] , [2] , [3] , [4] , [5] , [7] , [8] , [9]
  • LOG_ARCHIVE_FORMAT initialization parameter [1]
  • LOG_FILE_NAME_CONVERT initialization parameter [1]
  • logical backups [1]
  • logical block corruption [1]
  • log sequence numbers [1]
  • LOGSOURCE variable
  • long waits [1]
  • loss of
    • inactive log group [1]
  • lost writes, detecting [1]

M

  • maintenance commands, RMAN
    • Data Guard environment [1]
  • managing RMAN metadata [1] , [2]
  • MAXPIECESIZE parameter
    • SET command [1]
  • MAXSETSIZE parameter
    • BACKUP command [1] , [2]
    • CONFIGURE command [1]
  • media failures
    • archived redo log file loss [1]
    • complete recovery [1]
    • complete recovery, user-managed [1]
    • control file loss [1]
    • datafile loss [1]
    • definition [1]
    • NOARCHIVELOG mode [1]
    • online redo log group loss [1]
    • recovery [1]
    • recovery procedures
  • Media Management Layer (MML) API [1] , [2]
  • media managers
    • backing up files [1]
    • backup piece names [1]
    • Backup Solutions Program [1]
    • catalog [1]
    • configuring for use with RMAN [1]
    • crosschecking [1]
    • definition [1]
    • error codes [1]
    • file restrictions [1]
    • installing [1]
    • library location [1]
    • linking
    • linking to software [1] , [2]
    • multiplexing backups [1]
    • prerequisites for configuring [1]
    • sbttest program [1]
    • testing [1]
    • testing backups [1]
    • testing the API [1]
    • third-party [1]
    • troubleshooting [1]
  • media recovery
    • ADD DATAFILE operation [1]
    • after control file damage [1] , [2]
    • applying archived redo logs [1]
    • cancel-based [1] , [2]
    • complete
      • closed database [1]
    • complete, user-managed [1]
    • corruption
      • allowing to occur [1]
    • errors [1]
    • incomplete [1]
    • interrupting [1]
    • lost files
      • lost archived redo log files [1]
      • lost data files [1]
      • lost mirrored control files [1]
    • NOARCHIVELOG mode [1]
    • offline tablespaces in open database [1]
    • online redo log files [1]
    • parallel [1]
    • problems [1] , [3] , [4]
    • restarting [1]
    • restoring
      • whole database backups [1]
    • resuming after interruption [1]
    • roll forward phase [1]
    • scenarios [1]
    • time-based [1]
    • transportable tablespaces [1]
    • trial [1] , [3]
    • troubleshooting [1]
    • user-managed [1]
    • using Recovery Manager [1]
  • metadata, RMAN [1] , [2] , [3] , [4]
  • mirrored files
    • backups using [1]
    • splitting
      • suspend/resume mode [1]
      • using RMAN [1]
  • monitoring fast recovery area usage [1]
  • monitoring RMAN [1]
  • MTTR [1]
  • multiplexed backup sets [1] , [2] , [3] , [4]
  • multiplexed control files [1] , [2] , [3] , [5] , [6] , [7] , [8]
  • multisection backups
  • multisection incremental backups
  • multitenant container databases [1]

N

  • naming backup sets [1]
  • NLS_DATE_FORMAT environment variable [1]
  • NLS_LANG environment variable [1]
  • NOARCHIVELOG mode
    • backing up [1]
    • disadvantages [1]
    • recovery [1]

O

  • obsolete backups
  • off-site backups [1]
  • online redo logs
    • active group [1] , [2]
    • applying during media recovery [1]
    • archived group [1] , [2]
    • clearing
    • clearing inactive logs
    • configuring location [1]
    • current group [1] , [2]
    • inactive group [1] , [2]
    • loss of
    • loss of group [1]
    • multiple group loss [1]
    • replacing damaged member [1]
    • status of members [1] , [2]
  • OPEN RESETLOGS clause
  • ORA-01578 error message [1]
  • Oracle Advanced Compression option [1]
  • Oracle Backup Solutions Program (BSP) [1]
  • Oracle Data Pump [1] , [2]
  • Oracle Enterprise Manager Cloud Control
    • about [1]
    • accessing the Database Home page [1]
  • Oracle Flashback Database [1]
  • Oracle Flashback Drop [1]
  • Oracle Flashback Query [1]
  • Oracle Flashback Table [1]
  • Oracle Flashback Transaction [1]
  • Oracle Flashback Transaction Query [1]
  • Oracle Flashback Version Query [1]
  • Oracle keystore [1]
  • Oracle Managed Files
    • fast recovery [1]
  • Oracle Real Application Clusters (Oracle RAC)
    • RMAN channels and [1]
  • Oracle Secure Backup [1] , [2]
  • Oracle software keystore
    • and backups [1]
  • Oracle VSS writer [1]
  • orphaned backups [1]

P

  • packages
    • DBMS_PIPE [1]
  • password backup encryption [1]
  • password-mode encryption [1]
  • passwords
    • connecting to RMAN [1]
  • PDBs
    • about backup and recovery of [1]
    • backing up, using Oracle Enterprise Manager Cloud Control [1]
    • backing up, using RMAN [1]
    • complete recovery
      • data files [1]
      • tablespaces [1]
      • using RMAN [1]
    • complete restore [1]
    • connecting to [1]
    • duplicating [1]
    • duplicating tablespaces in [1]
    • orphaned backups [1]
    • performing point-in-time recovery [1]
    • point-in-time recovery and fast recovery area [1]
    • recovering table partitions [1]
    • recovering tables [1]
    • reporting [1]
    • restrictions when connected to [1]
    • transporting across platforms [1]
    • user-managed backups [1]
    • validating [1]
  • performance tuning
    • short waits
      • definition of [1]
  • performance tuning, RMAN
    • backup performance [1]
    • long waits [1]
  • physical backups [1]
  • physical block corruption [1]
  • pipe interface, RMAN [1]
  • pluggable databases [1]
  • point-in-time recovery
    • of CDBs [1]
    • of PDBs [1]
    • performing
      • with current control file [1]
    • tablespace [1]
  • point of recoverability
    • recovery window [1]
  • previewing backups [1]
  • PREVIEW option, RESTORE command [1]
  • PRINT SCRIPT command [1]
  • proxy copies [1] , [2]
  • PROXY option
    • BACKUP command [1]

Q

  • QUIT command [1]
  • quitting RMAN [1]

R

  • raw devices
    • backing up to [1]
    • UNIX backups [1]
    • Windows backups [1]
  • RC_ARCHIVED_LOG view [1]
  • RC_BACKUP_FILES view [1]
  • RC_BACKUP_PIECE view [1]
  • RC_BACKUP_SET view [1]
  • read-only tablespaces
    • backups [1]
    • transporting across platforms
      • using backup sets [1]
      • using image copies [1]
  • RECOVER clause
  • RECOVER command
    • COPY option [1]
    • FOREIGN DATAFILECOPY clause [1] , [3]
    • FROM SERVICE parameter [1]
    • PARALLEL and NOPARALLEL options [1]
    • TEST option [1]
    • unrecoverable objects and standby databases [1]
    • UNTIL TIME option [1]
    • USING BACKUP CONTROLFILE clause [1]
  • recovering
    • table partitions in PDBs [1]
    • tables in PDBs [1]
  • recovering database file
    • over the network [1]
  • recovering database files
    • over the network, example [1]
    • using physical standby [1]
  • recovering files over the network
    • scenarios [1]
  • recovering table partitions
  • recovering tables
  • recovery
    • ADD DATAFILE operation [1]
    • automatically applying archived logs [1]
    • cancel-based [1]
    • complete
      • CDBs [1]
      • CDBs using Oracle Enterprise Manager Cloud Control [1]
      • closed database [1]
      • data files in PDBs [1]
      • offline tablespaces [1]
      • PDBs [1]
      • root [1]
      • tablespaces in PDBs [1]
      • tablespaces in PDBs using Cloud Control [1]
    • corruption
      • intentionally allowing [1]
    • database
      • complete [1]
      • in NOARCHIVELOG mode [1]
    • database, point-in-time [1] , [2]
    • database files
      • how RMAN applies changes [1]
      • overview [1]
    • data files [1]
    • disaster using RMAN [1]
    • dropped table [1]
    • errors [1]
    • failures requiring [1]
    • interrupting [1]
    • media [1] , [2] , [3]
    • multiple redo threads [1]
    • of lost or damaged recovery catalog [1]
    • online redo logs
      • loss of group [1]
    • parallel [1]
    • preparing for [1]
    • problems
      • fixing [1]
      • investigating [1]
    • stuck [1]
    • third-party snapshots
    • time-based [1]
    • transportable tablespaces [1]
    • trial
      • explanation [1]
      • overview [1]
    • troubleshooting [1]
    • user errors [1]
    • user-managed [1] , [2] , [3]
    • using backup control file
      • without recovery catalog [1]
    • using logs in a nondefault location [1]
    • using logs in default location [1]
    • using logs in nondefault location [1]
    • using storage snapshots [1]
    • using third-party snapshots [1]
    • with Oracle Enterprise Manager Cloud Control [1]
    • without a recovery catalog [1]
  • RECOVERY_CATALOG_OWNER role [1] , [2]
  • recovery catalog
    • backing up [1]
    • cataloging backups [1] , [2]
    • centralization of metadata [1]
    • creating [1]
    • crosschecking [1]
    • DBID problems [1]
    • definition [1] , [2]
    • deleting backups [1]
    • deleting records [1]
    • dropping [1]
    • log switch record [1]
    • managing size of [1]
    • operating with [1]
    • purpose of [1]
    • recovery of [1]
    • refreshing [1]
    • registering databases [1] , [2] , [3]
    • resynchronizing [1] , [2]
    • space requirements [1]
    • stored scripts
    • synchronization [1]
    • unregistering databases [1]
    • updating
      • after operating system deletions [1]
    • upgrading [1] , [2]
    • views, querying [1]
    • virtual private catalogs [1]
  • recovery catalogs
  • Recovery Manager
    • allocating tape buffers [1]
    • archived redo logs
    • backups
    • channels
      • naming conventions [1]
    • client [1]
    • connecting to databases [1]
    • corrupt data file blocks
      • handling I/O errors and [1]
    • crosschecking recovery catalog [1]
    • database character set [1]
    • database connections
      • auxiliary database [1]
      • duplicate database [1]
      • hiding passwords [1]
      • SYSBACKUP or SYSDBA required for target [1]
      • without a catalog [1]
    • DBMS_PIPE package [1]
    • definition [1]
    • disconnecting from [1]
    • duplicate databases, overview of [1]
    • error codes
      • message numbers [1]
    • errors
      • interpreting [1]
    • file deletion [1]
    • fractured block detection in [1]
    • image copy backups [1]
    • incremental backups
      • cumulative [1]
      • differential [1]
      • level 0 [1]
    • integrity checking [1]
    • jobs, monitoring progress [1]
    • jobs, querying details of [1]
    • lists [1]
    • maintenance commands [1]
    • media management
      • backing up files [1]
      • Backup Solutions Program (BSP) [1]
      • crosschecking [1]
      • media manager, linking with a [1]
    • metadata [1] , [2] , [3] , [4]
    • monitoring [1]
    • overview [1] , [2]
    • performance
      • monitoring [1]
    • pipe interface [1]
    • proxy copy [1]
    • recovery
      • after total media failure [1]
    • recovery catalog
      • backing up [1]
      • crosschecking [1]
      • managing the size of [1]
      • operating with [1]
      • recovering [1]
      • registration of target databases [1] , [2] , [3]
      • resynchronizing [1]
      • synchronization [1]
      • upgrading [1]
    • reports
      • database schema [1]
      • objects needing a backup [1]
      • obsolete backups [1]
    • repository [1]
    • restoring
      • archived redo logs [1]
    • retention policies
      • configuring [1]
    • return codes [1]
    • setting time parameters [1]
    • snapshot control file location [1]
    • starting [1]
    • synchronous and asynchronous I/O [1] , [2] , [3]
    • terminating commands [1]
    • test disk API [1]
    • types of backups [1]
    • using RMAN commands [1]
  • recovery window
    • point of recoverability [1]
  • RECOVERY WINDOW parameter
    • CONFIGURE command [1]
  • recovery windows
    • configuring for retention policy [1]
    • definition [1]
  • recycle bin
    • restoring objects from [1]
  • redo logs
    • incompatible format [1]
    • naming [1]
    • parallel redo [1]
  • redo records
    • problems when applying [1]
  • REGISTER command [1]
  • REPAIR FAILURE command [1] , [2]
  • repair failures
  • repair options, Data Recovery Advisor [1]
  • repairs, Data Recovery Advisor
    • consolidation of [1]
    • manual and automatic [1]
  • REPLACE SCRIPT command [1]
  • REPORT command
    • NEED BACKUP option [1]
    • OBSOLETE option [1]
  • reporting
  • reports, RMAN
    • backup jobs [1]
    • database schema [1]
    • files needing backups [1]
    • obsolete backups [1]
    • unrecoverable backups [1]
  • repository, RMAN [1]
  • RESET DATABASE command
    • INCARNATION option [1]
  • RESETLOGS operation
    • when necessary [1]
  • RESETLOGS option
    • of ALTER DATABASE [1]
  • restartable backups [1]
  • restarting
    • duplication after a failure [1]
  • RESTORE command
    • ALL FOREIGN DATAFILES clause [1]
    • BACKUPSET clause [1]
    • DATAPUMP clause [1]
    • DATAPUMP DESTINATION clause [1] , [2]
    • DUMPFILE clause [1] , [2] , [3]
    • FORCE option [1]
    • FOREIGN DATABASE clause [1] , [2]
    • FOREIGN DATAFILE clause [1] , [2]
    • FOREIGN TABLESPACE clause [1] , [2]
    • FROM BACKUPSET clause [1]
    • FROM PLATFORM parameter [1]
    • FROM SERVICE parameter [1]
    • NOIMPORT option [1]
    • PREVIEW option [1] , [2]
    • VALIDATE HEADER option [1] , [2]
  • restore optimization [1]
  • restore points
    • creating [1]
    • flashing back to [1]
    • guaranteed
      • compared to storage snapshots [1]
    • listing [1]
    • requirements [1]
  • restore validation [1]
  • restoring
    • control files
      • to default location [1]
      • to nondefault location [1]
    • database
      • to default location [1]
    • database files [1] , [2] , [3]
    • server parameter files [1]
    • testing [1] , [2]
    • user-managed backups [1]
  • restoring database file
    • over the network [1]
  • restoring database files
    • over the network, example [1]
  • restoring files over the network
    • scenarios [1]
  • restrictions
  • RESUME clause
    • ALTER SYSTEM statement [1]
  • resuming recovery after interruption [1]
  • RESYNC CATALOG command
    • FROM CONTROLFILECOPY option [1]
  • resynchronizing the recovery catalog [1] , [2] , [3]
  • return codes
  • REVOKE command [1]
  • RMAN [1]
  • RMAN repository [1] , [2]
  • RMAN sessions [1] , [2]
  • root
    • backing up
      • using Oracle Enterprise Manager Cloud Control [1]
      • using RMAN [1]
    • complete recovery [1]
    • complete restore [1]

S

  • SBT [1] , [2] , [3]
  • sbttest program [1]
  • scenarios, Recovery Manager
    • NOARCHIVELOG backups [1]
    • recovering pre-resetlogs backup [1] , [2]
    • recovery after total media failure [1]
  • scripts, RMAN
    • substitution variables in [1]
  • server parameter files
  • server sessions, Recovery Manager [1]
  • session architecture, Recovery Manager [1]
  • SET command
    • DBID option [1]
    • ENCRYPTION option [1]
    • MAXCORRUPT option [1]
    • NEWNAME option [1]
  • SET statement
    • AUTORECOVERY option [1]
    • LOGSOURCE variable [1] , [2] , [3]
  • shadow copies [1]
  • shared server
    • configuring for use with RMAN [1]
    • configuring RMAN [1]
  • short waits
    • definition [1]
  • SHOW command [1] , [3]
  • SHUTDOWN statement
  • size of backup sets, setting [1]
  • skipping files in RMAN backups [1]
  • snapshot control file
    • specifying location [1]
    • specifying location in Oracle Real Application Clusters environment [1]
  • snapshot control files [1] , [2]
  • snapshots
    • backing up using third-party technologies [1]
    • using Storage Snapshot Optimization [1]
  • split mirrors
    • suspend/resume mode [1]
    • using as backups [1]
  • SPOOL command [1]
  • standby databases
    • creating with DUPLICATE [1]
  • statements, SQL
  • Storage Snapshot Optimization [1]
  • storage snapshots
    • recovering [1]
  • stored scripts
    • creating RMAN [1]
    • deleting [1]
    • dynamic [1]
    • executing [1]
    • listing names of [1]
    • managing [1]
    • printing [1]
    • substitution variables in [1]
  • stuck recovery [1]
  • substitution variables, FORMAT parameter [1] , [2] , [3]
  • substitution variables, stored scripts [1]
  • suspend/resume mode [1]
  • SUSPEND clause
    • ALTER SYSTEM statement [1]
  • suspending a database [1]
  • SWITCH command [1]
  • SYSBACKUP privilege [1]
  • system backup to tape [1]
  • system time
    • changing
      • effect on recovery [1]

T

  • tables, recovery of dropped [1]
  • tablespace point-in-time recovery
    • performing on dropped tablespaces [1]
    • planning [1]
    • preparing the auxiliary instance [1]
    • restrictions [1]
    • why perform [1]
  • tablespaces
    • backups
    • backups, in PDBs [1]
    • backups using RMAN [1]
    • excluding from backups [1]
    • excluding from RMAN backups [1]
    • read/write
      • backing up [1]
    • read-only
      • backing up [1]
    • recovering accessible
      • when database is open [1]
    • recovering in PDBs
      • using Cloud Control [1]
    • recovering offline in open database [1]
    • transporting across platforms, in PDBs [1]
    • transporting with RMAN [1]
    • user-managed backups, in CDBs [1]
    • user-managed backups, in PDBs [1]
  • tape devices [1]
  • target database
  • terminating RMAN commands [1]
  • test disk API [1]
  • testing RMAN
  • third-party snapshots
    • specifying recovery time [1]
  • time-based recovery [1]
  • time format
    • RECOVER DATABASE UNTIL TIME statement [1]
  • time parameters
    • setting for Recovery Manager use [1]
  • trace files, RMAN [1]
  • transparent backup encryption [1]
  • transparent-mode backup encryption [1]
  • transportable tablespaces
    • creating with RMAN
      • and Data Pump Export [1]
      • and past points in time [1]
      • auxiliary destination [1]
      • auxiliary instance parameter file [1] , [2]
      • file locations [1]
      • initialization parameters [1]
    • cross-platform [1]
    • recovery [1]
  • transporting tablespaces [1]
  • trial recovery [1] , [2] , [3]
  • tuning Recovery Manager

U

  • UNAVAILABLE option
    • of CHANGE [1]
  • UNCATALOG option
    • CHANGE command [1]
    • deleting repository records [1]
  • undo optimization, backup [1] , [2]
  • unrecoverable objects
  • UNREGISTER DATABASE command [1]
  • unregistering databases [1]
  • UNTIL TIME option
    • RECOVER command [1]
  • upgrading the recovery catalog [1]
  • user errors
    • definition [1]
    • recovery from [1]
  • user-managed backups
    • backup mode [1] , [2]
    • control files [1]
    • definition [1]
    • determining data file status [1]
    • hot backups [1] , [2]
    • listing files before [1]
    • of CDBs [1]
    • offline tablespaces [1]
    • of PDBs [1]
    • read-only tablespaces [1]
    • tablespaces [1]
    • tablespaces in CDBs [1]
    • tablespaces in PDBs [1]
    • verifying [1]
    • whole database [1]
  • user-managed recovery
    • ADD DATAFILE operation [1]
    • complete [1]
    • incomplete [1]
    • interrupting [1]
    • scenarios [1]
  • user-managed restore operations [1]

V

  • V$ARCHIVED_LOG view
    • listing all archived logs [1]
  • V$BACKUP_ASYNC_IO view [1]
  • V$BACKUP_DATAFILE view [1] , [2]
  • V$BACKUP_FILES view [1] , [2] , [3]
  • V$BACKUP_PIECE view [1] , [2]
  • V$BACKUP_REDOLOG view [1]
  • V$BACKUP_SET view [1] , [2]
  • V$BACKUP_SPFILE view [1]
  • V$BACKUP_SYNC_IO view [1]
  • V$BACKUP view [1]
  • V$BLOCK_CHANGE_TRACKING view [1]
  • V$CONTROLFILE view [1]
  • V$DATABASE_BLOCK_CORRUPTION view [1] , [2] , [3] , [4] , [6] , [7] , [9] , [10]
  • V$DATABASE_INCARNATION view [1]
  • V$DATABASE view [1] , [2] , [3]
  • V$DATAFILE_HEADER view [1] , [2]
  • V$DATAFILE view
    • listing files for backups [1]
  • V$DIAG_INFO view [1]
  • V$EVENT_NAME view [1]
  • V$FLASHBACK_DATABASE_LOG view [1] , [2] , [3]
  • V$FLASHBACK_DATABASE_STAT view [1]
  • V$INSTANCE view [1]
  • V$LOG_HISTORY view
    • listing all archived logs [1]
  • V$LOGFILE view [1] , [2] , [3]
  • V$PARAMETER view [1]
  • V$PROCESS view [1] , [2]
  • V$RECOVER_FILE view [1] , [2]
  • V$RECOVERY_AREA_USAGE view [1]
  • V$RECOVERY_FILE_DEST [1]
  • V$RECOVERY_FILE_DEST view [1]
  • V$RECOVERY_LOG view
    • listing logs needed for recovery [1]
  • V$RESTORE_POINT view [1]
  • V$RMAN_BACKUP_JOB_DETAILS view [1]
  • V$RMAN_BACKUP_SUBJOB_DETAILS view [1]
  • V$RMAN_ENCRYPTION_ALGORITHMS view [1] , [2] , [3]
  • V$RMAN_OUTPUT view [1]
  • V$RMAN_STATUS view [1]
  • V$SESSION_LONGOPS view [1]
  • V$SESSION_WAIT view [1]
  • V$SESSION view [1] , [2] , [3]
  • V$SGASTAT view [1]
  • V$SYSSTAT view [1]
  • V$TABLESPACE view [1] , [2]
  • VALIDATE command
    • SECTION SIZE parameter [1]
  • VALIDATE HEADER option, RESTORE command [1]
  • validating
  • validation, RMAN
  • views
    • for multisection backups [1]
  • views, recovery catalog [1] , [2]
  • virtual private catalogs
  • Volume Shadow Copy Service (VSS) [1] , [2]

W

  • whole database backups
    • ARCHIVELOG mode [1]
    • inconsistent [1]
    • NOARCHIVELOG mode [1]
    • preparing for [1]
    • using RMAN [1]