Contents

List of Examples

List of Figures

List of Tables

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 12c Release 1 (12.1.0.2)
  • New Features
• Changes in Oracle Database 12c Release 1 (12.1.0.1)
  • New Features
• Other Changes
  • Relocated Documentation

Part I Overview of Backup and Recovery

1 Introduction to Backup and Recovery

• Purpose of Backup and Recovery
  • About Data Protection
    • Media Failures
    • User Errors
    • Application Errors
  • About Data Archival
  • About Data Transfer
• Oracle Backup and Recovery Solutions
• 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
• Showing the Default RMAN Configuration
• Backing Up a Database
  • Backing Up a Database in ARCHIVELOG Mode
  • Backing Up a Database in NOARCHIVELOG Mode
  • About Typical RMAN Backup Options
  • Making Incremental Backups
    • Making Incrementally Updated Backups
  • Validating Database Files and Backups
  • Scripting RMAN Operations
• Reporting on RMAN Operations
  • Listing Backups
  • Reporting on Database Files and Backups
• Maintaining RMAN Backups
  • Cross-checking Backups
  • Deleting Obsolete Backups
• Diagnosing and Repairing Failures with Data Recovery Advisor
  • Listing Failures and Determining Repair Options
  • Repairing Failures
• Rewinding a Database with Flashback Database
• Restoring and Recovering Database Files
  • Preparing to Restore and Recover Database Files
  • Recovering the Whole Database
  • Recovering Tablespaces
  • Recovering Individual Data Blocks

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

• Overview of Interacting with the RMAN Client
  • About RMAN Database Connection Types
  • About Authentication for RMAN Database Connections
    • Authentication Using the Operating System
    • Authentication Using a Password File
• Starting and Exiting RMAN
• Making Database Connections with RMAN
  • Making Database Connections from the RMAN Prompt
  • Making RMAN Database Connections from the Operating System Command Line
  • Connecting RMAN to an Auxiliary Database
  • Making RMAN Connections to a CDB
    • 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
  • 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

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
• 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 Guaranteed Restore Points
• Using Normal and Guaranteed Restore Points
  • Creating Normal and Guaranteed Restore Points
  • Listing Restore Points
  • 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 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
• 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
  • Backing Up PDBs with Oracle Enterprise Manager Cloud Control
  • Backing Up Tablespaces and Data Files in a PDB
• 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 in non-CDBs
  • 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
  • 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 and Disabling 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
  • Reporting in CDBs and PDBs
    • Reporting in CDBs
    • Reporting in PDBs
• Listing Backups and Recovery-Related Objects
  • About the LIST Command
  • Listing All Backups and Copies
  • Listing Selected Backups and Copies
  • 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
• 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
  • Changing the Repository Status of Backups and Copies
    • Updating a Backup to Status AVAILABLE or UNAVAILABLE
    • Changing the Status of an Archival Backup
  • 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
  • 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
• 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
  • Executing 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 Virtual Private Catalogs
  • Creating and Managing Virtual Private Catalogs with Oracle Database 12c Release 1 (12.1.0.1)
    • Steps to Create a Virtual Private Catalog
    • Creating and Granting Privileges to a Virtual Private Catalog Owner
    • Creating a Virtual Private Catalog
    • Revoking Privileges from a Virtual Private Catalog Owner
    • Dropping a Virtual Private Catalog
  • Creating and Managing Virtual Private Catalogs with Oracle Database 12c Release 1 (12.1.0.2)
    • Creating Virtual Private Catalogs with Oracle Database 12c Release 1 (12.1.0.2)
  • Upgrading Virtual Private Catalogs to Oracle Database 12c Release 1 (12.1.0.2)
• 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
  • Executing Stored Scripts
  • Creating and Executing Dynamic Stored Scripts
  • Printing Stored Scripts
  • Listing Stored Script Names
  • Deleting Stored Scripts
  • Executing 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 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
    • Switching to a Data File Copy
    • 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 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

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
  • Basic Concepts of Point-in-Time Recovery and Flashback Features
    • Basic Concepts of Database Point-in-Time Recovery for non-CDBs
    • 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
• 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 Flashback Database Operations on a CDB When a PDB Was Recovered Using DBPITR
    • Example: Rewinding a CDB to a Point that is Beyond the Point in Time to Which a PDB Was Recovered
  • 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
• 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 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
  • Step 1: Select the Right Target Time for TSPITR
  • Step 2: Determine the Recovery Set
    • Identify and Resolve Dependencies on the Primary Database
  • Step 3: Identify and Preserve 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 from RMAN Backups

• Overview of Recovering Tables and Table Partitions from RMAN Backups
  • Purpose of Recovering Tables and Table Partitions from RMAN Backups
  • 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
    • About Renaming Recovered Tables and Table Partitions During RMAN Recovery
  • 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

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
  • Step 1: Remove the RATE Parameter from Channel Settings
  • Step 2: If You Use Synchronous Disk I/O, Set DBWR_IO_SLAVES
  • Step 3: If You Fail to Allocate Shared Memory, Set LARGE_POOL_SIZE
  • Step 4: Tune 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
  • 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 a Database

• Overview of RMAN Database Duplication
  • Purpose of Database Duplication
  • Basic Concepts of Database Duplication
    • Techniques for Duplicating a Database
      • About Active Database Duplication with RMAN
      • About Backup-Based Duplication with RMAN
    • Contents of a Duplicate Database
    • How RMAN Duplicates a Database
  • Basic Steps of Database Duplication
  • Duplicating CDBs
  • Duplicating PDBs
• Preparing to Duplicate a Database
  • Step 1: Choosing a Duplication Technique
    • Specifying Encryption for Active Database Duplication
    • Compressing Backup Sets Used to Perform Active Database Duplication
    • Creating Backup Sets in Parallel During Active Database Duplication
    • Specifying the State of the Duplicate Database
  • Step 2: Choosing a Strategy for Naming Duplicate Files
  • Step 3: Installing the Oracle Database Software on the Destination Host
  • Step 4: Making Backups Accessible to the Duplicate Instance
    • Making SBT Backups Accessible to the Auxiliary Instance
    • Making Disk Backups Accessible to the Auxiliary Instance
  • Step 5: Preparing Remote Access to Databases
    • Establishing Database Connectivity
    • Creating a Password File for the Auxiliary Instance
  • Step 6: Copying the Oracle Keystore to the Destination Host
  • Step 7: Creating an Initialization Parameter File and Starting the Auxiliary Instance
  • Step 8: Placing the Source Database in the Proper State
• Starting RMAN and Connecting to Databases
• Configuring RMAN Channels for Use in Duplication
  • Configuring Channels for Backup-Based Duplication
  • Configuring Channels for Active Database Duplication
• Duplicating a Database
  • Backup-Based Duplication Without a Target Connection: Example
  • Backup-Based Duplication with a Target Connection: Example
  • Backup-Based Duplication Without a Target or Recovery Catalog Connection: Example
• Example: Script to Duplicate a Database Using Backup-based Duplication
• Restarting DUPLICATE After a Failure

26 Duplicating a Database: Advanced Topics

• Specifying Alternative Names for Duplicate Database Files
  • Specifying Non-OMF or Non-ASM Alternative Names for Duplicate Database Files
    • Using SET NEWNAME to Name File System Data Files and Temp Files
    • Using CONFIGURE AUXNAME to Name File System Data Files and OMF/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
      • Duplicating a Database from a File System to ASM: Example
      • Duplicating a Database from ASM to ASM: Example
    • Using SET NEWNAME to Create OMF or ASM Files
    • Using DB_FILE_NAME_CONVERT to Generate Names for Non-OMF or ASM Data Files
      • Restrictions on Using DB_FILE_NAME_CONVERT During Database Duplication
    • Using LOG_FILE_NAME_CONVERT to Generate Names for Non-OMF or ASM Log Files
      • Restrictions on Using LOG_FILE_NAME_CONVERT During Database Duplication
• Making Disk Backups Accessible Without Shared Disk
• Duplicating a Database When No Server Parameter File Exists
• Starting the Auxiliary Instance When No Server Parameter File Exists
• Duplicating a Subset of the Source Database Tablespaces
  • Excluding Specified Tablespaces During Database Duplication
  • Including Specified Tablespaces During Database Duplication

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 Data Transport in CDBs and PDBs
  • Performing Cross-Platform Transport of a Whole CDB
  • Performing Cross-Platform Transport of PDBs
  • 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
• 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