Backup And Recovery User's Guide RMAN 04 PDF 18c Users E83709 02
User Manual:
Open the PDF directly: View PDF
Page Count: 909 [warning: Documents this large are best viewed by clicking the View PDF Link!]
- Contents
- 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
- 1.1 Purpose of Backup and Recovery
- 1.2 Oracle Backup and Recovery Solutions
- 1.3 Comparison of Oracle Backup Techniques
- 1.4 About Oracle Flashback Technology
- 1.5 About Data Recovery Advisor
- 1.6 RMAN and Oracle Enterprise Manager Cloud Control
- 1.7 About Zero Data Loss Recovery Appliance
- 1.8 Backup and Recovery Documentation Roadmap
- 2 Getting Started with RMAN
- 2.1 Overview of the RMAN Environment
- 2.2 Starting RMAN and Connecting to a Database: Quick Start
- 2.3 Showing the Default RMAN Configuration
- 2.4 Backing Up a Database: Quick Start
- 2.4.1 About Typical RMAN Backup Options
- 2.4.2 Backing Up a Database in ARCHIVELOG Mode
- 2.4.3 Backing Up a Database in NOARCHIVELOG Mode
- 2.4.4 Making Incremental Backups: Quick Start
- 2.4.5 Making Incrementally Updated Backups
- 2.4.6 Validating Database Files and Backups: Quick Start
- 2.4.7 Scripting RMAN Operations
- 2.5 Reporting on RMAN Operations: Quick Start
- 2.6 Maintaining RMAN Backups
- 2.7 Diagnosing and Repairing Failures with Data Recovery Advisor: Quick Start
- 2.8 Rewinding a Database with Flashback Database: Quick Start
- 2.9 Restoring and Recovering Database Files: Quick Start
- 1 Introduction to Backup and Recovery
- Part II Starting and Configuring RMAN and Flashback Database
- 3 Recovery Manager Architecture
- 3.1 About the RMAN Environment
- 3.2 About RMAN Command-Line Client
- 3.3 About RMAN Channels
- 3.4 About the RMAN Repository
- 3.5 About Media Management Using RMAN
- 3.6 About the Fast Recovery Area
- 3.7 About RMAN in a Data Guard Environment
- 3.8 About RMAN in a Recovery Appliance Environment
- 4 Starting and Interacting with the RMAN Client
- 4.1 Starting and Exiting RMAN
- 4.2 Making Database Connections with RMAN
- 4.2.1 About RMAN Database Connection Types
- 4.2.2 About Authentication for RMAN Database Connections
- 4.2.3 Making Database Connections from the RMAN Prompt
- 4.2.4 Making RMAN Database Connections from the Operating System Command Line
- 4.2.5 Making RMAN Connections to a CDB
- 4.2.6 Making RMAN Database Connections Within Command Files
- 4.2.7 Connecting RMAN to an Auxiliary Database
- 4.2.8 Diagnosing RMAN Connection Problems
- 4.3 Specifying the Location of RMAN Output
- 4.4 Setting Globalization Support Environment Variables for RMAN
- 4.5 Entering RMAN Commands
- 4.6 Using the RMAN Pipe Interface
- 5 Configuring the RMAN Environment
- 5.1 About Configuring the Environment for RMAN Backups
- 5.2 Configuring RMAN to Make Backups to a Media Manager
- 5.2.1 Prerequisites for Using a Media Manager with RMAN
- 5.2.2 Determining the Location of the Media Management Library
- 5.2.3 Configuring Media Management Software for RMAN Backups
- 5.2.4 Testing Whether the Media Manager Library Is Integrated Correctly
- 5.2.5 Configuring SBT Channels for Use with a Media Manager
- 5.3 Configuring RMAN to Make Backups to Recovery Appliance
- 5.4 Configuring the Fast Recovery Area
- 5.5 Configuring the Backup Retention Policy
- 5.6 Backup Optimization and the CONFIGURE command
- 5.7 Configuring an Archived Redo Log Deletion Policy
- 5.8 Configuring RMAN in a Data Guard Environment
- 6 Configuring the RMAN Environment: Advanced Topics
- 6.1 Configuring Advanced Channel Options
- 6.2 Configuring Advanced Backup Options
- 6.3 Configuring Auxiliary Instance Data File Names
- 6.4 Configuring the Snapshot Control File Location
- 6.5 Configuring RMAN for Use with a Shared Server
- 6.6 Enabling Lost Write Detection
- 6.7 Enabling Shadow Lost Write Protection
- 7 Using Flashback Database and Restore Points
- 7.1 Overview of Flashback Database, Restore Points and Guaranteed Restore Points
- 7.2 About Logging for Flashback Database and Guaranteed Restore Points
- 7.3 Prerequisites for Flashback Database and Restore Points
- 7.4 Using Normal and Guaranteed Restore Points
- 7.5 Using Flashback Database
- 3 Recovery Manager Architecture
- Part III Backing Up and Archiving Data
- 8 RMAN Backup Concepts
- 8.1 About Consistent and Inconsistent RMAN Backups
- 8.2 About Online Backups and Backup Mode
- 8.3 About Backup Sets
- 8.3.1 About Backup Sets and Backup Pieces
- 8.3.2 About RMAN Block Compression for Backup Sets
- 8.3.3 About Binary Compression for RMAN Backup Sets
- 8.3.4 About RMAN Backup Undo Optimization
- 8.3.5 About Encryption for RMAN Backup Sets
- 8.3.6 About File Names for RMAN Backup Pieces
- 8.3.7 About Number and Size of RMAN Backup Pieces
- 8.3.8 About Number and Size of RMAN Backup Sets
- 8.3.9 About Multiplexed RMAN Backup Sets
- 8.3.10 About RMAN Proxy Copies
- 8.4 About RMAN Image Copies
- 8.5 About Sparse Backups
- 8.6 About Preplugin Backups
- 8.7 About Multiple Copies of RMAN Backups
- 8.8 About RMAN Control File and Server Parameter File Autobackups
- 8.9 About RMAN Incremental Backups
- 8.10 About Backup Retention Policies
- 9 Backing Up the Database
- 9.1 Overview of RMAN Backups
- 9.2 Specifying Backup Output Options
- 9.2.1 Specifying the Device Type for an RMAN Backup
- 9.2.2 Specifying Backup Set or Copy for an RMAN Backup to Disk
- 9.2.3 Specifying a Format for RMAN Backups
- 9.2.4 Specifying Tags for an RMAN Backup
- 9.2.5 Making Compressed Backups
- 9.2.6 Specifying Multisection Incremental Backups
- 9.2.7 Making Multisection Backups Using Image Copies
- 9.3 Backing Up Database Files with RMAN
- 9.4 Backing Up CDBs and PDBs
- 9.4.1 About Backing Up CDBs and PDBs
- 9.4.2 Backing Up a Whole CDB
- 9.4.3 Backing Up the Root with RMAN
- 9.4.4 Backing Up the Root with Oracle Enterprise Manager Cloud Control
- 9.4.5 Backing Up PDBs with RMAN
- 9.4.6 Creating Preplugin Backups of PDBs Using RMAN
- 9.4.7 Backing Up PDBs with Oracle Enterprise Manager Cloud Control
- 9.4.8 Backing Up Tablespaces and Data Files in a PDB
- 9.4.9 Example: Creating a Preplugin Backup of a PDB with RMAN
- 9.5 Backing Up Application Containers
- 9.6 Backing Up Sparse Databases with RMAN
- 9.7 Backing Up Archived Redo Logs with RMAN
- 9.7.1 About Backups of Archived Redo Logs for non-CDBs
- 9.7.2 About Backup of Archived Redo Logs in CDBs
- 9.7.3 Backing Up Archived Redo Log Files in non-CDBs
- 9.7.4 Backing Up Only Archived Redo Logs That Need Backups in non-CDBs
- 9.7.5 Backing Up Archived Redo Logs in CDBs
- 9.7.6 Deleting Archived Redo Logs After Backups in non-CDBs
- 9.7.7 Deleting Archived Redo Logs After Backups in CDBs
- 9.8 Making and Updating RMAN Incremental Backups
- 9.8.1 Purpose of RMAN Incremental Backups
- 9.8.2 Planning an Incremental Backup Strategy
- 9.8.3 Making Incremental Backups
- 9.8.4 Incrementally Updating Backups
- 9.8.5 Using Block Change Tracking to Improve Incremental Backup Performance
- 9.9 Making Database Backups for Long-Term Storage
- 9.10 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
- 11.1 Overview of RMAN Reporting
- 11.2 Listing Backups and Recovery-Related Objects
- 11.3 Reporting on Backups and Database Schema
- 11.4 Reporting in CDBs and PDBs
- 11.5 Using V$ Views to Query Backup Metadata
- 11.6 Querying Recovery Catalog Views
- 12 Maintaining RMAN Backups and Repository Records
- 12.1 Overview of RMAN Backup and Repository Maintenance
- 12.2 Maintaining the Control File Repository
- 12.3 Maintaining the Fast Recovery Area
- 12.3.1 Deletion Rules for the Fast Recovery Area
- 12.3.2 Monitoring Fast Recovery Area Space Usage
- 12.3.3 Managing Space for Flashback Logs in the Fast Recovery Area
- 12.3.4 Responding to a Full Fast Recovery Area
- 12.3.5 Changing the Fast Recovery Area to a New Location
- 12.3.6 Disabling the Fast Recovery Area
- 12.3.7 Responding to an Instance Crash During File Creation
- 12.4 Updating the RMAN Repository
- 12.5 Deleting RMAN Backups and Archived Redo Logs
- 12.5.1 Overview of Deleting RMAN Backups
- 12.5.2 Deleting All Backups and Copies
- 12.5.3 Deleting Specified Backups and Copies
- 12.5.4 Deleting Expired RMAN Backups and Copies
- 12.5.5 Deleting Obsolete RMAN Backups Based on Retention Policies
- 12.5.6 Deleting Backups of Dropped PDBs
- 12.5.7 Deleting Preplugin Backups
- 12.6 Dropping a Database
- 13 Managing a Recovery Catalog
- 13.1 Overview of the RMAN Recovery Catalog
- 13.2 Creating a Recovery Catalog
- 13.3 Registering a Database in the Recovery Catalog
- 13.4 Cataloging Backups in the Recovery Catalog
- 13.5 Creating and Managing Virtual Private Catalogs
- 13.5.1 Overview of Virtual Private Catalogs
- 13.5.2 About Using the VPD Model for Virtual Private Catalogs
- 13.5.3 Creating Virtual Private Catalogs
- 13.5.4 Registering a Database with a Virtual Private Catalog
- 13.5.5 Revoking Privileges from a Virtual Private Catalog Owner
- 13.5.6 Upgrading Virtual Private Catalogs
- 13.6 Protecting the Recovery Catalog
- 13.7 Managing Stored Scripts
- 13.7.1 About Stored Scripts
- 13.7.2 Creating Stored Scripts
- 13.7.3 Replacing Stored Scripts
- 13.7.4 Executing Stored Scripts
- 13.7.5 Creating and Executing Dynamic Stored Scripts
- 13.7.6 Printing Stored Scripts
- 13.7.7 Listing Stored Script Names
- 13.7.8 Deleting Stored Scripts
- 13.7.9 Executing a Stored Script at RMAN Startup
- 13.8 Maintaining a Recovery Catalog
- 13.8.1 About Recovery Catalog Maintenance
- 13.8.2 Resynchronizing the Recovery Catalog
- 13.8.3 Updating the Recovery Catalog After Changing a DB_UNIQUE_NAME
- 13.8.4 Unregistering a Target Database from the Recovery Catalog
- 13.8.5 Resetting the Database Incarnation in the Recovery Catalog
- 13.8.6 Upgrading the Recovery Catalog
- 13.8.7 Importing and Moving a Recovery Catalog
- 13.9 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
- 15.1 Overview of Data Recovery Advisor
- 15.1.1 Purpose of Data Recovery Advisor
- 15.1.2 Basic Concepts of Data Recovery Advisor
- 15.1.3 Basic Steps of Diagnosing and Repairing Failures
- 15.1.4 Diagnosing and Repairing Failures in CDBs
- 15.2 Listing Failures
- 15.3 Checking for Block Corruptions by Validating the Database
- 15.4 Determining Repair Options
- 15.5 Repairing Failures
- 15.6 Changing Failure Status and Priority
- 15.1 Overview of Data Recovery Advisor
- 16 Validating Database Files and Backups
- 17 Performing Complete Database Recovery
- 17.1 Overview of Complete Database Recovery
- 17.2 Preparing for Complete Database Recovery
- 17.2.1 Identifying the Database Files to Restore or Recover
- 17.2.2 Determining the DBID of the Database
- 17.2.3 Previewing Backups Used in Restore Operations
- 17.2.4 Validating Backups Before Restoring Them
- 17.2.5 Restoring Archived Redo Logs Needed for Recovery
- 17.2.6 Providing the Password Required to Decrypt Encrypted Backups
- 17.3 Performing Complete Database Recovery
- 17.4 Performing Complete Recovery of CDBs
- 17.4.1 Performing Complete Recovery of a Whole CDB
- 17.4.2 Performing Complete Recovery of the Root
- 17.4.3 Performing Complete Recovery of PDBs with RMAN
- 17.4.4 Performing Complete Recovery of PDBs with Cloud Control
- 17.4.5 Performing Complete Recovery Using Preplugin Backups
- 17.4.6 Performing Complete Recovery of Tablespaces or Data Files in a PDB with RMAN
- 17.4.7 Performing Complete Recovery of Tablespaces in a PDB with Cloud Control
- 17.4.8 Performing Complete Recovering of CDBs After Switching to a Copy
- 17.5 Performing Complete Recovery of Application Containers
- 17.6 Performing Complete Recovery of Sparse Databases with RMAN
- 18 Performing Flashback and Database Point-in-Time Recovery
- 18.1 Overview of Oracle Flashback Technology and Database Point-in-Time Recovery
- 18.1.1 Purpose of Flashback and Database Point-in-Time Recovery
- 18.1.2 Basic Concepts of Point-in-Time Recovery and Flashback Features
- 18.1.3 Basic Concepts of Performing Flashback Database for CDBs and PDBs
- 18.2 Rewinding a Table with Flashback Table
- 18.3 Rewinding a DROP TABLE Operation with Flashback Drop
- 18.4 Rewinding a Database with Flashback Database
- 18.5 Performing Database Point-in-Time Recovery
- 18.6 Flashback and Database Point-in-Time Recovery Scenarios
- 18.1 Overview of Oracle Flashback Technology and Database Point-in-Time Recovery
- 19 Performing Block Media Recovery
- 20 Performing RMAN Recovery: Advanced Scenarios
- 20.1 Recovering a NOARCHIVELOG Database with Incremental Backups
- 20.2 Restoring the Server Parameter File
- 20.3 Performing Recovery with a Backup Control File
- 20.4 Performing Disaster Recovery
- 20.5 Restoring a Database on a New Host
- 20.6 Restoring Backups Created Using Older Versions of RMAN
- 20.7 Restoring and Recovering Files Over the Network
- 21 Performing RMAN Tablespace Point-in-Time Recovery (TSPITR)
- 21.1 Overview of RMAN TSPITR
- 21.2 TSPITR Restrictions, Special Cases, and Limitations
- 21.3 Planning and Preparing for TSPITR
- 21.4 Performing Fully Automated RMAN TSPITR
- 21.5 Overriding Defaults for RMAN TSPITR with an RMAN-Managed Auxiliary Database
- 21.5.1 Renaming TSPITR Recovery Set Data Files with SET NEWNAME
- 21.5.2 Naming TSPITR Auxiliary Set Data Files
- 21.5.3 Using Image Copies for Faster RMAN TSPITR Performance
- 21.5.4 Customizing Initialization Parameters for the Automatic Auxiliary Database in TSPITR
- 21.6 Performing RMAN TSPITR Using Your Own Auxiliary Database
- 21.7 Troubleshooting RMAN TSPITR
- 22 Recovering Tables and Table Partitions
- 22.1 Overview of Recovering Tables and Table Partitions
- 22.1.1 Purpose of Recovering Tables and Table Partitions from RMAN Backups
- 22.1.2 RMAN Backups Required to Recover Tables and Table Partitions
- 22.1.3 Basic Concepts of Recovering Tables and Table Partitions from RMAN Backups
- 22.1.3.1 Steps Performed By RMAN to Recover Tables and Table Partitions
- 22.1.3.2 About the Location of Auxiliary Database Files During RMAN Table Recovery
- 22.1.3.3 About the Data Pump Export Dump File Used During RMAN Table Recovery
- 22.1.3.4 About Importing Recovered Tables and Table Partitions into the Target Database
- 22.1.3.5 About Renaming Recovered Tables and Table Partitions During RMAN Recovery
- 22.1.3.6 About Recovering Tables and Partitions Into a New Schema
- 22.1.4 Limitations of Recovering Tables and Table Partitions from RMAN Backups
- 22.2 Preparing to Recover Tables and Table Partitions
- 22.3 Recovering Tables and Table Partitions
- 22.4 Recovering Tables and Table Partitions in PDBs
- 22.5 Examples: Recovering Tables and Table Partitions From RMAN Backups
- 22.1 Overview of Recovering Tables and Table Partitions
- Part VI Tuning and Troubleshooting
- 23 Tuning RMAN Performance
- 23.1 Purpose of RMAN Performance Tuning
- 23.2 Basic Concepts of RMAN Performance Tuning
- 23.3 Using V$ Views to Diagnose RMAN Performance Problems
- 23.4 Tuning RMAN Backup Performance
- 24 Troubleshooting RMAN Operations
- 24.1 Interpreting RMAN Message Output
- 24.2 Using V$ Views for RMAN Troubleshooting
- 24.3 Testing the Media Management API
- 24.4 Terminating an RMAN Command
- 23 Tuning RMAN Performance
- Part VII Transferring Data with RMAN
- 25 Duplicating Databases
- 25.1 Overview of RMAN Database Duplication
- 25.1.1 Purpose of Database Duplication
- 25.1.2 Basic Concepts of Database Duplication
- 25.1.3 Types of Database Duplication
- 25.1.3.1 Overview of Backup-Based Duplication
- 25.1.3.2 Techniques for Performing Backup-Based Duplication
- 25.1.3.3 Overview of Active Database Duplication
- 25.1.3.4 Techniques for Performing Active Database Duplication
- 25.1.3.5 Factors that Determine Whether Backup Sets or Image Copies Are Used for Active Database Duplication
- 25.1.4 How RMAN Duplicates a Database
- 25.1.5 Contents of a Duplicate Database
- 25.1.6 About the Destination Host for Database Duplication
- 25.1.7 About Duplicate Database File Names
- 25.1.8 About Duplicating a Database to a Past Point-in-Time
- 25.1.9 Prerequisites for Duplicating a Database
- 25.2 Planning to Duplicate a Database
- 25.3 Preparing the Auxiliary Instance
- 25.3.1 Creating Directories for the Duplicate Database
- 25.3.2 Creating an Initialization Parameter File for the Auxiliary Instance
- 25.3.3 Creating a Password File for the Auxiliary Instance
- 25.3.4 Establishing Oracle Net Connectivity Between the Source Database and Auxiliary Instance
- 25.3.5 Starting the Auxiliary Instance
- 25.3.6 Making the Oracle Keystore Available to the Destination Host
- 25.4 Duplicating a Database
- 25.4.1 Duplicating the Whole Database
- 25.4.2 Duplicating a Subset of the Source Database Tablespaces
- 25.4.3 Duplicating an Oracle RAC Database
- 25.4.4 Duplicating Sparse Databases
- 25.4.5 Configuring RMAN Channels for Use in Duplication
- 25.4.6 Placing the Source Database in a Proper State
- 25.4.7 Starting RMAN and Connecting to Databases
- 25.4.8 Using the DUPLICATE Command to Duplicate Databases
- 25.5 Duplicating CDBs and PDBs
- 25.6 Duplicating Databases to Oracle Cloud
- 25.7 Duplicating an Oracle Cloud Database as an On-premise Database
- 25.8 Restarting DUPLICATE After a Failure
- 25.9 Examples: Duplicating Databases
- 25.9.1 Example: Duplicating a Database to a Remote ASM Host by Using Active Database Duplication with Backup Sets
- 25.9.2 Example: Duplicating a Database to a Remote Host by Using Active Database Duplication with Image Copies
- 25.9.3 Example: Duplicating a Database to a Remote Host by Using Backup-based Duplication without a Target Connection or Recovery Catalog
- 25.9.4 Example: Duplicating a Database to a Remote Host by Using Backup-Based Duplication with a Recovery Catalog
- 25.9.5 Example: Duplicating a Database to a Remote Host by Using Backup-based Duplication with a Target Connection
- 25.9.6 Example: Duplicating a Database to the Local Host by Using Active Database Duplication
- 25.9.7 Example: Duplicating PDBs to a New CDB by Using Active Database Duplication
- 25.9.8 Example: Duplicating a PDB to an Existing CDB by Using Active Duplication
- 25.9.9 Example: Performing Backup-based Duplication by Using Encrypted Backups
- 25.10 Example: Script to Duplicate a Database Using Backup-based Duplication
- 25.1 Overview of RMAN Database Duplication
- 26 Duplicating Databases: Advanced Topics
- 26.1 Specifying Alternative Names for Duplicate Database Files
- 26.1.1 Specifying Non-OMF or Non-ASM Alternative Names for Duplicate Database Files
- 26.1.2 Specifying OMF or ASM Alternative Names for Duplicate Database Files
- 26.1.2.1 Settings and Restrictions for OMF Initialization Parameters
- 26.1.2.2 Setting Initialization Parameters for ASM
- 26.1.2.3 Examples: Duplicating Databases to ASM
- 26.1.2.4 Using the SET NEWNAME Command to Create OMF or ASM Files
- 26.1.2.5 Using the DB_FILE_NAME_CONVERT Parameter to Generate Names for Non-OMF or ASM Data Files
- 26.1.2.6 Using the LOG_FILE_NAME_CONVERT Parameter to Generate Names for Non-OMF or ASM Log Files
- 26.2 Making Disk Backups Accessible Without Shared Disk
- 26.1 Specifying Alternative Names for Duplicate Database Files
- 27 Creating Transportable Tablespace Sets
- 27.1 Overview of Creating Transportable Tablespace Sets
- 27.2 Customizing Initialization Parameters for the Auxiliary Instance
- 27.3 Creating a Transportable Tablespace Set
- 27.4 Troubleshooting the Creation of Transportable Tablespace Sets
- 27.5 Transportable Tablespace Set Scenarios
- 28 Transporting Data Across Platforms
- 28.1 About Cross-Platform Data Transport
- 28.2 Overview of Cross-Platform Data Transport Using Image Copies
- 28.3 Performing Cross-Platform Tablespace Conversion with Image Copies
- 28.4 Performing Cross-Platform Data File Conversion with Image Copies
- 28.5 Performing Cross-Platform Database Conversion with Image Copies
- 28.6 Overview of Cross-Platform Data Transport Using Backup Sets
- 28.6.1 Basic Terms Used in Cross-Platform Data Transport Using Backup Sets
- 28.6.2 About Backing Up Data on the Source Database for Cross-Platform Data Transport
- 28.6.3 About the Data Pump Export Dump File Used for Cross-Platform Tablespace Transport
- 28.6.4 About Restoring Data on the Destination Host During Cross-Platform Data Transport
- 28.6.5 About Selecting Objects to Be Restored from Cross-Platform Backups
- 28.6.6 About Names and Locations for Restored Objects on the Destination Database
- 28.6.7 About Importing the Data Pump Export Dump File Created During Cross-Platform Tablespace Transport
- 28.7 Performing Cross-Platform Database Transport with Backup Sets
- 28.8 Performing Cross-Platform Transport of Read-Only Tablespaces Using Backup Sets
- 28.9 Overview of Cross-Platform Transport of Tablespaces Using Inconsistent Backups
- 28.10 Performing Cross-Platform Transport of Tablespaces Using Inconsistent Backups
- 28.11 Performing Cross-Platform Transport of Data Files Over the Network
- 28.12 Performing Cross-Platform Data Transport in CDBs and PDBs
- 28.12.1 About Cross-Platform Transport of PDBs
- 28.12.2 Performing Cross-Platform Transport of a Whole CDB
- 28.12.3 Performing Cross-Platform Transport of a Closed PDB
- 28.12.4 Performing Cross-Platform Transport of a PDB Using Inconsistent Backups
- 28.12.5 Performing Cross-Platform Transport of Tablespaces in a PDB
- 25 Duplicating Databases
- Part VIII Performing User-Managed Backup and Recovery
- 29 Making User-Managed Database Backups
- 29.1 Querying V$ Views to Obtain Backup Information
- 29.2 Making User-Managed Backups of the Whole Database
- 29.3 Making User-Managed Backups of CDBs and PDBs
- 29.4 Making User-Managed Backups of Tablespaces and Data Files
- 29.4.1 Making User-Managed Backups of Offline Tablespaces and Data Files
- 29.4.2 Making User-Managed Backups of Online Tablespaces and Data Files
- 29.5 Making User-Managed Backups of Tablespaces in CDBs
- 29.6 Making User-Managed Backups of the Control File
- 29.7 Making User-Managed Backups of Archived Redo Logs
- 29.8 Making User-Managed Backups in SUSPEND Mode
- 29.9 Making User-Managed Backups to Raw Devices
- 29.10 Making Backups with Third-Party Snapshot Technologies
- 29.11 Verifying User-Managed Data File Backups
- 30 Performing User-Managed Database Flashback and Recovery
- 30.1 Performing Flashback Database with SQL*Plus
- 30.2 Overview of User-Managed Media Recovery
- 30.2.1 About User-Managed Restore and Recovery
- 30.2.2 Automatic Recovery with the RECOVER Command
- 30.2.3 Recovery When Archived Logs Are in the Default Location
- 30.2.4 Recovery When Archived Logs Are in a Nondefault Location
- 30.2.5 Recovery Using Storage Snapshot Optimization
- 30.2.6 Recovery Cancellation During User-Managed Recovery
- 30.2.7 Parallel Media Recovery
- 30.3 Performing Complete Database Recovery Using SQL*Plus
- 30.4 Performing Incomplete Database Recovery
- 30.5 Recovering a Database in NOARCHIVELOG Mode
- 30.6 Troubleshooting Media Recovery
- 30.6.1 About User-Managed Media Recovery Problems
- 30.6.2 Investigating the Media Recovery Problem: Phase 1
- 30.6.3 Trying to Fix the Recovery Problem Without Corrupting Blocks: Phase 2
- 30.6.4 Deciding Whether to Allow Recovery to Mark as Corrupt Blocks: Phase 3
- 30.6.5 Allowing Recovery to Corrupt Blocks: Phase 4
- 30.6.6 Performing Trial Recovery
- 31 Performing User-Managed Recovery: Advanced Scenarios
- 31.1 Responding to the Loss of a Subset of the Current Control Files
- 31.2 Recovering After the Loss of All Current Control Files
- 31.3 Re-Creating a Control File
- 31.4 Re-Creating Data Files When Backups Are Unavailable
- 31.5 Recovering NOLOGGING Tables and Indexes
- 31.6 Recovering Transportable Tablespaces
- 31.7 Recovering After the Loss of Online Redo Log Files
- 31.8 Recovering from a Dropped Table Without Using Flashback Features
- 31.9 Dropping a Database with SQL*Plus
- 29 Making User-Managed Database Backups
- Glossary
- active database duplication
- ancestor incarnation
- application container
- application PDB
- application root
- archival backup
- archived redo log
- archived redo log deletion policy
- archived redo log failover
- ARCHIVELOG mode
- archiving
- asynchronous I/O
- automatic channel allocation
- Automatic Diagnostic Repository (ADR)
- Automatic Storage Management (ASM)
- automatic undo management mode
- auxiliary channel
- auxiliary database
- auxiliary destination
- auxiliary instance
- auxiliary set
- backup
- backup and recovery
- backup-based duplication
- backup control file
- backup encryption
- backup mode
- backup optimization
- backup piece
- backup retention policy
- backup set
- backup undo optimization
- backup window
- base recovery catalog
- binary compression
- block change tracking
- block change tracking file
- block media recovery
- breaking a mirror
- CDB
- CDB restore point
- channel
- channel parallelism
- checkpoint
- checksum
- circular reuse records
- closed backup
- cold backup
- command file
- common user
- complete recovery
- consistent backup
- consistent shutdown
- control file autobackup
- convert script
- copy
- corrupt block
- crash recovery
- cross-platform backup
- crosscheck
- cumulative incremental backup
- current incarnation
- current online redo log
- data integrity check
- data repair
- Data Recovery Advisor
- database area
- database checkpoint
- database identifier
- database point-in-time recovery (DBPITR)
- database registration
- data file checkpoint
- data file media recovery
- DBID
- destination database
- destination host
- destination platform
- differential incremental backup
- direct ancestral path
- disaster recovery
- disk controller
- disk group
- disk quota
- duplexed backup set
- duplicate database
- expired backup
- export
- export dump file
- failure
- failure priority
- failure status
- fast recovery area
- file section
- flashback data archive
- flashback database window
- flashback logs
- flashback retention target
- foreign archived redo log
- foreign data file
- foreign data file copy
- foreign tablespace
- fractured block
- full backup
- full resynchronization
- fuzzy file
- guaranteed restore point
- hot backup
- hot backup mode
- image copy
- incarnation
- incomplete recovery
- inconsistent backup
- incremental backup
- incremental forever
- incrementally updated backup
- instance failure
- instance recovery
- interblock corruption
- intrablock corruption
- level 0 incremental backup
- level of multiplexing
- local user
- LogMiner
- log sequence number
- log switch
- logical backup
- logical corruption
- logical flashback features
- long-term backup
- lost write
- mean time to recover (MTTR)
- media failure
- media management catalog
- media management library
- media management software
- media manager multiplexing
- media recovery
- mirroring
- MTTR
- multiplexed backup set
- multiplexing
- multisection backup
- multitenant architecture
- multitenant container database (CDB)
- native transfer rate
- NOARCHIVELOG mode
- non-CDB
- noncircular reuse records
- normal restore point
- obsolete backup
- offline normal
- offsite backup
- online backup
- online redo log
- online redo log group
- online redo log member
- operating system backup
- operating system backup and recovery
- Oracle Enterprise Manager Cloud Control
- Oracle Flashback Database
- Oracle Flashback Technology
- Oracle managed file
- Oracle Managed Files (OMF)
- Oracle Secure Backup
- Oracle-suggested backup strategy
- Oracle VSS writer
- orphaned backups
- parallel recovery
- parent incarnation
- partial resynchronization
- password file
- PDB
- PDB restore point
- physical backup
- physical corruption
- physical schema
- physical standby database
- pluggable database (PDB)
- point-in-time recovery
- problem
- proxy copy
- raw device
- recover
- recovery
- recovery catalog
- recovery catalog database
- recovery catalog schema
- Recovery Manager (RMAN)
- recovery set
- recovery window
- recycle bin
- redo log
- redo log group
- redo thread
- redundancy
- redundancy set
- registration
- repair
- repair option
- RESETLOGS
- resilver a split mirror
- restartable backup
- restore
- restore failover
- restore optimization
- restore point
- resynchronization
- retention policy
- reverse resynchronization
- RMAN
- RMAN backup job
- RMAN client
- RMAN job
- RMAN maintenance commands
- RMAN repository
- RMAN session
- rollback segments
- rolling back
- rolling forward
- root
- RUN block
- SBT
- shadow copy
- snapshot control file
- source database
- source host
- source platform
- sparse backup
- sparse database
- sparse data file
- split mirror backup
- stored script
- synchronous I/O
- system change number (SCN)
- tablespace destination
- tablespace point-in-time recovery (TSPITR)
- tag
- target database
- target host
- target instance
- temp file
- transport script
- transportable tablespace
- transportable tablespace set
- trial recovery
- undo retention period
- undo tablespace
- unused block compression
- user-managed backup
- user-managed backup and recovery
- validation
- virtual private catalog
- Volume Shadow Copy Service (VSS)
- whole database backup
- Zero Data Loss Recovery Appliance (Recovery Appliance)
- Index