Oracle8i Recovery Manager User's Guide and Reference -- Contents

What's New in Oracle8i?

Release 8.1.6

Release 8.1.5

Structure

Changes to This Book

Audience

Knowledge Assumed of the Reader

Conventions

Text

Recovery Manager Syntax Diagrams and Notation

Code Examples

How to Use This Guide

Your Comments Are Welcome

Overview of Recovery Manager

Recovery Manager Features

What Recovery Manager Is Not

Recovery Manager Commands

Recovery Manager PL/SQL Packages

How Recovery Manager Compiles and Executes Commands

Types of Recovery Manager Commands

User Execution of Recovery Manager Commands

User Termination of Recovery Manager Commands

Recovery Manager Command Errors

Recovery Manager Repository

Storage of the RMAN Repository in the Recovery Catalog

Storage of the RMAN Repository Exclusively in the Control File

Media Management

Backup and Restore Operations Using a Media Manager

Media Manager Crosschecks

Proxy Copy

Media Manager Testing

Backup Solutions Program

Lists and Reports

Lists of Backups and Copies

Reports on Backups, Copies, and Database Schema

Channel Allocation

Channel Control Options

Channel Parallelization

Backup Sets

Storage of Backup Sets

Backup Set Compression

Filenames for Backup Pieces

Number and Size of Backup Sets

Size of Backup Pieces

Multiplexed Backup Sets

Duplexed Backup Sets

Parallelization of Backups

Backup Types

Image Copies

Tags for Backups and Image Copies

Restoring Files

Mechanics of Restore Operations

File Selection in Restore Operations

Restore Constraints

Media Recovery

Application of Incremental Backups and Redo Records

Incomplete Recovery

Tablespace Point-in-Time Recovery

Database Duplication

Integrity Checks

Detection of Physical Block Corruption

Detection of Logical Block Corruption

Detection of Fractured Blocks During Open Backups

Setting Up Recovery Manager

Using Password Files

Setting NLS Environment Variables

Determining the Snapshot Control File Location

Using RMAN with a Multi-Threaded Server

Deciding Whether to Use a Recovery Catalog

Consequences of Using the Recovery Catalog as the RMAN Repository

Consequences of Using the Control File as the RMAN Repository

Connecting to RMAN

Connecting to RMAN Without a Recovery Catalog

Connecting to RMAN with a Recovery Catalog

Connecting to an Auxiliary Database

Hiding Passwords When Connecting to RMAN

Disconnecting from RMAN

Using Basic RMAN Commands

Connecting to RMAN

Mounting the Database

Reporting the Current Schema

Copying a Datafile

Backing Up a Tablespace

Listing Backups and Copies

Validating a Restore

Configuring a Media Manager

Linking with a Media Manager

Generating Unique Filenames

Limiting File Size

Sending Device-Specific Strings to the Media Manager

Troubleshooting the Media Manager

Using Sample Scripts and Scenarios

Creating the Recovery Catalog

Setting Recovery Catalog Compatibility

Maintaining the RMAN Repository

Registering a Database with the Recovery Catalog

Unregistering a Database from the Recovery Catalog

Resetting the Recovery Catalog

Changing the Availability of a Backup or File Copy

Crosschecking the RMAN Repository

Deleting Backups and Copies and Updating Their Status in the RMAN Repository

Validating the Restore of Backups and Copies

Storing Scripts in the Recovery Catalog

Resynchronizing the Recovery Catalog

Managing Records in the Control File

Cataloging Operating System Backups

Backing Up and Recovering the Recovery Catalog

Backing Up the Recovery Catalog

Recovering the Recovery Catalog

Re-Creating the Recovery Catalog

Upgrading the Recovery Catalog

Dropping the Recovery Catalog

Managing the RMAN Repository Without a Recovery Catalog

Understanding Catalog-Only Command Restrictions

Monitoring the Overwriting of Control File Records

Maintaining the Control File Repository

Backing Up the Control File

Using Lists and Reports in Your Backup and Recovery Strategy

Generating Lists

Generating Reports

List and Report Scenarios

Makings Lists of Backups and Copies

Using Lists to Determine Obsolete Backups and Copies

Reporting Datafiles Needing Backups

Reporting Unrecoverable Datafiles

Reporting Obsolete Backups and Copies

Manually Deleting Obsolete Backups and Copies

Deleting Obsolete Backups and Copies Using a UNIX Shell Script

Generating Historical Reports of Database Schema

Listing Database Incarnations

Reporting Deleted Backups and Copies

Making Backups

Making Consistent and Inconsistent Backups

Making Whole Database Backups

Backing Up Tablespaces and Datafiles

Backing Up Control Files

Backing Up Archived Redo Logs

Making Incremental Backups

Making Split Mirror Backups

Making Image Copies

Backup and Copy Scenarios

Reporting Datafiles Needing Backups

Skipping Files when Backing Up a Database

Spreading a Backup Across Multiple Disk Drives

Backing Up a Large Database to Multiple Filesystems

Specifying the Size of Backup Sets

Specifying the Size of Backup Pieces

Multiplexing Datafiles in a Backup

Backing Up Archived Redo Logs

Backing Up and Deleting Multiple Copies of an Archived Redo Log

Performing Differential Incremental Backups

Performing Cumulative Incremental Backups

Duplexing Backup Sets

Determining How Channels Distribute a Backup Workload

Backing Up in NOARCHIVELOG Mode

Backing Up in a Parallel Server Environment

Cataloging Operating System Copies

Maintaining Backups and Copies

Handling Errors During Backups and Copies

Restoring Datafiles, Control Files, and Archived Redo Logs

Restoring a Database

Restoring Tablespaces and Datafiles

Restoring Control Files

Restoring Archived Redo Logs

Restoring in Preparation for Incomplete Recovery

Restoring in an OPS Configuration

Recovering Datafiles

Preparing for Media Recovery

Performing Complete Recovery

Performing Incomplete Recovery

Restore and Recovery Scenarios

Restoring Datafile Copies to a New Host

Restoring When Multiple Databases Share the Same Name

Restoring the Control File from a Backup Set Without Using RMAN

Recovering an Inaccessible Datafile in an Open Database

Recovering an Inaccessible Datafile Using Backups from Disk and Tape

Performing Recovery After a Total Media Failure

Recovering a Pre-RESETLOGS Backup

Recovering a Database in NOARCHIVELOG Mode

Recovering a Lost Datafile Without a Backup

Creating a Duplicate Database: Overview

Obeying Restrictions

Generating Files for the Duplicate Database

Preparing the Auxiliary Instance for Duplication

Creating a Duplicate Database on a Local or Remote Host

Duplicating a Database on a Remote Host with the Same Directory Structure

Duplicating a Database on a Remote Host with a Different Directory Structure

Creating a Duplicate Database on the Local Host

Duplication Scenarios

Setting New Filenames Manually

Resynchronizing the Duplicate Database with the Target Database

Creating a Non-Current Duplicate Database

Introduction to RMAN TSPITR

Planning for TSPITR

Performing TSPITR Without a Recovery Catalog

Understanding General Restrictions

Researching and Resolving Inconsistencies

Managing Data Relationships

Preparing the Auxiliary Instance for TSPITR

Performing TSPITR

Preparing the Target Database for Use After TSPITR

Responding to Unsuccessful TSPITR

Tuning TSPITR Performance

Specify a New Name for Datafiles in Auxiliary Set Tablespaces

Set the Auxiliary Name and Use a Datafile Copy for Recovery Manager TSPITR

Use the Converted Filename in the Auxiliary Control File

Summary: Datafile Naming Methods

Interpreting Message Output

Identifying Types of Message Output

Identifying Error Codes

Interpreting RMAN Error Stacks

Interpreting Debugging Output

Testing the Media Management API

Obtaining the Utility

Obtaining Online Documentation

Using the Utility

Monitoring RMAN Jobs

Correlating Server Sessions with Channels

Monitoring Job Progress

Monitoring Job Performance

Terminating an RMAN Session

Components of an RMAN Session

Process Behavior During a Hung Job

Terminating an RMAN Session

Troubleshooting Scenarios

After Linking to the Media Manager on UNIX, RMAN Fails to Back Up to Tape

After Installing the Media Manager on NT, RMAN Fails to Back Up to Tape

Backup Job Is Hanging

RMAN Fails to Start RPC Call

Backup Fails with Invalid RECID Error

Backup Fails Because of Control File Enqueue

RMAN Fails to Delete All Archived Logs

Backup Fails Because RMAN Cannot Locate an Archived Log

RMAN Issues Character Set Errors When You Attempt to Connect to the Target

RMAN Denies Logon to Target Database

Database Duplication Fails with RMAN-20240

UNKNOWN Database Name Appears in Recovery Catalog

Conventions Used in this Reference

Command Entries

Summary of RMAN Commands

allocate

allocateForMaint

alterDatabase

archivelogRecordSpecifier

backup

catalog

change

cmdLine

completedTimeSpec

configure

connect

connectStringSpec

copy

createCatalog

createScript

crosscheck

datafileSpec

debug

deleteExpired

deleteScript

deviceSpecifier

dropCatalog

duplicate

host

list

listObjList

printScript

recover

register

release

releaseForMaint

replaceScript

replicate

report

reset

restore

resync

rmanCommand

run

send

set

set_run_option

shutdown

sql

startup

switch

untilClause

upgradeCatalog

validate

RC_ARCHIVED_LOG

RC_BACKUP_CONTROLFILE

RC_BACKUP_CORRUPTION

RC_BACKUP_DATAFILE

RC_BACKUP_PIECE

RC_BACKUP_REDOLOG

RC_BACKUP_SET

RC_CHECKPOINT

RC_CONTROLFILE_COPY

RC_COPY_CORRUPTION

RC_DATABASE

RC_DATABASE_INCARNATION

RC_DATAFILE

RC_DATAFILE_COPY

RC_LOG_HISTORY

RC_OFFLINE_RANGE

RC_PROXY_CONTROLFILE

RC_PROXY_DATAFILE

RC_REDO_LOG

RC_REDO_THREAD

RC_RESYNC

RC_STORED_SCRIPT

RC_STORED_SCRIPT_LINE

RC_TABLESPACE

Contents

Title and Copyright Information

Send Us Your Comments

Preface

Part I Using Recovery Manager

1 Recovery Manager Concepts

2 Getting Started with Recovery Manager

3 Managing the Recovery Manager Repository

4 Generating Lists and Reports with Recovery Manager

5 Making Backups and Copies with Recovery Manager

6 Restoring and Recovering with Recovery Manager

7 Creating a Duplicate Database with Recovery Manager

8 Performing Point-in-Time Recovery with Recovery Manager

9 Recovery Manager Troubleshooting

Part II Recovery Manager Reference

10 Recovery Manager Command Syntax

11 Recovery Catalog Views

Glossary

Index