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
- 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 to non-CDBs from the RMAN Prompt
- 4.2.4 Making RMAN Connections to non-CDBs from the Operating System Command Line
- 4.2.5 Making RMAN Connections to CDBs and PDBs
- 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
- 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 Creating a Base Backup of New Data Files
- 9.8.6 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
- 10.1 Limiting the Size of RMAN Backup Sets
- 10.2 Using Backup Optimization to Skip Files
- 10.3 Skipping Offline, Read-Only, and Inaccessible Files
- 10.4 Duplexing Backup Sets
- 10.5 Making Split Mirror Backups with RMAN
- 10.6 Encrypting RMAN Backups
- 10.7 Restarting RMAN Backups
- 10.8 Managing Backup Windows
-
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 Running 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 Running 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.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
- 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 Rename the Recovered Tables and Table Partitions
- 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
- Index