Table of Contents

• Title and Copyright Information
• Preface
  • Audience
  • Documentation Accessibility
  • Related Documentation
  • Conventions
• Changes in This Release for Backup and Recovery User's Guide
  • Changes in Oracle Database Release 19c
  • Changes in Oracle Database Release 18c, Version 18.1
• Part I Overview of Backup and Recovery
  • 1 Introduction to Backup and Recovery
    • Purpose of Backup and Recovery
      • About Data Protection
      • About Failures that Require Database Recovery
      • About Data Archival
      • About Data Transfer
    • Oracle Backup and Recovery Solutions
    • Comparison of Oracle Backup Techniques
    • About Oracle Flashback Technology
      • Logical Flashback Features
      • Flashback Database
    • About Data Recovery Advisor
    • RMAN and Oracle Enterprise Manager Cloud Control
      • About Oracle Enterprise Manager Cloud Control
      • Accessing the Database Home Page Using Cloud Control
      • Performing Backup and Recovery Tasks with Cloud Control
    • About Zero Data Loss Recovery Appliance
      • Using RMAN with Recovery Appliance
    • Backup and Recovery Documentation Roadmap
      • Recovery Manager Documentation Roadmap
      • User-Managed Backup and Recovery Documentation Roadmap
  • 2 Getting Started with RMAN
    • Overview of the RMAN Environment
    • Starting RMAN and Connecting to a Database: Quick Start
    • Showing the Default RMAN Configuration
    • Backing Up a Database: Quick Start
      • About Typical RMAN Backup Options
      • Backing Up a Database in ARCHIVELOG Mode
      • Backing Up a Database in NOARCHIVELOG Mode
      • Making Incremental Backups: Quick Start
      • Making Incrementally Updated Backups
      • Validating Database Files and Backups: Quick Start
      • Scripting RMAN Operations
    • Reporting on RMAN Operations: Quick Start
      • Listing Backups: Quick Start
      • Reporting on Database Files and Backups: Quick Start
    • Maintaining RMAN Backups
      • Cross-checking Backups: Quick Start
      • Deleting Obsolete Backups: Quick Start
    • Diagnosing and Repairing Failures with Data Recovery Advisor: Quick Start
      • Listing Failures and Determining Repair Options
      • Repairing Failures: Quick Start
    • Rewinding a Database with Flashback Database: Quick Start
    • Restoring and Recovering Database Files: Quick Start
      • Preparing to Restore and Recover Database Files: Quick Start
      • Recovering the Whole Database: Quick Start
      • Recovering Tablespaces: Quick Start
      • Recovering Individual Data Blocks: Quick Start
• Part II Starting and Configuring RMAN and Flashback Database
  • 3 Recovery Manager Architecture
    • About the RMAN Environment
    • About RMAN Command-Line Client
    • About RMAN Channels
      • About RMAN Channels and Devices
      • About RMAN Automatic and Manual Channels
    • About the RMAN Repository
    • About Media Management Using RMAN
      • About RMAN Interaction with a Media Manager
      • About RMAN and Oracle Secure Backup
      • About the Backup Solutions Program
    • About the Fast Recovery Area
    • About RMAN in a Data Guard Environment
      • About RMAN Configuration in a Data Guard Environment
      • About RMAN File Management in a Data Guard Environment
        • About Interchangeability of Backups in a Data Guard Environment
        • About Association of Backups in a Data Guard Environment
        • About Accessibility of Backups in a Data Guard Environment
    • About RMAN in a Recovery Appliance Environment
      • Creating RMAN Backups to Recovery Appliance
  • 4 Starting and Interacting with the RMAN Client
    • Starting and Exiting RMAN
    • Making Database Connections with RMAN
      • About RMAN Database Connection Types
      • About Authentication for RMAN Database Connections
        • Authentication Using the Operating System
        • Authentication Using a Password File
      • Making Database Connections to non-CDBs from the RMAN Prompt
      • Making RMAN Connections to non-CDBs from the Operating System Command Line
      • Making RMAN Connections to CDBs and PDBs
        • About Performing Operations on CDBs and PDBs
        • Restrictions When Connected to a PDB
        • Connecting as Target to the Root
        • Connecting as Target to a PDB
      • Making RMAN Database Connections Within Command Files
      • Connecting RMAN to an Auxiliary Database
      • Diagnosing RMAN Connection Problems
        • Diagnosing Target and Auxiliary Database Connection Problems
        • Diagnosing Recovery Catalog Connection Problems
    • Specifying the Location of RMAN Output
    • Setting Globalization Support Environment Variables for RMAN
    • Entering RMAN Commands
      • Entering RMAN Commands at the RMAN Prompt
      • Using Command Files with RMAN
      • Entering Comments in RMAN Command Files
      • Using Substitution Variables in Command Files
      • Checking RMAN Syntax
        • Checking RMAN Syntax at the Command Line
        • Checking RMAN Syntax in Command Files
    • Using the RMAN Pipe Interface
      • Executing Multiple RMAN Commands in Succession Through a Pipe: Example
      • Executing RMAN Commands in a Single Job Through a Pipe: Example
  • 5 Configuring the RMAN Environment
    • About Configuring the Environment for RMAN Backups
      • Showing and Clearing Persistent RMAN Configurations
      • Configuring the Default Device for Backups: Disk or SBT
      • Configuring the Default Type for Backups: Backup Sets or Copies
      • Configuring Channels
        • About Channel Configuration
        • Configuring Channels for Disk
        • Configuring Parallel Channels for Disk and SBT Devices
        • Manually Overriding Configured Channels
      • Configuring Control File and Server Parameter File Autobackups
        • Configuring the Control File Autobackup Format
        • Overriding the Configured Control File Autobackup Format
    • Configuring RMAN to Make Backups to a Media Manager
      • Prerequisites for Using a Media Manager with RMAN
      • Determining the Location of the Media Management Library
      • Configuring Media Management Software for RMAN Backups
      • Testing Whether the Media Manager Library Is Integrated Correctly
        • Testing ALLOCATE CHANNEL on the Media Manager
        • Testing Backup and Restore Operations on the Media Manager
      • Configuring SBT Channels for Use with a Media Manager
        • About Media Manager Backup Piece Names
        • Configuring Automatic SBT Channels
    • Configuring RMAN to Make Backups to Recovery Appliance
      • Prerequisites for Using Recovery Appliance
      • Steps to Configure RMAN for Backups to Recovery Appliance
      • Determining the Location of the Recovery Appliance Backup Module
      • Specifying Recovery Appliance Configuration Settings for RMAN Backups
    • Configuring the Fast Recovery Area
      • Overview of Files in the Fast Recovery Area
        • Fast Recovery Area with Oracle Managed Files and Automatic Storage Management
        • How Oracle Manages Disk Space in the Fast Recovery Area
      • Enabling the Fast Recovery Area
        • Considerations When Setting the Size of the Fast Recovery Area
        • Considerations When Setting the Location of the Fast Recovery Area
        • Setting the Fast Recovery Area Location and Initial Size
      • Disabling the Fast Recovery Area
      • Configuring Locations for Control Files and Redo Logs
        • Configuring Online Redo Log Locations
        • Configuring Control File Locations
        • Configuring Archived Redo Log Locations
      • Configuring RMAN File Creation in the Fast Recovery Area
    • Configuring the Backup Retention Policy
      • Configuring a Redundancy-Based Retention Policy
      • Configuring a Recovery Window-Based Retention Policy
      • Disabling the Retention Policy
    • Backup Optimization and the CONFIGURE command
      • Overview of Backup Optimization
      • Effect of Retention Policies on Backup Optimization for SBT Backups
        • About Backup Optimization for SBT Backups with Recovery Window Retention Policy
        • About Backup Optimization for SBT Backups With Redundancy Retention Policy
      • Configuring Backup Optimization
    • Configuring an Archived Redo Log Deletion Policy
      • About Archived Redo Log Deletion Policies
        • When the Archived Redo Log Deletion Policy Is Disabled
        • When the Archived Redo Log Deletion Policy Is Enabled
      • Enabling an Archived Redo Log Deletion Policy
    • Configuring RMAN in a Data Guard Environment
  • 6 Configuring the RMAN Environment: Advanced Topics
    • Configuring Advanced Channel Options
      • About Channel Control Options
      • Configuring Specific Channel Parameters
        • Configuring Specific Channels: Examples
        • Relationship Between CONFIGURE CHANNEL and Parallelism Setting
    • Configuring Advanced Backup Options
      • Configuring the Maximum Size of Backup Sets
      • Configuring the Maximum Size of Backup Pieces
      • Configuring Backup Duplexing
      • Configuring Tablespaces for Exclusion from Whole Database Backups
      • Configuring Compression Options
        • About RMAN Precompression Block Processing
        • About RMAN Supported Compression Levels
          • About RMAN Default Compression
          • About Oracle Advanced Compression Option
      • Configuring Backup Encryption
        • About Backup Encryption
          • Transparent Encryption of Backups
          • Password Encryption of Backups
          • Dual Mode Encryption of Backups
        • Configuring RMAN Backup Encryption Modes
        • Configuring the Backup Encryption Algorithm
    • Configuring Auxiliary Instance Data File Names
    • Configuring the Snapshot Control File Location
      • Viewing the Configured Location of the Snapshot Control File
      • Setting the Location of the Snapshot Control File
    • Configuring RMAN for Use with a Shared Server
    • Enabling Lost Write Detection
    • Enabling Shadow Lost Write Protection
  • 7 Using Flashback Database and Restore Points
    • Overview of Flashback Database, Restore Points and Guaranteed Restore Points
      • About Flashback Database
      • About Flashback Database Window
      • Limitations of Flashback Database
      • About Normal Restore Points
      • About Guaranteed Restore Points
        • Guaranteed Restore Points versus Storage Snapshots
      • Overview of Restore Points in a Multitenant Environment
        • About CDB Restore Points
        • About Restore Points in PDBs
        • About the Namespace for PDB Restore Points
    • About Logging for Flashback Database and Guaranteed Restore Points
      • Guaranteed Restore Points and Fast Recovery Area Space Usage
      • About Logging for Guaranteed Restore Points with Flashback Logging Disabled
      • About Logging for Flashback Database with Guaranteed Restore Points Defined
    • Prerequisites for Flashback Database and Restore Points
    • Using Normal and Guaranteed Restore Points
      • Creating Normal and Guaranteed Restore Points in non-CDBs
      • Creating CDB Restore Points
      • Creating PDB Restore Points
      • Listing Restore Points Using the LIST Command
      • Listing Restore Points Using the V$RESTORE_POINT View
      • Dropping Restore Points
    • Using Flashback Database
      • Enabling Flashback Database
      • Disabling Flashback Database Logging
      • Configuring the Environment for Optimal Flashback Database Performance
      • Monitoring the Effect of Flashback Database on Performance
      • About Flashback Writer (RVWR) Behavior with I/O Errors
• Part III Backing Up and Archiving Data
  • 8 RMAN Backup Concepts
    • About Consistent and Inconsistent RMAN Backups
      • About Consistent RMAN Backups
      • About Inconsistent RMAN Backups
    • About Online Backups and Backup Mode
    • About Backup Sets
      • About Backup Sets and Backup Pieces
      • About RMAN Block Compression for Backup Sets
        • About Unused Block Compression
        • About Null Block Compression
      • About Binary Compression for RMAN Backup Sets
      • About RMAN Backup Undo Optimization
      • About Encryption for RMAN Backup Sets
      • About File Names for RMAN Backup Pieces
      • About Number and Size of RMAN Backup Pieces
      • About Number and Size of RMAN Backup Sets
      • About Multiplexed RMAN Backup Sets
      • About RMAN Proxy Copies
    • About RMAN Image Copies
      • About RMAN-Created Image Copies
      • About User-Managed Image Copies
    • About Sparse Backups
    • About Preplugin Backups
    • About Multiple Copies of RMAN Backups
      • About Duplexed Backup Sets
      • About Backups of RMAN Backups
        • Backups of Backup Sets
        • Backups of Image Copies
    • About RMAN Control File and Server Parameter File Autobackups
      • When RMAN Performs Control File Autobackups
      • How RMAN Performs Control File Autobackups
    • About RMAN Incremental Backups
      • About Multilevel Incremental Backups
        • About Differential Incremental Backups
        • About Cumulative Incremental Backups
      • About Block Change Tracking
      • About the Incremental Backup Algorithm
      • About Recovery with Incremental Backups
      • About the Incremental-Forever Backup Strategy for Recovery Appliance
    • About Backup Retention Policies
      • About the Recovery Window
      • About Backup Redundancy
      • About Batch Deletes of Obsolete Backups
      • About Backup Retention Policy and Fast Recovery Area Deletion Rules
  • 9 Backing Up the Database
    • Overview of RMAN Backups
      • Purpose of RMAN Backups
      • Basic Concepts of RMAN Backups
    • Specifying Backup Output Options
      • Specifying the Device Type for an RMAN Backup
      • Specifying Backup Set or Copy for an RMAN Backup to Disk
      • Specifying a Format for RMAN Backups
        • Specifying Multiple Formats for Disk Backups
      • Specifying Tags for an RMAN Backup
        • About Backup Tags
        • Specifying Tags for Backup Sets and Image Copies
      • Making Compressed Backups
      • Specifying Multisection Incremental Backups
      • Making Multisection Backups Using Image Copies
    • Backing Up Database Files with RMAN
      • Backing Up a Whole Database with RMAN
      • Backing Up Tablespaces and Data Files with RMAN
      • Backing Up Control Files with RMAN
        • About Manual Backups of the Control File
        • Making a Manual Backup of the Control File
      • Backing Up Server Parameter Files with RMAN
      • Backing Up a Database in NOARCHIVELOG Mode
      • Creating a Preplugin Backup of the Whole Database
    • Backing Up CDBs and PDBs
      • About Backing Up CDBs and PDBs
      • Backing Up a Whole CDB
      • Backing Up the Root with RMAN
      • Backing Up the Root with Oracle Enterprise Manager Cloud Control
      • Backing Up PDBs with RMAN
      • Creating Preplugin Backups of PDBs Using RMAN
      • Backing Up PDBs with Oracle Enterprise Manager Cloud Control
      • Backing Up Tablespaces and Data Files in a PDB
      • Example: Creating a Preplugin Backup of a PDB with RMAN
    • Backing Up Application Containers
      • About Backing Up Application Containers
      • Backing Up the Application Root
      • Backing Up the Application Root and its Application PDBs
      • Backing Up Application PDBs
    • Backing Up Sparse Databases with RMAN
      • Backing Up a Sparse Database with RMAN
      • Backing Up Sparse Tablespaces and Data Files with RMAN
      • Backing Up a Sparse CDB with RMAN
      • Backing Up a Sparse PDB with RMAN
    • Backing Up Archived Redo Logs with RMAN
      • About Backups of Archived Redo Logs for non-CDBs
        • About Archived Redo Log Failover
        • About Online Redo Log Switching
      • About Backup of Archived Redo Logs in CDBs
      • Backing Up Archived Redo Log Files in non-CDBs
      • Backing Up Only Archived Redo Logs That Need Backups
      • Backing Up Archived Redo Logs in CDBs
      • Deleting Archived Redo Logs After Backups in non-CDBs
      • Deleting Archived Redo Logs After Backups in CDBs
    • Making and Updating RMAN Incremental Backups
      • Purpose of RMAN Incremental Backups
      • Planning an Incremental Backup Strategy
      • Making Incremental Backups
        • Making Incremental Backups of a VSS Snapshot
      • Incrementally Updating Backups
        • Incrementally Updating Backups: Basic Example
        • Incrementally Updated Backups: Advanced Example
      • Creating a Base Backup of New Data Files
      • Using Block Change Tracking to Improve Incremental Backup Performance
        • About Block Change Tracking
          • About Space Management in the Block Change Tracking File
          • Location of the Block Change Tracking File
          • About the Size of the Block Change Tracking File
        • Enabling Block Change Tracking
        • Disabling Block Change Tracking
        • Checking Whether Change Tracking Is Enabled
        • Changing the Location of the Block Change Tracking File
    • Making Database Backups for Long-Term Storage
      • Purpose of Archival Backups
      • Basic Concepts of Archival Backups
      • Making an Archival Backup for Long-Term Storage
        • Making an Archival Backup
      • Making a Temporary Archival Backup
    • Backing Up RMAN Backups
      • About Backups of RMAN Backups
        • About Multiple Copies of RMAN Backup Sets
        • Viewing the Effect of a Backup Retention Policy on Backups of Backups
      • Backing Up Backup Sets with RMAN
      • Backing Up Image Copy Backups with RMAN
  • 10 Backing Up the Database: Advanced Topics
    • Limiting the Size of RMAN Backup Sets
      • About Backup Set Size
      • Limiting the Size of Backup Sets with BACKUP ... MAXSETSIZE
      • Dividing the Backup of a Large Data File into Sections
    • Using Backup Optimization to Skip Files
      • Optimizing a Daily Archived Log Backup to a Single Tape: Scenario
      • Optimizing a Daily Archived Log Backup to Multiple Media Families: Scenario
      • Creating a Weekly Secondary Backup of Archived Logs: Example
    • Skipping Offline, Read-Only, and Inaccessible Files
    • Duplexing Backup Sets
      • Duplexing Backup Sets with CONFIGURE BACKUP COPIES
      • Duplexing Backup Sets with BACKUP ... COPIES
    • Making Split Mirror Backups with RMAN
    • Encrypting RMAN Backups
      • About RMAN Backup Encryption Settings
      • Making Transparent-Mode Encrypted Backups
      • Making Password-Mode Encrypted Backups
      • Making Dual-Mode Encrypted Backups
    • Restarting RMAN Backups
      • About Restartable Backups
      • Restarting a Backup After It Partially Completes
    • Managing Backup Windows
      • About Backup Windows
      • Specifying a Backup Duration
      • Permitting Partial Backups in a Backup Window
      • Minimizing Backup Load and Duration
• Part IV Managing RMAN Backups
  • 11 Reporting on RMAN Operations
    • Overview of RMAN Reporting
      • Purpose of RMAN Reporting
      • Basic Concepts of RMAN Reporting
      • Reporting in a Data Guard Environment
    • Listing Backups and Recovery-Related Objects
      • About the LIST Command
      • Listing All Backups and Copies
      • Listing Selected Backups and Copies
      • Listing Preplugin Backups
      • Listing Database Incarnations
    • Reporting on Backups and Database Schema
      • About Reports of RMAN Backups
      • Reporting on Files Needing a Backup Under a Retention Policy
        • Using RMAN REPORT NEED BACKUP with Different Retention Policies
        • Using RMAN REPORT NEED BACKUP with Tablespaces and Data Files
        • Using REPORT NEED BACKUP with Backups on Tape or Disk Only
      • Reporting on Data Files Affected by Unrecoverable Operations
      • Reporting on Obsolete Backups
      • Reporting on the Database Schema
    • Reporting in CDBs and PDBs
      • Reporting in CDBs
      • Reporting in PDBs
        • Listing Backups of Dropped PDBs
    • Using V$ Views to Query Backup Metadata
      • Querying Details of Past and Current RMAN Jobs
      • Determining the Encryption Status of Backup Pieces
    • Querying Recovery Catalog Views
      • About Recovery Catalog Views
        • About Unique Identifiers for Registered Databases
        • About Unique Identifiers in a Data Guard Environment
      • Querying Catalog Views for the Target DB_KEY or DBID Values
      • Querying RC_BACKUP_FILES
  • 12 Maintaining RMAN Backups and Repository Records
    • Overview of RMAN Backup and Repository Maintenance
      • Purpose of Backup and Repository Maintenance
      • Basic Concepts of Backup and Repository Maintenance
        • About Maintenance Commands and RMAN Repository Metadata
        • About Maintenance Commands in a Data Guard Environment
          • About Crosschecks in a Data Guard Environment
          • About Deletion in a Data Guard Environment
          • About Updates to RMAN Metadata in a Data Guard Environment
          • About Files Not Associated with a Database
    • Maintaining the Control File Repository
      • About Control File Records
        • About Fast Recovery Area and Control File Records
      • Preventing the Loss of Control File Records
      • Protecting the Control File
    • Maintaining the Fast Recovery Area
      • Deletion Rules for the Fast Recovery Area
      • Monitoring Fast Recovery Area Space Usage
      • Managing Space for Flashback Logs in the Fast Recovery Area
      • Responding to a Full Fast Recovery Area
      • Changing the Fast Recovery Area to a New Location
      • Disabling the Fast Recovery Area
      • Responding to an Instance Crash During File Creation
    • Updating the RMAN Repository
      • Crosschecking the RMAN Repository
        • About RMAN Crosschecks
        • Crosschecking All Backups and Copies
        • Crosschecking Specific Backup Sets and Copies
        • Crosschecking Preplugin Backups
      • Changing the Repository Status of Backups and Copies
        • Updating a Backup to Status AVAILABLE or UNAVAILABLE
        • Changing the Status of an Archival Backup
        • Changing the Status of Backups for Dropped PDBs
        • Changing the Status of Preplugin Backups
      • Adding Backup Records to the RMAN Repository
        • About Cataloging Operations
        • Cataloging User-Managed Data File Copies
        • Cataloging Backup Pieces
        • Cataloging All Files in a Disk Location
        • Cataloging Preplugin Archived Redo Logs
      • Removing Records from the RMAN Repository
        • About Uncataloging Operations in the RMAN Repository
        • Removing Records for Files Deleted with Operating System Utilities
    • Deleting RMAN Backups and Archived Redo Logs
      • Overview of Deleting RMAN Backups
        • About RMAN Deletion Commands
        • About Deletion of Archived Redo Logs
      • Deleting All Backups and Copies
      • Deleting Specified Backups and Copies
        • Deleting Specified Files with BACKUP ... DELETE
      • Deleting Expired RMAN Backups and Copies
      • Deleting Obsolete RMAN Backups Based on Retention Policies
        • DELETE OBSOLETE Behavior When KEEP UNTIL TIME Expires
      • Deleting Backups of Dropped PDBs
      • Deleting Preplugin Backups
    • Dropping a Database
  • 13 Managing a Recovery Catalog
    • Overview of the RMAN Recovery Catalog
      • Purpose of the RMAN Recovery Catalog
      • Basic Concepts for the RMAN Recovery Catalog
        • About Database Registration in an RMAN Recovery Catalog
        • About Centralization of Metadata in a Base RMAN Recovery Catalog
        • About RMAN Recovery Catalog Resynchronization
        • About Stored Scripts
        • Recovery Catalog in a Data Guard Environment
      • Basic Steps of Managing a Recovery Catalog
    • Creating a Recovery Catalog
      • Configuring the Recovery Catalog Database
        • Planning the Size of the Recovery Catalog Schema
        • Allocating Disk Space for the Recovery Catalog Database
      • Creating the Recovery Catalog Schema Owner
      • Running the CREATE CATALOG Command
    • Registering a Database in the Recovery Catalog
      • About Registration of a Database in the Recovery Catalog
        • About Standby Database Registration
      • Registering a Database with the REGISTER DATABASE Command
    • Cataloging Backups in the Recovery Catalog
    • Creating and Managing Virtual Private Catalogs
      • Overview of Virtual Private Catalogs
      • About Using the VPD Model for Virtual Private Catalogs
      • Creating Virtual Private Catalogs
      • Registering a Database with a Virtual Private Catalog
      • Revoking Privileges from a Virtual Private Catalog Owner
      • Upgrading Virtual Private Catalogs
    • Protecting the Recovery Catalog
      • Backing Up the Recovery Catalog
        • Backing Up the Recovery Catalog Frequently
        • Choosing the Appropriate Technique for Physical Backups
        • Separating the Recovery Catalog from the Target Database
        • Exporting the Recovery Catalog Data for Logical Backups
      • Recovering the Recovery Catalog
    • Managing Stored Scripts
      • About Stored Scripts
      • Creating Stored Scripts
      • Replacing Stored Scripts
      • Running Stored Scripts
      • Creating and Executing Dynamic Stored Scripts
      • Printing Stored Scripts
      • Listing Stored Script Names
      • Deleting Stored Scripts
      • Running a Stored Script at RMAN Startup
    • Maintaining a Recovery Catalog
      • About Recovery Catalog Maintenance
      • Resynchronizing the Recovery Catalog
        • About Resynchronization of the Recovery Catalog
          • About RMAN Recovery Catalog Resynchronization in a Data Guard Environment
        • Deciding When to Resynchronize the Recovery Catalog
          • Resynchronizing After the Recovery Catalog is Unavailable
          • Resynchronizing in ARCHIVELOG Mode When You Back Up Infrequently
          • Resynchronizing After Configuring a Standby Database
          • Resynchronizing the Recovery Catalog Before Control File Records Age Out
        • Manually Resynchronizing the Recovery Catalog
      • Updating the Recovery Catalog After Changing a DB_UNIQUE_NAME
      • Unregistering a Target Database from the Recovery Catalog
        • Unregistering a Target Database When Not in a Data Guard Environment
        • Unregistering a Standby Database
        • Unregistering a Target Database in a Recovery Appliance Environment
      • Resetting the Database Incarnation in the Recovery Catalog
      • Upgrading the Recovery Catalog
        • About Recovery Catalog Upgrades
          • Special Considerations for Upgrading the Recovery Catalog in a Data Guard Environment
        • Determining the Schema Version of the Recovery Catalog
        • Using the UPGRADE CATALOG Command
      • Importing and Moving a Recovery Catalog
        • About Recovery Catalog Imports
        • About Importing Recovery Catalogs in a Recovery Appliance Environment
        • Prerequisites for Importing a Recovery Catalog
        • Importing a Recovery Catalog
        • Moving a Recovery Catalog
    • Dropping a Recovery Catalog
• Part V Diagnosing and Responding to Failures
  • 14 RMAN Data Repair Concepts
    • Overview of RMAN Data Repair
      • About Problems Requiring Data Repair
        • About User Errors
        • About Application Errors
        • About Media Failures
      • About RMAN Data Repair Techniques
    • About RMAN Restore Operations
      • About RMAN Backup Selection
      • About RMAN Restore Failover
      • About RMAN Restore of Encrypted Backups
      • About RMAN Restore Operations and ASM
      • About RMAN Restore Optimization
    • About RMAN Media Recovery
      • About Selection of Incremental Backups and Archived Redo Logs
      • About Database Incarnations
        • About RMAN OPEN RESETLOGS Operations
        • Relationship Among Database Incarnations
        • About Incarnations of PDBs
        • About Orphaned Backups
        • About Orphaned PDB Backups
  • 15 Diagnosing and Repairing Failures with Data Recovery Advisor
    • Overview of Data Recovery Advisor
      • Purpose of Data Recovery Advisor
      • Basic Concepts of Data Recovery Advisor
        • User Interfaces to Data Recovery Advisor
        • About Data Integrity Checks
        • About Failures
          • About the Failure Status
          • About Failure Priority
          • About Failure Grouping
        • About Manual Actions and Automatic Repair Options
          • About Consolidated Repairs
          • About Repair Scripts
        • About Supported Database Configurations for Data Recovery Advisor
          • About Data Recovery Advisor and Oracle Real Application Clusters
          • About Data Recovery Advisor and Oracle Data Guard
          • About Data Recovery Advisor and CDBs
      • Basic Steps of Diagnosing and Repairing Failures
      • Diagnosing and Repairing Failures in CDBs
    • Listing Failures
      • Listing All Failures
      • Listing a Subset of Failures
    • Checking for Block Corruptions by Validating the Database
    • Determining Repair Options
      • Determining Repair Options for All Failures
      • Determining Repair Options for a Subset of Failures
    • Repairing Failures
      • About Repairing Failures
      • Repairing a Failure
    • Changing Failure Status and Priority
  • 16 Validating Database Files and Backups
    • Overview of RMAN Validation
      • Purpose of RMAN Validation
      • Basic Concepts of RMAN Validation
        • About Checksums and Corrupt Blocks
        • About Physical and Logical Block Corruption
        • About Limits for Corrupt Blocks in RMAN Backups
        • About Detecting Block Corruption
    • Checking for Block Corruption with the VALIDATE Command
    • Validating Database Files with BACKUP VALIDATE
    • Validating Backups Before Restoring Them
    • Validating CDBs and PDBs
      • Validating a Whole CDB
      • Validating PDBs
  • 17 Performing Complete Database Recovery
    • Overview of Complete Database Recovery
      • Purpose of Complete Database Recovery
      • Scope of This Chapter
      • About Real-time Redo Transport for Recovery Appliance
    • Preparing for Complete Database Recovery
      • Identifying the Database Files to Restore or Recover
        • Identifying a Lost Control File
        • Identifying Data Files Requiring Media Recovery
          • Identifying Data Files with RMAN
          • Identifying Data Files with SQL
      • Determining the DBID of the Database
      • Previewing Backups Used in Restore Operations
        • Recalling Off-site Backups
      • Validating Backups Before Restoring Them
      • Restoring Archived Redo Logs Needed for Recovery
        • Restoring Archived Redo Logs to a New Location
        • Restoring Archived Redo Logs to Multiple Locations
      • Providing the Password Required to Decrypt Encrypted Backups
    • Performing Complete Database Recovery
      • About Complete Database Recovery
        • About Restoring Data Files to a Nondefault Location
      • Performing Complete Recovery of the Whole Database
      • Performing Complete Recovery of a Tablespace
      • Performing Complete Recovery After Switching to a Copy
        • Performing Recovery After Switching to a Data File Copy
        • Performing Complete Recovery After Switching to a Database Copy
    • Performing Complete Recovery of CDBs
      • Performing Complete Recovery of a Whole CDB
      • Performing Complete Recovery of the Root
      • Performing Complete Recovery of PDBs with RMAN
      • Performing Complete Recovery of PDBs with Cloud Control
      • Performing Complete Recovery Using Preplugin Backups
        • About Complete Recovery of PDBs Using PrePlugin Backups
        • Performing Complete Recovery of PDBs Using Preplugin Backups
        • Example: Performing Complete Recovery of PDBs Using Preplugin Backups
      • Performing Complete Recovery of Tablespaces or Data Files in a PDB with RMAN
      • Performing Complete Recovery of Tablespaces in a PDB with Cloud Control
      • Performing Complete Recovering of CDBs After Switching to a Copy
    • Performing Complete Recovery of Application Containers
      • Performing Complete Recovery of the Application Root
      • Performing Complete Recovery of the Application Root and Application PDBs
      • Performing Complete Recovery of Application PDBs
    • Performing Complete Recovery of Sparse Databases with RMAN
      • Performing Complete Recovery of a Sparse Database
      • Performing Complete Recovery of a Sparse CDB
      • Performing Recovery of a Sparse PDB with RMAN
  • 18 Performing Flashback and Database Point-in-Time Recovery
    • Overview of Oracle Flashback Technology and Database Point-in-Time Recovery
      • Purpose of Flashback and Database Point-in-Time Recovery
      • About Point-in-Time Recovery and Flashback Features
        • About Flashback Database and PITR for PDBs
      • Basic Concepts of Database Point-in-Time Recovery
        • Basic Concepts of Point-in-Time Recovery for PDBs
      • Basic Concepts of Flashback Technology
        • About Physical Flashback Features Useful in Backup and Recovery
        • About Logical Flashback Features Useful in Backup and Recovery
        • Basic Concepts of Performing Flashback Database for CDBs and PDBs
        • About Undo and Flashback Database Operations for PDBs
      • About Managing Redo Corruption in CDBs
    • Rewinding a Table with Flashback Table
      • Prerequisites for Flashback Table
      • Performing a Flashback Table Operation
        • Keeping Triggers Enabled During Flashback Table
    • Rewinding a DROP TABLE Operation with Flashback Drop
      • About Flashback Drop
      • Prerequisites of Flashback Drop
      • Performing a Flashback Drop Operation
        • Retrieving Objects Using Flashback Drop When Multiple Objects Share the Same Original Name
    • Rewinding a Database with Flashback Database
      • Prerequisites of Flashback Database
      • Performing a Flashback Database Operation
      • Performing a Flashback Database Operation for a Whole CDB
      • Performing a Flashback Database Operation for PDBs
      • Monitoring Flashback Database
    • Performing Database Point-in-Time Recovery
      • Prerequisites of Database Point-in-Time Recovery
      • Performing Database Point-in-Time Recovery
      • Performing Point-in-Time Recovery of CDBs and PDBs
        • Performing Point-in-Time Recovery of a Whole CDB
        • Performing Point-in-Time Recovery of PDBs
        • Recovering a Dropped PDB
      • Performing Point-in-Time Recovery of Application PDBs
      • Performing Point-in-Time Recovery of Sparse Databases
    • Flashback and Database Point-in-Time Recovery Scenarios
      • Rewinding an OPEN RESETLOGS Operation with Flashback Database
        • About Undoing an OPEN RESETLOGS on Standby Databases with Flashback Database
      • Rewinding the Database to an SCN in an Abandoned Incarnation Branch
      • Recovering the Database to an Ancestor Incarnation
  • 19 Performing Block Media Recovery
    • Overview of Block Media Recovery
      • Purpose of Block Media Recovery
      • Basic Concepts of Block Media Recovery
        • About Block Recovery and Standby Databases
        • About Identifying Corrupt Blocks
        • About Missing Redo During Block Recovery
    • Prerequisites for Block Media Recovery
    • Recovering Individual Blocks
      • Recovering Individual Blocks Using the RECOVER...BLOCK Command
      • Example: Recovering Individual Blocks Using the Data Recovery Advisor
    • Recovering All Blocks in V$DATABASE_BLOCK_CORRUPTION
  • 20 Performing RMAN Recovery: Advanced Scenarios
    • Recovering a NOARCHIVELOG Database with Incremental Backups
    • Restoring the Server Parameter File
      • Restoring the Server Parameter File from a Control File Autobackup
      • Creating an Initialization Parameter File with RMAN
    • Performing Recovery with a Backup Control File
      • About Recovery with a Backup Control File
        • About Control File Locations During RMAN Restore
        • About RMAN Recovery With and Without a Recovery Catalog
        • About RMAN Recovery When Using a Fast Recovery Area
      • Performing Recovery with a Backup Control File and No Recovery Catalog
    • Performing Disaster Recovery
      • Prerequisites of Disaster Recovery
      • Recovering the Database After a Disaster
    • Restoring a Database on a New Host
      • Preparing to Restore a Database on a New Host
      • Restoring Disk Backups to a New Host
      • Testing the Restore of a Database on a New Host
    • Restoring Backups Created Using Older Versions of RMAN
    • Restoring and Recovering Files Over the Network
      • About Restoring Files Over the Network
      • About Recovering Files Over the Network
      • Scenarios for Restoring and Recovering Files Over the Network
      • Restoring Data Files Over the Network
      • Rolling Forward a Physical Standby Database Using the RECOVER Command
        • Steps to Refresh a Physical Standby Database with Changes Made to the Primary Database
  • 21 Performing RMAN Tablespace Point-in-Time Recovery (TSPITR)
    • Overview of RMAN TSPITR
      • Purpose of RMAN TSPITR
      • Basic Concepts of RMAN TSPITR
        • Common Terms for RMAN TSPITR
        • Modes of RMAN TSPITR
        • How RMAN TSPITR Works With an RMAN-Managed Auxiliary Database
    • TSPITR Restrictions, Special Cases, and Limitations
      • Limitations of TSPITR
      • About Special Considerations When Not Using a Recovery Catalog
    • Planning and Preparing for TSPITR
      • Selecting the Right Target Time for TSPITR
      • Determining the Recovery Set
        • Identify and Resolve Dependencies on the Primary Database
      • Identifying and Preserving Objects That Are Lost After TSPITR
    • Performing Fully Automated RMAN TSPITR
    • Overriding Defaults for RMAN TSPITR with an RMAN-Managed Auxiliary Database
      • Renaming TSPITR Recovery Set Data Files with SET NEWNAME
      • Naming TSPITR Auxiliary Set Data Files
        • Considerations When Renaming OMF Auxiliary Set Files in TSPITR
          • Using ASM Storage
          • Using Non-ASM Storage
        • Using SET NEWNAME to Name Auxiliary Set Data Files During TSPITR
        • Using DB_FILE_NAME_CONVERT to Name Auxiliary Set Data Files During TSPITR
          • Renaming Temp Files During TSPITR
      • Using Image Copies for Faster RMAN TSPITR Performance
        • Using SET NEWNAME with Recovery Set Image Copies
        • Using SET NEWNAME and CONFIGURE AUXNAME with Auxiliary Set Image Copies
        • Performing TSPITR with CONFIGURE AUXNAME and Image Copies: Scenario
      • Customizing Initialization Parameters for the Automatic Auxiliary Database in TSPITR
        • Specifying the Auxiliary Database Control File Location in TSPITR
        • Specifying the Auxiliary Database Archived Logs in TSPITR
        • Specifying the Auxiliary Database Online Log Location in TSPITR
    • Performing RMAN TSPITR Using Your Own Auxiliary Database
      • Preparing Your Own Auxiliary Database for RMAN TSPITR
        • Step 1: Create an Oracle Password File for the Auxiliary Database
        • Step 2: Create an Initialization Parameter File for the Auxiliary Database
        • Step 3: Check Oracle Net Connectivity to the Auxiliary Database
      • Preparing RMAN Commands for TSPITR with Your Own Auxiliary Database
        • Planning Channels for TSPITR with Your Own Auxiliary Database
        • Planning Data File Names with Your Own Auxiliary Database: SET NEWNAME
      • Executing TSPITR with Your Own Auxiliary Database
        • Step 1: Start the Auxiliary Database in NOMOUNT Mode
        • Step 2: Connect the RMAN Client to Target and Auxiliary Databases
        • Step 3: Execute the RECOVER TABLESPACE Command
      • Performing TSPITR with Your Own Auxiliary Database: Scenario
    • Troubleshooting RMAN TSPITR
      • Troubleshooting File Name Conflicts During TSPITR
      • Troubleshooting the Identification of Tablespaces with Undo Segments During TSPITR
      • Troubleshooting the Restart of a Manual Auxiliary Database After TSPITR Failure
  • 22 Recovering Tables and Table Partitions
    • Overview of Recovering Tables and Table Partitions
      • Purpose of Recovering Tables and Table Partitions from RMAN Backups
      • RMAN Backups Required to Recover Tables and Table Partitions
      • Basic Concepts of Recovering Tables and Table Partitions from RMAN Backups
        • Steps Performed By RMAN to Recover Tables and Table Partitions
        • About the Location of Auxiliary Database Files During RMAN Table Recovery
        • About the Data Pump Export Dump File Used During RMAN Table Recovery
        • About Importing Recovered Tables and Table Partitions into the Target Database
        • Rename the Recovered Tables and Table Partitions
        • About Recovering Tables and Partitions Into a New Schema
      • Limitations of Recovering Tables and Table Partitions from RMAN Backups
    • Preparing to Recover Tables and Table Partitions
      • Prerequisites for Recovering Tables and Table Partitions from RMAN Backups
      • Determining the Point-in-time to Which Tables and Table Partitions Must be Recovered
    • Recovering Tables and Table Partitions
    • Recovering Tables and Table Partitions in PDBs
    • Examples: Recovering Tables and Table Partitions From RMAN Backups
      • Example: Recovering Tables to a Specified Point in Time
      • Example: Recovering Table Partitions to a Specified Log Sequence Number
      • Example: Recovering a Table into a New Schema
• Part VI Tuning and Troubleshooting
  • 23 Tuning RMAN Performance
    • Purpose of RMAN Performance Tuning
    • Basic Concepts of RMAN Performance Tuning
      • Read Phase
        • Allocation of Input Disk Buffers
        • Synchronous and Asynchronous Disk I/O
        • Disk I/O Slaves
        • RATE Channel Parameter
      • Copy Phase
      • Write Phase for System Backup Tape (SBT)
        • RMAN Component of the Write Phase for SBT
          • Allocation of Tape Buffers
          • Tape I/O Slaves
          • Synchronous and Asynchronous I/O
        • Media Manager Component of the Write Phase for SBT
          • Network Throughput
          • Native Transfer Rate
          • Tape Compression
          • Tape Streaming
          • Physical Tape Block Size
      • Write Phase for Disk
    • Using V$ Views to Diagnose RMAN Performance Problems
      • Monitoring RMAN Job Progress with V$SESSION_LONGOPS
      • Identifying Bottlenecks with V$BACKUP_SYNC_IO and V$BACKUP_ASYNC_IO
        • Identifying Bottlenecks with Synchronous I/O
        • Identifying Bottlenecks with Asynchronous I/O
    • Tuning RMAN Backup Performance
      • Removing the RATE Parameter from Channel Settings
      • Setting DBWR_IO_SLAVES to Simulate Asynchronous I/O
      • Setting LARGE_POOL_SIZE to Resolve Shared Memory Issues
      • Tuning the Read, Write, and Copy Phases
        • Using Backup Validation To Distinguish Between Read and Write Bottlenecks
        • Tuning the Read Phase
        • Tuning the Copy and Write Phases
  • 24 Troubleshooting RMAN Operations
    • Interpreting RMAN Message Output
      • Identifying Types of RMAN Message Output
      • Troubleshooting Long-Running RMAN Operations
      • Recognizing RMAN Error Message Stacks
      • Identifying RMAN Error Codes
        • RMAN Error Message Numbers
        • ORA-19511: Media Manager Errors
      • Interpreting RMAN Error Stacks
        • Interpreting RMAN Errors: Example
        • Interpreting Server Errors: Example
        • Interpreting SBT 2.0 Media Management Errors: Example
        • Interpreting SBT 1.1 Media Management Errors: Example
      • Identifying RMAN Return Codes
    • Using V$ Views for RMAN Troubleshooting
      • Monitoring RMAN Interaction with the Media Manager
      • Correlating Server Sessions with RMAN Channels
        • Matching Server Sessions with Channels When One RMAN Session Is Active
        • Matching Server Sessions with Channels in Multiple RMAN Sessions
          • Obtaining the Channel ID from the RMAN Output
          • Correlating Server Sessions with Channels by Using SET COMMAND ID
    • Testing the Media Management API
      • Obtaining the sbttest Utility
      • Obtaining Online Documentation for the sbttest Utility
      • Using the sbttest Utility
    • Terminating an RMAN Command
      • Terminating the Session with ALTER SYSTEM KILL SESSION
      • Terminating the Session at the Operating System Level
      • Terminating an RMAN Session That Is Not Responding in the Media Manager
        • Components of an RMAN Session
        • Process Behavior During a Suspended Job
        • Terminating an RMAN Session: Basic Steps
• Part VII Transferring Data with RMAN
  • 25 Duplicating Databases
    • Overview of RMAN Database Duplication
      • Purpose of Database Duplication
      • Basic Concepts of Database Duplication
        • Initialization Parameters for the Auxiliary Instance
        • About Parallelizing Backup Set Creation During Active Database Duplication
        • About Encrypting Backup Sets During Active Database Duplication
        • About Compressing Backup Sets During Active Database Duplication
      • Types of Database Duplication
        • Overview of Backup-Based Duplication
        • Techniques for Performing Backup-Based Duplication
          • Backup-Based Duplication with a Target Connection
          • Backup-Based Duplication Without a Target Connection
          • Backup-Based Duplication Without a Target Database and Recovery Catalog Connection
        • Overview of Active Database Duplication
        • Techniques for Performing Active Database Duplication
          • Active Database Duplication Using Image Copies
          • Active Database Duplication Using Backup Sets
        • Factors that Determine Whether Backup Sets or Image Copies Are Used for Active Database Duplication
      • How RMAN Duplicates a Database
      • Contents of a Duplicate Database
        • About Duplicating a Subset of the Source Database
      • About the Destination Host for Database Duplication
      • About Duplicate Database File Names
      • About Duplicating a Database to a Past Point-in-Time
      • Prerequisites for Duplicating a Database
    • Planning to Duplicate a Database
      • Choosing a Duplication Technique
      • Choosing a Strategy for Naming Duplicate Database Files
        • Using the Same Names for Database Files in the Source Database and Duplicate Database
        • Using Different Names for the Database Files in the Source Database and Duplicate Database
        • Methods of Generating Database File Names for the Duplicate Database
      • Installing the Oracle Database Software on the Destination Host
      • Deciding the State of the Duplicate Database
      • Making Backups Accessible to the Duplicate Instance
        • Making SBT Backups Accessible to the Auxiliary Instance
        • Making Disk Backups Accessible to the Auxiliary Instance
    • Preparing the Auxiliary Instance
      • Creating Directories for the Duplicate Database
      • Creating an Initialization Parameter File for the Auxiliary Instance
        • Steps to Create an Initialization Parameter File for the Auxiliary Instance
        • Copying the Server Parameter File from the Source Database
      • Creating a Password File for the Auxiliary Instance
      • Establishing Oracle Net Connectivity Between the Source Database and Auxiliary Instance
      • Starting the Auxiliary Instance
      • Making the Oracle Keystore Available to the Destination Host
    • Duplicating a Database
      • Duplicating the Whole Database
      • Duplicating a Subset of the Source Database Tablespaces
      • Duplicating an Oracle RAC Database
      • Duplicating Sparse Databases
      • Configuring RMAN Channels for Use in Duplication
        • Configuring Channels for Backup-based Duplication
        • Configuring Channels for Active Database Duplication
      • Placing the Source Database in a Proper State
      • Starting RMAN and Connecting to Databases
      • Using the DUPLICATE Command to Duplicate Databases
    • Duplicating CDBs and PDBs
      • Duplicating CDBs
      • Duplicating Sparse CDBs
      • Duplicating PDBs
        • About Duplicating PDBs
        • Restrictions on Duplicating a PDB to an Existing CDB
        • Duplicating a PDB to an Existing CDB
        • Duplicating a PDB to a New CDB
        • Duplicating Sparse PDBs
      • Duplicating Tablespaces Within a PDB to a New CDB
    • Duplicating Databases to Oracle Cloud
    • Duplicating an Oracle Cloud Database as an On-premise Database
    • Restarting DUPLICATE After a Failure
    • Examples: Duplicating Databases
      • Example: Duplicating a Database to a Remote ASM Host by Using Active Database Duplication with Backup Sets
      • Example: Duplicating a Database to a Remote Host by Using Active Database Duplication with Image Copies
      • Example: Duplicating a Database to a Remote Host by Using Backup-based Duplication without a Target Connection or Recovery Catalog
      • Example: Duplicating a Database to a Remote Host by Using Backup-Based Duplication with a Recovery Catalog
      • Example: Duplicating a Database to a Remote Host by Using Backup-based Duplication with a Target Connection
      • Example: Duplicating a Database to the Local Host by Using Active Database Duplication
      • Example: Duplicating PDBs to a New CDB by Using Active Database Duplication
      • Example: Duplicating a PDB to an Existing CDB by Using Active Duplication
      • Example: Performing Backup-based Duplication by Using Encrypted Backups
    • Example: Script to Duplicate a Database Using Backup-based Duplication
  • 26 Duplicating Databases: Advanced Topics
    • Specifying Alternative Names for Duplicate Database Files
      • Specifying Non-OMF or Non-ASM Alternative Names for Duplicate Database Files
        • Using the SET NEWNAME Command to Name File System Data Files and Temp Files
        • Using the CONFIGURE AUXNAME Command to Name File System Data Files and OMF or ASM Target Data Files
      • Specifying OMF or ASM Alternative Names for Duplicate Database Files
        • Settings and Restrictions for OMF Initialization Parameters
        • Setting Initialization Parameters for ASM
        • Examples: Duplicating Databases to ASM
        • Using the SET NEWNAME Command to Create OMF or ASM Files
        • Using the DB_FILE_NAME_CONVERT Parameter to Generate Names for Non-OMF or ASM Data Files
        • Using the LOG_FILE_NAME_CONVERT Parameter to Generate Names for Non-OMF or ASM Log Files
    • Making Disk Backups Accessible Without Shared Disk
  • 27 Creating Transportable Tablespace Sets
    • Overview of Creating Transportable Tablespace Sets
      • Purpose of Creating Transportable Tablespace Sets
      • Basic Concepts of Transportable Tablespace Sets
      • Basic Steps of Creating Transportable Tablespace Sets
    • Customizing Initialization Parameters for the Auxiliary Instance
      • About Setting Initialization Parameters for the RMAN Auxiliary Instance
      • Setting the Location of the Auxiliary Instance Parameter File
    • Creating a Transportable Tablespace Set
    • Troubleshooting the Creation of Transportable Tablespace Sets
    • Transportable Tablespace Set Scenarios
      • Creating a Transportable Tablespace Set at a Specified Time or SCN
      • Specifying Locations for Data Pump Files
      • Specifying Auxiliary File Locations with Transportable Tablespaces
        • Using SET NEWNAME for Auxiliary Data Files
        • Using CONFIGURE AUXNAME for Auxiliary Data Files
        • Using AUXILIARY DESTINATION to Specify a Location for Auxiliary Files
        • Using Initialization Parameters to Name Auxiliary Files
  • 28 Transporting Data Across Platforms
    • About Cross-Platform Data Transport
      • Purpose of Cross-Platform Data Transport
      • Methods of Transporting Data Across Platforms
      • Platforms that Support Cross-Platform Data Transport
    • Overview of Cross-Platform Data Transport Using Image Copies
      • Overview of Tablespace and Data File Conversion Using Image Copies
      • Overview of Database Conversion Using Image Copies
    • Performing Cross-Platform Tablespace Conversion with Image Copies
    • Performing Cross-Platform Data File Conversion with Image Copies
      • About Renaming Output Files During RMAN Cross-Platform Data File Conversion
      • Performing Tablespace Transportation on the Destination Host Using RMAN CONVERT DATAFILE
    • Performing Cross-Platform Database Conversion with Image Copies
      • Checking the Database Before Cross-Platform Database Conversion
      • Converting Data Files on the Source Host When Transporting a Database
      • Converting Data Files on the Destination Host When Transporting a Database
        • Performing Preliminary Data File Conversion Steps on the Source Host
        • Running the Conversion Scripts on the Destination Host
    • Overview of Cross-Platform Data Transport Using Backup Sets
      • Basic Terms Used in Cross-Platform Data Transport Using Backup Sets
      • About Backing Up Data on the Source Database for Cross-Platform Data Transport
      • About the Data Pump Export Dump File Used for Cross-Platform Tablespace Transport
      • About Restoring Data on the Destination Host During Cross-Platform Data Transport
      • About Selecting Objects to Be Restored from Cross-Platform Backups
      • About Names and Locations for Restored Objects on the Destination Database
      • About Importing the Data Pump Export Dump File Created During Cross-Platform Tablespace Transport
    • Performing Cross-Platform Database Transport with Backup Sets
      • Steps to Transport a Database to a Different Platform Using Backup Sets
    • Performing Cross-Platform Transport of Read-Only Tablespaces Using Backup Sets
      • Steps to Transport Read-Only Tablespaces to a Different Platform Using Backup Sets
    • Overview of Cross-Platform Transport of Tablespaces Using Inconsistent Backups
    • Performing Cross-Platform Transport of Tablespaces Using Inconsistent Backups
      • Steps to Transport Inconsistent Tablespaces to a Different Platform
        • Creating Files Required to Transport Tablespaces to a Different Platform
        • Transferring Files Created on the Source Host to the Destination Host
        • Restoring Tablespaces and Plugging them in to the Destination Database
      • Example: Performing Cross-Platform Inconsistent Tablespace Transport Using Backup Sets
    • Performing Cross-Platform Transport of Data Files Over the Network
    • Performing Cross-Platform Data Transport in CDBs and PDBs
      • About Cross-Platform Transport of PDBs
      • Performing Cross-Platform Transport of a Whole CDB
      • Performing Cross-Platform Transport of a Closed PDB
      • Performing Cross-Platform Transport of a PDB Using Inconsistent Backups
      • Performing Cross-Platform Transport of Tablespaces in a PDB
        • Example: Transporting a Tablespace in a PDB
• Part VIII Performing User-Managed Backup and Recovery
  • 29 Making User-Managed Database Backups
    • Querying V$ Views to Obtain Backup Information
      • Listing Database Files Before a Backup
      • Determining Data File Status for Online Tablespace Backups
    • Making User-Managed Backups of the Whole Database
    • Making User-Managed Backups of CDBs and PDBs
    • Making User-Managed Backups of Tablespaces and Data Files
      • Making User-Managed Backups of Offline Tablespaces and Data Files
      • Making User-Managed Backups of Online Tablespaces and Data Files
        • Making User-Managed Backups of Online Read/Write Tablespaces
        • Making Multiple User-Managed Backups of Online Read/Write Tablespaces
          • Backing Up Online Tablespaces in Parallel
          • Backing Up Online Tablespaces Serially
        • Ending a Backup After an Instance Failure or SHUTDOWN ABORT
          • Ending Backup Mode with the ALTER DATABASE END BACKUP Statement
          • Ending Backup Mode with the SQL*Plus RECOVER Command
        • Making User-Managed Backups of Read-Only Tablespaces
    • Making User-Managed Backups of Tablespaces in CDBs
      • Making User-Managed Backups of Offline Tablespaces and Data Files in CDBs
      • Making User-Managed Backups of Online Tablespaces in CDBs and PDBs
    • Making User-Managed Backups of the Control File
      • Backing Up the Control File to a Binary File
      • Backing Up the Control File to a Trace File
    • Making User-Managed Backups of Archived Redo Logs
    • Making User-Managed Backups in SUSPEND Mode
      • About the Suspend/Resume Feature
      • Making Backups in a Suspended Database
    • Making User-Managed Backups to Raw Devices
      • Backing Up to Raw Devices on Linux and UNIX
        • Backing Up with the dd Utility on Linux and UNIX: Examples
      • Backing Up to Raw Devices on Windows
        • Backing Up with OCOPY: Example
        • Specifying the -b and -r Options for OCOPY: Example
    • Making Backups with Third-Party Snapshot Technologies
    • Verifying User-Managed Data File Backups
      • Testing the Restoration of Data File Backups
      • Running the DBVERIFY Utility
  • 30 Performing User-Managed Database Flashback and Recovery
    • Performing Flashback Database with SQL*Plus
      • Performing Flashback Database of non-CDBs with SQL*Plus
      • Performing Flashback Database of CDBs with SQL*Plus
      • Performing Flashback Database of PDBs with SQL*Plus
    • Overview of User-Managed Media Recovery
      • About User-Managed Restore and Recovery
      • Automatic Recovery with the RECOVER Command
        • Automatic Recovery with SET AUTORECOVERY
        • Automatic Recovery with the AUTOMATIC Option of the RECOVER Command
      • Recovery When Archived Logs Are in the Default Location
      • Recovery When Archived Logs Are in a Nondefault Location
        • Resetting the Archived Log Destination
        • Overriding the Archived Log Destination
      • Recovery Using Storage Snapshot Optimization
      • Recovery Cancellation During User-Managed Recovery
      • Parallel Media Recovery
    • Performing Complete Database Recovery Using SQL*Plus
      • Performing Closed Database Recovery
      • Performing Open Database Recovery
      • Performing Crash and Instance Recovery of CDBs
    • Performing Incomplete Database Recovery
      • Performing Cancel-Based Incomplete Recovery
      • Performing Time-Based or Change-Based Incomplete Recovery
    • Recovering a Database in NOARCHIVELOG Mode
    • Troubleshooting Media Recovery
      • About User-Managed Media Recovery Problems
      • Investigating the Media Recovery Problem: Phase 1
      • Trying to Fix the Recovery Problem Without Corrupting Blocks: Phase 2
      • Deciding Whether to Allow Recovery to Mark as Corrupt Blocks: Phase 3
      • Allowing Recovery to Corrupt Blocks: Phase 4
      • Performing Trial Recovery
        • How Trial Recovery Works
        • Executing the RECOVER... TEST Statement
  • 31 Performing User-Managed Recovery: Advanced Scenarios
    • Responding to the Loss of a Subset of the Current Control Files
      • Copying a Multiplexed Control File to a Default Location
      • Copying a Multiplexed Control File to a Nondefault Location
    • Recovering After the Loss of All Current Control Files
      • Recovering with a Backup Control File in the Default Location
      • Recovering with a Backup Control File in a Nondefault Location
      • Recovering Through an Added Data File with a Backup Control File
      • Recovering Read-Only Tablespaces with a Backup Control File
    • Re-Creating a Control File
      • Recovering Through a RESETLOGS with a Created Control File
      • Recovery of Read-Only Files with a Re-Created Control File
    • Re-Creating Data Files When Backups Are Unavailable
    • Recovering NOLOGGING Tables and Indexes
    • Recovering Transportable Tablespaces
    • Recovering After the Loss of Online Redo Log Files
      • Recovering After Losing a Member of a Multiplexed Online Redo Log Group
      • Recovering After Losing All Members of an Online Redo Log Group
        • Losing an Inactive Online Redo Log Group
          • Clearing Inactive, Archived Redo
          • Clearing Inactive, Unarchived Redo
          • Failure of CLEAR LOGFILE Operation
        • Losing an Active Online Redo Log Group
          • Recovering from the Loss of Active Logs in NOARCHIVELOG Mode
          • Recovering from Loss of Active Logs in ARCHIVELOG Mode
        • Loss of Multiple Redo Log Groups
    • Recovering from a Dropped Table Without Using Flashback Features
    • Dropping a Database with SQL*Plus
• Glossary
• Index