SEARCH
Disclaimer: Authors have full rights over their works. Reproduction of any part of the content is prohibited without prior authorization.
BOOK ORACLE BACKUP AND RECOVERY USER-S GUIDE
SUMMARY
-
Items Found: 1230
- Preface
- What's New in Backup and Recovery?
- Part I Overview of Backup and Recovery
- 1 Introduction to Backup and Recovery
- Purpose of Backup and Recovery
- Data Protection
- Data Preservation
- Data Transfer
- Oracle Backup and Recovery Solutions
- Oracle Flashback Technology
- Logical Flashback Features
- Flashback Database
- Data Recovery Advisor
- 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 Database
- Showing the Default RMAN Configuration
- Backing Up a Database
- Backing Up a Database in ARCHIVELOG Mode
- Backing Up a Database in NOARCHIVELOG Mode
- Typical Backup Options
- Making Incremental Backups
- Validating Database Files and Backups
- Scripting RMAN Operations
- Reporting on RMAN Operations
- Listing Backups
- Reporting on Database Files and Backups
- Maintaining RMAN Backups
- Crosschecking 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
- 3 Recovery Manager Architecture
- About the RMAN Environment
- RMAN Command-Line Client
- RMAN Channels
- Channels and Devices
- Automatic and Manual Channels
- RMAN Repository
- Media Management
- RMAN Interaction with a Media Manager
- Oracle Secure Backup
- Backup Solutions Program
- Flash Recovery Area
- RMAN in a Data Guard Environment
- RMAN Configuration in a Data Guard Environment
- RMAN File Management in a Data Guard Environment
- 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
- 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
- Making Database Connections with RMAN
- About RMAN Database Connections
- Making RMAN Database Connections from the Operating System Command Line
- Making Database Connections from the RMAN Prompt
- Connecting RMAN to an Auxiliary Database
- Making RMAN Database Connections Within Command Files
- Diagnosing RMAN Connection Problems
- 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
- 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
- Configuring Control File and Server Parameter File Autobackups
- 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
- Configuring SBT Channels for Use with a Media Manager
- Configuring the Flash Recovery Area
- Overview of the Flash Recovery Area
- Enabling the Flash Recovery Area
- Configuring Locations for Control Files and Redo Logs
- Configuring RMAN File Creation in the Flash Recovery Area
- Configuring the Backup Retention Policy
- Configuring a Redundancy-Based Retention Policy
- Configuring a Recovery Window-Based Retention Policy
- Disabling the Retention Policy
- Configuring Backup Optimization
- Overview of Backup Optimization
- Effect of Retention Policies on Backup Optimization for SBT Backups
- Configuring Backup Optimization
- Configuring an Archived Redo Log Deletion Policy
- About Archived Redo Log Deletion Policies
- Enabling an Archived Redo Log Deletion Policy
- Configuring Oracle Flashback Database and Restore Points
- About Restore Points and Flashback Database
- Prerequisites for Flashback Database and Guaranteed Restore Points
- Enabling Flashback Database
- Creating Normal and Guaranteed Restore Points
- Configuring the Environment for Optimal Flashback Database Performance
- 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 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 the Backup Compression Algorithm
- Configuring Backup Encryption
- Configuring Auxiliary Instance Datafile 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
- Part III Backing Up and Archiving Data
- 7 RMAN Backup Concepts
- Consistent and Inconsistent RMAN Backups
- Consistent Backups
- Inconsistent Backups
- Online Backups and Backup Mode
- Backup Sets
- Backup Sets and Backup Pieces
- Compression for Backup Sets
- Encryption for Backup Sets
- Filenames for Backup Pieces
- Number and Size of Backup Pieces
- Number and Size of Backup Sets
- Multiplexed Backup Sets
- Proxy Copies
- Image Copies
- RMAN-Created Image Copies
- User-Managed Image Copies
- Multiple Copies of RMAN Backups
- Duplexed Backup Sets
- Backups of Backups
- Control File and Server Parameter File Autobackups
- When RMAN Performs Control File Autobackups
- How RMAN Performs Control File Autobackups
- Incremental Backups
- Multilevel Incremental Backups
- Block Change Tracking
- Incremental Backup Algorithm
- Recovery with Incremental Backups
- Backup Retention Policies
- Recovery Window
- Backup Redundancy
- Batch Deletes of Obsolete Backups
- Backup Retention Policy and Flash Recovery Area Deletion Rules
- 8 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 Tags for an RMAN Backup
- Making Compressed Backups
- Backing Up Database Files with RMAN
- Making Whole Database Backups with RMAN
- Backing Up Tablespaces and Datafiles with RMAN
- Backing Up Control Files with RMAN
- Backing Up Server Parameter Files with RMAN
- Backing Up a Database in NOARCHIVELOG Mode
- Backing Up Archived Redo Logs with RMAN
- About Backups of Archived Redo Logs
- Backing Up Archived Redo Log Files
- Backing Up Only Archived Redo Logs That Need Backups
- Deleting Archived Redo Logs After Backups
- 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
- Purpose of Archival Backups
- Basic Concepts of Archival Backups
- Making an Archival Backup for Long-Term Storage
- Making a Temporary Archival Backup
- Backing Up RMAN Backups
- About Backups of Backups
- Backing Up Backup Sets with RMAN
- Backing Up Image Copy Backups with RMAN
- 9 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 Datafile 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
- 10 Reporting on RMAN Operations
- Overview of RMAN Reporting
- Purpose of RMAN Reporting
- Basic Concepts of RMAN Reporting
- Listing Backups and Recovery-Related Objects
- About the LIST Command
- Listing Backups and Copies
- Listing Selected Backups and Copies
- Listing Database Incarnations
- Listing Restore Points
- Reporting on Backups and Database Schema
- About Reports of RMAN Backups
- Reporting on Files Needing a Backup Under a Retention Policy
- Reporting on Datafiles 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
- Querying Catalog Views for the Target DB_KEY or DBID Values
- Querying RC_BACKUP_FILES
- 11 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
- Maintaining the Control File Repository
- About Control File Records
- Preventing the Loss of Control File Records
- Protecting the Control File
- Maintaining the Flash Recovery Area
- Deletion Rules for the Flash Recovery Area
- Monitoring Flash Recovery Area Space Usage
- Managing Space For Flashback Logs in the Flash Recovery Area
- Responding to a Full Flash Recovery Area
- Dropping Restore Points
- Changing the Flash Recovery Area to a New Location
- Disabling the Flash Recovery Area
- Responding to an Instance Crash During File Creation
- Monitoring Flashback Database Performance Impact
- Flashback Writer (RVWR) Behavior With I/O Errors
- Updating the RMAN Repository
- Crosschecking the RMAN Repository
- Changing the Repository Status of Backups and Copies
- Adding Backup Records to the RMAN Repository
- Removing Records from the RMAN Repository
- Deleting RMAN Backups and Archived Redo Logs
- Overview of RMAN Deletion
- Deleting All Backups and Copies
- Deleting Specified Backups and Copies
- Deleting Expired RMAN Backups and Copies
- Deleting Obsolete RMAN Backups Based on Retention Policies
- Dropping a Database
- 12 Managing a Recovery Catalog
- Overview of the Recovery Catalog
- Purpose of the Recovery Catalog
- Basic Concepts for the Recovery Catalog
- Basic Steps of Managing a Recovery Catalog
- Creating a Recovery Catalog
- Configuring 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
- Registering a Database with the REGISTER DATABASE Command
- Cataloging Backups in the Recovery Catalog
- Creating and Managing Virtual Private Catalogs
- About Virtual Private Catalogs
- 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
- Protecting the Recovery Catalog
- Backing Up the Recovery Catalog
- 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
- 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
- 13 RMAN Data Repair Concepts
- Overview of RMAN Data Repair
- Problems Requiring Data Repair
- RMAN Data Repair Techniques
- RMAN Restore Operations
- Backup Selection
- Restore Failover
- Restore Optimization
- RMAN Media Recovery
- Selection of Incremental Backups and Archived Redo Logs
- Database Incarnations
- 14 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
- 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
- 15 Validating Database Files and Backups
- Overview of RMAN Validation
- Purpose of RMAN Validation
- Basic Concepts of RMAN Validation
- Checking for Block Corruption with the VALIDATE Command
- Parallelizing the Validation of a Datafile
- Validating Database Files with BACKUP VALIDATE
- Validating Backups Before Restoring Them
- 16 Performing Flashback and Database Point-in-Time Recovery
- Overview of 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
- Rewinding a Table with Flashback Table
- Prerequisites for Flashback Table
- Performing a Flashback Table Operation
- Rewinding a DROP TABLE Operation with Flashback Drop
- About Flashback Drop
- Prerequisites of Flashback Drop
- Performing a Flashback Drop Operation
- Rewinding a Database with Flashback Database
- Prerequisites of Flashback Database
- Performing a Flashback Database Operation
- Performing Database Point-in-Time Recovery
- Prerequisites of Database Point-in-Time Recovery
- Performing Database Point-in-Time Recovery
- Flashback and Database Point-in-Time Recovery Scenarios
- Rewinding an OPEN RESETLOGS Operation with Flashback Database
- Rewinding the Database to an SCN in an Abandoned Incarnation Branch
- Recovering the Database to an Ancestor Incarnation
- 17 Performing Complete Database Recovery
- Overview of Complete Database Recovery
- Purpose of Complete Database Recovery
- Scope of This Chapter
- Preparing for Complete Database Recovery
- Identifying the Database Files to Restore or Recover
- Determining the DBID of the Database
- Previewing Backups Used in Restore Operations
- Validating Backups Before Restoring Them
- Restoring Archived Redo Logs Needed for Recovery
- Performing Complete Database Recovery
- About Complete Database Recovery
- Performing Complete Recovery of the Whole Database
- Performing Complete Recovery of a Tablespace
- Performing Complete Recovery After Switching to a Copy
- 18 Performing Block Media Recovery
- Overview of Block Media Recovery
- Purpose of Block Media Recovery
- Basic Concepts of Block Media Recovery
- Prerequisites for Block Media Recovery
- Recovering Individual Blocks
- Recovering All Blocks in V$DATABASE_BLOCK_CORRUPTION
- 19 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
- 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
- Testing the Restore of a Database on a New Host
- 20 Performing RMAN Tablespace Point-in-Time Recovery (TSPITR)
- Overview of RMAN TSPITR
- Purpose of RMAN TSPTIR
- Basic Concepts of RMAN TSPITR
- Basic Steps of RMAN TSPITR
- Prerequisites and Consequences of TSPITR
- Consequences of TSPITR
- Special Considerations When Not Using a Recovery Catalog
- Planning and Preparing for TSPITR
- Choosing the Right Target Time for TSPITR
- Determining the Recovery Set
- Identifying and Preserving Objects That Will Be Lost After TSPITR
- Performing Fully Automated RMAN TSPITR
- Performing Customized RMAN TSPITR with an RMAN-Managed Auxiliary Instance 20-10
- Renaming Oracle Managed Files in TSPITR
- Renaming TSPITR Recovery Set Datafiles with SET NEWNAME
- Naming TSPITR Auxiliary Set Datafiles
- Using Image Copies for Faster RMAN TSPITR Performance
- Customizing Initialization Parameters for the Automatic Auxiliary Instance in TSPITR
- Performing RMAN TSPITR Using Your Own Auxiliary Instance
- Preparing Your Own Auxiliary Instance for RMAN TSPITR
- Preparing RMAN Commands for TSPITR with Your Own Auxiliary Instance
- Executing TSPITR with Your Own Auxiliary Instance
- Performing TSPITR with Your Own Auxiliary Instance: Scenario
- Troubleshooting RMAN TSPITR
- Troubleshooting Filename Conflicts
- Troubleshooting Identification of Tablespaces with Undo Segments
- Troubleshooting the Restart of a Manual Auxiliary Instance After TSPITR Failure
- Part VI Tuning and Troubleshooting
- 21 Tuning RMAN Performance
- Purpose of RMAN Performance Tuning
- Basic Concepts of RMAN Performance Tuning
- Read Phase
- Copy Phase
- Write Phase for SBT
- 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
- 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
- 22 Troubleshooting RMAN Operations
- Interpreting RMAN Message Output
- Identifying Types of Message Output
- Recognizing RMAN Error Message Stacks
- Identifying Error Codes
- Interpreting RMAN Error Stacks
- Identifying RMAN Return Codes
- Using V$ Views for RMAN Troubleshooting
- Monitoring RMAN Interaction with the Media Manager
- Correlating Server Sessions with RMAN Channels
- 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 Hung in the Media Manager
- Part VII Transferring Data with RMAN
- 23 Duplicating a Database
- Overview of RMAN Database Duplication
- Purpose of Database Duplication
- Basic Concepts of Database Duplication
- Basic Steps of Database Duplication
- Making Backups and Archived Logs Accessible to the Duplicate Instance
- Making SBT Backups Accessible to the Duplicate Instance
- Making Disk Backups Accessible to the Duplicate Instance
- Choosing a Strategy for Naming Duplicate Files
- Preparing the Auxiliary Instance
- Step 1: Create an Oracle Password File for the Auxiliary Instance
- Step 2: Establish Oracle Net Connectivity to the Auxiliary Instance
- Step 3: Create an Initialization Parameter File for the Auxiliary Instance
- Step 4: Start the Auxiliary Instance with SQL*Plus
- Starting and Configuring RMAN Before Duplication
- Step 1: Start RMAN and Connect to the Database Instances
- Step 2: Mount or Open the Source Database
- Step 3: Configure RMAN Channels for Use in the Duplication
- Duplicating a Database
- Duplicating a Database to a Remote Host with the Same Directory Structure
- Duplicating a Database to a Remote Host with a Different Directory Structure
- Creating a Duplicate Database on the Local Host
- Duplicating a Database with Oracle Managed Files or Automatic Storage Management
- Naming Duplicate Files with Alternative Techniques
- Naming Duplicate Control Files
- Naming Duplicate Online Redo Log Files
- Naming Duplicate Datafiles
- Naming Duplicate Tempfiles
- RMAN Duplication Scenarios
- Duplicating a Subset of the Source Database Tablespaces
- Using DUPLICATE to Restore an Archival Backup
- Using SET NEWNAME to Name Duplicate Files
- Using CONFIGURE AUXNAME to Name Duplicate Files
- 24 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
- Setting Initialization Parameters for the Auxiliary Instance
- Setting the Location of the Auxiliary Instance Parameter File
- Creating a Transportable Tablespace Set
- Troubleshooting 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
- 25 Transporting Data Across Platforms
- Overview of Cross-Platform Data Transportation
- Purpose of Cross-Platform Data Transportation
- Basic Concepts of Cross-Platform Data Transportation
- Performing Cross-Platform Tablespace Conversion on the Source Host
- Performing Cross-Platform Datafile Conversion on the Destination Host
- About Cross-Platform Datafile Conversion on the Destination Host
- Using CONVERT DATAFILE to Convert Datafile Formats
- Checking the Database Before Cross-Platform Database Conversion
- Converting Datafiles on the Source Host When Transporting a Database
- Converting Datafiles on the Destination Host When Transporting the Database
- Performing Preliminary Datafile Conversion Steps on the Source Host
- Converting Datafiles on the Destination Host
- 26 Performing ASM Data Migration
- Overview of ASM Data Migration
- Purpose of ASM Data Migration
- Basic Concepts of ASM Data Migration
- Basics Steps of Data Migration to ASM
- Preparing to Migrate the Database to ASM
- Migrating the Database to ASM
- Migrating a Database from ASM to Alternative Storage
- Moving Datafiles Between ASM Disk Groups
- 27 Making User-Managed Database Backups
- Querying V$ Views to Obtain Backup Information
- Listing Database Files Before a Backup
- Determining Datafile Status for Online Tablespace Backups
- Making User-Managed Backups of the Whole Database
- Making Consistent Whole Database Backups
- Making User-Managed Backups of Tablespaces and Datafiles
- Making User-Managed Backups of Offline Tablespaces and Datafiles
- Making User-Managed Backups of Online Tablespaces and Datafiles
- 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 to Raw Devices on Windows
- Making Backups with the Volume Shadow Copy Service (VSS)
- Verifying User-Managed Datafile Backups
- Testing the Restore of Datafile Backups
- Running the DBVERIFY Utility
- 28 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 Cancellation
- Parallel Media Recovery
- Performing Complete Database Recovery
- Performing Closed Database Recovery
- Performing Open Database Recovery
- 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 Corrupt Blocks: Phase 3
- Allowing Recovery to Corrupt Blocks: Phase 4
- Performing Trial Recovery
- 29 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 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 Datafile 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 Datafiles 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 the Loss of All Members of an Online Redo Log Group
- Recovering from a Dropped Table Without Using Flashback Features
- Dropping a Database with SQL*Plus
- Preface
- What's New in Backup and Recovery?
- Part I Overview of Backup and Recovery
- 1 Introduction to Backup and Recovery
- Purpose of Backup and Recovery
- Data Protection
- Data Preservation
- Data Transfer
- Oracle Backup and Recovery Solutions
- Oracle Flashback Technology
- Logical Flashback Features
- Flashback Database
- Data Recovery Advisor
- 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 Database
- Showing the Default RMAN Configuration
- Backing Up a Database
- Backing Up a Database in ARCHIVELOG Mode
- Backing Up a Database in NOARCHIVELOG Mode
- Typical Backup Options
- Making Incremental Backups
- Validating Database Files and Backups
- Scripting RMAN Operations
- Reporting on RMAN Operations
- Listing Backups
- Reporting on Database Files and Backups
- Maintaining RMAN Backups
- Crosschecking 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
- 3 Recovery Manager Architecture
- About the RMAN Environment
- RMAN Command-Line Client
- RMAN Channels
- Channels and Devices
- Automatic and Manual Channels
- RMAN Repository
- Media Management
- RMAN Interaction with a Media Manager
- Oracle Secure Backup
- Backup Solutions Program
- Flash Recovery Area
- RMAN in a Data Guard Environment
- RMAN Configuration in a Data Guard Environment
- RMAN File Management in a Data Guard Environment
- 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
- 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
- Making Database Connections with RMAN
- About RMAN Database Connections
- Making RMAN Database Connections from the Operating System Command Line
- Making Database Connections from the RMAN Prompt
- Connecting RMAN to an Auxiliary Database
- Making RMAN Database Connections Within Command Files
- Diagnosing RMAN Connection Problems
- 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
- 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
- Configuring Control File and Server Parameter File Autobackups
- 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
- Configuring SBT Channels for Use with a Media Manager
- Configuring the Flash Recovery Area
- Overview of the Flash Recovery Area
- Enabling the Flash Recovery Area
- Configuring Locations for Control Files and Redo Logs
- Configuring RMAN File Creation in the Flash Recovery Area
- Configuring the Backup Retention Policy
- Configuring a Redundancy-Based Retention Policy
- Configuring a Recovery Window-Based Retention Policy
- Disabling the Retention Policy
- Configuring Backup Optimization
- Overview of Backup Optimization
- Effect of Retention Policies on Backup Optimization for SBT Backups
- Configuring Backup Optimization
- Configuring an Archived Redo Log Deletion Policy
- About Archived Redo Log Deletion Policies
- Enabling an Archived Redo Log Deletion Policy
- Configuring Oracle Flashback Database and Restore Points
- About Restore Points and Flashback Database
- Prerequisites for Flashback Database and Guaranteed Restore Points
- Enabling Flashback Database
- Creating Normal and Guaranteed Restore Points
- Configuring the Environment for Optimal Flashback Database Performance
- 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 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 the Backup Compression Algorithm
- Configuring Backup Encryption
- Configuring Auxiliary Instance Datafile 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
- Part III Backing Up and Archiving Data
- 7 RMAN Backup Concepts
- Consistent and Inconsistent RMAN Backups
- Consistent Backups
- Inconsistent Backups
- Online Backups and Backup Mode
- Backup Sets
- Backup Sets and Backup Pieces
- Compression for Backup Sets
- Encryption for Backup Sets
- Filenames for Backup Pieces
- Number and Size of Backup Pieces
- Number and Size of Backup Sets
- Multiplexed Backup Sets
- Proxy Copies
- Image Copies
- RMAN-Created Image Copies
- User-Managed Image Copies
- Multiple Copies of RMAN Backups
- Duplexed Backup Sets
- Backups of Backups
- Control File and Server Parameter File Autobackups
- When RMAN Performs Control File Autobackups
- How RMAN Performs Control File Autobackups
- Incremental Backups
- Multilevel Incremental Backups
- Block Change Tracking
- Incremental Backup Algorithm
- Recovery with Incremental Backups
- Backup Retention Policies
- Recovery Window
- Backup Redundancy
- Batch Deletes of Obsolete Backups
- Backup Retention Policy and Flash Recovery Area Deletion Rules
- 8 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 Tags for an RMAN Backup
- Making Compressed Backups
- Backing Up Database Files with RMAN
- Making Whole Database Backups with RMAN
- Backing Up Tablespaces and Datafiles with RMAN
- Backing Up Control Files with RMAN
- Backing Up Server Parameter Files with RMAN
- Backing Up a Database in NOARCHIVELOG Mode
- Backing Up Archived Redo Logs with RMAN
- About Backups of Archived Redo Logs
- Backing Up Archived Redo Log Files
- Backing Up Only Archived Redo Logs That Need Backups
- Deleting Archived Redo Logs After Backups
- 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
- Purpose of Archival Backups
- Basic Concepts of Archival Backups
- Making an Archival Backup for Long-Term Storage
- Making a Temporary Archival Backup
- Backing Up RMAN Backups
- About Backups of Backups
- Backing Up Backup Sets with RMAN
- Backing Up Image Copy Backups with RMAN
- 9 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 Datafile 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
- 10 Reporting on RMAN Operations
- Overview of RMAN Reporting
- Purpose of RMAN Reporting
- Basic Concepts of RMAN Reporting
- Listing Backups and Recovery-Related Objects
- About the LIST Command
- Listing Backups and Copies
- Listing Selected Backups and Copies
- Listing Database Incarnations
- Listing Restore Points
- Reporting on Backups and Database Schema
- About Reports of RMAN Backups
- Reporting on Files Needing a Backup Under a Retention Policy
- Reporting on Datafiles 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
- Querying Catalog Views for the Target DB_KEY or DBID Values
- Querying RC_BACKUP_FILES
- 11 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
- Maintaining the Control File Repository
- About Control File Records
- Preventing the Loss of Control File Records
- Protecting the Control File
- Maintaining the Flash Recovery Area
- Deletion Rules for the Flash Recovery Area
- Monitoring Flash Recovery Area Space Usage
- Managing Space For Flashback Logs in the Flash Recovery Area
- Responding to a Full Flash Recovery Area
- Dropping Restore Points
- Changing the Flash Recovery Area to a New Location
- Disabling the Flash Recovery Area
- Responding to an Instance Crash During File Creation
- Monitoring Flashback Database Performance Impact
- Flashback Writer (RVWR) Behavior With I/O Errors
- Updating the RMAN Repository
- Crosschecking the RMAN Repository
- Changing the Repository Status of Backups and Copies
- Adding Backup Records to the RMAN Repository
- Removing Records from the RMAN Repository
- Deleting RMAN Backups and Archived Redo Logs
- Overview of RMAN Deletion
- Deleting All Backups and Copies
- Deleting Specified Backups and Copies
- Deleting Expired RMAN Backups and Copies
- Deleting Obsolete RMAN Backups Based on Retention Policies
- Dropping a Database
- 12 Managing a Recovery Catalog
- Overview of the Recovery Catalog
- Purpose of the Recovery Catalog
- Basic Concepts for the Recovery Catalog
- Basic Steps of Managing a Recovery Catalog
- Creating a Recovery Catalog
- Configuring 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
- Registering a Database with the REGISTER DATABASE Command
- Cataloging Backups in the Recovery Catalog
- Creating and Managing Virtual Private Catalogs
- About Virtual Private Catalogs
- 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
- Protecting the Recovery Catalog
- Backing Up the Recovery Catalog
- 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
- 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
- 13 RMAN Data Repair Concepts
- Overview of RMAN Data Repair
- Problems Requiring Data Repair
- RMAN Data Repair Techniques
- RMAN Restore Operations
- Backup Selection
- Restore Failover
- Restore Optimization
- RMAN Media Recovery
- Selection of Incremental Backups and Archived Redo Logs
- Database Incarnations
- 14 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
- 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
- 15 Validating Database Files and Backups
- Overview of RMAN Validation
- Purpose of RMAN Validation
- Basic Concepts of RMAN Validation
- Checking for Block Corruption with the VALIDATE Command
- Parallelizing the Validation of a Datafile
- Validating Database Files with BACKUP VALIDATE
- Validating Backups Before Restoring Them
- 16 Performing Flashback and Database Point-in-Time Recovery
- Overview of 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
- Rewinding a Table with Flashback Table
- Prerequisites for Flashback Table
- Performing a Flashback Table Operation
- Rewinding a DROP TABLE Operation with Flashback Drop
- About Flashback Drop
- Prerequisites of Flashback Drop
- Performing a Flashback Drop Operation
- Rewinding a Database with Flashback Database
- Prerequisites of Flashback Database
- Performing a Flashback Database Operation
- Performing Database Point-in-Time Recovery
- Prerequisites of Database Point-in-Time Recovery
- Performing Database Point-in-Time Recovery
- Flashback and Database Point-in-Time Recovery Scenarios
- Rewinding an OPEN RESETLOGS Operation with Flashback Database
- Rewinding the Database to an SCN in an Abandoned Incarnation Branch
- Recovering the Database to an Ancestor Incarnation
- 17 Performing Complete Database Recovery
- Overview of Complete Database Recovery
- Purpose of Complete Database Recovery
- Scope of This Chapter
- Preparing for Complete Database Recovery
- Identifying the Database Files to Restore or Recover
- Determining the DBID of the Database
- Previewing Backups Used in Restore Operations
- Validating Backups Before Restoring Them
- Restoring Archived Redo Logs Needed for Recovery
- Performing Complete Database Recovery
- About Complete Database Recovery
- Performing Complete Recovery of the Whole Database
- Performing Complete Recovery of a Tablespace
- Performing Complete Recovery After Switching to a Copy
- 18 Performing Block Media Recovery
- Overview of Block Media Recovery
- Purpose of Block Media Recovery
- Basic Concepts of Block Media Recovery
- Prerequisites for Block Media Recovery
- Recovering Individual Blocks
- Recovering All Blocks in V$DATABASE_BLOCK_CORRUPTION
- 19 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
- 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
- Testing the Restore of a Database on a New Host
- 20 Performing RMAN Tablespace Point-in-Time Recovery (TSPITR)
- Overview of RMAN TSPITR
- Purpose of RMAN TSPTIR
- Basic Concepts of RMAN TSPITR
- Basic Steps of RMAN TSPITR
- Prerequisites and Consequences of TSPITR
- Consequences of TSPITR
- Special Considerations When Not Using a Recovery Catalog
- Planning and Preparing for TSPITR
- Choosing the Right Target Time for TSPITR
- Determining the Recovery Set
- Identifying and Preserving Objects That Will Be Lost After TSPITR
- Performing Fully Automated RMAN TSPITR
- Performing Customized RMAN TSPITR with an RMAN-Managed Auxiliary Instance 20-10
- Renaming Oracle Managed Files in TSPITR
- Renaming TSPITR Recovery Set Datafiles with SET NEWNAME
- Naming TSPITR Auxiliary Set Datafiles
- Using Image Copies for Faster RMAN TSPITR Performance
- Customizing Initialization Parameters for the Automatic Auxiliary Instance in TSPITR
- Performing RMAN TSPITR Using Your Own Auxiliary Instance
- Preparing Your Own Auxiliary Instance for RMAN TSPITR
- Preparing RMAN Commands for TSPITR with Your Own Auxiliary Instance
- Executing TSPITR with Your Own Auxiliary Instance
- Performing TSPITR with Your Own Auxiliary Instance: Scenario
- Troubleshooting RMAN TSPITR
- Troubleshooting Filename Conflicts
- Troubleshooting Identification of Tablespaces with Undo Segments
- Troubleshooting the Restart of a Manual Auxiliary Instance After TSPITR Failure
- Part VI Tuning and Troubleshooting
- 21 Tuning RMAN Performance
- Purpose of RMAN Performance Tuning
- Basic Concepts of RMAN Performance Tuning
- Read Phase
- Copy Phase
- Write Phase for SBT
- 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
- 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
- 22 Troubleshooting RMAN Operations
- Interpreting RMAN Message Output
- Identifying Types of Message Output
- Recognizing RMAN Error Message Stacks
- Identifying Error Codes
- Interpreting RMAN Error Stacks
- Identifying RMAN Return Codes
- Using V$ Views for RMAN Troubleshooting
- Monitoring RMAN Interaction with the Media Manager
- Correlating Server Sessions with RMAN Channels
- 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 Hung in the Media Manager
- Part VII Transferring Data with RMAN
- 23 Duplicating a Database
- Overview of RMAN Database Duplication
- Purpose of Database Duplication
- Basic Concepts of Database Duplication
- Basic Steps of Database Duplication
- Making Backups and Archived Logs Accessible to the Duplicate Instance
- Making SBT Backups Accessible to the Duplicate Instance
- Making Disk Backups Accessible to the Duplicate Instance
- Choosing a Strategy for Naming Duplicate Files
- Preparing the Auxiliary Instance
- Step 1: Create an Oracle Password File for the Auxiliary Instance
- Step 2: Establish Oracle Net Connectivity to the Auxiliary Instance
- Step 3: Create an Initialization Parameter File for the Auxiliary Instance
- Step 4: Start the Auxiliary Instance with SQL*Plus
- Starting and Configuring RMAN Before Duplication
- Step 1: Start RMAN and Connect to the Database Instances
- Step 2: Mount or Open the Source Database
- Step 3: Configure RMAN Channels for Use in the Duplication
- Duplicating a Database
- Duplicating a Database to a Remote Host with the Same Directory Structure
- Duplicating a Database to a Remote Host with a Different Directory Structure
- Creating a Duplicate Database on the Local Host
- Duplicating a Database with Oracle Managed Files or Automatic Storage Management
- Naming Duplicate Files with Alternative Techniques
- Naming Duplicate Control Files
- Naming Duplicate Online Redo Log Files
- Naming Duplicate Datafiles
- Naming Duplicate Tempfiles
- RMAN Duplication Scenarios
- Duplicating a Subset of the Source Database Tablespaces
- Using DUPLICATE to Restore an Archival Backup
- Using SET NEWNAME to Name Duplicate Files
- Using CONFIGURE AUXNAME to Name Duplicate Files
- 24 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
- Setting Initialization Parameters for the Auxiliary Instance
- Setting the Location of the Auxiliary Instance Parameter File
- Creating a Transportable Tablespace Set
- Troubleshooting 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
- 25 Transporting Data Across Platforms
- Overview of Cross-Platform Data Transportation
- Purpose of Cross-Platform Data Transportation
- Basic Concepts of Cross-Platform Data Transportation
- Performing Cross-Platform Tablespace Conversion on the Source Host
- Performing Cross-Platform Datafile Conversion on the Destination Host
- About Cross-Platform Datafile Conversion on the Destination Host
- Using CONVERT DATAFILE to Convert Datafile Formats
- Checking the Database Before Cross-Platform Database Conversion
- Converting Datafiles on the Source Host When Transporting a Database
- Converting Datafiles on the Destination Host When Transporting the Database
- Performing Preliminary Datafile Conversion Steps on the Source Host
- Converting Datafiles on the Destination Host
- 26 Performing ASM Data Migration
- Overview of ASM Data Migration
- Purpose of ASM Data Migration
- Basic Concepts of ASM Data Migration
- Basics Steps of Data Migration to ASM
- Preparing to Migrate the Database to ASM
- Migrating the Database to ASM
- Migrating a Database from ASM to Alternative Storage
- Moving Datafiles Between ASM Disk Groups
- 27 Making User-Managed Database Backups
- Querying V$ Views to Obtain Backup Information
- Listing Database Files Before a Backup
- Determining Datafile Status for Online Tablespace Backups
- Making User-Managed Backups of the Whole Database
- Making Consistent Whole Database Backups
- Making User-Managed Backups of Tablespaces and Datafiles
- Making User-Managed Backups of Offline Tablespaces and Datafiles
- Making User-Managed Backups of Online Tablespaces and Datafiles
- 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 to Raw Devices on Windows
- Making Backups with the Volume Shadow Copy Service (VSS)
- Verifying User-Managed Datafile Backups
- Testing the Restore of Datafile Backups
- Running the DBVERIFY Utility
- 28 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 Cancellation
- Parallel Media Recovery
- Performing Complete Database Recovery
- Performing Closed Database Recovery
- Performing Open Database Recovery
- 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 Corrupt Blocks: Phase 3
- Allowing Recovery to Corrupt Blocks: Phase 4
- Performing Trial Recovery
- 29 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 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 Datafile 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 Datafiles 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 the Loss of All Members of an Online Redo Log Group
- Recovering from a Dropped Table Without Using Flashback Features
- Dropping a Database with SQL*Plus
