Book Image

Oracle Database 12c Backup and Recovery Survival Guide

Book Image

Oracle Database 12c Backup and Recovery Survival Guide

Overview of this book

The three main responsibilities of a successful DBA are to ensure the availability, recoverability, and performance of any database. To ensure the recoverability of any database, a DBA needs to have a strong backup and recovery skills set. Every DBA is always looking for a reference book that will help them to solve any possible backup and recovery situation that they can come across in their professional life. Oracle Database 12c Backup and Recovery Survival Guide has the unique advantage to be a reference to all Oracle backup and recovery options available, making it essential for any DBA in the world. If you are new to Oracle Database, this book will introduce you to the fantastic world of backup and recovery that is vital to your success. If you are an experienced DBA, this book will become a reference guide and will also help you to learn some possible new skills, or give you some new ideas you were never aware about. It will also help you to easily find the solution to some of the most well known problems you could find during your career as a DBA. This book contains useful screenshots, scripts, and examples that you will find more than useful. Most of the books currently available in the market concentrate only on the RMAN utility to backup and recovery. This book will be an exception to the rule and will become a must-have reference, allowing you to design a real and complete backup and recovery strategy. It covers the most important topics on Oracle database such as backup strategies, Nologging operations, new features in 12c, user managed backups and recoveries, RMAN (including reporting, catalog management, troubleshooting, and performance tuning), advanced data pump, Oracle Enterprise Manager 12c and SQL Developer. "Oracle Database 12c Backup and Recovery Survival Guide" contains everything a DBA needs to know to keep data safe and recoverable, using real-life scenarios.
Table of Contents (22 chapters)
Oracle Database 12c Backup and Recovery Survival Guide
Credits
About the Author
Acknowledgement
About the Author
Acknowledgement
About the Reviewers
www.PacktPub.com
Preface
Index

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