Index

A

• %a variable / Specifying parameters
• Active/Inactive / Viewing the status of archival destinations
• Active Duplicate feature
  • about / Active Duplicate
• Add Recovery Catalog option / Catalog settings
• ADD_FILE command / Parallel full database export and interactive-command mode
• Advanced Compression Option (ACO) license
  • about / Using RMAN compression for backups
• advanced Data Pump
  • data masking / Data masking
  • metadata repository, creating / Metadata repository and version control
  • version control, creating / Metadata repository and version control
  • SOURCE_EDITION, using / Using SOURCE_EDITION and TARGET_EDITIONS
  • TARGET_EDITION, using / Using SOURCE_EDITION and TARGET_EDITIONS
  • user, cloning / Cloning a user
  • smaller copies, creating of production environment / Creating smaller copies of production
  • database, creating in different file structure / Creating your database in a different file structure
  • objects, moving from one tablespace to another / Moving all objects from one tablespace to another
  • objects, moving to different schema / Moving an object to a different schema
  • data, migrating for upgrade / Migrating data for upgrade
  • Oracle Database, downgrading / Downgrading an Oracle Database
  • tablespace, transporting / Transporting a tablespace
  • performance tuning tips / Some performance tuning tips
• advanced RMAN
  • completed backup / Information about fully-completed backups
  • active session history, summary / Summary of the active session history
  • time, calculating / How long does it take?
  • V$BACKUP_ASYNC_IO / V$BACKUP_ASYNC_IO
  • TSPITR / Tablespace Point-in-time Recovery (TSPITR)
  • catalog, reporting / Reporting from a catalog
  • duplex backup / Duplex backup
  • database recovery, checking / Check if the database is recoverable
  • recover advisor / Recover advisor
• alert log file
  • using / Using the alert log and operating system trace files
• alerts
  • checking / Check for alerts
• ALTER DATABASE BACKUP CONTROLFILE command
  • about / Text file backup
• ALTER DATABASE FORCE LOGGING command / LOGGING versus NOLOGGING
• application error / Application error
• architecture, Data Pump / The Data Pump architecture
• architecture, RMAN
  • about / RMAN architecture
  • target database / Target database
  • Target Control File / Target Control File
  • channels / RMAN channels
  • auxiliary database / Auxiliary database
  • Recovery Catalog / Recovery Catalog
  • RMAN client / RMAN client
  • EM Cloud Control 12c / Oracle Enterprise Manager (EM) Cloud Control 12c
  • Media Management Library (MML) / Media Management Library (MML)
  • Oracle secure backup (OSB) / Oracle secure backup
  • memory requisites / Memory requirements for RMAN
  • ARCHIVELOG mode, configuring / Configuring ARCHIVELOG mode and FRA
  • FRA, configuring / Configuring ARCHIVELOG mode and FRA
• archived log deletion policy
  • configuring / Configuring the archived log deletion policy
• archived redo logs
  • backups, performing / Performing backups of the control file, the SPFILE, and archived redo logs
• ARCHIVELOG mode
  • about / The ARCHIVELOG mode, Understanding the ARCHIVELOG mode, Cold backup
  • preparing / Preparing for the ARCHIVELOG mode
  • status, checking / Checking the status of the ARCHIVELOG mode
  • parameters, specifying / Specifying parameters
  • archival destinations status, viewing / Viewing the status of archival destinations
  • database, palcing into / Placing a database into the ARCHIVELOG mode
  • undo / Differences between redo and undo
  • redo / Differences between redo and undo
  • excessive redo generation / Facing excessive redo generation during an online backup?
  • hot backup mode / Facing excessive redo generation during an online backup?
  • configuring / Configuring ARCHIVELOG mode and FRA
• ASM (Automatic Storage Management) / Number and size of the input and output buffers
• asynchronous IO mode / Synchronous and asynchronous I/O modes
• AU (Allocation Unit) / Number and size of the input and output buffers
• auto backup configuration
  • for SPFILE / Configuring auto backup for the control file and SPFILE
  • for control file / Configuring auto backup for the control file and SPFILE
• Automatic Diagnostic Repository / Performing backups of the control file, the SPFILE, and archived redo logs
• Automatic Diagnostic Repository (ADR) / Using the alert log and operating system trace files
• Automatic Memory Management (AMM) / Setting the Large Pool memory
• Automatic Shared Memory Management (ASMM) / Setting the Large Pool memory
• auxiliary database / Auxiliary database

B

• backup
  • purpose / Purpose of backup and recovery
  • testing / Testing backups
  • types / Types of backup
  • physical backup / A physical backup
  • logical backup / A logical backup
  • startegy / Backup strategies
  • performing / Taking your first RMAN backup
  • performing, of backups / Performing backups of backups
  • device type, configuration / Configuring the device types for the backup
  • monitoring / Monitoring a backup
  • examples / General backup examples
  • copies / Backup copies
• BACKUP command
  • about / Taking your first RMAN backup, Incrementally updated backups
• backup formats
  • about / Introducing RMAN backup formats
  • backup set / Backup sets
  • image copy / Image copy
• Backup Jobs option / RMAN operations
• backup limits (duration)
  • using / Using backup limits (duration)
• backup optimization
  • about / Using backup optimization
  • configuring / Using backup optimization
• backup piece / Backup sets
• backup privileges
  • about / Backup privileges
  • SYSDBA / Backup privileges
  • SYSBACKUP / Backup privileges
• backup retention policy
  • configuring / Configuring the backup retention policy
  • redundancy / Redundancy retention policy
• backup retention policy configuration
  • about / Configuring the backup retention policy, Redundancy retention policy, Recovery window retention policy
• backups
  • about / Backups
  • and NOLOGGING / Backups and NOLOGGING
  • updating, incrementally / Incrementally updated backups
  • performing, of SPFILE / Performing backups of the control file, the SPFILE, and archived redo logs
  • performing, of control file / Performing backups of the control file, the SPFILE, and archived redo logs
  • performing, of archived redo logs / Performing backups of the control file, the SPFILE, and archived redo logs
  • RMAN compression, using for / Using RMAN compression for backups
  • performing, of pluggable database / Performing backup of a pluggable database and root
  • performing, of root / Performing backup of a pluggable database and root
  • restricting / Restarting RMAN backups
  • compression, configuring / Configuring compression for backups
• backup set
  • about / Backup sets
• backup settings
  • about / Backup settings
• backups outputs (RMAN)
  • monitoring / Monitor backup outputs (RMAN)
• BEGIN BACKUP option
  • about / Hot backups
• benefits, incremental backups / Incremental backups
• BigFile tablespaces / File sections for backups of large data files
• binary backup / Binary backup
• Block Change Tracking (BCT) / Fast incremental backups using the block change tracking (BCT) file
• block change tracking (BCT) file
  • used, for performing incremental backups / Fast incremental backups using the block change tracking (BCT) file
• block corruption, in DB
  • checking / See block corruption in the DB, populated when backup or backup validate
• blocks
  • corrupting, due to NOLOGGING / Block corruption due to NOLOGGING
• BMR
  • performing / Performing Block Media Recovery (BMR)
  • about / Performing Block Media Recovery (BMR)
• bulk deletes
  • about / Bulk deletes, Bulk deletes
• bulk inserts
  • about / Bulk inserts, Bulk inserts
• bulk updates
  • about / Bulk updates, Bulk updates

C

• CATALOG option / Getting started with RMAN
• catalog option / Using the recovery catalog
• catalog settings / Catalog settings
• CDB
  • about / LOGGING versus NOLOGGING, Pluggable database, RMAN for multitenant container databases
• Change Tracking Writer (CTWR) / Fast incremental backups using the block change tracking (BCT) file
• channels
  • configuring / Configuring RMAN channels
• CHECKSYNTAX command
  • about / Using CHECKSYNTAX
  • using / Using CHECKSYNTAX
• cold backup
  • about / Cold backup
• COLD backup / Configuring ARCHIVELOG mode and FRA
• Command Line Interface (CLI) / Sizing and creating a database for the recovery catalog
• commands, RMAN
  • about / Getting introduced to RMAN commands
• compression
  • configuring, for backups / Configuring compression for backups
• configuration, ARCHIVELOG mode / Configuring ARCHIVELOG mode and FRA
• configuration, FRA / Configuring ARCHIVELOG mode and FRA
• Configuration Assistant (DBCA) / Sizing and creating a database for the recovery catalog
• CONFIGURE command / Backup sets
• container database
  • completerecovery / Complete recovery of a container database
• container database, hot backup
  • whole container database / Whole container database
  • root only or individual pluggable database / Root only or individual pluggable database
  • datafile status, checking / Check datafile status
• CONTINUE_CLIENT command / Parallel full database export and interactive-command mode
• control file
  • backups, performing / Performing backups of the control file, the SPFILE, and archived redo logs
  • auto backup, configuring / Configuring auto backup for the control file and SPFILE
  • using, for RMAN metadata / Using the control file for RMAN metadata
• control file backup
  • about / Control file backup
  • binary backup / Binary backup
  • text file backup / Text file backup
• control file backups
  • checking / See the control file backups
• control file recovery
  • performing / Performing control file recovery
• CONTROLFILE_RECORD_KEEP_TIME (CFRKT) / Using the CONTROLFILE_RECORD_KEEP_TIME parameter
• CONTROLFILE_RECORD_KEEP_TIME parameter
  • about / Using the CONTROLFILE_RECORD_KEEP_TIME parameter
  / Using the CONTROLFILE_RECORD_KEEP_TIME parameter
• conventional path method
  • used, for moving data / Conventional path
• copies
  • creating, of production environment / Creating smaller copies of production
• crash recovery
  • about / Crash and media recovery
  • steps / Steps involved in the crash/instance recovery
  • in container / Instance recovery in container and pluggable databases
• Create Restore Point page / Restore points
• Create Whole Database Backup page / RMAN operations
• CTAS
  • about / Indexed organized tables – an exception
• cumulative incremental backup
  • about / Cumulative incremental backup
• Customized Backup option
  • using / Using the Customized Backup option

D

• %d variable / Specifying parameters
• data
  • protecting / Protecting data
  • exporting, from data vault / Exporting data from the data vault
  • importing, via data link / Importing data via a network link
  • migrating, for upgrade / Migrating data for upgrade
• database
  • backing up, steps / Cold backup
  • creating, in different file structure / Creating your database in a different file structure
  • configuring / Configuring the database, Creating a new redo log group and associated files
• database configuration
  • spfile, using / Making sure an spfile is used to start the database
  • in archivelog mode / Placing the database in the archivelog mode and activating Flashback
  • Flashback, activating / Placing the database in the archivelog mode and activating Flashback
  • new redo log group, creating / Creating a new redo log group and associated files
• database duplication
  • steps / Active duplication of a database to a different server with the same structure (non-OMF and non-ASM)
  • PDB / Duplicating a PDB
  • ASM backup / ASM backup and restore
  • ASM restore / ASM backup and restore
  • SYSTEM tablespace loss, recovering from / Recovering from the loss of the SYSTEM tablespace
  • lost datafile, recovering from / Recovering a lost datafile using an image from an FRA
• Database Point-in-Time Recovery (DBPITR) / Table recovery
• database startup
  • stage overview / Overview of stages in the database startup
• data definition language (DDL)
  • about / Table recovery
• datafile / Data Pump files
• datafile copy method
  • used, for moving data / Datafile copy
• datafiles
  • working on / Skipping offline, inaccessible, or read-only datafiles
• data masking
  • about / Data masking
• data protetcion
  • media failure / Media failure
  • hardware failure / Hardware failure
  • hman error / Human error
  • application error / Application error
• Data Pump
  • import operations / Roles for Data Pump export and import
  • export operations / Roles for Data Pump export and import
  • about / Magic with Data Pump
  • preparing / Preparing Data Pump
  • data masking / Data masking
  • metadata repository / Metadata repository
  • user, cloning / Cloning a user
  • database, creating / Creating your database in a different structure
  • time based flashback / Time-based flashback
• Data Pump API / The Data Pump architecture
• Data Pump commands
  • auditing / Auditing Data Pump commands
• Data Pump flashback
  • about / Data Pump flashback
• Data Pump operations
  • Export Jobs / Data Pump operations
  • Import Jobs / Data Pump operations
• Data Pump utility
  • about / What is Data Pump?
  • features / What is Data Pump?
  • architecture / The Data Pump architecture
  • new concepts / New concepts with Data Pump
  • methods / Methods to move the data
  • files / Data Pump files
  • scenarios / Data Pump scenarios
  • job status, monitoring / Monitoring Data Pump job status
• DATAPUMP_EXP_FULL_DATABASE role / Roles for Data Pump export and import, Importing data via a network link
• DATAPUMP_IMP_FULL_DATABASE role / Roles for Data Pump export and import, Importing data via a network link
• data vault
  • data, exporting from / Exporting data from the data vault
• DBID
  • about / Getting started with RMAN
• DBMS_DATAPUMP package / The Data Pump architecture
• DBMS_METADATA package / The Data Pump architecture
• DBMS_REPAIR package / Why RMAN?
• DBPITR
  • recovering, steps / Recovering from a user-managed backup
  / Database Point-in-time Recovery (DBPITR)
• DBWR (database writer) / Synchronous and asynchronous I/O modes
• DEBUG clause
  • used, for debugging RMAN / Debugging RMAN using the DEBUG clause
• deletion policy
  • archiving / Archive deletion policy
• device type configuration
  • for backup / Configuring the device types for the backup
• dictionary views
  • used, for monitoring RMAN IO performance / Monitoring RMAN I/O performance using dictionary views
• differential incremental backup
  • about / Differential incremental backup
• Direct Memory Access (DMA) / Tuning SBT (tape) performance
• directory objects / New concepts with Data Pump
  • about / Directory objects
  • creating / Creating directory objects
• Direct Path API / The Data Pump architecture
• direct path inserts
  • about / Direct path inserts
• direct path load
  • using, in SQL*Loader / Direct path load using SQL*Loader
• direct path method
  • used, for moving data / Direct path
• DR (Disaster and Recovery)
  • about / Recovery Catalog
• DRA
  • about / Data recovery advisor
  • commands / Data recovery advisor
• DRP / Testing backups
• dump files / Data Pump files
• duplexed backups
  • creating / Creating duplexed backups
• DUPLICATE command / Active Duplicate, Duplicating a PDB

E

• EM Cloud Control 12c
  • about / Oracle Enterprise Manager (EM) Cloud Control 12c
• encrypted backups
  • configuring / Configuring encrypted backups
• encrypted backups configuration
  • about / Configuring encrypted backups
  • modes / Configuring encrypted backups
  • modes, Transparent Data Encryption (TDE) / Transparent encryption of backups
  • Oracle Software Keystore, creating / Creating and using Oracle Software Keystore
  • modes, Password encryption / Password encryption
  • modes, dual mode encryption / Dual-mode encryption
• encryption password feature / Encryption password
• enhancements, Data Pump
  • about / Data Pump's new features and enhancements
  • LOGGING, disabling on Data Pump Import / Disabling LOGGING on Data Pump Import
  • full transportable Export/Import / Full transportable Export/Import
  • views, exporting as tables / Exporting views as tables
  • extended character data types / Extended character data types
  • encryption password / Encryption password
  • tables, compressing on import / Compressing tables on Import
  • data, exporting from data vault / Exporting data from the data vault
  • SecureFile LOBs, creating on Import / Creating SecureFile LOBs on Import
  • Data Pump commands, auditing / Auditing Data Pump commands
• enhancements, RMAN
  • about / RMAN new features and enhancements
  • backup and restore, for pluggable database / Container and pluggable database backup and restore
  • backup and restore, for container database / Container and pluggable database backup and restore
  • Enterprise Manager Database Express / Enterprise Manager Database Express
  • backup privileges / Backup privileges
  • SQL commands / SQL and DESCRIBE
  • DESCRIBE / SQL and DESCRIBE
  • multi-section backups, for incremental backups / Multi-section backups for incremental backups
  • network-based recovery / Network-based recovery
  • Active Duplicate feature / Active Duplicate
  • support, for third-party snapshot / Support for the third-party snapshot
  • cross-platform data transport / Cross-platform data transport
  • table recovery / Table recovery
• Enterprise Manager Database Express
  • about / Enterprise Manager Database Express
• error stack
  • reading / Reading the RMAN error stack
• Exadata
  • about / Pluggable database
• execute command / Creating and managing stored scripts
• EXECUTE_CATALOG_ROLE role
  • about / Offline backup
• EXIT_CLIENT command / Parallel full database export and interactive-command mode
• exp utility / A logical backup
  • about / What is Data Pump?
• extended character data types / Extended character data types
• External Table API / The Data Pump architecture
• external tables method
  • used, for moving data / External tables

F

• Fast Recovery Area (FRA)
  • configuring / Configuring the FRA
• features, RMAN / Why RMAN?
• files, Data Pump
  • dump files / Data Pump files
  • log file / Data Pump files
  • SQL files / Data Pump files
  • datafile / Data Pump files
• file sections
  • for backups, of large data files / File sections for backups of large data files
• FILESIZE command / Parallel full database export and interactive-command mode
• Flashback Database
  • about / Flashback database
  • enabling, steps / Flashback database
• FLASHBACK DATABASE command
  • options / Flashback database
• FLASHBACK DROP functionality / Table recovery
• FORCE LOGGING mode
  • about / LOGGING versus NOLOGGING
• FRA
  • about / Flashback database, Configuring ARCHIVELOG mode and FRA
  • configuring / Configuring ARCHIVELOG mode and FRA
  / Synchronous and asynchronous I/O modes
• FRA usage
  • checking / Check FRA usage
• full backup
  • about / Full backup
  • performing, of multitenant CDB / Performing a full backup of a multitenant CDB
• full backups / Using incremental, multi-section, multiplexing, and parallelism

G

• generated archived log, by DB target
  • checking / See the archived log generated by the DB target
• Graphical User Interface (GUI) / Sizing and creating a database for the recovery catalog

H

• HCC (Hybrid Columnar Compression) / Why RMAN?
• HELP command / Parallel full database export and interactive-command mode
• high water mark (HWM)
  • about / LOGGING versus NOLOGGING
• hot backup
  • about / Hot backups
  • performing, of whole database / Hot backup of a whole database
  • performing, of tablespaces / Hot backup of tablespaces
  • of container database / Hot backup of a container database
• HOT backup / Configuring ARCHIVELOG mode and FRA
• human error / Human error

I

• image copy
  • about / Image copy
  • full backup / Full backup
  • incremental backups / Incremental backups
  • power of one / Power of one
• impdp tool
  • about / Metadata repository and version control
• Import
  • SecureFile LOBs, creating on / Creating SecureFile LOBs on Import
• imp utility / A logical backup
  • about / What is Data Pump?
• incremental backups
  • multi-section backups / Multi-section backups for incremental backups
  • about / Incremental backups
  • benefits / Incremental backups
  • differential incremental backup / Differential incremental backup
  • cumulative incremental backup / Cumulative incremental backup
  • performing, RMAN used / Using RMAN for performing incremental backups
  • performing, block change tracking (BCT) file used / Fast incremental backups using the block change tracking (BCT) file
  / Using incremental, multi-section, multiplexing, and parallelism, Incremental backups
• index-organized table (IOT)
  • about / Indexed organized tables – an exception
• interactive command-line mode / New concepts with Data Pump
• IO
  • and RMAN / I/O and RMAN – two sides of one coin
• IO operation
  • read phase / I/O and RMAN – two sides of one coin
  • copy phase / I/O and RMAN – two sides of one coin
  • write phase / I/O and RMAN – two sides of one coin

J

• job
  • monitoring / Monitoring the job

K

• key terms, recovery
  • data block / Key terms related to recovery
  • dirty block / Key terms related to recovery
  • change vectors / Key terms related to recovery
  • redo records / Key terms related to recovery
  • redo log buffer / Key terms related to recovery
  • redo log files / Key terms related to recovery
  • redo thread / Key terms related to recovery
  • redo stream / Key terms related to recovery
  • checkpoin / Key terms related to recovery
• KILL_JOB command / Parallel full database export and interactive-command mode

L

• Large Object (LOB) technology / Extended character data types
• Large Pool memory
  • setting / Setting the Large Pool memory
• Least Recently Used (LRU) algorithm / Synchronous and asynchronous I/O modes
• LGWR
  • about / Configuring ARCHIVELOG mode and FRA
• LIST BACKUP command / Unregistering databases from the recovery catalog
• LIST command
  • used, for reporting / Using the LIST command
• log buffer space event
  • about / The 'log buffer space' event
• log file / Data Pump files
• log file parallel write event / The 'log file parallel write' event
• log file sync event
  • about / The 'log file sync' event
• LOGGING
  • disabling, on Data Pump Import / Disabling LOGGING on Data Pump Import
• LOGGING operations
  • versus NOLOGGING operations / LOGGING versus NOLOGGING
  • tips / Tips when LOGGING is in effect (not using NOLOGGING)
• logical backup / A logical backup
• log writer (LGWR) process / What is redo?
• LOG_ARCHIVE_DEST_n parameter / Specifying parameters
• LOG_ARCHIVE_FORMAT parameter / Specifying parameters
• LOG_ARCHIVE_MIN_SUCCEED_DEST parameter / Specifying parameters

M

• md_backup command / ASM backup and restore
• Media Management Library (MML)
  • about / Media Management Library (MML)
  / Using the alert log and operating system trace files
• media recovery / Crash and media recovery
  • performing / Performing media recovery
• memory requisites, RMAN / Memory requirements for RMAN
• Metadata API / The Data Pump architecture
• metadata repository
  • building / Metadata repository and version control
• methods, Data Pump utility
  • datafile copy / Datafile copy
  • direct path / Direct path
  • external tables / External tables
  • conventional path / Conventional path
  • network link / Network link
• MOS (My Oracle Support) / Using the alert log and operating system trace files
• multi-section backups
  • for incremental backups / Multi-section backups for incremental backups
  / Using incremental, multi-section, multiplexing, and parallelism
• multiplexing / Using incremental, multi-section, multiplexing, and parallelism
• multi section incremental backups
  • about / Multi-section incremental backups
• multisections’ backups / Multisection backups
• multitenant CDB
  • full backup, performing / Performing a full backup of a multitenant CDB
• Multitenant Container Database
  • about / LOGGING versus NOLOGGING
  / Pluggable database
• multitenant container databases, RMAN
  • about / RMAN for multitenant container databases
  • full backup, performing of multitenant CDB / Performing a full backup of a multitenant CDB
  • partial backup, performing of multitenant CDB / Partial backup of a multitenant CDB
  • backup, performing of pluggable database / Performing backup of a pluggable database and root
  • backup, performing of root / Performing backup of a pluggable database and root
  • backup, performing of backups / Performing backups of backups
  • backups, restoring / Restarting RMAN backups
  • RMAN views, related to backups / Useful RMAN views related to backups

N

• NBC
  • about / Using RMAN compression for backups
• need backup option / Using the REPORT command
• Netbackup / Why RMAN?
• network-based recovery / Network-based recovery
• Network Configuration Assistant (NETCA) / Using the recovery catalog
• network link
  • data, importing via / Importing data via a network link
• network link method
  • used, for moving data / Network link
• Network Manager (NETMGR) / Using the recovery catalog
• newly added datafiles
  • backups / Backup of newly added datafiles
• NOARCHIVELOG mode / The NOARCHIVELOG mode, Cold backup
  • recovery / Recovery in the NOARCHIVELOG mode
• NOLOGGING operations
  • versus LOGGING operations / LOGGING versus NOLOGGING
  • about / NOLOGGING operations
  • and backups / Backups and NOLOGGING
  • blocks, corrupting / Block corruption due to NOLOGGING
  • changes, repairing on physical standby database / Repairing NOLOGGING changes on physical and logical standby databases
• non-system data files
  • recovery, ways / Loss of non-system data files
• NO UNREGISTER option / Merging multiple recovery catalogs into one

O

• objects
  • moving, from one tablespace to another / Moving all objects from one tablespace to another
  • moving, to different schema / Moving an object to a different schema
• OEM12c
  • operations performing, with Data Pump / Export/Import with OEM12c
  • export operation, performing / Executing an export operation
  • export, performing / Executing an export operation
• offline backup
  • about / Offline backup
• Offline backups
  • RMAN, using / Offline backups with RMAN
  • configured defaults, avoiding / Offline backup without using configured defaults
• offline tablespaces
  • backing up, steps / Offline backup
• operating system trace file
  • using / Using the alert log and operating system trace files
• ORA-600 / Using the alert log and operating system trace files
• ORA-4031
  • about / Getting started with RMAN troubleshooting
  / Getting started with RMAN troubleshooting
• ORA-19511 / Using the alert log and operating system trace files
• Oracle-Suggested Backup strategy option
  • using / Using the Oracle-Suggested Backup strategy option
• Oracle Database
  • downgrading / Downgrading an Oracle Database
• Oracle Debugger (oradebug) / Using the control file for RMAN metadata
• Oracle Enterprise Manager (OEM) / Preparing for the ARCHIVELOG mode
• Oracle Enterprise Manager Cloud Control / Enterprise Manager Database Express
• Oracle Enterprise MOEM12c
  • backup settings / Backup settings
  • recovery settings / Recovery settings
  • catalog settings / Catalog settings
• Oracle Secure Backup (OSB) / Tuning SBT (tape) performance
• OSB (Oracle Secure Backup)
  • about / Oracle secure backup

P

• PARALLEL command / Parallel full database export and interactive-command mode
• parallelism / Using incremental, multi-section, multiplexing, and parallelism
• partial backup
  • performing, of multitenant CDB / Partial backup of a multitenant CDB
• partitioning
  • about / Partitioning, Partitioning
• PDB
  • about / Pluggable database, RMAN for multitenant container databases
  • upgrading / Pluggable database
• PGA (Program Global Area) / I/O and RMAN – two sides of one coin
• physical backup / A physical backup
• physical standby database
  • NOLOGGING changes. repairing on / Repairing NOLOGGING changes on physical and logical standby databases
• pluggable database
  • about / Pluggable database
  • key points / Pluggable database
  • complete recovery / Complete recovery of a pluggable database
  • importing / Exporting and importing a whole database/pluggable database
  • exporting / Exporting and importing a whole database/pluggable database
• point-in-time recovery
  • performing / Performing point-in-time recovery, Database Point-in-time Recovery (DBPITR), Tablespace Point-in-time Recovery (TSPITR)
• point-in-time recovery, performing
  • DBPITR / Database Point-in-time Recovery (DBPITR)
  • TSPITR / Tablespace Point-in-time Recovery (TSPITR)
• production environment
  • smaller copies, creating / Creating smaller copies of production

R

• %r variable / Specifying parameters
• read-only datafiles
  • backups / Forcing backups of read-only datafiles
• Real Application Cluster (RAC) / Crash and media recovery
• RECOVER command / Network-based recovery, Support for the third-party snapshot, Incrementally updated backups
• recovery
  • purpose / Purpose of backup and recovery
  • versus, restore / Restore versus recovery
  • NOARCHIVELOG mode / Recovery in the NOARCHIVELOG mode
• Recovery Catalog / Why RMAN?, Recovery Catalog
• recovery catalog
  • features / What is a recovery catalog
  • creating / Creating the recovery catalog, Creating the recovery catalog
  • database, sizing / Sizing and creating a database for the recovery catalog
  • database, creating / Sizing and creating a database for the recovery catalog
  • default tablespace, creating for catalog owner / Creating the default tablespace for the catalog owner
  • catalog owner schema, creating / Creating the catalog owner schema
  • privileges, granting to catalog owner / Granting privileges to the catalog owner
  • using / Using the recovery catalog
  • resynchronizing, with control file / Resynchronizing the recovery catalog with the control file
  • merging, into single / Merging multiple recovery catalogs into one
  • virtual private catalogs, using / Using virtual private catalogs
  • stored scripts, creating / Creating and managing stored scripts
  • stored scripts, managing / Creating and managing stored scripts
  • availabilty, checking / Making a recovery catalog highly available
  • protecting, methods / Making a recovery catalog highly available
  • upgrading / Upgrading the recovery catalog
  • databases, unregistering from / Unregistering databases from the recovery catalog
  • dropping / Dropping a recovery catalog
  • related views / Views related to the recovery catalog
• Recovery Catalog Settings page / Catalog settings
• Recovery Point Objective (RPO) / Backup strategies
• recovery scenarios
  • about / Losing all copies of the current control file, Loss of archived redo logs or online redo logs
• recovery settings / Recovery settings
• Recovery Time Objective (RTO) / Backup strategies
• recovery window retention policy / Recovery window retention policy
• redo
  • about / What is redo?
  • log files / What is redo?
  • log groups, using / What is redo?
• redo, facts
  • redo, for DML / Redo and undo for DML
  • undo, for DML / Redo and undo for DML
  • redo, and temporary tables / Redo and temporary tables
  • redo generation / Redo generation and materialized views
  • materialized view / Redo generation and materialized views
  • Flashback, and NOLOGGING / Flashback and NOLOGGING
  • performance, considerations / Performance and recovery considerations
  • recovery, considerations / Performance and recovery considerations
  • direct path load, using in SQL*Loader / Direct path load using SQL*Loader
• redo, scripts
  • redo_since_startup.sql / Redo generated since instance startup
  • redo_since_session_started.sql / Redo generated since session startup
  • redo_generated_by_session.sql / Redo generated by current user sessions
  • redo_current_status.sql / Current status for redo logs
  • redo_switch_info.sql / Redo log group and log switch information
  • NOLOGGING objects, in database / NOLOGGING objects in the database
• Redo Apply / Repairing NOLOGGING changes on physical and logical standby databases
• redo generating sessions
  • searching / Finding sessions that generate lots of redo
• redo generation
  • about / Redo generation and recoverability
  • disabling / Disabling redo generation (NOLOGGING)
  • reducing / Reducing redo generation
• redo logs
  • archiving / Understanding the ARCHIVELOG mode
• redo log space request event
  • about / The 'redo log space request' event
• redo related wait events
  • about / Redo-related wait events
  • log file parallel write / The 'log file parallel write' event
  • log file sync / The 'log file sync' event
  • redo log space request / The 'redo log space request' event
  • log buffer space / The 'log buffer space' event
• redo switches time
  • checking / FRA – checking number of redo switches
• redo_current_status.sql script / Current status for redo logs
• redo_generated_by_session.sql script / Redo generated by current user sessions
• redo_since_session_started.sql script / Redo generated since session startup
• redo_since_startup.sql script / Redo generated since instance startup
• redo_switch_info.sql script / Redo log group and log switch information
• redundancy / Backup settings
• redundancy retention policy / Redundancy retention policy
• REMAP_DATA parameter / Data masking
• REPORT command
  • used, for reporting / Using the REPORT command
• RESETLOGS option / Active duplication of a database to a different server with the same structure (non-OMF and non-ASM)
• restore
  • versus recovery / Restore versus recovery
• restore point
  • using / Restore points
  • normal restore point / Restore points
  • guaranteed restored point / Restore points
• Retain all backups option / Backup settings
• retention policy, for backup set
  • modifying / Modifying the retention policy for a backup set (archival backups)
• REUSE_DUMPFILES command / Parallel full database export and interactive-command mode
• Review page / Executing an export operation
• RMAN
  • used, for performing table partitions recovery / Table recovery
  • features / Why RMAN?
  • starting with / Getting started with RMAN
  • architecture / RMAN architecture
  • backup formats / Introducing RMAN backup formats
  • used, for performing incremental backups / Using RMAN for performing incremental backups
  • for multitenant container databases / RMAN for multitenant container databases
  • authentication configuration / Configuring authentication for RMAN
  • reporting option / Reporting in RMAN
  • reporting option, LIST command used / Using the LIST command
  • reporting option, REPORT command used / Using the REPORT command
  • about / Getting started with RMAN troubleshooting
  • debugging, DEBUG clause used / Debugging RMAN using the DEBUG clause
  • and IO / I/O and RMAN – two sides of one coin
  • controlling / Stopping RMAN from being uncontrollable
  • configuring / Configuring RMAN
  • using, for DB scan / Using RMAN to scan DB for physical and logical errors
• RMAN authentication configuration
  • about / Configuring authentication for RMAN
  • OS authentication / Operating system authentication
  • password file authentication / Authenticating the password file
• RMAN backup
  • scheduling / Scheduling an RMAN backup
  • Oracle-Suggested Backup strategy option, using / Using the Oracle-Suggested Backup strategy option
  • Customized Backup option, using / Using the Customized Backup option
• RMAN backups
  • table partition-level recovery / Table and table partition-level recovery from RMAN backups
• RMAN channels / RMAN channels
• RMAN client
  • about / RMAN client
• RMAN commands
  • about / Getting introduced to RMAN commands
• RMAN compression
  • using, for backups / Using RMAN compression for backups
• RMAN configuration
  • about / RMAN configuration – an introduction
  • V$RMAN_CONFIGURATION view using / Using the V$RMAN_CONFIGURATION view
  • SHOW ALL command / Using the SHOW ALL command
  • target DB RMAN backup account, creating / Creating the target DB RMAN backup account
  • configure command, using / Configure RMAN using the configure command
  • database, backing up / Backup database
  • obsolete backups, checking / Checking and deleting obsolete backups
  • catalog user, creating / Creating RMAN catalog user
  • recovery catalog, creating / Creating recovery catalog
  • DB, registering in recovery catalog / Register your DB in the recovery catalog
  • virtual private catalog, creating / Creating a virtual private catalog
  • Block Change tracking, enabling / Enabling Block Change tracking
  • checking / See all RMAN configurations (equivalent to show all)
• RMAN IO performance
  • monitoring, dictionary views used / Monitoring RMAN I/O performance using dictionary views
• RMAN metadata
  • control file, using / Using the control file for RMAN metadata
• RMAN operations
  • monitoring / Monitoring RMAN sessions and operations
• RMAN options
  • Backup Jobs / RMAN operations
  • Backup Sets / RMAN operations
  • Image Copies / RMAN operations
  • RMAN Settings / RMAN operations
  • Scheduled RMAN Actions / RMAN operations
• rmanoutput.log file / Getting started with RMAN
• RMAN performance
  • troublseshooting, tracing used / Troubleshooting RMAN performance using tracing
• RMAN performance tuning
  • about / RMAN tuning – an introduction
• RMAN session
  • monitoring / Monitoring RMAN sessions and operations
• RMAN troubleshooting
  • about / Getting started with RMAN troubleshooting
• RMAN views, related to backups
  • V$BACKUP_FILES / Useful RMAN views related to backups
  • V$BACKUP_PIECE / Useful RMAN views related to backups
  • V$BACKUP_REDOLOG / Useful RMAN views related to backups
  • V$BACKUP_SET_SUMMARY / Useful RMAN views related to backups
  • V$BACKUP_CONTROLFILE_DETAILS / Useful RMAN views related to backups
  • V$BACKUP_COPY_DETAILS / Useful RMAN views related to backups
  • V$BACKUP_DATAFILE_DETAILS / Useful RMAN views related to backups
  • V$RMAN_OUTPUT / Useful RMAN views related to backups
  • V$RMAN_STATUS / Useful RMAN views related to backups
  • V$RMAN_BACKUP_JOB_DETAILS / Useful RMAN views related to backups
• rollback segments
  • about / Redo and undo for DML
• root container
  • complete recovery / Complete recovery of the root container
• RPC (Remote Procedure Calls)
  • about / Oracle secure backup

S

• %s variable / Specifying parameters
• %S variable / Specifying parameters
• SaaS (Software as a Service)
  • about / Pluggable database
• SBT performance
  • tuning / Tuning SBT (tape) performance
• SBTTEST utility / Using the alert log and operating system trace files
• scenarios, Data Pump utility
  • schema export / Schema export and import
  • schema import / Schema export and import
  • tables, importing / Exporting and importing tables
  • tables, exporting / Exporting and importing tables
  • pluggable database, exporting / Exporting and importing a whole database/pluggable database
  • pluggable database, importing / Exporting and importing a whole database/pluggable database
  • Export, used for estimating space / Using Export to estimate space
  • parallel full database export / Parallel full database export and interactive-command mode
  • interactive-command mode / Parallel full database export and interactive-command mode
  • tables, importing with only metadata / Importing tables with only metadata
  • views, exporting as tables / Exporting views as tables
  • data, importing via network link / Importing data via a network link
• SCN (System Change Number) / Facing excessive redo generation during an online backup?
  • about / Flashback and NOLOGGING, Fast incremental backups using the block change tracking (BCT) file
• SecureFile LOBs
  • creating, on Import / Creating SecureFile LOBs on Import
• SEED
  • about / Pluggable database
• SGA (System Global Area) / I/O and RMAN – two sides of one coin
• Shared Pool / Memory requirements for RMAN
• SHOW ALL command
  • using / Using the SHOW ALL command
• SID (System ID) / Monitoring RMAN sessions and operations
• SLAs (Service Level Agreement) / Backup strategies
• snapshot control file
  • configuring / Configuring the snapshot control file
• SOURCE_EDITION parameter
  • using / Using SOURCE_EDITION and TARGET_EDITIONS
• Specific number of days option / Backup settings
• SPFILE
  • backups, performing / Performing backups of the control file, the SPFILE, and archived redo logs
  • auto backup, configuring / Configuring auto backup for the control file and SPFILE
• SQL*Loader
  • direct path loader, using in / Direct path load using SQL*Loader
• SQL developer 3.2
  • about / SQL developer 3.2
  • RMAN Operations / RMAN operations
  • Data Pump operations / Data Pump operations
• SQL files / Data Pump files
• SSN
  • about / Data masking
• START_JOB command / Parallel full database export and interactive-command mode
• Statspack report
  • about / The 'log file parallel write' event
• STATUS command / Parallel full database export and interactive-command mode
• STOP_JOB command / Parallel full database export and interactive-command mode
• Symmetric Binary Tape (SBT) / Using backup optimization
• synchronous IO mode / Synchronous and asynchronous I/O modes
• SYSBACKUP administrative privilege
  • about / Backup privileges
• SYSBACKUP privilege / Getting started with RMAN
• SYSDBA privilege / Backup privileges, Getting started with RMAN
• system data files
  • recovery,steps / Loss of system data files

T

• %T variable / Specifying parameters
• %t variable / Specifying parameters
• table partition-level recovery
  • RMAN backups / Table and table partition-level recovery from RMAN backups
• table partitions recovery
  • performing, RMAN used / Table recovery
• tables
  • views, exporting as / Exporting views as tables, Exporting views as tables
  • compressing, on import / Compressing tables on Import
  • importing / Exporting and importing tables
  • exporting / Exporting and importing tables
  • importing, with only metadata / Importing tables with only metadata
• tablespace
  • transporting / Transporting a tablespace
• Tablespace Point-in-Time Recovery (TSPITR)
  • about / Recovering from a user-managed backup
• tablespace point-in-time recovery (TSPITR)
  • about / Table recovery, Auxiliary database
• tablespaces
  • configuring, for exclusion / Configuring tablespaces for exclusion from whole database backups
• TABLE_EXISTS_ACTION parameter / Importing tables with only metadata
• Target Control File / Target Control File
• target database / Target database
• TARGET_EDITION parameter
  • using / Using SOURCE_EDITION and TARGET_EDITIONS
• tee command / Getting started with RMAN
• temporary file
  • recovery, ways / Loss of a temporary file
• text file backup / Text file backup
• tips, LOGGING operations
  • backups / Backups
  • bulk inserts / Bulk inserts
  • bulk deletes / Bulk deletes
  • bulk updates / Bulk updates
  • partitioning / Partitioning
  • for developers / Tips for developers
• tips, NOLOGGING operations
  • partitioning / Partitioning
  • direct path inserts / Direct path inserts
  • bulk inserts / Bulk inserts
  • bulk deletes / Bulk deletes
  • bulk updates / Bulk updates
• Tivoli / Why RMAN?
• tracing
  • used, for troubleshooting RMAN performance / Troubleshooting RMAN performance using tracing
• Transparent Network Substrate (TNS) / Using the recovery catalog
• transportable tablespace set / Transporting a tablespace
• TSPITR / Tablespace Point-in-time Recovery (TSPITR)
• TSPITR (Tablespace Point-in-Time Recovery)
  • about / Multi-section backups for incremental backups

U

• UBC
  • about / Using RMAN compression for backups
• UNREGISTER command / Unregistering databases from the recovery catalog
• UPGRADE CATALOG command / Upgrading the recovery catalog
• user
  • cloning / Cloning a user
• user-managed backup
  • recovering from / Recovering from a user-managed backup

V

• V$BACKUP_ASYNC_IO view
  • about / V$BACKUP_ASYNC_IO (for asynchronous I/O)
• V$BACKUP_CONTROLFILE_DETAILS view / Useful RMAN views related to backups
• V$BACKUP_COPY_DETAILS view / Useful RMAN views related to backups
• V$BACKUP_DATAFILE_DETAILS view / Useful RMAN views related to backups
• V$BACKUP_FILES view / Useful RMAN views related to backups
• V$BACKUP_PIECE view / Useful RMAN views related to backups
• V$BACKUP_REDOLOG view / Useful RMAN views related to backups
• V$BACKUP_SET_SUMMARY view / Useful RMAN views related to backups
• V$BACKUP_SYNC_IO view
  • about / V$BACKUP_SYNC_IO (for synchronous I/O)
• v$pwfile_users view
  • about / Backup privileges
• V$RECOVERY_AREA_USAGE view
  • options / Flashback database
• V$RECOVERY_FILE_DEST view
  • options / Flashback database
• V$RMAN_BACKUP_JOB_DETAILS view / Useful RMAN views related to backups
• V$RMAN_CONFIGURATION view
  • using / Using the V$RMAN_CONFIGURATION view
• V$RMAN_OUTPUT view / Useful RMAN views related to backups
• V$RMAN_STATUS view / Useful RMAN views related to backups
• Valid/Invalid / Viewing the status of archival destinations
• version control
  • creating / Metadata repository and version control
• views
  • exporting, as tables / Exporting views as tables, Exporting views as tables
• VLDB (Very Large Databases) / Why RMAN?

X

• X$KCCBP (Kernel Cache Control Backup Piece) / Using the control file for RMAN metadata