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 $31.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.

* 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   1  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: