Contents

Title and Copyright Information

Send Us Your Comments

Preface

What's New in User-Managed Backup and Recovery?

1 Introduction to User-Managed Backup and Recovery

About User-Managed Backup and Recovery

Why Use User-Managed Backup and Recovery Methods?

Overview of User-Managed Backup and Recovery

About User-Managed Backups

About User-Managed Restore and Recovery

2 Making User-Managed 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 Offline Tablespaces and Datafiles

Making User-Managed Backups of Online Tablespaces and Datafiles

Making User-Managed Backups of Online Read/Write Tablespaces

Making Multiple User-Managed Backups of Online Read/Write Tablespaces

Ending a Backup After an Instance Failure or SHUTDOWN ABORT

Making User-Managed Backups of Read-Only Tablespaces

Making User-Managed Backups of Undo Tablespaces

Making User-Managed Backups in SUSPEND Mode

About the Suspend/Resume Feature

Making Backups in a Suspended Database

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 to Raw Devices

Backing Up to Raw Devices on UNIX

Backing Up to Raw Devices on Windows NT

Verifying User-Managed Backups

Testing the Restore of Backups

Using the DBVERIFY Utility

Making Logical Backups with Export

Using Export

Using Import

Making User-Managed Backups of Miscellaneous Oracle Files

3 Performing User-Managed Restore Operations

About User-Managed Restore Operations

Keeping Records For Use in a Restore Scenario

Recording the Locations of Datafiles, Control Files, and Online Redo Logs

Recording the Locations of Archived Redo Logs

Recording the Locations of Backup Files

Determining Which Datafiles Require Recovery

Restoring Datafiles

Re-Creating Datafiles When Backups Are Unavailable

Restoring and Re-Creating Control Files

Losing a Member of a Multiplexed Control File

Losing All Members of a Multiplexed Control File When a Backup Is Available

Losing All Current and Backup Control Files

Restoring Archived Redo Logs

4 Performing User-Managed Media Recovery

Performing User-Managed Media Recovery: Overview

Preconditions of Performing User-Managed Recovery

Applying Logs Automatically with the RECOVER Command

Recovering When Archived Logs Are in the Default Location

Recovering When Archived Logs Are in a Nondefault Location

Resetting the Archived Log Destination

Overriding the Archived Log Destination

Responding to Unsuccessful Application of Redo Logs

Performing Complete User-Managed Media Recovery

Performing Closed Database Recovery

Performing Datafile Recovery in an Open Database

Performing Incomplete User-Managed Media Recovery

Preparing for Incomplete Recovery

Restoring Datafiles Before Performing Incomplete Recovery

Performing Cancel-Based Incomplete Recovery

Performing Time-Based Incomplete Recovery

Performing Change-Based Incomplete Recovery

Recovering a Database in NOARCHIVELOG Mode

Restoring the Database to its Default Location

Restoring the Database to a New Location

Performing Media Recovery in Parallel

Opening the Database After User-Managed Media Recovery

About RESETLOGS Operations

Determining Whether to Reset the Online Redo Logs

Following Up After a RESETLOGS Operation

Recovering a Backup Created Before a RESETLOGS

Interrupting User-Managed Media Recovery

User-Managed Media Recovery Restrictions

User-Managed Recovery of Unrecoverable Tables and Indexes

User-Managed Recovery of Read-Only Tablespaces with a Noncurrent Control File

5 Troubleshooting User-Managed 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

About Trial Recovery

How Trial Recovery Works

Executing the RECOVER ... TEST Statement

6 User-Managed Media Recovery Scenarios

Recovering After the Loss of Datafiles: Scenarios

Losing Datafiles in NOARCHIVELOG Mode

Losing Datafiles in ARCHIVELOG Mode

Recovering Through an Added Datafile: Scenario

Recovering Transportable Tablespaces: Scenario

Recovering After the Loss of Online Redo Log Files: Scenarios

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 After the Loss of Archived Redo Log Files: Scenario

Recovering from User Errors: Scenario

Performing Media Recovery in a Distributed Environment: Scenario

Coordinating Time-Based and Change-Based Distributed Database Recovery

7 Performing User-Managed TSPITR

Introduction to User-Managed Tablespace Point-in-Time Recovery

TSPITR Terminology

TSPITR Methods

Preparing for Tablespace Point-in-Time Recovery: Basic Steps

Step 1: Review TSPITR Requirements

Step 2: Identify All of the Files in the Recovery and Auxiliary Set Tablespaces

Step 3: Determine Whether Objects Will Be Lost

Step 4: Choose a Method for Connecting to the Auxiliary Instance

Step 5: Create an Oracle Password File for the Auxiliary Instance

Step 6: Create the Initialization Parameter File for the Auxiliary Instance

Restoring and Recovering the Auxiliary Database: Basic Steps

Restoring and Recovering the Auxiliary Database on the Same Host

Restoring the Auxiliary Database on a Different Host with the Same Path Names

Restoring the Auxiliary Database on a Different Host with Different Path Names

Performing TSPITR with Transportable Tablespaces

Step 1: Unplugging the Tablespaces from the Auxiliary Database

Step 2: Transporting the Tablespaces into the Primary Database

Performing Partial TSPITR of Partitioned Tables

Step 1: Create a Table on the Primary Database for Each Partition Being Recovered

Step 2: Drop the Indexes on the Partition Being Recovered

Step 3: Exchange Partitions with Standalone Tables

Step 4: Drop the Recovery Set Tablespace

Step 5: Create Tables at Auxiliary Database

Step 6: Drop Indexes on Partitions Being Recovered

Step 7: Exchange Partitions with Standalone Tables on the Auxiliary Database

Step 8: Transport the Recovery Set Tablespaces

Step 9: Exchange Partitions with Standalone Tables on the Primary Database

Step 10: Back Up the Recovered Tablespaces in the Primary Database

Performing TSPITR of Partitioned Tables When a Partition Has Been Dropped

Step 1: Find the Low and High Range of the Partition that Was Dropped

Step 2: Create a Temporary Table

Step 3: Delete Records From the Partitioned Table

Step 4: Drop the Recovery Set Tablespace

Step 5: Create Tables at the Auxiliary Database

Step 6: Drop Indexes on Partitions Being Recovered

Step 7: Exchange Partitions with Standalone Tables

Step 8: Transport the Recovery Set Tablespaces

Step 9: Insert Standalone Tables into Partitioned Tables

Step 10: Back Up the Recovered Tablespaces in the Primary Database

Performing TSPITR of Partitioned Tables When a Partition Has Split

Step 1: Drop the Lower of the Two Partitions at the Primary Database

Steps 2: Follow Same Procedure as for Partial TSPITR of Partitioned Tablespaces

Index