Table of Contents
- Title and Copyright Information
- Preface
- Changes in This Release for Backup and Recovery User's Guide
-
Part I Overview of Backup and Recovery
- 1 Introduction to Backup and Recovery
-
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
- Reporting on RMAN Operations: Quick Start
- Maintaining RMAN Backups
- Diagnosing and Repairing Failures with Data Recovery Advisor: Quick Start
- Rewinding a Database with Flashback Database: Quick Start
- Restoring and Recovering Database Files: Quick Start
-
Part II Starting and Configuring RMAN and Flashback Database
- 3 Recovery Manager Architecture
-
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
- 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
- Making RMAN Database Connections Within Command Files
- Connecting RMAN to an Auxiliary Database
- Diagnosing RMAN Connection Problems
- Specifying the Location of RMAN Output
- Setting Globalization Support Environment Variables for RMAN
- Entering RMAN Commands
- Using the RMAN Pipe Interface
-
5
Configuring the RMAN Environment
- About Configuring the Environment for RMAN Backups
- Configuring RMAN to Make Backups to a Media Manager
- Configuring RMAN to Make Backups to Recovery Appliance
- Configuring the Fast Recovery Area
- Configuring the Backup Retention Policy
- Backup Optimization and the CONFIGURE command
- Configuring an Archived Redo Log Deletion Policy
- Configuring RMAN in a Data Guard Environment
-
6
Configuring the RMAN Environment: Advanced Topics
- Configuring Advanced Channel Options
- Configuring Advanced Backup Options
- Configuring Auxiliary Instance Data File Names
- Configuring the Snapshot Control File Location
- 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 Logging for Flashback Database and Guaranteed Restore Points
- Prerequisites for Flashback Database and Restore Points
- Using Normal and Guaranteed Restore Points
- Using Flashback Database
-
Part III Backing Up and Archiving Data
-
8
RMAN Backup Concepts
- About Consistent and 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 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 Sparse Backups
- About Preplugin Backups
- About Multiple Copies of RMAN Backups
- About RMAN Control File and Server Parameter File Autobackups
- About RMAN Incremental Backups
- About Backup Retention Policies
-
9
Backing Up the Database
- Overview of RMAN Backups
- Specifying Backup Output Options
- Backing Up Database Files with RMAN
-
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
- Backing Up Sparse Databases with RMAN
-
Backing Up Archived Redo Logs with RMAN
- About Backups of Archived Redo Logs for non-CDBs
- 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
- Incrementally Updating Backups
- Creating a Base Backup of New Data Files
- Using Block Change Tracking to Improve Incremental Backup Performance
- Making Database Backups for Long-Term Storage
- Backing Up RMAN Backups
- 10 Backing Up the Database: Advanced Topics
-
8
RMAN Backup Concepts
-
Part IV Managing RMAN Backups
-
11
Reporting on RMAN Operations
- Overview of RMAN Reporting
- Listing Backups and Recovery-Related Objects
- Reporting on Backups and Database Schema
- Reporting in CDBs and PDBs
- Using V$ Views to Query Backup Metadata
- Querying Recovery Catalog Views
-
12
Maintaining RMAN Backups and Repository Records
- Overview of RMAN Backup and Repository Maintenance
- Maintaining the Control File Repository
-
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
- Deleting RMAN Backups and Archived Redo Logs
- Dropping a Database
-
13
Managing a Recovery Catalog
- Overview of the RMAN Recovery Catalog
- Creating a Recovery Catalog
- Registering a Database in the Recovery Catalog
- Cataloging Backups in the Recovery Catalog
- Creating and Managing Virtual Private Catalogs
- Protecting the Recovery Catalog
- Managing Stored Scripts
-
Maintaining a Recovery Catalog
- About Recovery Catalog Maintenance
- Resynchronizing the Recovery Catalog
- Updating the Recovery Catalog After Changing a DB_UNIQUE_NAME
- Unregistering a Target Database from the Recovery Catalog
- Resetting the Database Incarnation in the Recovery Catalog
- Upgrading the Recovery Catalog
- Importing and Moving a Recovery Catalog
- Dropping a Recovery Catalog
-
11
Reporting on RMAN Operations
-
Part V Diagnosing and Responding to Failures
- 14 RMAN Data Repair Concepts
-
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
- Basic Steps of Diagnosing and Repairing Failures
- Diagnosing and Repairing Failures in CDBs
- Listing Failures
- Checking for Block Corruptions by Validating the Database
- Determining Repair Options
- Repairing Failures
- Changing Failure Status and Priority
-
Overview of Data Recovery Advisor
- 16 Validating Database Files and Backups
-
17
Performing Complete Database Recovery
- Overview of Complete Database Recovery
- Preparing for Complete Database Recovery
- Performing Complete Database Recovery
-
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
- 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 Sparse Databases with RMAN
-
18
Performing Flashback and Database Point-in-Time Recovery
- Overview of Oracle Flashback Technology and Database Point-in-Time Recovery
- Rewinding a Table with Flashback Table
- Rewinding a DROP TABLE Operation with Flashback Drop
- Rewinding a Database with Flashback Database
- Performing Database Point-in-Time Recovery
- Flashback and Database Point-in-Time Recovery Scenarios
- 19 Performing Block Media Recovery
-
20
Performing RMAN Recovery: Advanced Scenarios
- Recovering a NOARCHIVELOG Database with Incremental Backups
- Restoring the Server Parameter File
- Performing Recovery with a Backup Control File
- Performing Disaster Recovery
- Restoring a Database on a New Host
- Restoring Backups Created Using Older Versions of RMAN
- Restoring and Recovering Files Over the Network
-
21
Performing RMAN Tablespace Point-in-Time Recovery (TSPITR)
- Overview of RMAN TSPITR
- TSPITR Restrictions, Special Cases, and Limitations
- Planning and Preparing for TSPITR
- Performing Fully Automated RMAN TSPITR
- Overriding Defaults for RMAN TSPITR with an RMAN-Managed Auxiliary Database
- Performing RMAN TSPITR Using Your Own Auxiliary Database
- Troubleshooting RMAN TSPITR
-
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
- Recovering Tables and Table Partitions
- Recovering Tables and Table Partitions in PDBs
- Examples: Recovering Tables and Table Partitions From RMAN Backups
-
Overview of Recovering Tables and Table Partitions
-
Part VI Tuning and Troubleshooting
-
23
Tuning RMAN Performance
- Purpose of RMAN Performance Tuning
- Basic Concepts of RMAN Performance Tuning
- Using V$ Views to Diagnose RMAN Performance Problems
- Tuning RMAN Backup Performance
-
24
Troubleshooting RMAN Operations
- Interpreting RMAN Message Output
- Using V$ Views for RMAN Troubleshooting
- Testing the Media Management API
- Terminating an RMAN Command
-
23
Tuning RMAN Performance
-
Part VII Transferring Data with RMAN
-
25
Duplicating Databases
-
Overview of RMAN Database Duplication
- Purpose of Database Duplication
- Basic Concepts of Database Duplication
- Types of Database Duplication
- How RMAN Duplicates a Database
- Contents of a Duplicate 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
-
Preparing the Auxiliary Instance
- Creating Directories for the Duplicate Database
- Creating an Initialization Parameter File for the Auxiliary Instance
- 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
- 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 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
-
Overview of RMAN Database 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
-
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
-
Specifying Alternative Names for Duplicate Database Files
-
27
Creating Transportable Tablespace Sets
- Overview of Creating Transportable Tablespace Sets
- Customizing Initialization Parameters for the Auxiliary Instance
- Creating a Transportable Tablespace Set
- Troubleshooting the Creation of Transportable Tablespace Sets
- Transportable Tablespace Set Scenarios
-
28
Transporting Data Across Platforms
- About Cross-Platform Data Transport
- Overview of Cross-Platform Data Transport Using Image Copies
- Performing Cross-Platform Tablespace Conversion with Image Copies
- Performing Cross-Platform Data File Conversion with Image Copies
- Performing Cross-Platform Database Conversion with Image Copies
-
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
- Performing Cross-Platform Transport of Read-Only Tablespaces Using Backup Sets
- Overview of Cross-Platform Transport of Tablespaces Using Inconsistent Backups
- Performing Cross-Platform Transport of Tablespaces Using Inconsistent Backups
- Performing Cross-Platform Transport of Data Files Over the Network
- Performing Cross-Platform Data Transport in CDBs and PDBs
-
25
Duplicating Databases
-
Part VIII Performing User-Managed Backup and Recovery
-
29
Making User-Managed Database Backups
- Querying V$ Views to Obtain Backup Information
- 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 Tablespaces in CDBs
- Making User-Managed Backups of the Control File
- Making User-Managed Backups of Archived Redo Logs
- Making User-Managed Backups in SUSPEND Mode
- Making User-Managed Backups to Raw Devices
- Making Backups with Third-Party Snapshot Technologies
- Verifying User-Managed Data File Backups
-
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
- Recovery When Archived Logs Are in the Default Location
- Recovery When Archived Logs Are in a Nondefault Location
- Recovery Using Storage Snapshot Optimization
- Recovery Cancellation During User-Managed Recovery
- Parallel Media Recovery
- Performing Complete Database Recovery Using SQL*Plus
- Performing Incomplete Database 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
-
31
Performing User-Managed Recovery: Advanced Scenarios
- Responding to the Loss of a Subset of the Current Control Files
- Recovering After the Loss of All Current Control Files
- Re-Creating a 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 from a Dropped Table Without Using Flashback Features
- Dropping a Database with SQL*Plus
-
29
Making User-Managed Database Backups
- Glossary
- Index