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
- 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
- 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
- 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
- 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
- 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
- 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
- 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 / 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
- cumulative incremental backup
- about / Cumulative incremental backup
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- index-organized table (IOT)
- 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
- 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)
- 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
- multiplexing / Using incremental, multi-section, multiplexing, and parallelism
- 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
- 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
- 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
- ORA-600 / Using the alert log and operating system trace files
- ORA-4031 / Getting started with RMAN troubleshooting
- ORA-19511 / Using the alert log and operating system trace files
- 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
- point-in-time recovery, performing
- 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
- 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
- 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
- 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
- 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
- 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?
- 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
- 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
- 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)
- 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
- 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)
U
- UBC
- 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
- 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
- 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
- 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
