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

Oracle Software
image
image
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
  Phone
  800-766-1884
Oracle News
Oracle Forum
Oracle Tips
Articles by our Authors
Press Releases
SQL Server Books
image
image

Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle

STATSPACK Viewer

    Privacy Policy

  


ISBN:
0-9844282-3-2
ISBN 13:
978-0-9844282-3-6

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 http://www.kamranagayev.com 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 http://blog.aristadba.com

 

 

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

Datafiles

Control Files

Redo Log Files

RMAN Backup Concepts

Backup Set

Backup Piece

Channel Allocation

Autobackups

Summary

 

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

Conclusion

 

Chapter 3:  Backing Up the Database Using RMAN

Introduction

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

Summary

 

Chapter 4:  Restoring and Recovering the Database Using RMAN

Introduction

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

Conclusion

 

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

Conclusion

 

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

Conclusion

 

 

 Chapter 7:  Managing the Recovery Catalog

Introduction

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

Conclusion

 

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

Conclusion

 

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

Conclusion

 

Chapter 10:  Using the Media Management Layer

Introduction

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

Conclusion

 

Chapter 11:  Performing Flashback Recovery

Introduction

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

Conclusion

 

Chapter 12:  Backing Up Database Using Data Pump Utility

Introduction

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

Conclusion

Book Conclusion

Index:

$

$ORACLE_BASE

 

/

/home/oracle/aux folder

 

11.2 Error Message Guide

 

A

access_method parameter

add_file command

administrative domain

administrative server

alert.log file    

all

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

archivelog backupsets

archivelog mode     

asynchronous I/O

attach

auto command

autobackup

automatic backup

auxiliary database

auxiliary instance    

auxiliary instance parameter

auxiliary server

auxname configuration

 

B

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  

backup_tape_io_slaves

binary backup

binary compression

Block Media Recovery

block change tracking  

Block Media Recovery   

blockrecover command

buffer cache

 

C

cancel -based incomplete recovery

cancel-based recovery

catalog command    

catalog database

catalog for database command

change command  

change-based incomplete recovery

channel

channel allocation

checkpoint

checksyntax

class

CLI interface

client

client process

clone database   

clone process

cloned instance

cloud computing

command line installation

command prompt

commit statement

compatibility parameter

complete recovery

compression

compression feature

compression parameter

configure

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

customize

 

D

data dictionary views

data file copy method

Data Pump          

Data Pump export

Data Recovery Advisor

data_only

database backup

database identifier (DBID)

dataguard environment

DB Verify (DBV)

dba_flashback_archive

dba_flashback_archive_ts

DBID

dbms_data pump package

dbms_flashback

dbms_flashback.transaction_backout

DBWR

dbwr_io_slaves

debug option

default flashback data archive

delete input command

delete script command

differential incremental backup

direct path method

directory

dirty buffers

disaster recovery

disk

DMnn

drop catalog command

drop command

DROP TABLE clause

drop table command

dropped schema

dropped table

dropped tablespace

dual mode

dumpfile  

dumpfile parameter

duplicate command  

duplicate database

duplicate database command

DWnn

dynamic script

 

E

ENABLE TRIGGERS clause

encrypted backup sets

encrypted mode

encrypted_columns_only

encryption algorithm  

encryption_mode

encryption_password

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

 

F

failures

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_archive_tables

flashback_scn parameter

flashback_transaction_query

fractured block

full backup

full database export

full resynchronization

fuzzy

 

G

global scripts

grant register database command

GUI interface

 

H

high availability

hot backups

 

I

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

 

 

 

L

LGWR

Linux

list command   

list copy command

list incarnation command

listener.ora

local scripts

log option

log_archive_format parameter

logfile

logical backup

logical corruption

 

M

Manageability Monitor (MMON)

manual redo log switch

master control process

maxopenfiles

maxpiecesize

maxpiecesize parameter

maxsetsize

media crash

media failure

Media Management Layer (MML)

Media Management Library (MML)

media recovery

media server

metadata  

metadata_only

mount mode

multiplexed control files

multiplexing control files

 

N

network failure

network link method

network_link parameter

New Dataset link

no backup

noarchivelog mode   

nomount mode     

none

non-reusable section

NULL compression

 

O

Object Level Recovery

obtool  

OF SCN clause

online redo logs

Oracle Encryption Wallet  

Oracle Enterprise Manager (OEM)

Oracle flashback query

Oracle Secure Backup

oradim utility

orapwd utility

OSB    

OSB daemons

 

P

parallel option

parallel parameter

parfile

partial backup

partial resynchronization

password mode

physical backup

physical corruption

PMON

print script command

process crash

process failure

production database   

PURGE clause

 

Q

query parameter

 

R

read only datafile

recover

recover command

recover datafile command

recovery  

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         

redundancy

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

restore command

restore point

resync catalog command

retention policy    

reusable section

reuse_dumpfiles parameter

reverse resynchronization

revoke command

RMAN          

RMAN prompt

RMAN scripts

rman’s list backup command

roll backward

roll forward

rollback command

run block

 

S

sample parameter

SBT   

sbtio.log

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

SKIP TABLESPACE clause

SMON

snapshot control file

spfile   

sql command

sqlfile parameter

standby command

standby database  

start timestamp

statement failure

Streams Pool

Symmetric Binary Tape interact (SBT)

synching

synchronous I/O

 

T

table mode

table_exists_action parameter

tablespace mode

Tablespace Point in Time Recovery (TSPITR)  

tablespace recovery

tape

tape drives

target database    

tbl_readonly table

tbl_test table

TIME clause

time-based incomplete recovery

time-based recovery

tnsnames.ora

tracking file

transaction_backout

transparent encryption

transparent mode

transport tablespace command

transport tablespace mode

transport.sql script

Transportable Tablespace

troubleshoot

truncate table command

 

U

undo datafile

undo tablespace  

undo_management parameter

undo_tablespace parameter

unregister database

until time command

unused block compression

update command

upgrade catalog command

user_dump_dest

user-managed backup

utlirp.sql

 

V

v$ rman_status

v$backup view

v$backup_files

v$database view

v$datafile view

v$datafile_header view

v$recover_file view

v$recovery_log view

v$rman_backup_job_details  

v$rman_configuration

v$rman_output

validate backup command

validate command

validity

Virtual Catalog

 

W

wallet

Webtool

whole backup

Windows

Windows host

Windows service

worker process

 

Z

ZLIB

Reader Comments:

Errata:

 

   

 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