Oracle Database Backup And Recovery User’s Guide RMAN 01 PDF 112 Users E10642 08
User Manual:
Open the PDF directly: View PDF
Page Count: 604 [warning: Documents this large are best viewed by clicking the View PDF Link!]
- Contents
- Preface
- What's New in Backup and Recovery?
- 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
- Showing the Default RMAN Configuration
- Backing Up a Database
- Reporting on RMAN Operations
- Maintaining RMAN Backups
- Diagnosing and Repairing Failures with Data Recovery Advisor
- Rewinding a Database with Flashback Database
- Restoring and Recovering Database Files
- 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
- Specifying the Location of RMAN Output
- Setting Globalization Support Environment Variables for RMAN
- Entering RMAN Commands
- Making Database Connections with RMAN
- Using the RMAN Pipe Interface
- 5 Configuring the RMAN Environment
- Configuring the Environment for RMAN Backups
- Configuring RMAN to Make Backups to a Media Manager
- 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
- 7 Using Flashback Database and Restore Points
- Part III Backing Up and Archiving Data
- 8 RMAN Backup Concepts
- Consistent and Inconsistent RMAN Backups
- Online Backups and Backup Mode
- Backup Sets
- Image Copies
- Multiple Copies of RMAN Backups
- Control File and Server Parameter File Autobackups
- Incremental Backups
- Backup Retention Policies
- 9 Backing Up the Database
- Overview of RMAN Backups
- Specifying Backup Output Options
- Backing Up Database Files with RMAN
- Backing Up Archived Redo Logs with RMAN
- Making and Updating Incremental Backups
- Purpose of Incremental Backups
- Planning an Incremental Backup Strategy
- Making Incremental Backups
- Incrementally Updating Backups
- 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
- 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
- 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 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
- 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
- Listing Failures
- Checking for Block Corruptions by Validating the Database
- Determining Repair Options
- Repairing Failures
- Changing Failure Status and Priority
- 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
- 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
- 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 Instance
- Performing RMAN TSPITR Using Your Own Auxiliary Instance
- Troubleshooting RMAN TSPITR
- Part VI Tuning and Troubleshooting
- 22 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
- 23 Troubleshooting RMAN Operations
- Interpreting RMAN Message Output
- Using V$ Views for RMAN Troubleshooting
- Testing the Media Management API
- Terminating an RMAN Command
- Part VII Transferring Data with RMAN
- 24 Duplicating a Database
- Overview of RMAN Database Duplication
- Preparing to Duplicate a Database
- Placing the Source Database in the Proper State
- Starting RMAN and Connecting to Databases
- Configuring RMAN Channels for Use in Duplication
- Duplicating a Database
- Restarting DUPLICATE After a Failure
- 25 Duplicating a Database: 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
- 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
- Specifying Alternative Names for Duplicate Database Files
- 26 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
- 27 Transporting Data Across Platforms
- Overview of Cross-Platform Data Transportation
- Performing Cross-Platform Tablespace Conversion on the Source Host
- Performing Cross-Platform Data File Conversion on the Destination Host
- 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
- Part VIII Performing User-Managed Backup and Recovery
- 28 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 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 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 the Volume Shadow Copy Service (VSS)
- Verifying User-Managed Data File Backups
- 29 Performing User-Managed Database Flashback and Recovery
- Performing Flashback Database with SQL*Plus
- Overview of User-Managed Media Recovery
- Performing Complete Database Recovery
- Performing Incomplete Database Recovery
- Recovering a Database in NOARCHIVELOG Mode
- Troubleshooting Media Recovery
- 30 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
- Glossary
- Index