Oracle Consulting Oracle Training Oracle Support Development
Oracle Books
SQL Server Books
IT Books
Job Interview Books
Rampant Horse Books
911 Series
Pedagogue Books

Oracle Software
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
Oracle News
Oracle Forum
Oracle Tips
Articles by our Authors
Press Releases
SQL Server Books

Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle


Privacy Policy


ISBN 13:

Library of Congress Number: 2011925691

665 Pages
Perfect Bound 9x7

Publication Date: 0711

Shelving: Databases/Oracle

Oracle In-Focus Series:
# 42

  Oracle Backup & Recovery:
Expert secrets for using RMAN and Data Pump

Kamran Agayev Agamehdi & Aman Sharma

Retail Price $59.95 /  £38.95

Order now for 40% off ! Only $35.95
(40% off)
Key Features   About the Author Reader Comments
Table of Contents   Index Errata 

Backup and recovery are mission-critical DBA tasks, and it is critical that every Oracle professional develop a RMAN strategy that guarantees recoverability while minimizing unplanned downtime.

RMAN is one of the world's most sophisticated backup and recovery tools.  It is robust and complex with thousands of options.  This landmark book demonstrates, by example, how to create a successful backup and recovery infrastructure using RMAN.

This book also contains links to RMAN video tutorials and a download of working RMAN scripts to guide users through full automation of a backup strategy.   

Together, backup and recovery are the single most important combined DBA activity, and it is crucial that you master the RMAN and Data Pump Import utilities to protect against catastrophic data loss.

Written by practicing Oracle DBAs with years of RMAN experience, this is a pragmatic approach to RMAN, focusing less on theory and more on real-world, practical RMAN tools, tips and techniques.

This Oracle backup and recovery book is unique because it provides real-world examples on how to use RMAN and other tools to protect your mission critical data.

Even with reliable mirrored disks, your important Oracle database is still at-risk from from software corruption, user error and hardware failures.  This book details Oracle RMAN best practices and shows the best ways to minimize backup and recovery time, which is critical for maximizing system availability

This is the definitive RMAN reference that guides you, step-by-step, through all of the techniques for Oracle backup and recovery, from simple cold backups to complex incremental backups. Experienced RMAN experts guide you through the installation, setup and configuration for a complete RMAN backup and recovery infrastructure using proven techniques and Oracle best practices.

Best of all, you be given the opportunity to learn from supplemental video tutorials and working examples how to recover from every possible data scenario.  This book has step-by-step checklists that you can follow to guide you through a complex recovery with minimal unplanned system outages.

This is an indispensible RMAN reference for every professional DBA who needs to ensure that they understand every possible backup and recovery strategy.  It also contains a download of working RMAN scripts to help you easily automate and monitor your RMAN backups.

Key Features
* Understand Oracle best practices for using RMAN.

* Get expert secrets for minimizing downtime during an RMAN recovery.

* See working examples of complex RMAN recovery scenarios.

* Learn how to test your RMAN recovery methods.

* See how to implement incremental backups.

* Understand how to create the RMAN catalog.

* See how to to logical backups with Data Pump export.

* Learn how to automate your backup jobs.

* See how to migrate between platforms using RMAN.

* Includes video tutorials!


About the Authors:


Kamran Agayev Agamehdi


      Kamran Aghayev A. is an Oracle Certified Master, Oracle RAC Certifeid Expert, OCP (9i,10g,11g), Oracle ACE Director and President of Azerbaijan Oracle User Group (AzerOUG) working at AzerCell Telecom LLC.  He has hands-on experience with real-world Production environments, and he has risen in the ranks from a developer to a managing DBA.  

      He runs a popular blog where he shares his experience and contributes fairly regularly to newsgroups, forums, and user group meetings and events around the world.  

      Kamran is a frequent presenter at Oracle related conferences such as Oracle OpenWorld, OUGTH, TROUG and others.   He also delivers a class about Oracle Database Administration at Qafqaz University.


Aman Sharma


      Aman Sharma is an Oracle database specialist, an Oracle Certified Professional(9i,10g,11g), an Oracle Certified Expert for Linux and SQL and an Oracle ACE.  He is a  Sun Certified System Admin with over 6 years of experience.

      Mr. Sharma works as an instructor training professionals around Asia Pacific in Oracle related technologies. Prior to his work as an instructor, he worked as a DBA for a large software development company. 

      In his spare time, when he is not teaching or not traveling, he likes to spend his free time in various Oracle forums over the web.  Mr. Sharma also writes about Oracle database over his blog at



Table of Contents:

Chapter 1:  Backup and Recovery Overview

Introduction to Backup and Recovery

DBA Duties

Errors and Failures Requiring Recovery

Oracle Backup and Recovery Techniques and Solutions


Control Files

Redo Log Files

RMAN Backup Concepts

Backup Set

Backup Piece

Channel Allocation




Chapter 2:  Configuring RMAN and Connecting to the Database

Using the Recovery Catalog

Setting Persistent RMAN Configurations

Retention Policy

Backup Optimization

Determining the Device Type

Setting up Automatic Backups of the Control File

Configuring Parallelism

Configuring the Backup Set Size

Setting Up Encryption and Encryption Algorithm for the Backup

Configuring Archivelog Deletion Policy

Configuring the Snapshot Control File

Configuring and Using the Flashback Recovery Area

Connecting to RMAN

Connecting to RMAN Without Using Recovery Catalog

Connecting to RMAN using a Recovery Catalog

Switching to Archivelog Mode

Setting Up the Archivelog Mode

Taking the First Backup and Performing the First Recovery

Checking RMAN Syntax Using CheckSyntax



Chapter 3:  Backing Up the Database Using RMAN


Backing up the Whole Database

Backing up a Database Running in Noarchivelog Mode

Backing Up the Control File

Multiplexing Control Files

Backing up the Server Parameter File

Backing Up Datafiles

Taking Multisection Backups

Backing Up Archived Redolog Files

Delete Input

Back Up Tablespaces

Creating Archival Backups

Creating Compressed Backups

Creating Encrypted Backups

Validating Backups

Backing Up Backup Sets

Making Incremental Backups

Block Change Tracking Overview

Enabling Block Change Tracking

Renaming and Disabling Block Change Tracking

Missing Tracking File

RMAN Reporting on Backups

Using the list Command

Skipping a Tablespace from the Output of the list Command

Listing Information about Backup of Archived Redo Log Files

Listing Image Copies of Database Files

Reporting information about RMAN Backups



Chapter 4:  Restoring and Recovering the Database Using RMAN


Doing a Recovery Operation?

Instance Crash Recovery

User Created Mistake Recovery

User Process Failure Recovery

Media Crash/Failure Recovery

Disaster Recovery

What is Recovery All About?

What Does Recovery Mean?

When is a Recovery Needed?

How is a Recovery Accomplished?

Media Recovery

Restoring and Recovering Control Files

Recovering from the Loss of a Control File When a Mirrored Copy is Available

Restoring Control File with Redo Logs Intact

Recovery When Control Files and Data Files are Lost but the Redo Logs are Intact

Recovery when Control Files, Datafiles, and Redo Logs are Lost

Recovery from the Loss of Control Files when No Backup Files are Available but Redo Logs are Intact

Restoring the Spfile

A Dirty Workaround

Restoring and Recovering Datafiles

Restoration and Recovery of a System Datafile

Recovering a Datafile That is Not Backed Up

Restoring Tablespaces

Restoration of the Archivelogs

Using set newname to Change the Restored File Location

Performing Block Media Recovery

Performing Block Recovery Without RMAN Backups

Performing Disaster Recovery

Performing an Incomplete Recovery

Scn-based Incomplete Recovery

Time-based Incomplete Recovery

Change-based Incomplete Recovery

Recovering to Restore Point

Recovering a Database to a Previous Incarnation

Tablespace Point-in-Time Recovery

Using Data Recovery Advisor



Chapter 5:  Cloning Database with RMAN

Cloning Database with RMAN Overview

Creating a Duplicate Database on Remote Host with the Same Directory Structure

Creating a Duplicate Database on a Remote Host

Duplicating Database to the Remote Host with Different Directory Structure

Creating Duplicate Database with Different Directory Structure

Creating a Duplicate Database on a Local Host

Resynchronize a Duplicate Database

Configure AUXNAME configuration of RMAN

Duplicate on Windows Host

Duplicate Database Without Any Backup (g New Feature)

Duplicate database Without Connecting to the Target Database

Cloning Database Using Enterprise Manager

Creating Standby Database Using RMAN

Recovering Standby Database Using Incremental Backups

Resolving Archived Redo Log Gaps Using Incremental Backups



Chapter 6:  Transportable Tablespaces and Databases

Transportable Tablespace (TTS) Feature

Transporting Tablespace Using RMAN Backups

Transporting Tablespace Manually Without RMAN Backups

Transporting the Tablespace across Different Platforms which have a different endian format

Using the convert tablespace command on the source host to transport the whole tablespace (with all its datafiles) from Solaris OS to the Linux OS

Using the convert datafile Command on the Destination Host to Convert the Datafile from the Linux Platform to the Windows OS

Cross-Platform Database Migration

Copying Datafiles from ASM Storage




 Chapter 7:  Managing the Recovery Catalog


Creating the Recovery Catalog

Registering a Database in the Recovery Catalog

Unregistering the Database From the Catalog

Dropping the Recovery Catalog

Synching a Catalog

Saving RMAN Scripts in the Recovery Catalog

Creation of RMAN Scripts

Create Script from a File

Delete the Stored Script

Cataloging the Copies of the Files

Backing Up and Recovering the Recovery Catalog

Creating Virtual Private Catalogs

Merging and Moving the Recovery Catalog

Querying the Recovery Catalog



Chapter 8:  Troubleshooting, Monitoring and Tuning RMAN

RMAN Troubleshooting Overview

Interpreting RMAN Error Stack

RMAN in Debug Mode

Using the sbttest Utility

Monitoring RMAN

RMAN Tuning Introduction

It is All About I/O

Be In Synch With Asynchronous I/O



Chapter 9:  User-managed Backup and Recovery Scenarios

Modes of the Backup

Backing Up Database Running in Noarchivelog Mode

Back Up the Database Running in Archivelog Mode

Diving Deep into the Backup Mode

Restore/recover the Database Running in Noarchivelog Mode

User-managed Backup of Controlfile

Backing Up Controlfile in Binary Format

Text Backup of Controlfile

Backing Up Archive Files

Backing Up Spfile, Password File and Network Files

Backing Up Offline and Read Only Datafiles

Verifying User-managed Backups

User-managed Recovery Scenarios

Recovering from the Loss of Controlfiles

Recovering from Loss of all Controlfiles Using Backup Controlfile

Recovering From Loss of a Member of Multiplexed Controlfile

Recovering Read Only Tablespace From Loss of Controlfiles

Recovery of Datafiles and Tablespaces

Recovering Offline and Read Only Datafiles

Recovering a Datafile Which Has No Backup

Recovering Undo Datafile

Performing User-Managed Recovery from Loss of Redo Log Files

Performing Incomplete Recovery

Time-based Incomplete Recovery



Chapter 10:  Using the Media Management Layer


The sbttest Utility

Simulating SBT Channel

Introduction to Oracle Secure Backup

A Closer Look at Oracle Secure Backup (OSB)

Oracle Application Servers

Daemons Related to OSB

Installing OSB on Linux

Configuring OSB

RMAN Configuration with OSB

Database Backup and Recovery Using OSB

Doing File System Backup and Restore Using OSB

Oracle Secure Backup Cloud Module



Chapter 11:  Performing Flashback Recovery


Oracle Flashback Query

Viewing/Retrieving the Dropped PL/SQL Object codes using Flashback Query

Using Flashback Query on Dropped Table

Oracle Flashback Versions Query

Oracle Flashback Transaction Query

Flashback Transaction Backout

Oracle Flashback Table

Oracle Flashback Drop

Managing the Recycle Bin

Purging Objects From the Recycle Bin

Oracle Flashback Database

Excluding Tablespace from Flashback

Performing Flashback Database When There is Tablespace Excluded From Flashback

Recover Dropped Schema with Flashback Database

Restoring Dropped Tablespace Using Flashback Database

Monitoring Changes in Flashback Database

Oracle Flashback Data Archive (Total Recall)

Modify the Flashback Data Archive

Using Default Flashback Data Archive for the System

Query Flashback Data Archive

Using Flashback Versions Query and Flashback Table with Enterprise Manager

Using Flashback Drop from OEM



Chapter 12:  Backing Up Database Using Data Pump Utility


Data Pump Overview

Data Pump Architecture

Data Pump Dump File

Data Pump Modes

Using Data Pump Export Utility (expdp)

Data and Metadata Filtering Using Data Pump

Exporting Remote Database Schema Objects

Exporting Objects Consistent with Specified scn or time

Estimating the Size of the Dump File

Parallelizing Export Process

Compressing the Data While Exporting

Exporting a Tablespace

Export of the Whole Database

Encrypted Export

Using Data Pump to Export/Import Tables

Using Data Pump Import Utility (impdp)

Remapping Through Data Pump

Using dbms_data pump Package to Move Data

Interactive Command Line Mode of Data Pump

Attaching to a Job

Getting the Best Out of the Data Pump

Main Differences Between Data Pump and Original Export/Import Tools


Book Conclusion






/home/oracle/aux folder


11.2 Error Message Guide



access_method parameter

add_file command

administrative domain

administrative server

alert.log file    


allocate channel command

alter database command

alter flashback archive command

alter system checkpoint command

alter system kill session command

archive files

archive log file

archive log mode

archive logs

archived redo log files        


archivelog backupsets

archivelog mode     

asynchronous I/O


auto command


automatic backup

auxiliary database

auxiliary instance    

auxiliary instance parameter

auxiliary server

auxname configuration



backup backupset command

backup command    

backup control file

backup database command   

backup folder

backup mode

backup naming format

backup optimization

backup piece

backup set

backup set size

Backup Settings

backup tablespace command

backup validate command  


binary backup

binary compression

Block Media Recovery

block change tracking  

Block Media Recovery   

blockrecover command

buffer cache



cancel -based incomplete recovery

cancel-based recovery

catalog command    

catalog database

catalog for database command

change command  

change-based incomplete recovery


channel allocation




CLI interface


client process

clone database   

clone process

cloned instance

cloud computing

command line installation

command prompt

commit statement

compatibility parameter

complete recovery


compression feature

compression parameter


configure auxname

configure channel command

configure command     

consistent backup

content parameter

continue_client command

control file            

control files  

controlfile backup

controlfile script

convert database command  

convert datafile … to platform command

convert datafile command

convert tablespace command

copy command

cp command  

crash recovery

create catalog command

create controlfile command

create flashback archive command

create script command

Cross Platform migration

Cross Platform transportable tablespace

Cross-Platform Tablespace Transportation

cumulative incremental backup

Current redo log group




data dictionary views

data file copy method

Data Pump          

Data Pump export

Data Recovery Advisor


database backup

database identifier (DBID)

dataguard environment

DB Verify (DBV)




dbms_data pump package





debug option

default flashback data archive

delete input command

delete script command

differential incremental backup

direct path method


dirty buffers

disaster recovery



drop catalog command

drop command


drop table command

dropped schema

dropped table

dropped tablespace

dual mode


dumpfile parameter

duplicate command  

duplicate database

duplicate database command


dynamic script




encrypted backup sets

encrypted mode


encryption algorithm  



encryption_password parameter

end backup command

end timestamp

error code range

error message

error stack

estimate_only switch

exclude parameter

existing script

expdp utility

export tablespace

external table method




FBDA (Flashback Data Archive)

filesize parameter

filesperset parameter

flash recovery area

flash recovery area   

Flash Recovery Area (FRA)  

flashback data archive

flashback database

flashback database option

flashback database to command

flashback drop   

flashback logs

flashback query

flashback recovery area   

flashback table

flashback table command

flashback technology  

flashback transaction backout

flashback transaction query

flashback versions query


flashback_scn parameter


fractured block

full backup

full database export

full resynchronization




global scripts

grant register database command

GUI interface



high availability

hot backups



image copy

impdp utility

import catalog command

import mode

Inactive redo log group

include parameter

incomplete recovery  

inconsistent backup

incremental backups    

influx blocks

instance crash

instance failure

instance recovery

interactive command line mode

invalid data failure







list command   

list copy command

list incarnation command


local scripts

log option

log_archive_format parameter


logical backup

logical corruption



Manageability Monitor (MMON)

manual redo log switch

master control process



maxpiecesize parameter


media crash

media failure

Media Management Layer (MML)

Media Management Library (MML)

media recovery

media server



mount mode

multiplexed control files

multiplexing control files



network failure

network link method

network_link parameter

New Dataset link

no backup

noarchivelog mode   

nomount mode     


non-reusable section

NULL compression



Object Level Recovery


OF SCN clause

online redo logs

Oracle Encryption Wallet  

Oracle Enterprise Manager (OEM)

Oracle flashback query

Oracle Secure Backup

oradim utility

orapwd utility


OSB daemons



parallel option

parallel parameter


partial backup

partial resynchronization

password mode

physical backup

physical corruption


print script command

process crash

process failure

production database   

PURGE clause



query parameter



read only datafile


recover command

recover datafile command


recovery catalog         

recovery catalog owner

recovery catalog query

recovery operation

recovery process

recovery window

Recovery Writer (RVWR)

recycle bin   

recyclebin parameter

redo data

redo log

redo log files         


register database

remap_data parameter

remap_datafile parameter

remap_schema parameter

remap_table parameter

remap_tablespace parameter

remapping options

RENAME clause

report command   

report schema command

resetlogs command  

resetlogs option              


restore command

restore point

resync catalog command

retention policy    

reusable section

reuse_dumpfiles parameter

reverse resynchronization

revoke command


RMAN prompt

RMAN scripts

rman’s list backup command

roll backward

roll forward

rollback command

run block



sample parameter



sbttest utility

Schedule Backup

schema mode

SCN number   

scn value      

SCN-based recovery

set newname command

shadow process

show all command

show recycle_bin command



snapshot control file


sql command

sqlfile parameter

standby command

standby database  

start timestamp

statement failure

Streams Pool

Symmetric Binary Tape interact (SBT)


synchronous I/O



table mode

table_exists_action parameter

tablespace mode

Tablespace Point in Time Recovery (TSPITR)  

tablespace recovery


tape drives

target database    

tbl_readonly table

tbl_test table

TIME clause

time-based incomplete recovery

time-based recovery


tracking file


transparent encryption

transparent mode

transport tablespace command

transport tablespace mode

transport.sql script

Transportable Tablespace


truncate table command



undo datafile

undo tablespace  

undo_management parameter

undo_tablespace parameter

unregister database

until time command

unused block compression

update command

upgrade catalog command


user-managed backup




v$ rman_status

v$backup view


v$database view

v$datafile view

v$datafile_header view

v$recover_file view

v$recovery_log view




validate backup command

validate command


Virtual Catalog





whole backup


Windows host

Windows service

worker process




Reader Comments:




 Copyright © 1996 -2011 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation. SQL Server® is the registered trademark of Microsoft Corporation. 
Many of the designations used by computer vendors to distinguish their products are claimed as Trademarks